O'Reilly logo

Reporting with Microsoft SQL Server 2012 by Bill Anton, James Serra

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

Enhancing data models

As mentioned in the previous sections, possible data sources for Power View are a PowerPivot for SharePoint workbook or an Excel 2013 data model. Both allow you to view and edit the data models in PowerPivot while in Excel. A benefit is that it allows you to make enhancements to the data model before users start to create reports against it in Power View. The enhancements can also be made to a tabular model via a Tabular Analysis Services project in SQL Server Data Tools (SSDT).

The following are some of the enhancements you can make:

  • Default Field Set: This setting is used for a table and gives you the ability to select default columns and measures and define the preferred order. Then, these columns and measures are automatically ...

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