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.…
Released
9/13/2018- 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
Share this video
Embed this video
Video: Using PowerView