AdventureWorks Data Analysis - Power BI

Overview

This project involves analyzing sales data for AdventureWorks, a fictitious company that sells outdoor equipment. The analysis focuses on product sales, salesperson performance, and territory-based orders. The dashboards provide insights into total sales, order details, and geographic distribution of sales.

First Process:

Data Source: collecting data from OLTP “Direct Query”

Data Modelling: Star Schema

All Process

Data Collection: Gathered sales data from AdventureWorks database.

Data Extraction : Retrieved data from essential tables, views and function.

Date Table Creation: Implemented an M language script to generate a comprehensive date dimension table for enhanced time-based analysis.

Data Transformation: Cleaned and prepared the dataset by renaming tables and columns and removing unused data.

Data Modeling: Structured data into a star schema for efficient querying and analysis.

Measures: Created a set of critical measures for analysis, including the use of USERELATIONSHIP function to manage Inactive Relationships in a Role-Playing Dimension.

Data Analysis: Performed descriptive statistics and trend analysis.

Data Visualization: Created interactive dashboards using Power BI.

Reporting: Summarized findings and prepared reports for stakeholders.