Analyzing data with Power View

Power View enables highly flexible analytical views view from within Excel. Users can leverage Power View to create interactive data exploration, visualizations, and presentations. Users who are familiar with pivot tables will quickly be able to leverage Power View. The Power View interface enables faster exploration of data over traditional pivot tables. This recipe will show you how to connect to your model from Excel. You will then see how to build and interact with Power View against the data.

How to do it...

  1. Open a new worksheet in Excel and select the Data menu. Then Get External Data, From Other Sources, and select From Analysis Services.

  2. On the Data Connection Wizard, enter your server name (this example uses ...

Get Tabular Modeling with SQL Server 2016 Analysis Services Cookbook now with O’Reilly online learning.

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