Microsoft Excel Advanced Data Analysis - 1 Day Course - Brisbane
Mon 20
July 2020
9:00 AM
- 4:00 PM
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