/AdventureWorks-Case-Study-PowerBI

This repository analyzes OLTP data using PowerBI for a cycle company called AdventureWorks.

AdventureWorks-Case-Study-PowerBI

This repository analyzes OLTP data using PowerBI for a cycle company called Adventure Works Cycles. A multinational manufacturing company's dataset covers various aspects such as product management, sales, purchasing, and employee information.

Raw_Data: This folder contains the raw CSV files used for analysis:

  • AdventureWorks Calendar Lookup.csv: Calendar information including dates and fiscal periods.

  • AdventureWorks Customer Lookup.csv: Customer details and demographics.

  • AdventureWorks Product Categories Lookup.csv: Product category information.

  • AdventureWorks Product Lookup.csv: Detailed product information.

  • AdventureWorks Product Subcategories Lookup.csv: Product subcategory details.

  • AdventureWorks Returns Data.csv: Data on product returns.

  • AdventureWorks Sales Data 2020.csv: Sales data for the year 2020.

  • AdventureWorks Sales Data 2021.csv: Sales data for the year 2021.

  • AdventureWorks Sales Data 2022.csv: Sales data for the year 2022.

  • AdventureWorks Territory Lookup.csv: Information on sales territories.

PowerBI_Report: This folder contains the PowerBI report file for the AdventureWorks case study:

  • AdventureWorks_CaseStudy: PowerBI report analyzing the sales and other business metrics of Adventure Works Cycles.