Explore, Visualize, and Present your Data with Excel’s Power Tools (15 hrs)

Course Code: CRS-N-0048952

In this course, participants will learn how to use Power Pivot to analyse large amounts of data and create analytics dashboard with Power View’s amazing visualizations tools.

  • Apply Power View, Power Pivot, Power Query, and Power Map
  • Create graphs, reports and visualizations
  • Create key performance indicators (KPIs) in Power Pivot

Quick overview of Excel power tools

  • Introduction to Power View, Power Pivot, Power Query and Power Map

Working with Power View

  • Power View interface
  • Working with tables
  • Understanding aggregations
  • Utilising matrix
  • Working with drill through
  • Using cards
  • Applying filters and highlights
  • Cross-filtering
  • Creating charts
  • Adding tiles
  • Adding slicers to reports
  • Applying themes

Working with Power Pivot

  • Power Pivot interface
  • Getting data for Power Pivot
  • Working with relationships
  • Configuring calculated columns and calculated fields
  • Creating Pivot Tables
  • Introducing DAX functions
  • Build measures with DAX functions
  • Using KPIs
  • Working with hierarchies

Power Query

  • Power Query interface
  • Importing data
  • Appending files in folders
  • Data transformation (unpivoting, pivoting, grouping data)

Power Map

  • Power Map interface
  • Using Bing maps
  • Review map types and presentation

Build Dashboard

  • Create dashboard with Excel power tools
  • Know the best practices

Participants will benefit from the hands-on practical sessions during the course.

This course is intended for business analysts, business intelligence developers, and reporting professionals.

Prerequisite

Participants must have a basic working knowledge of Excel.

Duration : 2 days (15 hrs)
Time : 9:00am – 5:30pm

Course Fee : $900.00
Nett Fee Incl. 7% GST : $963.00
SDF Support* : $30.00

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with COMAT)

Key Benefits
  • Apply Power View, Power Pivot, Power Query, and Power Map
  • Create graphs, reports and visualizations
  • Create key performance indicators (KPIs) in Power Pivot
Course Contents

Quick overview of Excel power tools

  • Introduction to Power View, Power Pivot, Power Query and Power Map

Working with Power View

  • Power View interface
  • Working with tables
  • Understanding aggregations
  • Utilising matrix
  • Working with drill through
  • Using cards
  • Applying filters and highlights
  • Cross-filtering
  • Creating charts
  • Adding tiles
  • Adding slicers to reports
  • Applying themes

Working with Power Pivot

  • Power Pivot interface
  • Getting data for Power Pivot
  • Working with relationships
  • Configuring calculated columns and calculated fields
  • Creating Pivot Tables
  • Introducing DAX functions
  • Build measures with DAX functions
  • Using KPIs
  • Working with hierarchies

Power Query

  • Power Query interface
  • Importing data
  • Appending files in folders
  • Data transformation (unpivoting, pivoting, grouping data)

Power Map

  • Power Map interface
  • Using Bing maps
  • Review map types and presentation

Build Dashboard

  • Create dashboard with Excel power tools
  • Know the best practices
Learning Methodology

Participants will benefit from the hands-on practical sessions during the course.

Who Should Attend

This course is intended for business analysts, business intelligence developers, and reporting professionals.

Prerequisite

Participants must have a basic working knowledge of Excel.

Course Details

Duration : 2 days (15 hrs)
Time : 9:00am – 5:30pm

Course Fee : $900.00
Nett Fee Incl. 7% GST : $963.00
SDF Support* : $30.00

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with COMAT)

Course Application

Details Registration
January 20, 2020 - January 21, 2020 (9:00 am - 5:30 pm) Closed
February 20, 2020 - February 21, 2020 (9:00 am - 5:30 pm) Closed
March 12, 2020 - March 13, 2020 (9:00 am - 5:30 pm) Closed
August 13, 2020 - August 14, 2020 (9:00 am - 5:30 pm) Closed
September 24, 2020 - September 25, 2020 (9:00 am - 5:30 pm) Register Now
October 19, 2020 - October 20, 2020 (9:00 am - 5:30 pm) Register Now
November 19, 2020 - November 20, 2020 (9:00 am - 5:30 pm) Register Now
December 17, 2020 - December 18, 2020 (9:00 am - 5:30 pm) Register Now