K2's Data Analysis With Power Pivot

Course Details

Date

Friday, February 28, 2020

10:00am – 11:40am
(Registration: 9:30am)

Field of Study

Technology

Course Number

4193609G

CPE Credit

2.0 hours CPE credit

Level of Knowledge

Advanced

Vendor

CalCPA Education Foundation

Prerequisites

Fundamental knowledge of computer operations and Microsoft Excel, including creating PivotTables.

Description

Utilize Power Pivot to make PivotTable reports become even more powerful. Learn how Power Pivot can connect directly to many common external data sources or can be used in conjunction with Power Query for superior data import and transformation capability.

DAX functions allow users to create sophisticated calculations, both columns and measures, and the relational functionality of Power Pivot provides all the tools necessary for creating an intermediary database from multiple data sources.

Highlights

  • PivotTables
  • Power Pivot
  • Data Models, Data Analysis Expressions and Key Performance Indicators

Objectives

  • Differentiate between ordinary PivotTables and those created with Power Pivot.
  • Describe the advantages of working with Power Pivot.
  • Explain the procedure for building a PivotTable using Power Pivot.
  • Define Data Models, Data Analysis Expressions and Key Performance Indicators.

Designed For

CPAs and financial professionals.

Course Pricing

Member Fee

Applicable if you are a HSCPA member in good standing.

$60.00
Non-Member Fee

Applicable if you are not a HSCPA member.

$94.00
Your Price $94.00

CPE Choice

Learn more about CPE Choice.
This course does not qualify for CPE Choice.

View All Webcasts