Microsoft Office® Excel:
Introduction to Excel Power Tools

Learn the fundamentals of the Excel Power BI tools, such as Get & Transform Data (Power Query), Power Pivot, and an introduction to Power BI Desktop.

Full Course Description:

Have you spent hours trying to bring data from multiple sources into a single spreadsheet to analyze your data? This three-day boot camp explores the fundamentals of data transformation using Get & Transform (Power Query), as well as data analysis and reporting with PowerPivot.

Learn to easily incorporate data from multiples sources to model data and create powerful visual reports in Power BI Desktop. You will learn to use the data model, build tables, charts, relationships, measures, hierarchies, KPI's, and drill downs of your data, as well as publish a completed Power BI Desktop file to the cloud.

This Boot Camp is designed to provide an introduction to using the Excel Power Tools and Power BI. As these are very powerful Data Analysis tools, you may need additional training to learn all their capabilities.

Prerequisites: To ensure your success, we recommend that you first take Excel Level 1, Level 2, and In-Depth PivotTables, or have equivalent knowledge and skills - such as knowledge of advanced features and functions.