Project Title: US Candy Distributor Dashboard
This project utilizes the Mavens Matrix dataset to create a dynamic Power BI dashboard focused on the candy distribution industry. Key features include:
- City-Wise Best Product Analysis: Visualizes the top-selling products in each city, allowing users to quickly identify market leaders and make informed stocking decisions.
- Month & Year-Wise Sales and Profit Margins: Provides insights into sales trends and profit margins over time, helping stakeholders understand seasonal fluctuations and overall performance.
- Division-Wise and Product-Wise Profit Margins: Analyzes profitability at different levels, offering a granular view of which divisions and products contribute most to the bottom line.
- Dynamic Top N Selection Using DAX: Users can select a numeric range (up to 5) to display their desired number of top products. For instance, selecting '2' reveals the Top 2 Products based on sales data, enhancing user interactivity and customization.
This dashboard empowers candy distributors to make data-driven decisions, optimize inventory, and boost sales performance.