Microsoft Excel Advanced Data Analysis - 1 Day Course - Brisbane, Odyssey Training (RACQ Building), Wednesday, 11. December 2019

Analyse and refine data using Power View, Power Map, Power Pivot and Power Query (Get and Transform).

What you will learn

Use Power View to examine and analyse data.

Perform a variety of analytical tasks using Power Pivot.

Import and refine data with Get and Transform.

Effectively create and work with data in Power Map.

Topics covered in this training course

Power View

Understanding Power View

Enabling Power View

Adding Power View to the Ribbon

Creating a Power View sheet

Working with a Power View object

Working with Power View fields

Rearranging and sorting fields

Working with measure fields

Formatting Power View data

Tiling data in Power View

Filtering in Power View

Switching visualisations

Adding more Power Views

Adding titles and images

Updating a Power View report

Power Pivot

Understanding Power Pivot

Understanding relational data

Enabling Power Pivot

Connecting to a data source

Working with the Data Model

Working with Data Model fields

Changing a Power Pivot view

Creating a Data Model PivotTable

Using related Power Pivot fields

Creating a calculated field

Creating a concatenated field

Formatting Data Model fields

Using calculated fields

Creating a timeline

Adding slicers

Get and Transform

Understanding Get and Transform

Understanding the Navigator pane

Creating a new query from a file

Creating a new query from the web

Understanding the query editor

Displaying the query editor

Managing data columns

Reducing data rows

Adding a data column

Transforming data

Editing query steps

Merging queries

Working with merged queries

Saving and sharing queries

The advanced editor

Power Map

Understanding Power Map

Creating a Power Map tour

Working with location fields

Working with mapping confidence

Working with height and category


Filtering data

Navigating a data map

Changing the look

Working with layers

Working with scenes

Working with scene options

Working with time settings

Viewing and editing a tour

Exporting a tour as a video

Wednesday, 11. December 2019, Odyssey Training (RACQ Building), Microsoft Excel Advanced Data Analysis - 1 Day Course - Brisbane

Find more interesting events
Get event recommendations based on your Facebook taste. Get it now!Show me the suitable events for meNot now