All Projects
Data Analytics

AdventureWorks Sales Analytics Dashboard

End-to-end data analytics project using Excel, SQL Server and Power BI to analyze AdventureWorks sales, customers, products and geographic regions across 6 interactive dashboard pages.

View Code
Dataset

AdventureWorks (Microsoft sample database)

Approach

ETL pipeline: Excel cleaning → SQL analysis → Power BI visualization

Tech Stack
Microsoft ExcelSQL ServerPower BIDAX
Keywords
ExcelSQL ServerPower BIDAXData CleaningBusiness Intelligence
Visualizations2 Charts
Deep Dive

AdventureWorks Sales Analytics is a comprehensive end-to-end data analytics project showcasing the full data pipeline from raw data to actionable business insights.

Workflow: Raw Data → Excel Cleaning → SQL Analysis → Power BI Dashboard → Business Decision

Project Phases:

  • ▸Phase 1 — Excel: Data cleaning, duplicate removal, pivot tables & charts
  • ▸Phase 2 — SQL Server: Joins, CTEs, window functions, sales / customer / product / geographic analysis
  • ▸Phase 3 — Power BI: 6 interactive pages (Executive, Sales, Customers, Products, Geography, Detail Report) with DAX measures

Key Insights:

  • ▸Bikes drive the majority of total sales and profit
  • ▸USA and Australia are the highest-revenue markets
  • ▸A small group of customers contributes significantly to total revenue
  • ▸Interactive dashboards enable faster and smarter business decisions
Back to ProjectsHire Me