March 2018
Beginner to intermediate
638 pages
16h 29m
English
There are three fact tables for this dataset—Internet Sales, Reseller Sales, and the Sales and Margin Plan. The ability to analyze and filter two or all three of these tables concurrently via common dimensions, such as Date, Product, and Sales Territory, is what gives this dataset its analytical value to the business. A Power BI report, which is always connected to a single dataset, could contain visualizations comparing total Adventure Works Sales (Internet Sales plus Reseller Sales) to the overall Sales and Margin Plan. This same report could also include detailed visualizations that explain higher-level outcomes, such as the growth in online customers or changes in the Reseller Sales margin rates:
Read now
Unlock full access