Dorcas_Akinnibosun.xlsxOpen to work · Lagos · Remote, home page
← All case studiesCase study 02 · Retail & sales

Maven Electronics Sales Performance

A 4-page Power BI report for a global electronics retailer: what sells, who buys, which stores carry the business and where revenue is slipping.

BriefToolsDataDashboard
Maven ElectronicsPower BI26.3K orders · 15.3K customers · 67 stores · 5 linked tables4 pages · 15+ KPIs
Interactive

Don't just look at it. Click through it.

This is the real, published Power BI report. Use the slicers, change pages and click any visual to cross-filter the rest, the same way a manager would use it.

Real Power BI reports, published from my workspace. Nothing here is a mock-up: filter, drill and cross-highlight like a stakeholder would.

Page by page · screenshots

Object · Maven Electronics dashboard · dark theme1 / 4
Maven Electronics Sales Performance: Overview dashboard pageFull size ↗

Overview. Executive overview: revenue, profit, customers and unit price against the prior year, the revenue and profit trend, segments and categories.

The brief

Sales, customers & store performance

Note · the problem

Maven Electronics is a multinational electronics retailer with several years of transaction data across products, customers, regions, sales channels and stores.

The goal was to find patterns in revenue, spot high-performing products and regions, understand customer demographics and compare store performance. I modelled five raw tables (sales, customers, stores, products and exchange rates) into a star schema and built a four-page Power BI report with page navigation, DAX time intelligence and drill-through.

TechniquesUsed
Star-schema data modelTRUE
DAX: YoY, YTD, PY, Top NTRUE
Time intelligenceTRUE
Power Query cleaningTRUE
Bookmarks & page navigationTRUE
Drill-through & tooltip pagesTRUE
Key insights

What the data said.

#Key numberFinding
1+12.1%Growth, then a 2020 dipRevenue reached $55.8M, up 12.1% year on year. Revenue and profit peaked in 2019 and declined from 2020, likely tied to wider market shifts. The average unit price held steady at $356.8.
2SatSaturdays and Thursdays drive ordersCustomers order most on Thursdays and Saturdays, with Saturday the single busiest day.
384.6%Loyal customers carry the businessLoyal customers make up 84.6% of the base: strong retention, but a sign the business may be saturating. Millennials and Gen Z are buying more.
4$23.8MThe US leads; France trailsThe United States earns $23.8M, while France brings in $1.2M. The top five stores account for a large share of store revenue.
520.4%Online is under-usedPhysical stores generate 79.55% of revenue and online only 20.45%, leaving room to grow the online channel.
Recommendations

What to do next.

#Recommendation
1Sell harder on peak daysConcentrate promotions, flash sales and email pushes on Thursdays and Saturdays, when buying intent is naturally high.
2Grow the online channelReduce checkout friction, improve the platform experience and add online-exclusive offers.
3Lift low-revenue regionsUse localised marketing, product bundles and partnerships in regions like France ($1.2M).
4Reward loyaltyAdd tiered rewards, referral bonuses and personalised promotions for the 84.6% loyal base.
5Stock for the winnersKeep stock levels right for Computers and Home Appliances, and use bundles and dynamic pricing in top categories.
Outcome

A complete, interactive Power BI report that helps Maven Electronics understand revenue drivers, track product performance, compare stores and regions, and back strategic decisions with data.

Data source

Datasets provided by Tina Okonkwo as a practical assignment in a Power BI cohort. All cleaning, modelling and visuals were done independently by Dorcas.

Next case study ▸HeartSync Product AnalyticsA 5-page Power BI product report for a global dating app, following the user journey from sign-up to match, subscription and safety reports.
Contact

=IF(you_have_data, "let's look at it together", "say hello anyway")

Whether it's a role, a messy spreadsheet or a question about one of the case studies, messages come straight to my inbox.

Open to data analyst and BI work: full-time, contract or freelance, remote or on-site