Loading...

Course Description

In a data-driven environment analyzing and displaying data is a core accountability. Learn to perform powerful data analysis and create stunning interactive visualizations using Excel Tools including Power Pivot, Power Query and Power View. Each tool has unique features for creating powerful analysis, display and presentation outputs needed for busy data analysts, business decision makers and information workers. This course is designed for analysts, managers, and decision makers who want to communicate and present quantitative analysis.

Course Details

By completion of this course, successful students will be able to:

  • Review concepts and definitions of Relational Data
  • Create data models in Power Pivot.
  • Retrieve, transform and combine data using Power query for data models.
  • Consolidate data with PivotTables.
  • Perform calculation fields in PivotTables.
  • Use Power View’s objects and fields to tile and filter data or to switch visualizations.

Proficiencies

The content of this course is advanced. Completion of ICT 416 and 420 is recommended:

  • Completion of ICT 416 Excel Level 2 – 14 hours
  • Completion of ICT 420 Microsoft Access Level 1 – 14 hours or knowledge of database essentials is an asset.

Applies Towards the Following Program(s)

Loading...
Enrol Now - Select a section to enrol in
Type
Class
Days
F
Time
8:30AM to 4:30PM
Dates
Oct 14, 2022 to Oct 21, 2022
Schedule and Location
Hours
14.0
Delivery Options
Course Fees
Flat fee non-credit $575.00
Reading List / Textbook
No Required Textbook.
Section Notes

Delivery format may change in response to COVID-19. Students will be informed of any changes.

This course uses Desire2Learn (D2L), an online learning management system. The instructor will post your course outline and other materials in D2L. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least seven calendar days prior to the start date of the course.

Type
Online Synchronous
Days
Th, T
Time
6:00PM to 9:00PM
Dates
Mar 02, 2023 to Mar 16, 2023
Schedule and Location
Hours
14.0
Delivery Options
Course Fees
Flat fee non-credit $575.00
Reading List / Textbook
No Required Textbook
Section Notes

You will require access to a computer with the required software: Microsoft Excel.

This course uses Desire2Learn (D2L), an online learning management system. The instructor will post your course outline and other materials in D2L. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least seven calendar days prior to the start date of the course.

Type
Class
Days
F
Time
8:30AM to 4:30PM
Dates
May 05, 2023 to May 12, 2023
Schedule and Location
Hours
14.0
Delivery Options
Course Fees
Flat Fee non-credit $575.00
Reading List / Textbook
No Required Textbook.
Section Notes

Students will require access to a computer with the required software: Microsoft Excel 2019

This course uses Desire2Learn (D2L), an online learning management system. The instructor will post the course outline and other materials in D2L. For more information about D2L, please visit our Online Learning Resources.

Unless otherwise stated, notice of withdrawal or transfer from a course must be received at least seven calendar days prior to the start date of the course.

Required fields are indicated by .