end-to-end Data Analytics Supply Chain Project FedEx data to an interactive Power BI dashboard 🎥 .

In this video, I share a complete A-to-Z walkthrough of a real-world Supply Chain analytics project from raw data to an interactive Power BI dashboard.

The project is built using real shipment data from a FedEx business day and follows the same structure used in production analytics environments.

What’s covered in the video:

1️⃣ SQL Server (SSMS) - Data Warehouse Design

• Creating an analytics database

• Using schemas (staging / dim / fact)

• Designing Fact and Dimension tables

• Applying a Star Schema for analytics

2️⃣ SSIS - ETL Process

• Loading raw CSV data into staging

• Building ETL pipelines for dimensions

• Generating surrogate keys using Lookups

• Loading the Fact table correctly

3️⃣ Power BI - Modeling & Visualization

• Connecting Power BI to SQL Server

• Building relationships using Star Schema

• Creating business-focused visuals

• Analyzing delivery performance and delays

This project was built with a real-world mindset:

Data modeling before visualization

ETL before dashboards

Business questions before charts

📌 The best way to learn data analytics is hands-on practice.

This dataset is practical, realistic, and perfect for training.

If you’d like:

• the CSV dataset,Codes

• or the Power BI background/template

drive.google.com/drive/folders/1eJCRxlTRzah6eDrzqgXAbLYVBbSD1tPa
https://www.linkedin.com/in/eng-mohamed96/
#DataAnalytics #PowerBI #SQLServer #SSIS #DataWarehouse #SupplyChainAnalytics #ETL #BusinessIntelligence #LearningByDoing #UX #UI #SSMS