Session

Supercharge VLOOKUPS with Power Query Joins

Ever hit a roadblock when trying to shape or enrich your data in Excel?
Let's shine the spotlight on Power Query Joins.
These aren’t just the VLOOKUPs and XLOOKUPs from our regular Excel in a fancy new suit. They're the powerhouse tools that help you mold and enhance your data, setting the stage for some killer analyses later on.

In our upcoming session, we're going hands-on with these joining wonders. We'll break down the usual join suspects and then venture into the shadows where the mysterious seventh type lurks. From fuzzy-matching fun to multi-column join shenanigans, we're covering it all. But here's the thing: it's not just about making datasets play nice together. It's about pulling in rich details, filling in gaps, and creating that perfect dataset that makes your analyses pop.

By the time we call it a wrap, you'll be all set to use Power Query Joins like a pro. They'll be your secret weapon in crafting and refining data either in Excel but also Power BI, Data Flows and other Microsoft Tools, setting you up for smoother, more insightful analyses. Ready to master the merging magic? Let’s dive in and shape some data!

Struggling with data shaping in Excel? Discover the power of Power Query Joins! In our hands-on session, we’ll explore all join types, including advanced techniques like fuzzy matching and multi-column joins. Learn how to enrich datasets, fill gaps, and create the perfect foundation for impactful analyses in Excel, Power BI, and beyond. Unleash your data potential with Power Query!

Cristian Angyal

Microsoft MVP

Timişoara, Romania

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top