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.
Registration for this course has passed.
Course Pricing
WYOCPA Member Fee
$60.00
Non-Member Fee
$94.00
Your Price
$94.00
Upcoming Courses
-
Critical Thinking for Financial Professionals
April 18, 2024
-
Ethics Case Studies: Remaining Ethical in the Age of Oversharing
April 18, 2024
-
Leases: Mastering the New FASB Requirements
April 18, 2024
View all upcoming courses