@@ Adventure Works
- Data Source:
Sales.xlsx
Modeling:
- Star Schema
- Product Hierarchy
Measures:
- # Orders Measure
- # Order Details Measure
- Total Subtotal Measure
- Total Tax Measure
- Total Freight Measure
- Total Due Measure
Create DAX Measures table that contains all measures
Visuals: (Use Measures)
- Drill Down
- Tooltip Page
- # Orders Card
- # Order Details Card
- Total Subtotal Card
- Total Tax Card
- Total Freight Card
- Total Due Card
# Orders by Order Date
# Orders by Status
# Order Qty by Category, Subcategory, Product
# Orders vs. Total Due by Territory
-- Use Brand Colors, Good Layout and Chart Titles (Meaningful)