E-Commerce Challenge

Summary

This Power BI report uses the e-commerce sales dataset from a global software retailer that sells subscriptions and add-ons across analytics, design, collaboration, and AI. The report features ZoomCharts Drill Down PRO custom visuals for Power BI. It was submitted to the Onyx Data DataDNA ZoomCharts Mini Challenge in October 2025.

Author description:

This model brings together 48,000 events across 4,000 customers and 101 products, revealing $9.38M in net revenue, 14,399 orders, 86,259 units sold, and an Average Order Value of $651.34. One insight that stood out immediately: 3,503 loyal customers drive ~97.7% of total revenue, showing how critical retention is in this business. I designed the dashboard to uncover real commercial levers, identifying high-performing products and vendors, understanding how channels influence purchasing behaviour, and spotlighting where refund rates and attach-rate opportunities lie. I also explored customer loyalty patterns, regional sales differences, and category revenue drivers, building DAX measures and a clean data model to support deep analysis. This project sharpened my skills in modelling, Power Query transformations, UX layout, and creating insights that non-technical users can act on.