Webcast: K2's PowerPivot and Power View - Desktop Analytics in Excel (XKPPV117)
Tell a Friend About This EventTell a Friend
 

Two new Excel features - PowerPivot and Power View - provide unparalleled options for analyzing data and preparing interactive reports. With PowerPivot, your PivotTables reports become even more potent, while Power View offers data visualization techniques for better analysis and communication. You will learn to put the power of both of these amazing tools to use immediately by participating in this very practical session, which is sure to help you improve your analytical and reporting processes

5/25/2017
When: 05/25/2017
9:00 AM until 11:00 AM
Where: Webcast
K2
United States
Presenter: Mac McClelland


Online registration is closed.
« Go to Upcoming Event List  

AcronymXKPPV117
CPE2 hours
VendorK2 Enterprises
Category
Management
LevelAdvanced
PrerequisiteUsers of Excel 2010/2013 or Office 365 that have a good working knowledge of Excel and PivotTables
Adv PrepNone
Yellow Book?No
Designed forAccountants and finance professionals responsible for reporting who want to streamline their reporting processes while increasing report accuracy
Registration
Member$79
CPA Non-Member$104

The Member rate applies to LCPA members, other state society members, and non-CPA staff of LCPA members. To register online, use the ‘Register’ button above. To register by phone, call the LCPA Member Service Center at 800.288.5272 or 504.464.1040, Monday through Friday, 8am to 5pm.

Course Description

Two new Excel features - PowerPivot and Power View - provide unparalleled options for analyzing data and preparing interactive reports. With PowerPivot, your PivotTables reports become even more potent, while Power View offers data visualization techniques for better analysis and communication. You will learn to put the power of both of these amazing tools to use immediately by participating in this very practical session, which is sure to help you improve your analytical and reporting processes.

Objectives

Upon completing this course, you should be able to:

  • Describe the advantages of working with PowerPivot and Power View and list relevant limitations associated with each of these tools
  • Identify how to acquire PowerPivot and Power View
  • Explain, at a high-level, the procedure for building a PivotTable in PowerPivot
  • Define Data Models, Data Analysis Expressions, and Key Performance Indicators and describe how to create and work with each
  • Create reports based on PowerPivot and Power View

Topics

  • Creating basic PivotTables with the Excel Data Model and 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 and calculated fields using DAX functions in PowerPivot
  • Adding key performance indicators
  • Building interactive dashboards using Power View
  • Applying filters and maps to Power View reports