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.

Multi-table analysis

Multi-table analysis

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

Start my 1-month free trial Buy for my team

Multi-table analysis

“

- [Instructor] Okay, so we just saw an example of how ChatGPT can analyze a single simple dataset. Now let's crank up the difficulty and try uploading multiple files. For this example, we'll use data from Maven Electronics, a fictitious global retailer. And you can see from this data model here that we have a number of tables to work with. We've got a sales table, this is our fact table containing transactional records. We've got a bunch of dimension tables with details about stores, customers, exchange rates, products, subcategories, categories, and calendar fields. And we also have a dedicated table with some measures that I've defined to calculate things like orders, revenue, and delivery time. Now, in this case, I've already done all the hard work. I've used Power Query, Power Pivot, and DAX to load up the data, create this relational model, and define the calculations and measures that I need. But instead of trying to feed this model into ChatGPT, let's actually try importing…

Contents