Overview
-
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.
Syllabus
-
Introduction
- Learn to do more with data in SharePoint
- What you should know before watching this course
- What is business intelligence?
- PivotTables vs. PowerPivot and PowerView
- Use SharePoint as a BI Center
- 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
- The advantage of relationships in PowerPivot
- Establish hierarchies
- Using PowerView
- PowerView maps and more
- Create the BI Center
- Prepare a workbook for upload
- Upload the workbook
- Create a dashboard on a web part page
- Share with your team
- Next steps
