SSAS

ARTICLE

Measuring the dictionary size of a column correctly

This article explains how to correctly measure the dictionary size of a column in a model created in Power BI, Power Pivot, or Analysis Services Tabular.

ARTICLE

New function and the importance of variables in #dax

I recently wrote a few articles about a new function in DAX and the use of variables. For those of you using Power BI or Azure Analysis Services, you always have access to the latest version of the language. Well, in reality I see that new features appears

TOOL

Tabular Editor

Tabular Editor is an editor alternative to SSDT for authoring Tabular models for Analysis Services even without a workspace server.

ARTICLE

Learn DAX, data modeling, and data visualization after MS Data Insight Summit #dax #powerbi #dataviz

I spent three days in Seattle at Microsoft Data Insight Summit , delivering a preconference day about data modeling for business users, and two workshops about DAX. All of these were sold-out, so even if you attended the conference, you might be interested

ARTICLE

User group meetings and #dax training in Minneapolis and Chicago

In the next three weeks I will deliver many speeches and training in United States. Here is the list: June 11, 2017 : Precon Data Modeling with Power BI at Microsoft Data Insights Summit (Seattle, WA) June 12, 2017 : Workshop DAX 101 at Microsoft Data

ARTICLE

Start learning DAX for free

SQLBI offers a new introductory DAX video course called Introducing DAX. This article describes which users will benefit more from this learning experience, and how to enroll in the course.

ARTICLE

Choosing tier in Azure Analysis Services

This article describes the differences in the levels available in Azure Analysis Services (Azure AS), comparing them with the features in SQL Server Analysis Services (SSAS) on-premises.

ARTICLE

Small benchmark for Tabular and Power BI formula engine (FE) #ssas #tabular #powerbi

If you run SSAS Tabular or Power BI, please help me in gathering some performance data for a study I’m doing about Formula Engine performance following these steps: 1) Copy the PowerShell code below in a script Benchmark.ps1, modifying serverName, ssasInstanceName

ARTICLE

Avoid measure and column with the same name in #dax

I recently wrote an article about duplicated names in DAX to highlight a possible case where you can have a measure with the same name of a column. This is not a good idea, mainly because the syntax to reference a measure and a column is identical, and

ARTICLE

New edition of the Analysis Services Tabular book #ssas #tabular

Last year I and Alberto Ferrari wrote a new edition of the Analysis Services Tabular book, which official title is Tabular Modeling in SQL Server Analysis Services (2nd Edition) . Some delay in editing and production delayed the printing, but the book