Extract, Analyze and Visualize Data

Excel Level 4

Duration: 6 Hours

Prerequisite: Excel Level 3

Cost: $299 CAD / Person

Course provided remotely by a live instructor via Microsoft Teams or Zoom.

Minimum enrollment required. Discounts for government employees and groups.

Learning Objectives

Course Overview

  • Course Flow

  • Course Flow Graphical Objectives

Extraction, Transformation, and Loading

  • Understanding the ETL Process

  • Power Query Overview

  • Getting Started with Power Query

  • Managing Query Results

  • Reorganizing Data

  • Combining Data

  • Working with Web Data

Working with Data Analysis and Dashboards

  • Data Analysis and Dashboard Overview

  • Getting Started with Dashboards

  • Data Analysis for Dashboard Objects

  • Completing and Using Dashboards

Supplemental Topics

  • Working with Slicers in Dashboards

  • Course Data Folder Location

Get Quote

Want more information on our courses? Send a message and we’ll reply shortly.