Navigating Challenges: A Data-Driven Boost for 99 Market Mall Data-driven analysis and recommendations for optimizing sales, inventory, and customer experience using business data management techniques.
This capstone project analyzes 99 Market Mall’s business data to identify operational challenges and provide data-driven recommendations. The objective is to optimize inventory management, boost sales, and enhance customer experience despite limited resources.
- Location: Maharajganj, Siwan, Bihar (Pin Code: 841238)
- Overview: A local retail mall offering fashion, groceries, and daily essentials
- Monthly Revenue: ~₹2,00,000
- Strengths: Trusted by the local community, customer-centric approach, wide product variety
- Limited resources restrict innovation, expansion, and improvements in customer experience.
- Increasing competition from larger retailers requires differentiation to maintain customer loyalty and market share.
- Source: Sales records and inventory systems from 99 Market Mall
- Features: Product categories, stock quantity, sales amount, monthly revenue, profit, customer preferences
- Format: CSV / Excel
- Data Cleaning: Missing values handled, standardized formats applied, and data consistency ensured
The repository is organized to reflect different stages of the capstone project submission.
BDM-Capstone-Project/
│── Proposal.pdf
│── Mid term report.pdf
│── End Term Submission.pdf
│── Presentation.pdf
│── README.md
-
Proposal.pdf Provides an introduction to the project, outlining objectives, scope, and analytical approach. Highlights the primary challenges faced by the retail business.
-
Mid term report.pdf Contains the executive summary, proof of data originality, metadata, descriptive statistics, and a detailed explanation of the data collection, cleaning, and analysis methodology. Discusses initial findings.
-
End Term Submission.pdf Includes a comprehensive analysis of the data, results, and findings. Provides detailed insights into customer preferences, sales trends, and inventory management, along with recommendations for optimizing operations and business strategies.
-
Presentation.pdf Final presentation summarizing the problem statement, data analysis, key findings, and recommendations using charts and visualizations.
This repository contains documentation submitted at various stages of the BDM capstone project.
-
Proposal.pdf Provides an introduction to the project, outlining objectives and analytical approach. Highlights the primary challenges faced by the retail business.
-
Mid term report.pdf Contains an executive summary, proof of data originality, metadata, descriptive statistics, and a detailed explanation of the data collection, cleaning, and analysis process. Discusses initial findings and methodology.
-
End Term Submission.pdf Includes comprehensive data analysis, results, and findings. Provides detailed insights into customer preferences, sales trends, and inventory management, along with business optimization strategies.
-
Presentation.pdf Summarizes the project, including the problem statement, analysis, key findings, and recommendations using charts and visualizations.
- Monthly stock comparison (bar charts)
- Stock allocation (pie charts)
- Pareto analysis to identify critical inventory items
- Monthly sales and profit trend analysis
- Pareto charts to identify top-selling products
- Festival season impact analysis (November highest, January lowest)
- Women’s Wear, Backpacks, and Apparel contribute approximately 70% of total sales
Visualizations help identify high-demand products, seasonal trends, and inventory imbalances.
- Customer Preferences: Women’s Wear and Apparel are the primary revenue drivers.
- Sales Trends: Sales fluctuate seasonally, with peaks during festival periods.
- Inventory Management: Optimized stock planning can reduce capital blockage and improve availability of high-demand items.
- Demand-driven stocking can significantly improve operational efficiency.
- Targeted promotions during peak seasons can enhance revenue.
- Data-driven monitoring enables better forecasting and decision-making.
- Conduct regular audits to eliminate unnecessary costs.
- Partner with local suppliers to optimize procurement.
- Apply lean management principles for operational efficiency.
- Implement low-cost, cloud-based inventory management tools.
- Emphasize personalized service and exclusive product offerings.
- Organize community events and partnerships.
- Run targeted marketing campaigns.
- Strengthen online presence through social media platforms.
- Introduce loyalty programs to retain repeat customers.
MS Excel: For data analysis and visualization. Python: For data cleaning and statistical analysis. Data Visualization Tools: To create charts and graphs for better data understanding.
By analyzing sales and inventory data, this project identifies key opportunities for improving operations and customer experience at 99 Market Mall. Implementing these data-driven strategies can help optimize resources, increase profitability, and maintain a competitive edge.
✅ Project Outcome: A clear roadmap for data-driven decision-making with actionable recommendations for inventory optimization, sales growth, and customer engagement.
- Name: Rajeev Kumar
- Email: rajeev90767@gmail.com
- LinkedIn: linkedin.com/in/rajeev245
- GitHub: github.com/21f3001527
Feel free to reach out for any queries or further information regarding the project.