Tag : SSAS Tabular

HomePosts Tagged SSAS Tabular

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

The Most Important DAX Concept

Data Analysis Expressions (DAX) is the native query and formula language for Microsoft Power Pivot data models and SQL Server Analysis Services Tabular models. DAX includes some of the familiar Excel functions that you have frequently utilized in Excel formulas, but also includes additional functions designed to manipulate relational data as needed. Much
Continue Reading

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