$475.84

Microsoft Excel Advanced Data Analysis - 1 Day Course - Sydney

Event Information

Share this event

Date and Time

Location

Location

Odyssey Training

Suite 1

Level 2, 45 Clarence Street

Sydney, NSW 2000

Australia

View Map

Refund Policy

Refund Policy

Contact the organiser to request a refund.

Eventbrite's fee is nonrefundable.

Event description

Description

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

Share with friends

Date and Time

Location

Odyssey Training

Suite 1

Level 2, 45 Clarence Street

Sydney, NSW 2000

Australia

View Map

Refund Policy

Contact the organiser to request a refund.

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved