From the course: Excel and ChatGPT: Data Analysis Power Tips
Unlock the full course today
Join today to access over 23,100 courses taught by industry experts.
Generate sample datasets
From the course: Excel and ChatGPT: Data Analysis Power Tips
Generate sample datasets
- [Instructor] All right, if you are a data analyst or an Excel user and you're looking for a fun way to use ChatGPT, here's a great demo for you. I'm going to show you how you can use ChatGPT to generate custom sample data sets that you can use to practice your skills. So check this out. I'm going to walk through a couple different examples. We're going to start with a prompt like this. "I'm a recently hired web analyst for an e-commerce business, looking for sample data that I can use to apply my skills. Can you please produce a sample data set in CSV format containing common fields that web analysts typically encounter on the job?" Let's see what we get back. So, "Certainly, here's a sample dataset in CSV format that contains common fields, often encountered by web analysts." And it's producing the data right here. Looks like we've got columns like timestamp, visitor_id and so on. And check this out. It's actually…
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 Excel1m 43s
-
(Locked)
Explain fundamental Excel concepts8m 54s
-
(Locked)
Generate Excel formulas from descriptions7m 45s
-
(Locked)
Generate DAX and M Code5m 12s
-
(Locked)
Automate tasks with VBA macros4m 52s
-
(Locked)
Generate formulas from sample data6m 6s
-
(Locked)
Ask for Excel data visualization advice4m 53s
-
(Locked)
Produce step-by-step Excel tutorials10m 36s
-
(Locked)
Collaborate on data prep and EDA6m 40s
-
(Locked)
Generate sample datasets5m 14s
-
(Locked)
-