From the course: Utilizing Excel, Python, and Copilot as a Citizen Data Scientist

Unlock this course with a free trial

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

Data ingestion methods in Power Query

Data ingestion methods in Power Query

From the course: Utilizing Excel, Python, and Copilot as a Citizen Data Scientist

Start my 1-month free trial Buy for my team

Data ingestion methods in Power Query

“

- [Instructor] Now, in some of our previous videos, we talked about the role of an AI citizen data scientist, how they use a combination of large language models and AI workflows to help automate how they process data, how they visualize and analyze data. Now's look at how they blend data. Now, specifically when you blend data as an AI citizen data scientist, you have two main methods that come to mind. There's the use of Excel where you're relying on formula-based driven approaches to join data, which can be very inefficient. And then the more advanced methodology, which is Power Query that uses logic known as SQL logic behind the scenes to help join and merge different data sets together. Let's start with the Excel based approach. So we really, we have two methods, which is our VLOOKUP and our XLOOKUP You also have concatenation, which is another method to join data, but we won't talk about in today's session. Now with V lookup and X lookup, they're both really useful lookup…

Contents