From the course: Excel and ChatGPT: Data Analysis Power Tips

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Single table analysis

Single table analysis

From the course: Excel and ChatGPT: Data Analysis Power Tips

Start my 1-month free trial Buy for my team

Single table analysis

“

- [Instructor] Alright, so the demos I've shared up to this point have been using some of the earliest versions of ChatGPT, and since then, quite a bit has changed. These next few demos are designed to showcase some of ChatGPT's latest and greatest functionality, including the ability to upload files directly, to scrape data from the web, and collaborate on writing or coding tasks using a dedicated canvas view. Now, keep in mind that some of these features do require a ChatGPT Plus subscription, which is currently $20 a month. And note that I'm going to be using the GPT-4o model for these demos. You could use other models like o1 as well. So without further ado, let's start by exploring that file upload option and use it to analyze a single dataset from a CSV file. So for this demo, let's work with coffee shop transactions. Got this coffee shop sales CSV table. And if we do a quick exploration, we can see it's a pretty small sample of data. Got 500 rows, 499 transactions represented…

Contents