/AdventureWorks-Analytics

Analyzing Manufacturing and Inventory Operations of the AdventureWorks Database using Power BI

AdventureWorks Analytics

Overview

AdventureWorks is a fictional bicycle manufacturing company created by Microsoft, this database contains standard transactions data from an Enterprise Resource Planning System. It contains data from the following scenarios of the company: Human Resources, Product Management, Manufacturing, Purchasing, Inventory, Sales, and Admin. This analysis focuses on the Manufacturing and Inventory scenario of the data. Microsoft Power BI has been used to create an interactive dashboard while pulling data from SQL Server.

Data Source

Data Source

Data Model

DataModel

Built With

Power BISQL Server

Details

For more details about the analysis please refer to this article

Detailed Analysis

Features

Dashboard Features Inventory Overview Page Navigation Inventory Value and Quantity graph Category Analysis Page Navigation

Screenshots

Main Page

Production Overview Page

Production Category Analysis

Inventory data overview