ITI ,Cairo,Egypt

AdventureWorks database.

Project Overview:

Data source: OLTP

Connection Mode: DirectQuery

Source Documentation: AdventureWorks Installation Guide

Key Highlights:

Conductivity Mode: Leveraging DirectQuery for real-time analysis.

Tables and Views: Meticulous cleanup and transformation, including renaming and removal of unused columns.

Product Hierarchy: Implementation of a Star Schema with a structured product hierarchy.

Measures (DAX): Crafting essential measures such as # Orders, Total SubTotal, Tax, Freight, Total Due, and # Qty.

Visualization and Analysis:

Charts: Utilizing line charts for insightful calculations.

Drill-Down Capability: In-depth exploration of OrderDate, ShipDate, and DueDate.

Top 10 Sales Persons: A dynamic view, filterable by Orders or Total Amount.

Additional Insights: Status, Shipmethod, Category, SubCategory, Product, FlagOnlineOffline, Territory.

Professional Touch: