Database Reference
In-Depth Information
To check whether you have the Power View Add-In, look for the Power View icon on the Insert tab of
the Ribbon. If you see it, then the Power View Add-In is already activated. But if you're not so lucky,
you can activate the Power View Add-In by following these steps:
1. Choose File Options.
2. Select the Add-Ins option on the left, select COM Add-Ins from the Manage drop-down
menu, and click Go.
3. Select Power View in the list of available COM Add-Ins, and click OK.
The Power View command now appears on the Insert tab. If you don't see it, restart
Excel 2013.
You must have Silver Light installed on your machine in order to use Power View. Search
for Silver Light using your favorite search engine to get the free download from Microsoft.
Note
Creating a Power View Dashboard
In Chapters 2 and 3, you discovered how you can leverage the internal Data Model in Excel 2013 to
create powerful PivotTable analyses. After you've loaded your data into the internal Data Model, you
can create a Power View dashboard from that Data Model. Click the Power View button on the Insert
tab. Excel takes a moment to create a new worksheet called Power ViewX, where X represents a
number that makes the sheet name unique (for example, Power View1).
This new worksheet has the three main sections shown in Figure 5-1:
Canvas: Contains the charts, tables, and maps you add to your dashboard.
Filter pane: Contains the data filters you define.
Field list: Add and configure the data for your dashboard.
You build up your Power View dashboard by dragging the fields from the field list to the respective
sections. For example, dragging the Generator_Size field to the filter pane creates a list of filterable
items (see Figure 5-2) with check boxes that can be selected or deselected. The filter pane has a few
icons that help you work with the filters. These icons enable you to expand or collapse the entire filter
pane, clear applied filters, call up advanced filter options, or delete the filter.
To add data to the canvas, use the field list to drag the needed data fields to the FIELDS drop zone.
Figure 5-3 show the Waste_Code and Generated_Qty fields moved to the FIELDS drop zone. This
results in a new table of data on the canvas.
 
Search WWH ::




Custom Search