Power Pivot & BI Tools

Course Dates:

By using Power Pivot for Excel, you can transform enormous quantities of data with incredible speed into meaningful information to get the answers you need in seconds.

Duration 2 Days

Course Content

ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ What is Power Pivot ?
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ What are the benefits of using Power Pivot ?
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ How to enable the Power Pivot add-in
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ The Power Pivot Window
Importing Your Data and the Data Model
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ How to import data into the PowerPivot Data Model.
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Importing Data from a variety of Data Sources
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Working with Data Connections
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Refreshing Data
Creating the Power Pivot Data Model
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ How to create relationships between tables in the PowerPivot Data Model.
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Understanding One-to Many Relationships
Excel Analysis Tables
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ What is an Excel Analysis Table?
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Using Slicers to filter data in the Table
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Why Excel Tables are important to Power Pivot
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Adding Linked Tables to the Data Model
Analysing Data using a Pivot Table
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Understanding Compact Layout
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Changing the Layout
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Using the ƒƒ‚¢ƒ‚‚€ƒ‚‚œin-situƒƒ‚¢ƒ‚‚€ƒ‚‚ filters
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Grouping data for ad-hoc subtotals
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Grouping date columns into years, months
Creating PivotTables with PowerPivot
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ How to create a PivotTable with PowerPivot data
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ How to use the Field list with the Data Model
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ What is different in a PowerPivot Pivot Table
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ How Drill-down differs in PowerPivot.
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Creating a Flattened Pivot Table to analyse combinations of unique data.
Working with Dates in Power Pivot
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ How to analyse by Year, Quarter, Month etc.
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Why a Date Table (Calendar Table) is required
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Generating & Marking as a Date Table.
Using Slicers to Filter Data
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ How to filer data using Slicers
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Connecting Slicers to multiple Tables
Using Pivot Charts and Dashboards
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ What is different about PowerPivot Charts
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Connecting Slicers to Pivot Charts
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Creating “Dashboards”.

Creating Simple Calculated Columns
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ How to create a Calculated Column
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ Looking up values from related tables
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ What is a Calculated Field
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ How to Add a Calculated Field to a PowerPivot PivotTable
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢ What are PowerPivot Sets?
Power Query
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Adding Data to Power Query from various data sources
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Creating a Query, the Query Editor Window
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Load to Worksheet and Load to Data Model
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Remove Duplicate Data in Columns
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Split and Merge Columns of Data
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Group data to create summary Queries
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Merge and Append Queries
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Transpose Data to swap Rows and Columns
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Filling data Down populating missing values
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Unpivot Columns: flatten a ƒƒ‚¢ƒ‚‚€ƒ‚‚œcross tabƒƒ‚¢ƒ‚‚€ƒ‚‚ table
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Duplicate Columns
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Creating Custom Columns and Additional Date Columns
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Working with Applied Steps
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Importing Data from a Folder
Power View
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢The Power View Field List
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Using Text Boxes
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Creating Tables
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Changing Table Visualisations
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Using a Matrix and Enable Drill Down
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Using Cards; Setting up Titles and Pictures
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Creating Chart Visualisations and Interactive Charts
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Creating Power View Slicers
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Using Tiles
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Using Power View Filters
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Working with interactive Bubble Charts using the Play Axis
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Creating Power View Maps
Power Map
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Create a Power Map & Plot Geographic Data
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Creation Visualisation; Column, Bubble, Heatmap, Regions
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Using the 3-D Environment
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Using Charts with Power Maps
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Working with Layers and adding Scenes
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Adding Annotations
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Visualising Data over Time
ƒƒ‚¢ƒ‚‚€ƒ‚‚¢Playing the Tour


Courses, IT Skills

Related Products