Topic: Modeling
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
DAX from the field
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
How to Calculate with Hierarchies in DAX?
Marco Russo discusses ratio-to-parent measures, which use DAX hierarchies, in this short video. You will see how to create such a calculation and how to use it in a Pivot Table (00:30). DAX does not have an internal mechanism for… Watch now
Hierarchies in DAX
Marco Russo shows you how to handle hierarchies in DAX in this 55-minute, demo-focused video. Although DAX does not have a specific syntax for working with categories, hierarchies can be defined in the data model in Power Pivot and in… Watch now
Many-to-many Relationships in DAX
Let Alberto Ferrari show you how to work with many-to-many relationships in DAX by using an example from a banking data model. Unfortunately, these types of relationship do not just work out-of-the-box—you need to apply correct DAX formulas to benefit… Watch now
Microsoft PowerPivot Excel 2013 in Action
Microsoft Excel 2013 and Business Intelligence: a marriage made in heaven. PowerPivot and Power View, the two most exciting BI tools in the Microsoft stack are now integrated into Excel 2013, providing the perfect environment to build self-service BI solutions.… Watch now
Modern Data Warehousing Strategy
The recent introduction of new technologies like PowerPivot, BI Semantic Model, columnstore indexes in SQL Server and the more general trend of advances in Self-Service BI and Big Data might be considered threats to the classic data warehouse ecosystem. In… Watch now