Sales Analysis Dashboard

This report demonstrates a basic multi-page Power BI report using AdventureWorks2019. The source is populated from a local SQL DB installation to an AzureSQL DB using Azure Data Factory (ADF). Note that there are 7 report tabs here.

Some Power BI concepts implemented:

• Slicers / Filters are implemented throughout the report tabs.
• Dynamic Tooltips: You can hover the mouse cursor over bottom right graph on the first page for a demonstration. Filters and slicers will impact the results shown in the tool-tips page that will pop up.
• Drill-throughs: The bottom 2 visuals will allow you to drill-through to a details look at the current data. Current filters and slicers will impact the results of the drill-through page shown.
• Bookmarks: This has been implemented in various places, but a simple example can be observed on the second report tab ("Performance" tab).
• Note that the paginated report button on the first tab (Overview tab) will not function, as it is not possible for PowerBI to easily make those public at this time.
• The Forecast tab also has a demonstration of forecasting future values based on past values.
• Many other visuals such as bar graphs, column graphs, line graphs, treemaps, maps, tables, and matrices are also demonstrated throughout the report.
• Measures: Various DAX measures were created to perform YTD, YOY, other rolling calculations.