From the course: ChatGPT and Power BI
Unlock this course with a free trial
Join today to access over 24,800 courses taught by industry experts.
Connect to data from Power BI
From the course: ChatGPT and Power BI
Connect to data from Power BI
- [Instructor] For this demo, I want to explore how LLMs can help explain how to connect to data. So let's pretend that you've just been hired as a data analyst for a stuffed animal company called the Maven Fuzzy Factory, and you need to start creating a report in Power BI that's based on their existing data and technology platforms. You've been given access to the company's MySQL database, and you need to get data from the database into Power BI, but you're not quite sure how to do it. Plus, you're the first analyst that's been hired, so you don't have anybody else that you can really ask or have an existing report to reference to see how the connection works. So let's see if ChatGPT can help us out here. So I'm going to use a prompt here, and it basically says, "Hey, I've just been hired as a data analyst for Maven Fuzzy Factory, and I need to import data from their MySQL database into Power BI. I have access to MySQL, but I'm not sure how to connect. Can you help me?" So let's see…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Intro to ChatGPT for Power BI1m 46s
-
(Locked)
Getting started with ChatGPT for Power BI5m 19s
-
(Locked)
Connect to data from Power BI9m 15s
-
(Locked)
Create a data dictionary6m 18s
-
(Locked)
Format and comment power query code5m 39s
-
(Locked)
Explain fundamental Power BI concepts7m 52s
-
(Locked)
Generate DAX from examples7m 23s
-
(Locked)
Explain and comment DAX code4m 53s
-
(Locked)
Generate DAX measures from scratch8m 18s
-
(Locked)
Troubleshoot DAX errors6m 14s
-
(Locked)
Visualize data with Power BI8m 14s
-
(Locked)
Build a Power BI dashboard6m 42s
-
(Locked)
-