Power BI: Working Together with ChatGPT
48mIntermediate2023-12-18
Authors
Joshua Rischin
Company Director of Axium Solutions
Course details
ChatGPT may be seen as a barrier for some, and there are inherent risks in its use, but as you lean into the technology in a Power BI context, you can use chat-driven AI to enhance your Power BI experience. In this course, instructor Joshua Rischin explains what Power BI and ChatGPT are and how you can use them together. Then he focuses on data integration, data manipulation, and data analysis, with detailed explanations and practical challenges for each main topic. It’s important to be aware of the strengths and weaknesses of ChatGPT, but AI is here to stay, and with this course, you can get a head start on using it effectively with Power BI.
Skills covered
Power BIChatGPTOpenAIBusiness AnalyticsBusiness IntelligenceAI Productivity ToolsData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftOne-Off
Concepts
0. Introduction
- 01 - Working with Power BI and ChatGPT
- 02 - What you should know
1. Understanding Power BI and OpenAI
- 03 - What is Power BI
- 04 - What is ChatGPT
- 05 - How can Power BI be used effectively with ChatGPT
2. Power BI ChatGPT Data Integration
- 06 - Data source troubleshooting
- 07 - Types of data connectors
- 08 - Connecting with data
- 09 - Challenge - Use ChatGPT to guide you on connecting with an Excel file
- 10 - Solution - Use ChatGPT to guide you on connecting with an Excel file
3. Power BI ChatGPT Data Manipulation
- 11 - Why use ChatGPT for data manipulation
- 12 - Changing field types
- 13 - Working with filters
- 14 - Merging fields
- 15 - Extracting part of a field
- 16 - Creating calculated fields
- 17 - Challenge - Use ChatGPT to guide you on changing the format of a data field
- 18 - Solution - Use ChatGPT to guide you on changing the format of a data field
4. Power BI ChatGPT Data Analysis
- 19 - Why use ChatGPT for data analysis
- 20 - Creating visualizations
- 21 - Idea generation
- 22 - Challenge - Use ChatGPT to guide you on creating a card visualization
- 23 - Solution - Use ChatGPT to guide you on creating a card visualization
Continuing Your Power BI and Generative AI Learning Journey
- 24 - Where to learn more about ChatGPT