From the course: Enhancing Excel with Generative AI Tools
Join today to access over 24,800 courses taught by industry experts.
Reshape datasets for AI with Power Query
From the course: Enhancing Excel with Generative AI Tools
Reshape datasets for AI with Power Query
- [Instructor] Let's explore how you can manipulate and reshape your data sets using Power Query in Excel, specifically tailored for preparing your data for AI analysis. This is a crucial skill to enhance your data analysis capabilities with AI tools as properly formatted data leads to deeper insights and more accurate outcomes. Follow along, open reshape data with Power Query from your course exercise files. Quick note, make sure to use a starter file here, not the one labeled with solution. The solution file serves as an answer key you can use to compare your work against the finished product at the end of the video. We'll consistently use this format of a starter and a solution workbook throughout the course. Okay, back to our reshape data file. We're working with a wholesale customer's data set from the University of California Irvine's machine learning repository. At first glance, it may look like a typical sales data set, but with closer inspection, you'll see that it's not…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.