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

Kurs Kostenlos Starten

4 Stunden7 Videos21 Übungen3.561 LernendeLeistungsnachweis

Kostenloses Konto erstellen

Google LinkedIn Facebook

oder

Durch Klick auf die Schaltfläche akzeptierst du unsere Nutzungsbedingungen, unsere Datenschutzrichtlinie und die Speicherung deiner Daten in den USA.

Trainierst du 2 oder mehr?

Versuchen DataCamp for Business

Beliebt bei Lernenden in Tausenden Unternehmen

Kursbeschreibung

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.

Für Unternehmen

Trainierst du 2 oder mehr?

Verschaffen Sie Ihrem Team Zugriff auf die vollständige DataCamp-Plattform, einschließlich aller Funktionen.

In den folgenden Tracks

Datenanalyse mit Excel Power Tools

Gehe zu Track

1
Combining Queries in Power Query
Kostenlos
In 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.
Kapitel Jetzt Abspielen
Appending and merging queries
50 xp
Using Append vs. Merge
100 xp
Combining queries with Power Query
50 xp
Appending queries
100 xp
Merging queries with left outer join
100 xp
Merging queries with inner join
100 xp
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.
Kapitel Jetzt Abspielen
Custom columns
50 xp
Conditional logic with M
50 xp
Custom columns in Power Query with M
50 xp
Custom conditional columns
100 xp
Advanced conditional columns
100 xp
Calculating early warning system scores
100 xp
Grouped index columns
100 xp
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
Kapitel Jetzt Abspielen
M Formula Language
50 xp
Power Query Advanced Editor
100 xp
M for Power Query in Excel
50 xp
Built-in M functions
100 xp
Query parameters
100 xp
Debugging the advanced editor
100 xp
Custom functions
100 xp
Congratulations!
50 xp