Modeling

ARTICLE

Filtering Tables in DAX

This article describes a number of techniques available to filter tables in DAX, showing possible pitfalls that you can avoid once you know them, in particular using bidirectional filters. One of the hardest things to do, when learning DAX, is to get rid of common sense reasoning and learn to

ARTICLE

Many-to-many relationships in Power BI and Excel 2016

The new DAX available in Excel 2016 and the data model in Power BI and Analysis Services 2016 offer tools to manage many-to-many relationships in a more efficient way than previous version, as described in this article.

VIDEO

Scalable BI and Advanced Modeling with Analysis Services and Power Pivot

In this session, you will learn how to define a scalable data model in Power Pivot or Analysis Services, handling a growing volume of data and requests. You will see how to optimize memory usage and performance, how to use relationships in the data model, how to solve common design

VIDEO

SSAS Tabular from the Trenches

Microsoft released its new Tabular model of Analysis Services almost three years ago. Even if it is relatively new for many developers, we already used it in several production scenarios. In this session, we will share some of the hard lessons learned from the first large deployments in Tabular. How

VIDEO

Advanced Modeling with Analysis Services Tabular

This session goes beyond the classical star schema modeling, exploring new techniques to model data with Power Pivot and SSAS Tabular. You will see how brute-force power in DAX allows different data models than those used in SSAS Multidimensional. You will see several practical examples, including creating a virtual relationship

VIDEO

Improving Power Pivot Data Models for Microsoft Power BI

Power BI offers many tools to explore a data model created in Power Pivot, such as Excel, Power View, and Q&A. You can improve the user experience and the accessibility of information by creating the data model in a proper way. In this session, learn the best practices in data

VIDEO

Many-to-Many Relationships in DAX

VIDEO

DAX from the field: Real World Case Studies

VIDEO

Advanced Modeling with Analysis Services Tabular

This session goes beyond the classical star schema modeling, exploring new techniques to model data with Power Pivot and SSAS Tabular. You will see how brute-force power in DAX allows different data models than those used in SSAS Multidimensional. You will see several practical examples, including creating virtual relationship (without

VIDEO

DAX from the field