In this video, Phil Gold demonstrates how to create PowerViews from PowerPivot. Learn the difference between regular graphs and charts and PowerViews, and learn how to create and format them.
- [Instructor] Now since you already know…about pivot tables, you know about pivot charts, right?…Well if not, you'll want to check out the section…on pivot charts in the course Pivot Tables in Depth.…This is actually a great all around pivot table class.…Power View is a step beyond pivot charts…in that it allows for some very interactive…and ad hoc ways of visualizing your data.…You get to Power View from the menu.…Now this might require a little setup on your part.…
When I first installed Power View,…I didn't have any command for it at all.…I actually had to go in and customize my ribbon…to add a Power View item to the Insert tab on the menu bar.…Now I'm not gonna go through all that right now,…but if you need help with this,…there's a good support article…on customizing ribbons available online.…Anyways, let's start from this Power Pivot table…and click the Power View icon, and start a new worksheet.…
The Power View builder is a little different…from what we've seen so far.…To build your chart, you need to add data to the data area.…
- 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.