Create a sales dashboard in Power BI with the help of ChatGPT and Zebra BI visuals! 🚀
Download the full sales template 👉👉👉 https://bit.ly/3BrkfCF
Join our free PBI Course Academy 👉👉👉 https://bit.ly/4iGxZtX
In this video, we team up with ChatGPT to build a dynamic sales dashboard in Power BI from scratch. Watch as we integrate Zebra BI visuals, create a custom calendar table, calculate actual vs. previous year data, and add an option for dynamic measure selection. Perfect for analysts, finance pros, and business managers ready to take their reporting to the next level!
Timestamps
00:00 - Introduction
00:44 - Exploring the data and understanding the structure
02:15 - Overview: What we’ll build in this video
03:07 - First prompt: Getting started with ChatGPT and Power BI
07:17 - Importing data into Power BI
11:10 - Creating a calendar table for time intelligence
12:53 - Second prompt: Enhancing the dashboard with ChatGPT's help
18:36 - Creating measures for Revenues and Costs
22:08 - Using slicers and visualizing the new measures
26:26 - Third prompt: Adding a Dynamic Measure Selector with a Slicer
34:57 - Building the interactive dashboard
37:42 - Fourth prompt: Setting a default measure for visuals
41:30 - Sorting months correctly in Power BI and building the final dashboard
📧 Contact us
info@zebrabi.com
📱Socials
Get updates & reach out on our Social Media Profiles!
Twitter: https://twitter.com/zebrabi
Facebook: https://www.facebook.com/zebra.bi/
LinkedIn: https://www.linkedin.com/company/5051039
#powerbi #chatgpt #salesdashboard