Self-Paced Course
ChatGPT for Data Analytics
Leverage AI tools like ChatGPT and Bard to work smarter and faster with Excel, Google Sheets, Power BI, SQL and Python.
Course Description
AI is changing the world around us, and completely revolutionizing the way we work.
As data professionals, we now have access to tools that give us superpowers to work smarter and faster than ever before.
In this course we’ll introduce you to the world of deep learning and generative AI, explore the rapid rise of large language models like ChatGPT and Gemini, and get you up and running with free tools that will take your skills and productivity to the next level.
We’ll dive into the art of prompt engineering, review tips and best practices for generating consistent, accurate model outputs, and address common limitations and pitfalls to be aware of.
From there, we’ll walk through some of the most powerful and practical ChatGPT use cases for data science and analytics, with instructor-led demos in Excel, Google Sheets, Power BI, SQL and Python.
You’ll practice using ChatGPT to explain and interpret code, generate formulas from scratch, diagnose and troubleshoot errors, optimize complex queries, automate manual tasks, and much more.
This course is beginner-friendly, and designed for anyone who wants to leverage modern technology to work more efficiently, and make smarter, data-driven decisions.
- Course Structure & Outline
- DOWNLOAD: Course Resources
- Meet Your Instructors
- Setting Expectations
- Why Data Professionals Need to Use AI
- AI Use Cases for Data Analytics
- The AI Landscape
- Generative AI & Large Language Models
- The Road to ChatGPT
- Generative AI Tools
- WARNING: Pitfalls of ChatGPT
- Accessing ChatGPT & Google Bard
- Intro to Prompt Engineering
- Prompt Tip: Be Clear & Specific
- Prompt Tip: Provide Context
- Prompt Tip: Establish Roles
- Prompt Tip: Set the Tone
- Intro to ChatGPT for Excel
- DEMO: Explain Fundamental Excel Concepts
- DEMO: Generate Excel Formulas From Descriptions
- DEMO: Generate DAX & M Code
- DEMO: Automate Tasks with VBA Macros
- DEMO: Generate Formulas From Sample Data
- DEMO: Ask for Excel Data Visualization Advice
- DEMO: Troubleshoot Excel Formula Errors
- DEMO: Produce Step-by-Step Excel Tutorials
- DEMO: Collaborate on Data Prep & EDA
- DEMO: Generate Sample Datasets
- Intro to ChatGPT for Google Sheets
- DEMO: Explain Google Sheets Formulas
- DEMO: Troubleshoot Google Sheets Formula Errors
- DEMO: Generate Google Sheets Formulas from Descriptions
- DEMO: Apply Formula-Based Conditional Formats
- DEMO: Add Sparklines & Data Bars to Google Sheets
- DEMO: Write Regular Expressions (REGEX) in Google Sheets
- DEMO: Automate Tasks with Apps Scripts
- Intro to ChatGPT for Power BI
- DEMO: Get Started with Power BI
- DEMO: Explain How to Connect to Data
- DEMO: Create a Data Dictionary
- DEMO: Format & Comment Power Query Code
- DEMO: Explain Fundamental Power BI Concepts
- DEMO: Create New Calculated Columns
- DEMO: Explain & Comment DAX Code
- DEMO: Generate New DAX Measures
- DEMO: Troubleshoot DAX Errors
- DEMO: Ask for Power BI Data Visualization Advice
- DEMO: Build a Power BI Dashboard
- Intro to ChatGPT for SQL
- DEMO: Explain Fundamental SQL Concepts
- DEMO: Explain a SQL Query
- DEMO: Add Comments to a SQL Query
- DEMO: Debug SQL Code
- DEMO: Create a SQL Query from Scratch
- DEMO: Optimize a SQL Query
- Intro to ChatGPT for Python
- DEMO: Explain Python Code
- DEMO: Add Comments to Python Code
- DEMO: Optimize Python Code for Efficiency
- DEMO: Troubleshoot Python Errors
- DEMO: Generate New Python Code from Scratch
- DEMO: Generate Python Code for Data Visualization
- DEMO: Quickly Research Python Libraries
- DEMO: Python Web Scraping
- DEMO: Interpret Machine Learning Models in Python
- DEMO: ChatGPT Extension For Jupyter Notebooks
- Key Takeaways
- Course Feedback Survey
- Share the love!
- Next Steps
WHO SHOULD TAKE THIS COURSE?
Data professionals who want to stay ahead of the skills curve and leverage AI to work smarter and more efficiently
Excel, Sheets, Power BI, SQL or Python users looking for practical tips and case studies for working with ChatGPT and Google Bard
Analysts or Data Scientists looking for a brief history of artifical intelligence, deep learning and large language models
WHAT ARE THE COURSE REQUIREMENTS?
This is a beginner-friendly course (no advance preparation required)
Excel, Sheets, Power BI, SQL and Python will be used for course demos, but you do not need access to these tools to follow along
Start learning for FREE, no credit card required!
Every subscription includes access to the following course materials
- Interactive Project files
- Downloadable e-books
- Graded quizzes and assessments
- 1-on-1 Expert support
- 100% satisfaction guarantee
- Verified credentials & accredited badges
Ready to become a
data rockstar?
Start learning for free, no credit card required!