Sales Data Dashboard -- 2
Budget: ₹750 – ₹1,250 INR
Developed a comprehensive Power BI dashboard to analyze and visualize sales data across regions, products, and time periods, enabling the sales and marketing teams to track KPIs, identify trends, and make data-driven decisions.
Key Features & Contributions:
Data Sources: Connected Power BI to multiple data sources including Excel files and a SQL Server database containing historical and current sales transactions.
Data Cleaning & Transformation: Used Power Query to clean and transform raw sales data — including missing value handling, column renaming, and date formatting.
Data Modeling: Designed a star schema with fact and dimension tables (Sales, Products, Customers, Regions, Time) and defined relationships using Power BI’s data model.
DAX Calculations: Created measures for KPIs such as:
Total Sales
Profit Margin
YoY Growth
Average Order Value
Sales by Region/Product/Category
Interactive Visuals:
Line and column charts for monthly sales trends
Donut charts for sales distribution by product category
Map visuals for geographic performance
Slicers and filters for dynamic user interaction
Performance Optimization: Applied best practices such as disabling auto date/time, optimizing DAX expressions, and minimizing visuals per page to improve report responsiveness.
Deployment: Published the dashboard to Power BI Service, set up refresh schedules, and shared the report with stakeholders through Power BI workspace and email subscriptions.
Key Features & Contributions:
Data Sources: Connected Power BI to multiple data sources including Excel files and a SQL Server database containing historical and current sales transactions.
Data Cleaning & Transformation: Used Power Query to clean and transform raw sales data — including missing value handling, column renaming, and date formatting.
Data Modeling: Designed a star schema with fact and dimension tables (Sales, Products, Customers, Regions, Time) and defined relationships using Power BI’s data model.
DAX Calculations: Created measures for KPIs such as:
Total Sales
Profit Margin
YoY Growth
Average Order Value
Sales by Region/Product/Category
Interactive Visuals:
Line and column charts for monthly sales trends
Donut charts for sales distribution by product category
Map visuals for geographic performance
Slicers and filters for dynamic user interaction
Performance Optimization: Applied best practices such as disabling auto date/time, optimizing DAX expressions, and minimizing visuals per page to improve report responsiveness.
Deployment: Published the dashboard to Power BI Service, set up refresh schedules, and shared the report with stakeholders through Power BI workspace and email subscriptions.