Using Power BI for Consumer Financial Complaints Analytics | Workshop

Описание: Build a practical Power BI report for consumer financial complaints- start to finish. Follow along as Aivis Pavlovs (Senior Product Expert, ZoomCharts) prepares the dataset, models relationships, creates DAX measures for KPIs like average response time, and designs an interactive report with ZoomCharts visuals to explore trends by channel, time, and region.

📥 Get Dataset & Read about the challenge: https://zoomcharts.com/en/microsoft-p...

In this workshop, you will learn how to:

• Set up the ZoomCharts Developer License via theme JSON
• Prepare and model the data in Power Query
• Create core DAX measures (counts, min/max/average response time)
• Build drillable timelines, donut KPIs, and map views
• Use bookmarks, Reset, and Apply all slicers for clean UX
• Tune display periods, zoom, and clustering for performance
• Add dynamic titles and tidy filter panels

Timestamps
00:00 Intro & goals
01:00 ZoomCharts Developer License: setup & scope
09:00 Dataset overview, data dictionary, Power Query tips
13:30 KPIs & DAX for response time and counts
16:00 TimeSeries: display periods, drill/zoom, toolbar cleanup
21:30 Donut: KPI in-center, “Other” grouping, sizing modes
29:00 Bookmarks & Reset; Apply all slicers; collapsible filters
41:30 Performance considerations with bookmarks/panels
45:50 Map design: clustering, shape layers, zoom levels
53:50 Layout choices, testing with users, wrap-up

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

Subscribe for more ZoomCharts Power BI tutorials! #powerbi #zoomcharts #dax #powerbivisuals #financialanalytics