DATA ANALYSIS - ADVENTUREWORKS
AESTHETIC POWER BI DASHBOARD FOR ADVENTUREWORKS SALES DATA
ADVENTURE WORKS
This Power BI dashboard analyzes AdventureWorks sales data, a retail dataset from Microsoft, to help the management team track key performance indicators (KPIs), compare regional performance, analyze product-level trends, and identify high-value customers.
• Connect and transform the raw data
• Build a relational data model
• Create calculated columns and measures with DAX
• Design an interactive dashboard to visualize the data
ABOUT
The management team needs a way to track KPIs (sales, revenue, profit, returns), compare
regional performance, analyze product-level trends, and identify high-value customers.
All you’ve been given is a folder of raw csv files, which contain information about
transactions, returns, products, customers, and sales territories
- Includes tables, views, procedures, and functions
- Supports online transaction processing scenarios
- Includes modules for business entities, people, human resources, products, manufacturing, purchasing, inventory, sales, and admin
Year
2024
Client
Adventure Works
Services
Data Analysis
Project
Dynamic
Description
This project highlights my ability to work with real-world datasets, apply data modeling techniques, and create insightful visualizations to support data-driven business decisions.
Results & Insights:
- Identified top-selling products and their contribution to revenue.
- Analyzed regional sales performance to optimize business strategies.
- Tracked high-value customers to enhance customer engagement.
- Monitored product returns to identify potential areas for improvement.
