Completed a comprehensive ๐๐บ๐ฎ๐๐ผ๐ป ๐ฆ๐ฎ๐น๐ฒ๐ ๐๐ฎ๐๐ต๐ฏ๐ผ๐ฎ๐ฟ๐ฑ ๐ฎ๐ฌ๐ฎ๐ฐ project๐, and I would love to walk you through its features and the insights it provides.ย
๐ฅ ๐๐ถ๐บ:ย This dashboard focuses on visualizing key metrics of sales along with Highlighting top-performing cities, states, and products for better decision-making in Sales Management.
๐ ๐๐ฎ๐๐ฎ ๐๐ผ๐น๐น๐ฒ๐ฐ๐๐ถ๐ผ๐ป: Data obtained from Sales Team.
๐๐๐ฒ๐ ๐๐ฒ๐ฎ๐๐๐ฟ๐ฒ๐ ๐ผ๐ณ ๐๐ต๐ฒ ๐๐ฎ๐๐ต๐ฏ๐ผ๐ฎ๐ฟ๐ฑ:ย
๐ซ๐๐ฒ๐ ๐ฃ๐ฒ๐ฟ๐ณ๐ผ๐ฟ๐บ๐ฎ๐ป๐ฐ๐ฒ ๐๐ป๐ฑ๐ถ๐ฐ๐ฎ๐๐ผ๐ฟ๐: For KPIโs Bans are used and for comparison between actual and target dough nut chart is used.
1๏ธโฃ Sales: Total sales amounted to โน10,226,625, achieving 81% of the target. This metric provides a clear snapshot of sales performance against target.
2๏ธโฃ Units Sold: A total of 33,874 units were sold, with a 92% achievement rate, highlighting operational efficiency.
3๏ธโฃ No. of Cities: The sales spanned across 23 cities, reaching 82% of the target cities.
๐ซ ๐ฉ๐ถ๐๐๐ฎ๐น๐ถ๐๐ฎ๐๐ถ๐ผ๐ป๐:
1๏ธโฃ City-Wise Sales: A line chart reveals the sales trends across different cities, with significant spikes in Delhi and other metro areas, allowing us to identify high-revenue locations.
2๏ธโฃ State-Wise Sales: A geographic map visualizes state-wise performance.
3๏ธโฃ Product-Wise Units Sold: A Funnel chart highlights top-performing products, with Nestle Smarties Pop-Up leading the sales.
๐ ๏ธ ๐ง๐ผ๐ผ๐น๐ & ๐ฆ๐ธ๐ถ๐น๐น๐ ๐จ๐๐ฒ๐ฑ:
1๏ธโฃ Microsoft Excel: Advanced charting, data formatting, and layout design.
2๏ธโฃ Data Analysis: Filtering and summarizing data to identify patterns and trends.
3๏ธโฃ Visualization Design: Intuitive visuals for quick understanding and actionable insights.
4๏ธโฃ Interactivity Features: Allow to switch between Dashboard, Pivot Tables, and Data.
โถ๏ธ ๐๐ถ๐ป๐ฎ๐น ๐๐ถ๐ป๐ฑ๐ถ๐ป๐ด๐ ๐ณ๐ผ๐ฟ ๐๐ต๐ฒ ๐๐ฎ๐น๐ฒ๐ ๐บ๐ฎ๐ป๐ฎ๐ด๐ฒ๐บ๐ฒ๐ป๐:
The dashboard includes target comparisons for key metrics like sales, units sold, and city coverage, identifying areas for improvement (e.g., achieving targets in additional cities, Increasing Sales Volume by implementing better marketing strategies, etc.).
This project has deepened my understanding of creating user-focused dashboards and delivering clear, impactful data stories. I would love to hear your feedback or discuss ideas for further improvement.ย
๐๐ต๐ฒ๐ฐ๐ธ ๐ผ๐๐ ๐๐ต๐ฒ ๐๐ถ๐๐ฒ ๐ฑ๐ฎ๐๐ต๐ฏ๐ผ๐ฎ๐ฟ๐ฑ ๐ต๐ฒ๐ฟ๐ฒ:ย https://github.com/Kanuboss12/Amazon_Sales_Dashboard-using-Excel
Commentaires