Search results for:
No result found! Try with different keywords!
Advertisement

Microsoft Excel Advanced Data Analysis - 1 Day Course - Melbourne

Advertisement

Microsoft Excel Advanced Data Analysis - 1 Day Course - Melbourne


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

Ticket Information Ticket Price
Individual AUD 450



You may also like the following events from Odyssey Training:

Tags
Map Level 7, 31 Queen St, Melbourne, Australia
Event details from Report a problem

Are you going to this event?

Tickets for AUD 450 on eventbrite.com.au
Advertisement