Advanced Sales Analytical Dashboard in Microsoft POWER BI using DAX
This Sales Analytical Dashboard is filled with DAX and Visualizations (Storytelling). Following DAX are used in this POWER BI file, CALCULATE, FILTER, ALL, ALLEXCEPT, ALLSELECTED, PREVIOUSYEAR, DATESYTD, DATESBETWEEN, FIRSTDATE, LASTDATE, CLOSING AND OPENING BALANCES, YEAR ON YEAR (YOY), SUM, AVERAGE, COUNT, and many others to calculate analytics using Explicit Measures (DAX) at the advanced level. This dashboard is relevant for all finance and sales professionals.
- Blinking Icons / Alerts
- TOP 5 Customers DAX
- Highlight TOP 3 in Bar Chart
- Others Category in Bar Chart
- Time Intelligence DAX
- Sales Analytical Summary
- Artificial Intelligence AI Visuals
- Last N Days Calculation
- Fiscal Year
- Gauge Chart with Conditional Formatting
