Adventure Works Production & Purchasing Analysis Project

This project aims to analyze production and purchasing efficiency, identify bottlenecks, and improve overall supply chain and operational efficiency for Adventure Works.

Tools Used:

SQL Server: For data extraction and joining multiple tables

Power BI: For data analysis, building the data model, creating relationships, and generating insights.

Excel: For initial data exploration, anomaly detection, and data quality checks.

Key Objectives:

Analyze production performance and identify delays.

Track purchasing and order processes for improvement.

Develop insights to enhance production planning and operational efficiency.