تفاصيل العمل

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)

بطاقة العمل

اسم المستقل
عدد الإعجابات
0
عدد المشاهدات
54
تاريخ الإضافة
تاريخ الإنجاز
المهارات