Sales Performance Analytics for AdventureWorks Using SQL & Power BI

Project Overview

This project focuses on the analysis and visualization of the AdventureWorks database, which represents the operations of a fictional bicycle manufacturing company. The database contains comprehensive data on products, sales, customers, and employees.

Using SQL for data extraction and transformation, and Microsoft Power BI for visualization, the project delivers actionable insights into the company’s sales performance and operational metrics. Through the integration of advanced DAX functions, SQL queries, and dynamic data modeling, a comprehensive and interactive sales dashboard has been developed. This dashboard enables users to monitor key performance indicators (KPIs), assess team contributions, and forecast revenue trends in real-time.

The outcome includes a set of user-friendly reports and dashboards designed to support data-driven decision-making and enhance overall business understanding.

Key Features

  • Interactive EDA Dashboards: Rich visual reports in Power BI featuring drill-down filters on sales trends, customer segments, and product performance.
  • Sales Analytics: DAX-driven breakdowns of total, annual, and monthly sales to uncover revenue patterns and seasonality.
  • Customer Behavior Insights: Segment exploration showing repeat purchasers and average spend per customer, revealing loyalty and value trends.
  • Product Performance Metrics: Identification of top-selling products and category-level analysis with insights into quantity sold and revenue contribution.
  • Operational SQL Insights: Use of SQL scripts for table exploration (e.g., DimCustomer, FactInternetSales), data cleansing, transformation, and aggregations.

Technical Implementation

  • AdventureWorksDW2022 Database: Restored in SQL Server for analysis; includes DimCustomer, DimDate, DimProducts, DimGeography, FactInternetSales.
  • SQL (T‑SQL): Queries are used to extract and clean data from different tables like DimCustomers, DimProducts, FactInternetSales and etc.
  • Power BI: Data modeling and interactive visual dashboards, including entity diagrams and sales/customer/product pages.
  • DAX Measures: Transform data within Power BI, and apply DAX measures for KPIs like total sales, total order, profit & profit margin , distinct product and customer count.

Business Impact

  • Enhanced Sales Visibility: Decision‑ready insights with monthly/yearly sales trends, product performance, and customer segmentation.
  • Optimized Resource Allocation: Data‑driven identification of top products and high-value customers boosts marketing and inventory strategy.
  • Improved Data Accuracy & Timeliness: Automated refresh and integration reduce manual processing, ensure up-to-date reporting.
  • Actionable Customer Insights: Analysis of repeat purchase behavior and average per-customer spend informs loyalty and sales tactics.

Interactive Sales Dashboard