Power BI Sales Report: Build a Festive Dashboard
In this hands-on Power BI workshop, Federico Pastor (FP20 Analytics) and Aivis Pavlovs (ZoomCharts) show how to clean and transform a retail dataset, fix common pitfalls (types, labels, lat/long), and design interactive, audience-friendly visuals. You’ll learn practical modeling choices, age binning, event/seasonality checks, and when to use custom visuals to make stories easier to read and explore.
📥 Get Dataset & Read about the challenge: : https://zoomcharts.com/en/microsoft-p...
Clean columns, data types, and labels for clarity
Fix latitude/longitude headers and map Canadian regions via GeoJSON
Create dimensions, measures, and “Amount To Pay”
Compare online vs. in-person and returns vs. satisfaction
Use age bins, field parameters, and intuitive slicers/search
Apply a restrained holiday palette and simple iconography
When to switch from native visuals to interactive custom visuals
Timestamps
0:00 Intro, agenda, Q&A format
3:28 Dataset quirks to notice (IDs, booleans, lat/long)
4:54 Power Query cleanup: choose columns, types, replacements
7:16 Latitude/Longitude header fix; sanity checks
10:56 Converting True/False flags to user-friendly labels
12:45 Calculated column: Amount To Pay
13:30 Dimensions from references; closing & applying changes
15:19 Transaction volume overview
19:17 UX choices: labels vs. flags; order type naming
20:06 Age profiling, bins vs. lists; audience-first grouping
24:27 Map setup; using public GeoJSON safely
27:51 Timeline split: online vs. in-person; seasonality focus
30:12 Event context (Black Friday/Christmas)
31:03 Returns & satisfaction; reading the signal
32:41 Weather impact on shopping patterns
35:01 Visual storytelling ideas (icons, ratings)
36:12 Holiday palette tips (avoid red/green overload)
41:33 Feedback & resources; giveaway reminder
51:42 Field parameters for flexible hierarchies
55:04 Where to learn more; ZoomCharts developer license
55:54 Wrap-up & holiday wishes
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...
Follow us for more Power BI insights:
LinkedIn: / zoomcharts
Facebook: / zoomcharts
Instagram: / zoomcharts
X.com: https://x.com/zoomcharts
#PowerBI #DataVisualization #PowerBIReporting #SalesAnalysis #DataCleaning #BusinessIntelligence #PowerBIDashboard #PowerBIWorkshop #zoomcharts #builtwithzoomcharts #interactivedashboards #interactivereports #timeline #datachallenge
🔔 Don't forget to subscribe and hit the bell icon to stay updated on our latest Power BI tutorials and interactive visuals!