E-Commerce Sales Power BI Dashboard: Hands-On Workshop

Build a clean, focused Power BI report for e-commerce sales—step by step. Join ZoomCharts Product Expert Aivis Pavlovs to prep the dataset in Power Query, create the right measures, and design visuals that answer real business questions without clutter.

???? Get Dataset & Read about the challenge: : https://zoomcharts.com/en/microsoft-power-bi-custom-visuals/challenges/onyx-data-november-2025?utm_source=youtube&utm_medium=social&utm_campaign=onyx-daya-november-2025-workshop&utm_content=see-the-challenge-reports

In this video, you will learn how to:
Set up column profiling/quality and remove blank rows in Power Query
Create conditional columns (e.g., Region fix), refund flags, and clean labels
Build net revenue & quantity measures and switch with field parameters
Use Timeline and Donut (with native KPI) for fast drill-down exploration
Add a Reset bookmark and slicer search for a friendly report UX

00:00 What we’ll cover & logistics
02:00 Free developer license for ZoomCharts visuals
03:40 What comes with the dataset (brief, cheat sheet, data dictionary)
10:00 Power Query: profiling, removing blank rows
13:40 Region cleanup with conditional column (future-proofing)
21:50 Refunds: flags vs. date logic; what “null” means
24:10 Net revenue logic: quantity × price − discounts − refunds (notes on limits)
26:00 Visual choices: donuts vs. bars, color restraint
30:45 Field parameters to toggle KPIs (Revenue/Quantity)
31:00 Native KPI in Donut—simpler than overlay cards
35:45 Region/Country breakdown and when to skip maps
36:50 Refunds by channel; ratio thinking
37:40 Resale models (affiliate/marketplace/direct)
38:50 Shortening long product names & extracting attributes
39:45 Overview page + customer profile page pattern
40:55 The must-have Reset button (bookmark + action)
43:35 Date table to fact table; common Q&A tips
60:00 Wrap-up & feedback

Enhance your reports with interactive visuals! https://zoomcharts.com/en/microsoft-power-bi-custom-visuals/all-visuals/?utm_source=youtube&utm_medium=social&utm_campaign=onyx-daya-november-2025-workshop&utm_content=enhance-your-reports-with-interactive-visuals

Learn about ZoomCharts: https://zoomcharts.com/en/microsoft-power-bi-custom-visuals/?utm_source=youtube&utm_medium=social&utm_campaign=onyx-daya-november-2025-workshop&utm_content=learn-about-zoomcharts

???????????????? ???????? ???????????? ???????????????????????????? ???????????????? ????????????????????????????????????? Each month, a new dataset is provided for you to create your next Power BI report. Join us today to sharpen your Power BI skills! https://zoomcharts.com/en/microsoft-power-bi-custom-visuals/challenges/?utm_source=youtube&utm_medium=social&utm_campaign=onyx-daya-november-2025-workshop&utm_content=monthly-data-challenge

LinkedIn: https://www.linkedin.com/company/zoomcharts
Facebook: https://www.facebook.com/zoomcharts
Instagram: https://www.instagram.com/zoomcharts
X.com: https://x.com/zoomcharts

#powerbitutorial #ecommerce #ecommerceanalytics #powerbivisuals #powerbi #dataviz
Subscribe for more videos ????