Power BI E-Commerce Revenue Growth Diagnostic Case Study

Power BI E-Commerce Revenue Growth Diagnostic Case StudyPower BI E-Commerce Revenue Growth Diagnostic Case Study

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

Walid Chibi

• 3h

Case study on 100K+ real e-commerce orders (Olist dataset): why did revenue growth stop? I built a 6-page Power BI diagnostic star schema, 25+ DAX measures (revenue decomposition into volume vs. basket effects, MoM/YoY, CROSSFILTER) plus a plain-English executive report with a 30/60/90 action plan. Key findings: orders flatlined at 6.6K/month; 97% of buyers never return; one region carries 38.4% of revenue; one category hides a 15.7% decline. Full pipeline on GitHub: Python ETL, SQL validation, dashboard, report.

Completed work

Microsoft Power BI Data Analysis Database Development Data Visualization Microsoft Excel SQL

Orbix Studio

max

• Oct 1

Real estate dashboards are usually built for data entry. Aurex Living was built for decision-making.

$873,42.39 total revenue. 1,269 completed deals this month. $276K sold, $346K rented. Property cards, agent tracking, map view, average sale value trending +10% - every number a real estate operator actually needs, on one clean white canvas.

Check it out

Completed work

Data Analysis UX Design dashboard UI Design Figma

Suba Sundar

• Oct 1

📊 Turn Your Excel Data Into a Clear Business Dashboard

Still managing your business reports in Excel and spending hours trying to understand your numbers?

I help small businesses turn their existing Excel/CSV data into simple, interactive Power BI dashboards.

With a dashboard, you can quickly track:

• 📈 Sales performance • 🏆 Top-selling products • 👥 Customer trends • 🏪 Store/branch performance • 📦 Product performance • 🎯 KPIs and monthly targets

I recently built a retail analytics dashboard using Power BI, with data cleaning and transformation using Excel/Power Query.

I'm currently looking to work with small businesses, retailers, and growing teams that want their data to be easier to understand and use.

💬 If you already maintain your business data in Excel, feel free to message me. I'd be happy to show you what a dashboard could look like for your business.

Completed work