This is a Power Bi Project of the Production Analysis of a Manufacturing Company The Project is to analyze and derive insights to answer crucial questions and make the company make data driven decision

Disclaimer : Datasets from the Mircosoft Adevtureworks database. Used to demomstrate my learnings and capabilities with Proving Data Driven Decisions woth power BI

To provide insights into production performance by various categories and time periods

1. What Product categories contributed to the highest production performance
2. What time period did the highest production performance occur?

The following Power BI features were incorporated

• Getting data from the server (Microsoft based)
• Modelling relationships with tables
• DAX and Calculated Measure
• Page Navigation and Button

Get data Data was requested using server method via the local host computer The Model is a star schemma Modelling D The Model is a star schemma

The report comprises 5 pages:

1. Overview
2. Production By Product
3. Production B Work Order
4. Production By Work Order Routing
5. Production By Date

You can interact with the report here

The items with Produc ID 758 and 766 were the most produced at 116 units

Average number of days to make modification to the units was at 10 days

On the average, there was 5.65 deays to the scheduled end date

The Highest aseembled quanity occured around Sep 2010