ramaruompha01-hue/advanced-dax-powerbi-dashboard

Advanced Power BI dashboard using 13 DAX measures including Time Intelligence, RANKX and SWITCH on African business sales data # Advanced Power BI DAX Dashboard 🧮 ## 📌 Project Overview Built an advanced Power BI dashboard using DAX measures on an African Business Sales dataset covering 5,000 transactions across 5 countries from 2021–2024. ## 🛠️ Tools Used - Power BI Desktop - DAX (Data Analysis Expressions) - Power Query (M Language) ## 📂 Dataset - African Business Sales Dataset (custom built) - 5,000 rows, 23 columns - Countries: South Africa, Nigeria, Kenya, Ghana, Egypt ## 🧮 DAX Measures Created ### Basic Measures ```dax Total Sales = SUM(BI_Sales_Dataset[Sales]) Total Profit = SUM(BI_Sales_Dataset[Profit]) Total Orders = COUNTROWS(BI_Sales_Dataset) Profit Margin % = DIVIDE(SUM(BI_Sales_Dataset[Profit]), SUM(BI_Sales_Dataset[Sales])) * 100 Average Order Value = DIVIDE(SUM(BI_Sales_Dataset[Sales]), COUNTROWS(BI_Sales_Dataset)) Return Rate % = DIVIDE(SUM(BI_Sales_Dataset[Returns]), COUNTROWS(BI_Sales_Dataset)) * 100 ``` ### Time Intelligence Measures ```dax YTD Sales = CALCULATE( SUM(BI_Sales_Dataset[Sales]), DATESYTD('Date Table'[Date]) ) Sales Last Year = CALCULATE( SUM(BI_Sales_Dataset[Sales]), DATEADD('Date Table'[Date], -1, YEAR) ) YoY Growth % = DIVIDE([YTD Sales] - [Sales Last Year], [Sales Last Year]) * 100 ``` ### Advanced Measures ```dax Running Total Sales = CALCULATE( SUM(BI_Sales_Dataset[Sales]), FILTER( ALLSELECTED('Date Table'), 'Date Table'[Year] = 20000000, "High Performer", SUM(BI_Sales_Dataset[Sales]) >= 10000000, "Mid Performer", "Low Performer" ) ``` ## 📊 Dashboard Pages ### Page 1 — Sales Dashboard - KPI Cards: Total Sales, Total Profit, Total Orders - Time Intelligence Cards: YTD Sales, Sales Last Year, YoY Growth % - Sales by Category Bar Chart - Total Profit by Region Column Chart - Sales Over Time Line Chart - Profit Margin by Category Bar Chart ### Page 2 — Customer Dashboard - Top 5 Customers using RANKX - Sales Performance Table using SWITCH - Running Total Sales Line Chart ## 💡 Key DAX Concepts Demonstrated - SUM, COUNTROWS, DIVIDE — basic a …