2014
Lynda
Neicole Crepeau
0:48
English
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
Download File Size:109.06 MB