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.
- [Phil] If you've used SharePoint lists with custom fields and views, you know how powerful that can be as a way to organize and retrieve data. But when it comes to analyzing that data, people are still looking for more. Using Power Pivot and Power Views are a couple of the most, well, powerful tools available. Hi, my name's Phil Gold. I'm a communications and training professional who has worked with SharePoint as a user, as a site owner and developer, and as an instructor.
I spent years helping people worldwide get the most out of their SharePoint experience. In this course, I'm gonna introduce you to Microsoft Power Pivot and Power View. I'll show you how to get started by setting them up in Excel, how to connect them to your data, and how to use them to create a business intelligence center that will let you share dashboards on SharePoint with your entire team. If you think having better ways to show meaningful information with your team to help everyone make smarter business decisions sounds like a good idea, well, then stick around, and see you in the next video.
- PivotTables vs. PowerPivot and PowerView
- Using SharePoint as a BI Center
- Connecting PowerPivot to an existing Excel workbook
- Connecting to external data sources
- Exporting list data from SharePoint to create a workbook
- Using PowerPivot and PowerView in Excel
- Uploading a workbook to a SharePoint BI Center
- Publishing workbooks and creating dashboards