Power Query for Excel & Power BI Training
Microsoft Power Query, a revolutionary data tool for Excel that allows you to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources for use in Excel and Microsoft Power BI. Power Query is a free add-in for Excel that enhances the self-service Business Intelligence experience in Excel.
Power Query is part of Transform and Load Data in Microsoft Excel 2019 and Office 365
This class is best taken together with Analysis and Data Visualization with Power BI
Class Goals
- Understand the revolutionary changes in Power Query and the ease it provides for Excel pros.
- Understand how to consolidate data from multiple workbooks/Worksheets
- Successfully navigate the Power Query interface.
- Understand and properly configure data types.
- Understand and perform importing data.
- Understand and perform transforming data.
- Understand and perform loading data.
- Understand and utilize ranges in Excel.
- Understand and handle special situations.
- Understand and perform appending operations.
- Understand and utilize working with folders and files.
- Understand and perform combining worksheets.
- Understand and utilize PivotTables.
- Understand working with relational data.
- Understand and perform importing from SQL Server Analysis Services Multidimensional.
- Understand and perform importing from SQL Server Analysis Services Tabular.
- Understand the issues encountered when performing merges.
- Understand and utilize merges.
- Understand and utilize loading into Excel
Fast Track: 3 sessions of 3 hours each