This beginner-friendly course helps users leverage Power BI and ChatGPT together to work more efficiently and make smarter, data-driven decisions.
Overview
Syllabus
Introduction
- The future is now: Intro to AI for data analytics
- Setting expectations
- Why AI is a game changer for data analysis
- AI use cases for data analytics
- The AI landscape
- Generative AI and large language models
- The road to ChatGPT
- Generative AI tools
- Warning: Pitfalls of ChatGPT
- Accessing ChatGPT and Google Bard
- Intro to prompt engineering
- Prompt tip: Be clear and specific
- Prompt tip: Provide context
- Prompt tip: Establish roles
- Prompt tip: Set the tone
- Intro to ChatGPT for Power BI
- Getting started with ChatGPT for Power BI
- Connect to data from Power BI
- Create a data dictionary
- Format and comment power query code
- Explain fundamental Power BI concepts
- Generate DAX from examples
- Explain and comment DAX code
- Generate DAX measures from scratch
- Troubleshoot DAX errors
- Visualize data with Power BI
- Build a Power BI dashboard
- Key takeaways and next steps
Taught by
Maven Analytics and Aaron Parry
