Should you use Import or DirectQuery data connectivity mode for your Power BI models? Let’s make the right choice by comparing the performance and scalability of the two options!  Watch now

The introduction of the weak relationships in Power BI composite models enables new data modeling techniques. However, not all of the many-to-many relationships can be managed by using weak relationship. The “classical” many-to-many relationships in data warehouse is a design…  Watch now

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…  Watch now

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…  Watch now

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…  Watch now

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…  Watch now

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…  Watch now