logistics-inventory-data-analysis

SQL and Power BI analysis of shipment lead times, delay rates, inventory days, and SKU performance for a retail logistics context.

Overview

This project demonstrates SQL skills using a simulated logistics and inventory dataset. It includes table creation, feature engineering, aggregations, joins, and window functions.

SQL Skills Demonstrated

• CREATE TABLE
• Data import
• ALTER TABLE
• DATEDIFF and CASE logic
• LEFT JOIN with SKU master
• Monthly delay rate aggregation
• ROW_NUMBER ranking
• Moving average window function

File Structure

/data — CSV datasets
/sql — SQL scripts
/powerbi — dashboard visualization

Tools Used

MySQL Workbench (MySQL 8) Power BI

Example Output

• Monthly delay rate
• Worst delayed orders
• Delay by region & shipping mode