This project showcases an interactive Power BI dashboard designed to analyze and visualize chocolate sales performance across multiple regions and product categories.
The dashboard helps stakeholders track key performance indicators (KPIs) such as total sales, profit, costs, shipments, and product-wise performance, enabling data-driven business decisions.
- To build a data-driven dashboard for sales analytics and profitability insights.
- To monitor performance metrics like sales, shipments, and profit trends.
- To identify high-performing products and markets using visual analytics.
- To enhance business understanding through interactive Power BI visualizations.
- Power BI – Dashboard creation and data visualization
- Excel – Data preprocessing and source input
- DAX (Data Analysis Expressions) – KPI calculations
- Power Query – Data transformation and cleaning
- 💰 KPIs Overview: Displays Total Sales, Total Profit, Total Costs, Total Shipments, and Total Boxes
- 🌎 Regional Insights: Visualizes sales and shipment performance across multiple countries (India, UK, USA, Canada, Australia, New Zealand)
- 🍬 Product Analytics: Highlights top-performing chocolate products by sales and profit
- 📦 Trend Analysis: Shows monthly sales and shipment trends for forecasting
- 📊 Interactive Filters: Enables drill-through insights by region and category
- Identified top-selling chocolates contributing to major revenue share.
- Found regions with higher shipment volumes but lower profit margins.
- Discovered month-wise trends useful for seasonal sales planning.
- Import the dataset (
chocolates_sales_data.xlsx) into Power BI - Clean and transform the data using Power Query
- Create relationships in Model View
- Build KPI cards, bar charts, and trend lines
- Apply filters and slicers for interactivity
- Format and publish the dashboard
- Enhanced understanding of data visualization and storytelling using Power BI.
- Gained experience in data modeling and DAX functions.
- Developed professional dashboard design and layout skills.