E-Commerce Sales Power BI Dashboard | Hands-On Workshop скачать в хорошем качестве

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-p... 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-p... Learn about ZoomCharts: https://zoomcharts.com/en/microsoft-p... 𝗪𝗵𝗮𝘁 𝗶𝘀 𝘁𝗵𝗲 𝗠𝗼𝗻𝘁𝗵𝗹𝘆 𝗗𝗮𝘁𝗮 𝗖𝗵𝗮𝗹𝗹𝗲𝗻𝗴𝗲? 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-p... LinkedIn:   / zoomcharts   Facebook:   / zoomcharts   Instagram:   / zoomcharts   X.com: https://x.com/zoomcharts #powerbitutorial #ecommerce #ecommerceanalytics #powerbivisuals #powerbi #dataviz Subscribe for more videos 🔔