K2's Data Analysis with PowerPivot (2 hours)

K2's Data Analysis with PowerPivot (2 hours)

  • $89.00

PowerPivot provides unparalleled options for analyzing data & preparing summary reports in Excel. With PowerPivot, available in Microsoft Office Professional Plus or the standalone version of Excel, your PivotTable reports become even more powerful. PowerPivot can connect directly to a large number of common external data sources or can be used in conjunction with Power Query for superior data import & transformation capability. DAX functions allow users to create sophisticated calculations, both columns & measures, & the relational functionality of PowerPivot provides all the tools necessary for creating an intermediary database from multiple data sources. Put PowerPivot to use immediately by participating in this practical session to improve analytical & reporting processes.

Major Topics

  • Creating basic PivotTables with the Excel Data Model & PowerPivot
  • Using external data sources with PowerPivot
  • Converting PivotTables into individual formulas that can be refreshed from the data source
  • Relating multiple tables with PowerPivot
  • Creating calculated columns & calculated fields using DAX functions  
  • Adding key performance indicators to PivotTable reports

Learning Objectives

Upon completing this course, you should be able to:

  • Differentiate between ordinary PivotTables and those created with PowerPivot
  • Describe the advantages of working with PowerPivot
  • Explain the procedure for building a PivotTable using PowerPivot
  • Define Data Models, Data Analysis Expressions, and Key Performance Indicators
  • Create reports from data summarized using PowerPivot

Course Information

  • CPE credit: Recommended for 2 hours Computer Software & Applications
  • Prerequisites: Users of Excel 2013 and newer, including Office 365, that have a good working knowledge of Excel & PivotTables
  • Program level: Advanced
  • Advance preparation: None
  • Who should participate: Accountants & finance professionals who want to streamline & improve their data analysis & reporting processes