This Dashboard about AdventureWorks2019 contains Dimension tables about (DimProduct that made by left join between product table , Product subcategory table , Product category table) & DimTerritory & DimShipMethod & DimStatus & DimDate & Sales.vsalesperson(view) & Fact tsble that contains (Sales.SalesOrderHeader & Sales.SalesOrderDetail) and model the data into star schema and contains userelationship-or-role-playing-date dimension that contains one active Relationship and two inactive Relationship between (DueDate , OrderDate , ShipDate in facttable and datekey in Dimdate)
and contains measures about
No. of Orders
Total SubTotal Measure
Total Tax Measure
Total Freight Measure
Total Due Measure
Qty
# Orders by Status
# Orders by Shipmethod
# Orders by Category, SubCategory, Product
# Orders by FlagOnlineOffline
# Orders and TotalDue by Territory
Top 10 Sales Perosns (# Orders)