Tabular offers only one-to-many relationships on a single column: it seems poor when compared with Multidimensional. However, with DAX, you can handle any relationship. We analyze and solve scenarios with calculated, virtual and complex many-to-many.
Learn about Excel and PowerBI from the Excel team.
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
Learn ready-to-use DAX patterns improving development speed of Power Pivot solutions. Good also for SSAS Tabular developers.
Explore Power Query features to import data from existing Corporate BI systems.
An in-depth session on advanced Power Query functionality and the M language
You probably already heard a lot of the wonders of PowerPivot and Power View, but will you have any other cool new BI features with Excel 2013. The answer is a big YES! This session will demo a lot of those.
In this session, you will learn how to combine data from web services, tables and cubes to build a powerful model, and visualise it in Excel.
How to get started with PowerPivot and QlikView. Covering how to combine data sources, common pitfalls, adding some calculation logic and building a basic dashboard. We’ll walk through the same example on both systems and compare the results.
Introduce the features of BISM (BI Semantic Model), the new engine that will be available in Analysis Services "Denali".
A look at the Microsoft Business Intelligence stack and how other products can enhance a SQL BI project.
During this session we are going to analyze common business problems that require and advanced usage of DAX functions and data modeling with PowerPivot.