Sales Dashboard

AdventureWorks

Conductivity Mode => Import

DimDates (DAX) Contains: Year, Month, Day, Month Name, Day Name

Modelig:

- Star Schema

- Product Hierarchy

- Date Hierarchy

- line chart vs. counts (USERELATIONSHIP)

orderdate

shipdate

duedate

Measures

- # Orders Measure

- Total SubTotal Measure

- Total Tax Measure

- Total Freight Measure

- Total Due Measure

create DAX table that contains all measures

Visuals: (Use Measures)

- Drill Down

- Drill Through

- Bookmark to switch between to chart (show and hide)

- Add Slicer in two pages and Synced

- Max Qty per Product

- Matrix Chart (Row Territories, Column Years, Values: total sales, total Canada sales)

- Q&A chart