O'Reilly logo

Microsoft Business Intelligence Tools for Excel Analysts by Bernard Wehbe, Jared Decker, Michael Alexander

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 Plus: Available with an ongoing ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required