In this video, Phil Gold shows how to add specific PowerPivot tables and charts onto SharePoint pages. Learn how to insert the PowerPivot web part onto SharePoint pages, and how to configure the part for maximum value.
- [Instructor] Alright, we're almost done.…We've got our workbook with all of our cool stuff in it…and we've got it loaded to our BI Center.…All that remains is to create a dashboard…or dashboards and share them with the team.…So, in the BI Center, click the menu link for dashboards.…In the Dashboard Library, click the New icon…and select Web Part Page from the pop-up menu.…Now, if you don't get this page,…you need to go back to your system admin…and make sure that you have the right permissions.…
Since we do, our next step is to name the page,…and since this will be the URL,…once again, no spaces or special characters,…but try and make it clear if you can.…I'm gonna call this Hplus_BikeSales.…Now we get to select the page layout,…and as you can see, you can get kinda fancy here.…All of the areas are spots where you can add web parts.…If you don't use them, they'll collapse and be invisible.…
I encourage you to play around with this,…but for the moment, I'm just gonna use…the full-page vertical layout…to make the demonstration clearer.…
- 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.