Intermediate Power Query in Excel
Building on your foundational Power Query in Excel knowledge, this intermediate course takes you to the next level of data transformation mastery
Start Course for Free3 Hours7 Videos21 Exercises
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Training 2 or more people?Try DataCamp For Business
Loved by learners at thousands of companies
Course Description
Building on your foundational Power Query in Excel knowledge, this intermediate course takes you to the next level of data transformation mastery. Discover advanced data integration techniques, including appending and merging datasets with various join types. Delve into M language syntax for creating custom conditional columns and harness advanced table transformations. Unlock the Power Query Advanced Editor, exploring M's built-in functions, mastering best practices like query grouping, and dynamically adjusting filter criteria with parameters. Elevate your skills by crafting custom M formula language functions, unleashing advanced query design capabilities that will empower you to extract deeper insights from your data.
For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more- 1
Combining Queries in Power Query
FreeIn this chapter, you’ll delve into Power Query's data integration capabilities. You’ll master the art of appending queries to combine datasets seamlessly. You’ll also learn to merge datasets together, harnessing various join types to render datasets in multiple ways.
- 2
Custom columns
It’s all about customization in this chapter. You’ll learn the fundamentals of M language syntax, and how it underpins every transformation step in query development. You’ll leverage M to create custom conditional columns using logical operators to suit numerous scenarios. You’ll also delve into M table transformation expressions to create custom grouped index columns, enhancing your proficiency in advanced query design.
- 3
M Formula Language
In this final chapter, you’ll delve into the Power Query Advanced Editor, unraveling M-Language syntax for code modification and debugging. You’ll explore M's built-in functions, and master best practices such as query grouping and dynamic filtering with parameters. Lastly, you’ll elevate your skills by crafting custom M formula language functions, unlocking advanced query design capabilities
For Business
Training 2 or more people?
Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and moreDatasets
Exercises and DatasetsCollaborators
Lyndsay Girard
See More
Analytics Consultant, Halton Healthcare Services Corp
Lyndsay Girard is a highly skilled analytics consultant with Halton Healthcare Services Corp. She has over 15 years of experience in hospital analytics, utilizing BI tools and advanced analytical methods to drive data-driven decisions and transformative change. Lyndsay holds a Master’s of Science degree in Epidemiology from McGill University and is passionate about helping learners grow their analytics skills and bring their careers to the next level! When not delving into data, Lyndsay enjoys weightlifting and wilderness camping adventures.
What do other learners have to say?
Join over 13 million learners and start Intermediate Power Query in Excel today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.