PowerPivot and Power View - Desktop Analytics in Excel Webinar

Apr 27
3:30 - 5:30 p.m.

Online

2-Other
CPE Credits

* 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
Highlights
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

Registration

PICPA Member: $79
Nonmember: $104

More Information

Course No. WK2-PPV172 Level: Advanced

Prerequisites: Users of Excel 2010/2013 or Office 365 that have a good working knowledge of Excel and PivotTables

Notes
Your log-in instructions will be sent by K2 Enterprises at least 24 hours before the webinar.

Speaker(s)

Lawrence McClelland