Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Learning Power Pivot and SharePoint 2013

via LinkedIn Learning

Overview

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.

Syllabus

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

Taught by

Neicole Crepeau

Reviews

Start your review of Learning Power Pivot and SharePoint 2013

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.