Pareto Analysis

This dashboard offers a comprehensive analysis of U.S. electronics sales, providing a detailed breakdown of regional performance and year-over-year (YoY) trends. It includes insights by product category and tracks key performance indicators (KPIs) such as sales, profit, and orders over time and across geographical regions. The data is fully sliceable by different years for enhanced flexibility and in-depth exploration. Drill down into each region by clicking on it to deep dive into which products are the driving force behind sales, profit and orders with a Pareto Analysis that provides immediate actionable insights.

Regional Comparison:

The dashboard shows data for four U.S. regions: West, South, Midwest, and Northeast. Each region includes metrics for sales, profit, and orders, along with YoY percentage changes.

Category-Specific Insights:

Sales performance is categorized into key product groups like laptops, tablets, smart devices, and mobile phones, with YoY growth trends for each.

Trend Analysis:

Line graphs illustrate the trends in sales, profit, and orders throughout the year for each region.

Interactive Drill-Downs:

Clicking on a specific region enables a Pareto analysis of product models, adhering to the 80/20 rule. This identifies which products drive the majority of sales or profit, offering actionable insights.

This dashboard was created as part of a tutorial on the website Power BI Park but has been altered from the original with my own touches.

Pareto Analysis

Links

Portfolio

Contact