Optimize Supply Chain with Strategic Intelligence DashboardOptimize Supply Chain with Strategic Intelligence Dashboard
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
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)
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started