Adventure Works Sales Analytics Transformation

Revamped AdventureWorks OLTP Data Source through Import Mode, enhancing data visualization, model efficiency, and analytical capabilities.

Key Actions:

Data Transformation:

Conductivity Mode: DirectQuery

Renamed Tables and Columns

Removed Unused Columns

Merging Tables:

Merged Production.Product, Production.ProductSubcategory, and Production.ProductCategory into a single table.

Table Content: ProductID, Product, SubCategory, Category

Calculation Enhancements:

Solved TotalDue, Tax, and Freight using Power Query or DAX

Modeling:

Star Schema Implementation

Product Hierarchy Development

Measures:

Orders Measure

Total SubTotal Measure

Total Tax Measure

Total Freight Measure

Total Due Measure

Qty Measure

DAX Table containing all measures

Visualizations:

Drill Down and Drill Through

Tooltip Page

Card Visuals:

Orders Card

Total SubTotal Card

Total Tax Card

Total Freight Card

Total Due Card

Line Charts:

Orders by OrderDate vs. ShipDate vs. DueDate

Orders by Status

Orders by Shipmethod

Orders by Category, SubCategory, Product

Orders by FlagOnlineOffline

Orders vs. TotalDue by Territory

Top 10 Sales Persons Analysis:

Top 10 Sales Persons by # Orders or Total Amount

Utilized USERELATIONSHIP and Filter Pane for enhanced filtering

Enhancements and Hints:

Utilized Role-Playing Dimensions to handle inactive relationships.

Incorporated best practices from Radacad Hints for improved performance.

Aesthetics:

Implemented Good Colors, Layout, and Meaningful Chart Titles for an enhanced user experience.

This project showcases a comprehensive transformation of the Adventure Works OLTP Data Source, ensuring improved data representation, analytics, and ease of interpretation.