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
Back to feedPost
Multi-Warehouse Stock Management Command Center
Built for a national office automation group operating across Cape Town, Durban & Johannesburg warehouses.
The Problem: No single view of stock.
Team was managing stock levels across 3 warehouses in Excel. No visibility on what’s on hand vs. on order vs. issued. Overstocking in one warehouse, stockouts in another. No value tracking.
What I Built:Live Power BI Command Center connected directly to SQL Server ERP data.
Top KPIs:24 509 Stock On Hand , 1 548 Parts On Order, 4 561 Parts Issued, 4 Core Modules:
Stock Qty On Hand — breakdown by PartType (Con, HW, Spare, Ton) x WarehouseStock Value On Hand — R35M+ total value tracked live (R13.5M CPT, R9.7M DBN, R11.7M JHB)
Parts Issued — consumption tracking by warehouse to spot trends/anomalies
Parts On Order — pipeline visibility to prevent stockouts
Trend Analysis — Sum of Parts Issued by PartType, Year & Month — 18 months trending
Features:Dynamic date range & slicers (PartType, Warehouse)SQL views with business logic — deduplication, status mapping. Handles large datasets (20K+ SKUs, 3 warehouses, multi-year history)Built for business users + ops team — investigative, not just reporting
Tech Stack: Advanced SQL (CTEs, Joins, Window Functions), SQL Server, Power BI, ERP Integration
Result: Ops team now sees in 10 seconds what took 2 hours in Excel. Prevented stockouts, reduced duplicate orders, gave finance live R35M stock value.
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
Related posts
I Created Microsoft Power BI Dashboard By using many of the Tools
🚀 Data Modelling
🧠 Data Visualization
🚀 Group By
🧠 Data Cleaning
Hello all!
Assembling a few sample performance and analytics dashboards, using randomized dummy data to keep client info private, to refine how reporting gets presented to design and brand partners.
When working on brand, web, or UI/UX projects, what metrics or visual insights do you actually find valuable in a report? Are you looking to see how visual changes impact user engagement and conversion paths, or do you prefer high-level ROI summaries to show clients the impact of your work?
Always open to connecting with designers, agencies, and growth strategists looking to partner on the performance and reporting side of client accounts.
Título: Optimización y Validación de Calidad de Datos
Descripción: Implementé controles para evaluar la calidad de la información almacenada en bases de datos operativas, identificando registros incompletos, duplicados e inconsistentes.
Responsabilidades:
Análisis de calidad de datos.
Validación de registros.
Generación de alertas.
Elaboración de informes de hallazgos.
Herramientas utilizadas:
Excel
SQL
Power BI
Resultado:
Mejora de la confiabilidad de la información.
Reducción de errores en reportes.
Fortalecimiento de procesos de control
