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.
- Define “static snapshot.”
- Recall when to use a SharePoint BI Center.
- Cite the licensing requirements for PowerPivot.
- Describe how to add data relationships.
- Explain what happens when you export a list from SharePoint to Excel.
- Summarize what happens when you expand a filter.
- Describe how you can see data without scrolling.
- Explain how to create a BI Center.