We write articles and white papers on Microsoft Business Intelligence technologies on a regular basis. The list below showcases all our content sorted chronologically - you can filter through the content by post type, topic, and author.
     Page 2 of 927 posts
article –

The importance of star schemas in Power BI

Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! This article shows why a star schema can fix some of the issues in your report.  Read more

blog post –

Choosing Azure Analysis Services for large datasets

I often get questions about use cases for Azure Analysis Services. So I wanted to do a quick recap of the points I commonly discuss in these conversations, and have them readily available for the next conversation… As a bonus,…  Read more

article –

Naming temporary columns in DAX

This article describes a naming convention for temporary columns in DAX expressions to avoid ambiguity with the measure reference notation.  Read more

blog post –

VertiPaq Analyzer 2.0 Preview 1

In 2015 I released the first version of VertiPaq Analyzer, a tool to quickly analyze the structure and data distribution of a Tabular model that can be used with Analysis Services and Power BI.  Read more

DAX 101 –

Previous year up to a certain date

This article describes how to compute previous year values up to a certain date. This is useful in case the data is presenting incomplete months or years.  Read more