Contoso Dashboard Project

Contoso Dashboard & Reporting

In this capstone project, I leveraged the Contoso dataset—a sample data set provided by Microsoft—to develop a comprehensive interactive dashboard using Power BI. The project demonstrates my ability to transform raw data into actionable insights through effective dashboard design and advanced reporting techniques.

Key Highlights:

Comprehensive Data Visualization:
Developed a multi-page Power BI dashboard that covers both categorical and numerical analyses. The visualizations include descriptive analysis of key categorical variables such as Product Category, Channel, Date (Seasonal trends), Geography, and Store. This enabled a detailed view of sales distributions and contributions by segments.

Trend and Change-over-time Analysis:
Incorporated change-over-time analyses to showcase the evolution of sales performance across different years (2007, 2008, and 2009). Interactive line charts and bar graphs provided insights into seasonal patterns and overall revenue trends.

Advanced Analytical Techniques:
Employed advanced techniques such as Pareto analysis, decomposition trees, and correlation analysis (e.g., between Discount Amount and Sales Amount). These visuals helped in identifying key drivers behind sales performance and highlighted opportunities for further business optimization.

Sales Distribution & Cluster Analysis:
The dashboard features violin plots and scatter plots that illustrate the distribution of Sales Amount and Sales Quantity. This analysis, coupled with clustering by sales quantity groups (e.g., small-, middle-, and high-amount orders), provided a granular view of order segmentation and revenue contribution.

Interactive Reporting:
Integrated interactive elements like slicers and filters that allow users to drill down by various dimensions (product, channel, geography, etc.), making the dashboard a powerful tool for stakeholders to perform ad-hoc analysis and extract specific insights.

Actionable Insights:
The project not only visualized key metrics such as total revenue, profit, and sales trends but also supported decision-making by revealing patterns in customer behavior, sales channel performance, and product category contributions.