Overview

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) advanced level.
There are 5 pages in the dashboard, The first page consists of the overall advanced sales analytical dashboard, the second page consists of customer-wise information, the third page contains a time intelligence matrix so that users can learn in more detail. The remaining 2 pages are used for tooltips.
Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end-users to create their own reports and dashboards.
Microsoft Power BI is a business intelligence platform that provides non-technical business users with tools for aggregating, analyzing, visualizing, and sharing data. Power BI's user interface is fairly intuitive for users familiar with Excel and its deep integration with other Microsoft products makes it a very versatile self-service tool that requires little upfront training.
Thank you

Reviews Add a review
No reviews yet

More From Rahim Zulfiqar Ali

Browse our top rated business templates. See All
Gantt Chart in Microsoft Excel
144
4
 Gantt Chart in Microsoft ExcelMany people have never heard of a Gantt chart. Simply put, a Gantt chart is a bar…
Human Resource (HR) Headcount Analytical Dashboard in POWER BI
440
0
Human Resource (HR) Headcount Analytical Dashboard in POWER BIVideo: https://youtu.be/jVPFEEjCdvkPower BI is a business analytics service by Microsoft. It aims to…
Financial Model for Startup in Microsoft Excel | Entrepreneurship
907
167
Financial Model for Startup | EntrepreneurshipNUMBERS THAT EXPLAIN YOUR STARTUP’S POTENTIALThis template includes the following worksheets:1. Capital Structure and Details2.…
Advanced Sales & Marketing Dashboard in Microsoft Excel
542
0
Advanced Sales & Marketing Dashboard in Microsoft ExcelKey features:Usually fits on one pageDisplays key trends, comparisons, and data graphically or…
Financial Model - Microsoft Excel - Based on 5 Years Projections (Standard Model for Everyone)
541
0
Financial Model - Microsoft Excel - Based on 5 Years Projections (Standard Model for Everyone)This template contains the following worksheets:1.…
Cryptocurrency Portfolio Dashboard in Microsoft Excel - Data Live from COINMARKETCAP Website
644
1
Cryptocurrency Portfolio Dashboard in Microsoft Excel - Data Live from COINMARKETCAP Website (Improved & Advanced) May 2021Instructions: https://youtu.be/fYzKnLA2VNEWatch the above videoFeatures…
See All