Learning Power Pivot and SharePoint 2013

Learn how to combine the power of Excel's Power Pivot and Power View tools with SharePoint 2013, to view, analyze, and manipulate large amounts of data.

Learn how to combine the power of Excel's Power Pivot and Power View tools with SharePoint 2013, to view, analyze, and manipulate large amounts of data. Neicole Crepeau guides you through the process of creating workbooks and dashboards to help your organization use big data to answer big questions. She shows how to connect to data sets and how to create relationships between them, plus how to use Power View to visualize the information. Then, moving on to SharePoint, Neicole explains how to create a Business Intelligence Center site and dashboards from your Excel workbooks.

Introduction

• Welcome
• What you should know before watching this course
• Using the exercise files

1. Business Intelligence in SharePoint 2013

• What is business intelligence?
• Power Pivot and Power View

2. Create the Excel Workbook

• Installing Power Pivot and Power View
• Connecting to data sources

3. Using Power Pivot and Power View in Excel

• Using data models
• Using hierarchies, Power Pivot, and PivotTables
• Using Power Pivot and Power View

4. Uploading a Workbook to a BI Center

• Creating the BI Center
• Preparing a workbook for upload

5. Publishing Workbooks and Creating Dashboards

• Creating a dashboard