Events.com apps

Microsoft Excel Advanced Data Analysis - 1 Day Course - Brisbane

Microsoft Excel Advanced Data Analysis - 1 Day Course - Brisbane
Image from eventbrite.com
Event ended

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

Views - 21/07/2020 Last update
sports courses
Odyssey Training (RACQ Building)
Level 1, 60 Edward St, Brisbane, 4000, QLD, AU
Create an event
Create events for free. They will be immediately recommended to interested users.
Nearby hotels and apartments
Level 1, 60 Edward St, Brisbane, 4000, QLD, AU
Discover more events in Brisbane
Discover now
Discover more events in Brisbane
Discover now
Odyssey Training (RACQ Building)
Level 1, 60 Edward St, Brisbane, 4000, QLD, AU
Create an event
Create events for free. They will be immediately recommended to interested users.
  1. Brisbane
  2. Microsoft Excel Advanced Data Analysis - 1 Day Course - Brisbane
 
 
 
 
Your changes have been saved.