ChatGPT & Generative AI for Data Analytics
Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
ChatGPT & Generative AI for Data Analytics
Instructor: Maven Analytics
5,481 already enrolled
Included with
Ask Coursera
23 reviews
Recommended experience
23 reviews
Recommended experience
What you'll learn
Explore powerful AI use cases for data science and analytics, including generating code, debugging and optimizing queries, automating tasks and more
Learn prompt engineering tips and best practices to get the most out of tools like ChatGPT and Gemini
See examples of using generative AI to work smarter with tools like Excel, Google Sheets, Power BI, SQL and Python
Skills you'll gain
Details to know
See how employees at top companies are mastering in-demand skills
There are 7 modules in this course
As data professionals in the age of AI, 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.
In this module we'll introduce the course curriculum, set expectations, and download the resources you'll need to follow along from home. We'll explore the AI landscape, introduce powerful and practical use cases for data professionals, and share prompt engineering tips and best practices to help you integrate generative AI into your daily workflow.
What's included
16 videos2 readings1 assignment1 discussion prompt
16 videos•Total 37 minutes
- Course Structure & Outline•2 minutes
- Meet Your Instructors•1 minute
- Setting Expectations•2 minutes
- Why Data Professionals Need to Use AI•4 minutes
- AI Use Cases for Data Analytics•2 minutes
- The AI Landscape•3 minutes
- Generative AI & Large Language Models•5 minutes
- The Road to ChatGPT•5 minutes
- Generative AI Tools•2 minutes
- WARNING: Pitfalls of ChatGPT•3 minutes
- Accessing ChatGPT & Gemini•2 minutes
- Intro to Prompt Engineering•2 minutes
- Prompt Tip: Be Clear & Specific•1 minute
- Prompt Tip: Provide Context•1 minute
- Prompt Tip: Establish Roles•1 minute
- Prompt Tip: Set the Tone•1 minute
2 readings•Total 20 minutes
- Welcome to ChatGPT & Generative AI for Data Analytics!•10 minutes
- DOWNLOAD: Course Resources•10 minutes
1 assignment•Total 30 minutes
- Implementing Gen AI in your workflow•30 minutes
1 discussion prompt•Total 10 minutes
- Introduce yourself!•10 minutes
In this module we'll demonstrate how to leverage tools like ChatGPT with Excel, including generating and troubleshooting formulas, automating tasks, creating sample datasets, and more.
What's included
15 videos1 assignment
15 videos•Total 93 minutes
- Intro to ChatGPT for Excel•2 minutes
- DEMO: Explain Fundamental Excel Concepts•9 minutes
- DEMO: Generate Excel Formulas From Descriptions•8 minutes
- DEMO: Generate DAX & M Code•5 minutes
- DEMO: Automate Tasks with VBA Macros•5 minutes
- DEMO: Generate Formulas From Sample Data•6 minutes
- DEMO: Ask for Excel Data Visualization Advice•5 minutes
- DEMO: Troubleshoot Excel Formula Errors•6 minutes
- DEMO: Produce Step-by-Step Excel Tutorials•11 minutes
- DEMO: Collaborate on Data Prep & EDA•7 minutes
- DEMO: Generate Sample Datasets•5 minutes
- DEMO: Single-Table Analysis•9 minutes
- DEMO: Multi-Table Analysis•10 minutes
- DEMO: The Canvas Interface•3 minutes
- DEMO: Scraping Data from the Web•3 minutes
1 assignment•Total 30 minutes
- Integrating ChatGPT into your Excel Workflow•30 minutes
In this module we'll demonstrate how to leverage tools like ChatGPT with Google Sheets, including generating formulas from sample data or descriptions, applying conditional formats, writing apps scripts, and more.
What's included
8 videos1 assignment
8 videos•Total 57 minutes
- Intro to ChatGPT for Google Sheets•1 minute
- DEMO: Explain Google Sheets Formulas•9 minutes
- DEMO: Troubleshoot Google Sheets Formula Errors•12 minutes
- DEMO: Generate Google Sheets Formulas from Descriptions•13 minutes
- DEMO: Apply Formula-Based Conditional Formats•5 minutes
- DEMO: Add Sparklines & Data Bars to Google Sheets•6 minutes
- DEMO: Write Regular Expressions (REGEX) in Google Sheets•4 minutes
- DEMO: Automate Tasks with Apps Scripts•7 minutes
1 assignment•Total 30 minutes
- Integrating ChatGPT into your Google Sheets Workflow•30 minutes
In this module we'll demonstrate how to leverage tools like ChatGPT with Power BI, including formatting and commenting DAX and M code, explaining technical concepts, generating and troubleshooting measures, and more.
What's included
12 videos1 assignment
12 videos•Total 78 minutes
- Intro to ChatGPT for Power BI•2 minutes
- DEMO: Get Started with Power BI•5 minutes
- DEMO: Explain How to Connect to Data•9 minutes
- DEMO: Create a Data Dictionary•6 minutes
- DEMO: Format & Comment Power Query Code•6 minutes
- DEMO: Explain Fundamental Power BI Concepts•8 minutes
- DEMO: Generate DAX Examples•7 minutes
- DEMO: Explain & Comment DAX Code•5 minutes
- DEMO: Generate New DAX Measures•8 minutes
- DEMO: Troubleshoot DAX Errors•6 minutes
- DEMO: Ask for Power BI Data Visualization Advice•8 minutes
- DEMO: Build a Power BI Dashboard•7 minutes
1 assignment•Total 30 minutes
- Integrating ChatGPT into your Power BI Workflow•30 minutes
In this module we'll demonstrate how to leverage tools like ChatGPT with SQL, including commenting and optimizing code, debugging and troubleshooting, generating new queries and more.
What's included
7 videos1 assignment
7 videos•Total 45 minutes
- Intro to ChatGPT for SQL•1 minute
- DEMO: Explain Fundamental SQL Concepts•6 minutes
- DEMO: Explain a SQL Query•7 minutes
- DEMO: Add Comments to a SQL Query•5 minutes
- DEMO: Debug & Troubleshoot SQL Code•8 minutes
- DEMO: Create a SQL Query from Scratch•8 minutes
- DEMO: Optimize a SQL Query•10 minutes
1 assignment•Total 30 minutes
- Integrating ChatGPT into your SQL Workflow•30 minutes
In this module we'll demonstrate how to leverage tools like ChatGPT with Python, including generating and commenting code, researching libraries, scraping web data, interpreting machine learning models and more.
What's included
11 videos1 assignment
11 videos•Total 51 minutes
- Intro to ChatGPT for Python•1 minute
- DEMO: Explain Python Code•7 minutes
- DEMO: Add Comments to Python Code•3 minutes
- DEMO: Optimize Python Code for Efficiency•5 minutes
- DEMO: Troubleshoot Python Errors•5 minutes
- DEMO: Generate New Python Code from Scratch•6 minutes
- DEMO: Generate Python Code for Data Visualization•5 minutes
- DEMO: Quickly Research Python Libraries•4 minutes
- DEMO: Python Web Scraping•6 minutes
- DEMO: Interpret Machine Learning Models in Python•5 minutes
- DEMO: ChatGPT Extension For Jupyter Notebooks•5 minutes
1 assignment•Total 30 minutes
- Integrating ChatGPT into your Python Workflow•30 minutes
In this module we'll recap the key takeaways from the course and discuss the next steps of your learning journey.
What's included
2 videos1 assignment
2 videos•Total 5 minutes
- Key Takeaways•4 minutes
- More from Maven Analytics•1 minute
1 assignment•Total 30 minutes
- Reflecting on your experience with Gen AI•30 minutes
Instructor
Offered by
Why people choose Coursera for their career
Learner reviews
- 5 stars
82.60%
- 4 stars
13.04%
- 3 stars
4.34%
- 2 stars
0%
- 1 star
0%
Showing 3 of 23
Reviewed on Jan 19, 2025
one good start and guide to AI world with practical tips and useful explanations
Frequently asked questions
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
More questions
Financial aid available,