I’m currently building out a Strategic Supply Chain Intelligence Dashboard that bridges the gap between raw database management and executive decision-making. This isn’t just about making "pretty charts" it’s about solving real-world operational bottlenecks.
Logistics Efficiency: Carrier B is our clear winner, maintaining a 5.3-day average shipping time, outperforming all others without a significant jump in cost.
Supplier Risk vs. Reward: While Supplier 1 is a model of reliability (14.8-day lead time), Supplier 5 is a major bottleneck with 18-day delays and higher-than-average defect rates.
The Quality Bottleneck: A staggering 41% of inspections are currently "Pending." This suggests that our production isn't just a manufacturing challenge, but a quality control one.
Revenue Drivers: Skincare isn't just a category; it’s our powerhouse, generating over $241K in revenue.
What I’ve achieved in this phase:
Database Engineering (MySQL): Cleaned and transformed messy supply chain data, moving past "Incorrect DECIMAL" errors and encoding issues to create a math-ready schema.
KPI Development: Built out core metrics including Net Profit, Supplier Lead Times, and Defect Rates to track manufacturing health.
Operational Intelligence: Identified that Carrier B is our logistics powerhouse (5.3-day avg), while Supplier 5 poses a significant risk to the supply chain with 18-day delays.
Advanced Visualization (Power BI): Developed a dark-themed, futuristic dashboard focused on high-level executive cards and correlation line charts.
There are still a few "pending" items to fix (like that 41% inspection bottleneck!), but this project marks the biggest "jump" in my technical journey so far. I’m staying "Locked In" to ensure the final result is bulletproof.
Tools used: 🛠️ Excel (Data Prep) 💻 MySQL (Data Analysis & Cleaning) 📊 Power BI (Business Intelligence)