Loading...

Course Description

Create PivotTables and PivotCharts from large, multi-source data sets. Import data directly from the source, or build queries to extract specific parts of data from very large sources. Learn how to relate multiple data tables through key fields, allowing fact tables to lookup information from other parts of the data model. Add calculated columns and measures directly in the data model within DAX (data analysis expressions). Break the data down with user-defined hierarchies. Generate dynamic key performance indicators (KPI) for display. Utilize date intelligence functions to pinpoint trends within the data, allowing end users to make informed data-driven decisions.

Prerequisites

Introduction to PivotTables or equivalent experience.

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Introduction to PowerPivot
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
Jun 06, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
Jun 04, 2024
Transfer Request Deadline
Jun 04, 2024
Section Title
Introduction to PowerPivot
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
Jun 06, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
Jun 04, 2024
Transfer Request Deadline
Jun 04, 2024
Required fields are indicated by .