Power View for Power Pivot / Tabular Data Models

Power Pivot or SSAS Tabular data model optimization is important for Power View reporting usability and functionality. In this posting, we will discuss the following topics: X-Axis Guidelines Advanced Properties Image Handling Data Categories Table Behavior Field Behavior   X-Axis Guidelines Data type and distribution Utilize a number or date that increases uniformly (primarily for … Read more

Power View Data Model Optimization

Before a Power View report can be built, you have to have a data model built as a data source.  There are several configuration options to help optimize your data model specifically for Power View.  These configurations and/or optimizations are made within your Power Pivot model or in SQL Server Data Tools on the SSAS … Read more

Power View Best Practices

Power View is an interactive data exploration, visualization, and presentation experience that encourages intuitive ad-hoc reporting. It is a feature of Microsoft Excel 2013, and of Microsoft SharePoint Server 2010 and 2013 Enterprise Edition. Power View in SharePoint is browser-based Silverlight application, a feature of the SQL Server Reporting Services Add-in for Microsoft SharePoint Server. Creating, opening, … Read more