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


Fields


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