Introduction to Power Query in Excel

Explore Excel Power Query for advanced data transformation and cleansing to boost your decision-making and analysis.

3 Stunden9 Videos27 Übungen9.441 LernendeLeistungsnachweis

Kostenloses Konto erstellen

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

Navigating Data with Excel Power Query

Embark on a transformative journey through Excel Power Query, where data manipulation becomes an art. Designed for novices and experts alike, this course unlocks new efficiencies in data handling, leaving behind time-consuming manual processes. Discover the power to connect with varied data sources, streamline your datasets, and ready them for insightful analysis. Excel Power Query's suite of tools awaits to elevate your reporting and decision-making prowess, saving time and revealing valuable insights from your data.

Discovering Power Query in Excel

Begin with a comprehensive overview of Power Query, transforming Excel into a potent data analysis tool. Learn to import and systematically organize data with intuitive commands, tracking each step with precision. This foundational knowledge sets the stage for sophisticated data manipulation within the familiar Excel workspace.

Cleansing Data for Clarity

Dive into Power Query's cleaning features to produce immaculate datasets. Tackle errors, fill gaps in data, and eradicate duplicates. This chapter hones your skills in data refinement, ensuring your dataset's integrity and priming it for complex analysis.

The Art of Data Transformation

Conclude with a deep dive into data transformation techniques. Master the essentials of column transformations, including numerical, date/time, and text adjustments, leveraging Power Query's built-in functions. Experience advanced structuring methods like transposing, pivoting, and grouping, and learn to interlink queries for a comprehensive analytical narrative.

This condensed course promises a hands-on approach to mastering data efficiency and insight extraction with Excel Power Query, empowering you to become a savvy data analyst.

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
Getting Started with Power Query in Excel
Kostenlos
Imagine Excel as you've never seen it before – Power Query opens a window to a whole new world of data possibilities! In this chapter, you’ll explore the layout and features of Power Query and its interplay with traditional Excel workbooks. You’ll load data from multiple sources and learn to structure them through column and row manipulations while maintaining an applied steps log of all your actions.
Kapitel Jetzt Abspielen
Introduction to Power Query
50 xp
Excel Workbooks vs Excel Power Query
100 xp
Navigating the Power Query Editor
50 xp
Getting Started and Loading Data
100 xp
Managing Columns
100 xp
Extracting PDF Data
100 xp
2
Data Cleaning and Preparation
In this chapter, you’ll harness Power Query’s digital cleaning features to prepare a squeaky-clean dataset! Column profiling features will be covered, allowing you to handle errors and missing data effectively. You’ll also master eliminating duplicate data and correcting for data entry issues and outliers.
Kapitel Jetzt Abspielen
Data Cleaning and Preparation
50 xp
Importance of Clean Data
50 xp
Data Cleaning Techniques in Excel Power Query
50 xp
Handling errors
100 xp
Assessing column quality and missing data
100 xp
Removing duplicate data
100 xp
Outlier detection
100 xp
3
Column Transformations
It’s time to transform! This chapter covers many basic column transformations - a vital step in the journey from raw data to meaningful insights. You will learn how and when to apply numeric, date/time, and text transformations to both transform and derive column contents with Excel Power Query’s many built-in features.
Kapitel Jetzt Abspielen
Column Transformations
50 xp
Impact of column transformations
50 xp
Transformation types in Excel Power Query
50 xp
Text transformations
100 xp
Calculating age between two dates
100 xp
Numeric transformations
100 xp
Multiple column transformations
100 xp
4
Shaping and Grouping Data
It’s all about shaping and grouping in this final chapter! You will get hands-on experience with powerful transformation options to bring your analysis prep to the next level. You’ll learn how and when to apply transpose, pivot, and group-by transformations - all within the Power Query editor. You’ll also learn how to leverage existing queries to build new ones and track their connection in the Query Dependencies tree.
Kapitel Jetzt Abspielen
Introduction to Data Shaping and Grouping
50 xp
Which transformation to use?
100 xp
Shaping and Grouping Data in Excel Power Query
50 xp
Transposing data
100 xp
Pivoting in Excel Power Query
100 xp
Group by transformation
100 xp
Congratulations!
50 xp