pvn-ptl / 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

Built With

•Power BI •SQL Server

Details

For more details about the analysis please refer to this article

Detailed Analysis

Features

Screenshots

adventureworks-analytics's Issues

Inventory Overview Issue

Hi everyone,
I am practicing to do Inventory Overview sheet but I meet some issues. The field Inventory cost, Inventory Value, Inventory Turnover do not change when I choose Fiscal Year in slicer.
Could you help me show how to solve this problem please?
Thank you very much.