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.
Collaborate on data prep and EDA
From the course: Excel and ChatGPT: Data Analysis Power Tips
Collaborate on data prep and EDA
- [Instructor] Alright, so one use case that I've been exploring that I'm really excited about and impressed with is using tools like ChatGPT and Bard to collaborate on things like data prep and exploratory analysis. It's such a great way to leverage the conversational nature of these tools and actually learn quite a bit along the way. So let me show you an example of what this might look like. Here in ChatGPT, I'm going to drop in a prompt like this. "I just exported a raw CSV file containing web traffic data. Could you please act like a data quality assurance engineer and give me a step-by-step plan to help me QA and prepare my data for analysis?" So you can see I'm really trying to set clear context here with this prompt. I'm describing the type of data that I'm analyzing. I'm specifying the role that I want ChatGPT to play, and I'm providing clear guidance on the type of output that I'm looking for, a step-by-step…
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)
-