Udemy
Free
UdemyPower Query - Advanced Microsoft Excel
4.5(820)15k studentsINTERMEDIATEEnglish
Korshub's take
Clean and connect your data without writing code
Power Query addresses one of the most time-consuming parts of working with data: pulling it together from scattered sources and cleaning it up before any real analysis can happen. This course focuses on using Power Query's no-code interface to handle that work efficiently inside Excel.
What's covered
- Connecting to a wide range of data sources through the Power Query Editor
- Applying transformations by previewing data and selecting options from the interface, with no coding required
- Importing and cleaning large volumes of records
- Loading cleaned data into the data model for further analysis and reporting
Who it's for
Excel users who spend significant time preparing data before they can even start analyzing it. This is pitched as an intermediate-level course, so some familiarity with Excel is assumed, but no prior Power Query or coding experience is required.
About this course
Our data sources are scattered and dynamic. To connect, collect and clean the data is a time consuming and tedious task. Power Query is a data connection technology that enables you to discover, connect, combine, and refine data sources.
Power Query is a data transformation tool that helps to connect almost any data source and transform data using user-friendly features with just one click and no coding. You import and clean millions of records and load them to data model for data analysis and reporting.
Business users spend up to 80 percent of their time on data preparation, which delays the work of analysis and decision-making. Several challenges contribute to this situation, and Power Query helps address many of them.
The Power Query Editor is the primary data preparation experience, where you can connect to a wide range of data sources and apply hundreds of different data transformations by previewing data and selecting transformations from the UI. These data transformation capabilities are common across all data sources, whatever the underlying data source limitations.
When you create a new transformation step by interacting with the components of the Power Query interface, Power Query automatically creates the M code required to do the transformation so you don't need to write any code.
Advertisement
