SharePoint Advanced: Working with PowerPivot

Learn how to use PowerPivot and SharePoint to move data between SharePoint and Office 365 apps, as well as visualize and manipulate data inside SharePoint.

Introduction

• Learn to do more with data in SharePoint
• What you should know before watching this course

1. SharePoint As a Data Tool

• What is business intelligence?
• PivotTables vs. PowerPivot and PowerView
• Use SharePoint as a BI Center

2. Start by Creating and Connecting

• Install PowerPivot and PowerView
• Connect to an existing Excel workbook
• Adding data relationships
• Connect to external data sources
• Export list data from SharePoint to create a workbook

3. Use PowerPivot and PowerView in Excel

• The advantage of relationships in PowerPivot
• Establish hierarchies
• Using PowerView
• PowerView maps and more

4. Upload a Workbook to a SharePoint BI Center

• Create the BI Center
• Prepare a workbook for upload
• Upload the workbook

5. Publish Workbooks and Create Dashboards

• Create a dashboard on a web part page
• Share with your team

Conclusion

• Next steps