Chapter 5: Creating Dashboards with Power View

In This Chapter

  • Starting a Power View dashboard
  • Creating and working with Power View charts
  • Visualizing data on a Power View map

Excel 2013 introduces a feature called Power View. Power View is an interactive canvas that allows you to display charts, tables, maps, and slicers in one dashboard window. The components in the Power View window are inherently linked so that they all work together and respond to any filtering or slicing you apply while using the dashboard. Select a region in one chart, and the other components in the Power View dashboard automatically respond to show you data for only that region.

This powerful feature runs on the internal Data Model in Excel 2013. This chapter shows you how to combine the internal Data Model and Power View to create powerful interactive dashboards.

Activating the Power View Add-In

Similar to the Power Pivot functionality covered in Chapter 3, the Power View functionality is only available when you activate the Power View Add-In. It’s important to note that the Power View Add-In does not install with every edition of Office 2013. For example, if you have the Office Home Edition, you will not be able to see or activate the Power View Add-In.

As of this writing, the Power View Add-In is only available to you if you have one of the following editions of Office or Excel:

  • Office 2013 Professional Plus: Available through volume licensing only
  • Office 365 Pro ...

Get Microsoft Business Intelligence Tools for Excel Analysts now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.