Regional Sales Dashboard

Objective: Creation of a real-time dashboard for comprehensive insights into sales, budgets, and market performance.

Skills Demonstrated:

SQL & Data Preparation: Expert use of SQL for data integration, highlighting adeptness in handling complex datasets.

PowerBI Modeling & Visualization: Developed a dynamic data model and interactive visualizations, showcasing advanced PowerBI skills.

Analytical Acumen: Created measures for sales and budget analysis, demonstrating deep analytical capabilities.

Key Insights:

- Uncovered that 95% of sales interest was in Bikes, totaling around 5M pounds.

- Identified discrepancies between sales performance and budget goals.

- Revealed strong market performance in the US and Australia, with growth potential in Canada.