Power Pivot: Big Data Analysis Made Easy (Video) (Course Id 2216)

• Who is this course for?
  This course is for CPAs, accountants, and other professionals needing Continuing Professional Education (CPE), particularly those with basic Excel knowledge who want to enhance their data analysis capabilities using Power Pivot.

• What is this course about or what problem does this course solve?
  This course introduces Power Pivot as a superior alternative to conventional Excel pivot tables for big data analysis, helping users overcome Excel’s row limitations and simplifying data integration and analysis.

• How can the knowledge from this course be used?
  The knowledge can be used to map data tables, integrate multiple data sources into one pivot table, apply essential DAX formulas, and implement best practices in Power Pivot modeling for effective business analytics.

• Why is this course important to a CPA, Accountant, or IRS Enrolled Agent?
  This course is important because it equips professionals with advanced Excel-based data analysis skills using Power Pivot, which can improve efficiency, accuracy, and insights in financial reporting and decision-making.

• When is this course relevant or timely?
  This course is timely as businesses increasingly rely on large datasets, and professionals need powerful tools like Power Pivot to analyze and visualize this data effectively; it was most recently revised in January 2024.

• How is a course like this consumed or used?
  This video-based, self-study course is consumed online through a NASBA QAS-approved platform, includes review and final exam questions, and provides 1.5 CPE credits upon successful completion with a score of 70% or higher.

The course is presented in four parts.

First, brief introduction to Power Pivot and discuss reasons it has become more versatile than the conventional pivot table:

• Excel spreadsheet has limit of 1 million rows, while Power Pivot can connect to over 1 million rows of data. So no limit on the data sources
• Power Pivot can combine all data sources into one pivot table. So no more VLOOKUP()
• A plethora of DAX formulas in Power Pivot. Plus the formulas can be re-used!

Second part is to demonstrate basic maneuvers on how to:

• map all dimension tables and fact tables together, and
• incorporate data from ALL sources into 1 pivot table, and

Third, we demonstrate 6 fundamental DAX formulas in Power Pivot to get you started in building advanced models for effective analytics, including:

• CALCULATE
• SUMX
• RELATED
• SAMEPERIODLASTYEAR

Last, we culminate the webinar with the best practices in Power Pivot modeling, including:

• Use Measures (or Calculated Fields) over Calculated Column in order to
• Table naming conventions, and
• DAX format

Video - NASBA QAS - NASBA Registry - 2216

Course Learning Objectives

• Discover Power Pivot as the big data analysis tool
• Identify the best practices in Power Pivot modeling
• Recognize Power Pivot’s essential steps in relationship and integration
• Discover 6 essential DAX formulas to get you started in Power Pivot formula writing
• Explore differences between a calculated column and a calculate field

Chapter 1 - Power Pivot: Big Data Analysis Made Easy

Chapter 1 Review Questions

Glossary/Index