Excel Mastery: Using Power Query and Power Pivot
This course is designed for an Advanced Excel user to Understand the capability of the new Business Intelligence tools in Excel and use them to create great data visualisations and dashboards. Our Excel course has been developed to fill the gap with this first look at the new data manipulation features. Intended for Advanced Excel users this course runs through how to use Business Intelligence tools.
Description
Get & Transform (formerly Power Query)
Identify Data Sources Internally
Search for data publicly available
Previewing data
Security
Combining data from different sources
Sharing to collaborate with others
Power Pivot
Manipulating large amounts of data
Joining data from several tables
Creating & Editing Relationships between files and Tables
Power PivotTables and PivotCharts
First look at Desktop BI Visualisations
Creating a new Dashboard of Visualisations
Using data from multiple sources
Types of Charts
Types of Tables
Using Slicers to filter data
Deleting & Editing Visualization elements
Refreshing Data
Prerequisites
This course requires completion of Level 3 (Advanced) Excel training or equivalent experience. For example, you should already be competent at creating Pivot Tables and Advanced Charts to take full advantage of this Advanced Features class.
We also look at Desktop Power BI App.