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
Overview:
This project is an end-to-end Business Intelligence solution that transforms 100 SKUs of raw supply chain data into a high-level strategic tool. It was born out of a "messy land" phase where I had to backtrack to MySQL and Excel to resolve encoding errors and data-type conflicts before building a responsive, three-page executive dashboard in Power BI.
The Three Pillars of the Dashboard:
Slide 1: Executive Financial Overview
Focus: Core profitability and top-line metrics.
The Big Win: I developed custom DAX measures for Net Profit and Revenue generated, identifying Skincare as the primary profit engine ($217,242). This slide serves as the "Financial Pulse" of the company.
Slide 2: Customer & Market Intelligence
Focus: Demographic spending and regional logistics.
The Big Win: By mapping revenue against location and demographics, I identified that Kolkata is our highest-volume market but suffers from a 19.4-day delivery delay. I proposed a logistics shift based on Delhi's faster 14.6-day model to unlock growth.
Slide 3: Supplier Risk & Quality Audit
Focus: Partner performance and manufacturing health.
The Big Win: This is the "Risk" engine. I uncovered a massive liability with Supplier 4, who carries the highest manufacturing costs ($62.71) but holds a 0% inspection pass rate. This provides an immediate, data-backed recommendation for procurement offboarding.
Technical Execution:
Data Engineering: Used MySQL to sanitize product types and create a math-ready schema, overcoming "Incorrect DECIMAL" errors that initially broke the responsiveness of the dashboard.
Advanced Analytics: Built a Weighted Defect Rate measure to identify quality outliers and a Product Affinity Heatmap to show which demographics buy which products.
UI/UX Design: Implemented a futuristic "Dark Mode" theme with neon accents and interactive slicers to allow executives to drill down into specific categories or regions instantly.
The "Jump":
This work represents a move beyond simple data reporting. It demonstrates the ability to audit one's own errors, go back to the source code to fix them, and deliver a "bulletproof" product that connects backend logistics to front-end profit.
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
Trending
retrofuturism
Share your favorite designs from the past exploring the distant future. Or your own take on the aesthetic 🚀
halftone
Dots. Texture. Grain. Let's see your designs using the halftone technique.
Midjourney
Creatives are showing off what they're making with Midjourney.
colorgrade
Video editors sound off: How do you enhance the mood of your video in color grading?
Related posts
:This is a self created portfolio demonstrating my Excel data management and analysis skills. I can work with various Excel features including data entry, data formatting, data validation,formulas, sum if/sum ifs conditional formatting, consolidation and reporting. This samples demonstrates my ability to turn raw data into clean, organised, and useful information.
Power BI dashboard created to analyze HR metrics such as employee count, salary, attrition, work modes, and performance, helping identify trends and support decision-making.
I build custom Power BI dashboards that turn raw numbers into clear, actionable insights. From organizing backend data models with SQL and Power Query to writing custom DAX and designing clean reports, I help businesses make sense of their data without the headache.
