Tag : Best Practices

HomePosts Tagged Best Practices

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 Power BI forecasting but we have

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

User Friendly Data Models in Power Pivot & Tabular

Organization and user friendly data model development in Power Pivot & Tabular environments take precedence over almost all other concerns. We will discuss best practices of creating a data dictionary, naming rules, etc. of Power Pivot & Tabular data models in other, related postings.   In this posting, we will discuss some options of organizing the

Normalization vs. Denormalization

Normalization vs. Denormalization best practices for Power Pivot / Tabular data modeling is typically not disputed.   First, let's quickly define in human terms what we are referencing when we speak of normalization vs. denormalization. Normalization is reducing data duplication by splitting dimensional data and attributes into their dimension tables.  Typically,

Data Model Best Practices

We will start off discussing the data model itself.   The data model that is created in Power Pivot or a Tabular solution is the foundation of any Microsoft business intelligence solution. The data model consists of the data structure (including tables and their relationships, columns in the tables, and all measures