Course ID: EXCELPP

Excel 2013/2016 PowerPivot and PowerView Business Intelligence Tools for Advanced Data Analysis


The free PowerPivot add-in for Excel takes PivotTable analysis to a new level. PowerPivot is more than a simple replacement for the Excel PivotTable. It is a business intelligence tool that will provide you with additional features to build complex relationships between sets of data. With PowerPivot you can: analyze data beyond the limits of the Excel PivotTable; organize tables in a relational way; define complex calculation expressions; integrate different data sources into your analysis; provide enhanced interactive graphs; and discover analysis solutions that the Excel PivotTable is not able to provide. PowerView, PowerQuery, and the 2016 Power BI Desktop application to create dashboards will also be covered. Attendees will receive practical information and tips. This course applies to Excel 2013 and 2016.


LEARNING OBJECTIVES
  • Become familiar with the Excel PowerPivot application and import data
  • Manipulate sets of data in a variety of PowerPivot reports
  • Use DAX functions in PowerPivot
  • Create graphic representations of PowerPivot reports
  • Distribute PowerPivot Data
  • Use PowerView, Power Query, and the new Power BI Desktop application for building dashboards

MAJOR TOPICS
  • Install and Explore the PowerPivot Application
  • Import Data from Various Data Sources
  • Refresh Data from a Data Source
  • Create Linked Tables
  • Organize and Format Tables
  • Create Calculated Columns
  • Sort and Filter PowerPivot Data
  • Create and Manage Table Relationships
  • Create PowerPivot PivotTables
  • Create PivotCharts
  • Filter Data Using Slicers
  • Present PivotTable Data Visually
  • Manipulate PowerPivot Data Using DAX Functions
  • Extract Data from Tables Using Functions
  • Work with Time Dependent Data
  • Protect Reports
  • Save Reports in Different File Formats
  • Work with PowerView data mapping
  • Work with PowerQuery to access database data
  • Use the new Power BI desktop app to create a variety of dashboards linked to data

DESIGNED FOR
CPAs, accountants, finance professionals at all levels of an organization to learn how to analyze data with Excel PowerPivot

PREREQUISITES
Working knowledge of Microsoft Excel at an intermediate/advanced level

COURSE PRODUCER
Business Learning Institute

CPE CREDITS
8.0

LEVEL
Advanced

This course is available to be scheduled as:

Group Live
 

Let's Roll!

To learn more or customize this course for your group, complete this form and a BLI team member will get back with you shortly.


Or, contact BLI: 888-481-3500 or learn@blionline.org