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
Project Management Dashboard in Microsoft Excel
301
19
 Project Management Dashboard in Microsoft Excel
Project Portfolio Dashboard in Microsoft Excel
296
32
 Project Portfolio Dashboard in Microsoft Excel
Income Tax Return Calculator 2021 FBR (Pakistan) - Salaried Individuals - Business Indv. and AOP
752
34
Income Tax Return Calculator 2021 FBR (Pakistan) - Salaried Individuals - Business Indv. and AOP
Personal Finance Template - Monthly Budget - Microsoft Excel
812
76
Personal Finance Template - Monthly Budget - Microsoft Excel
Microsoft Excel Tips and Tricks Practice with 30+ Examples
801
0
Microsoft Excel Tips and Tricks Practice with 30+ ExamplesTypes of SpreadsheetsRoaming, Autosum & ShortcutsFinancial Results LSEFormat PainterClipboard, Font, AlignmentAutofitBordersData TypesOperatorsEquationsFunctions…
Excel Competency Wheel
827
63
Excel Competency Wheel
See All