←   Back to Home

POWER BI PROJECT

Sale Inventory Report by AdventureWorks

Sales, Product & Customer Analysis

SQL Data Analysis Power Query DAX Data Visualization

Power BI Dashboard

Project Overview

Adventure Works Cycles is a global manufacturing company. This project analyzes sales data from 2015 to 2017 to understand sales performance, products, customers, and different markets.

The project focuses on building an interactive Power BI dashboard to track key business KPIs and provide insights into sales, revenue, profit, customers, products, and country performance.

Dataset

Adventure Works Cycles

Global manufacturing company with sales data covering the period from 2015 to 2017.

Dimension Tables

  • Customers
  • Sale_Territories
  • Calendar
  • Product_Categories
  • Product_Subcategories
  • Products
  • Supplier
  • SalePerson

Fact Table

  • SaleDetails

Tools

SQL Power Query DAX Power BI Data Visualization

Project Brief

01

Track important KPIs including sales, revenue, profit and customers.

02

Compare sales performance across different countries.

03

Identify high-value customers and perform deeper customer analysis.

Data Model

Adventure Works Power BI Data Model