O'Reilly logo

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook by Derek Wilson

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

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 ...

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