In Part 1 of this series we introduced the concept of enterprise grade semantic models and in Part 2 we discussed some general learnings from developing and deploying enterprise grade semantic models. In Part 3 we will discuss the technical learnings. You won't find a treatise on how to do ...

In Part 1 of this series, I gave a brief introduction to the concept of semantic models and why they should be designed. In this article I discuss the general learnings from developing and deploying semantic models If you are doing it all by yourself, it is not enterprise grade ...

For the past one year, I have been fortunate enough to work on a digital transformation project for one of Australia's largest superannuation funds to develop enterprise grade semantic models. I worked with a wonderful team comprising Solution Architects, Information Architects, Data Modelers, Data Stewards, Product Champions, Business Intelligence Analysts, ...

0In Part 4 of the series, we talked about how to solve business problems when you want to filter a measure using numeric and date expressions. In this series, we go to the next level of business problems where we discuss problems involving % of the total. These kind of ...

In Part 3 of the series, we talked about how to solve business problems when you want to filter a measure by attributes from the fact/dimension table and then evaluate an expression. In this series, we continue the conversation and this time we talk about how to filter the tables ...

There are several articles and books written on how to write better DAX and I have written a fair few as well. This article is not one of them. What will cover in this article are some of the best practices associated with DAX management and housekeeping before we deploy ...