It's a good idea to stick to the star schema paradigm whenever we create a data model inside Power BI or Analysis Services Tabular. Dimensional modeling is key to the analytical power and the performance of our data model. But sometimes, sticking to a concept prevents us from finding creative solutions for many problems. In this session, I will showcase data modeling solutions for topics like the event-in-progress challenge, helping to create more simple DAX statements, and for this reason, also performing fast on top of large sets of data. But data modeling can also help to overcome challenges for data visualization. Next to the event-in-progress challenge, I will demonstrate different approaches to data modeling to help solve the "dynamic axis content" requirement.
Next to the gains we can achieve through data modeling, I will also cover the costs we have to pay. Costs don't necessarily mean money, but the time it takes to create a model (of course, time is money) and model complexity.