Topic: Modeling
Import vs. DirectQuery in Power BI
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
Different types of many-to-many relationships in Power BI
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
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… Watch now
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… Watch now
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… Watch now
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… Watch now
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… Watch now