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.
Alberto will show you some common techniques to use when building a budget model with Power Pivot and Power Query, including previous year allocation, multiple-step budgeting with linked back tables, handling of budget on non-existing products
See how to use Power Query to build a detail-level reporting solution
Learn how Auditing provides Configurable Auditing policy and Azure storage to log database activity. Also learn how to leverage Dynamic Data Masking reduce the exposure of sensitive data in application and DevOps scenarios.
Learn how to use the Power BI tools to help you analyse, specify and test the concepts and requirements of your next data Warehouse project.
Using PowerQuery, PowerPivot, PowerView and DAX to model, analyse and win a Fantasy Formula 1 league. Guarantee yourself eternal glory as a braniac petrol head, and become a PowerBI and DAX pro in the process.
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.
PowerBi is hot. This session starts with an empty Excel workbook and walks you via Power Pivot and Power Query to Power View and Power Map.
  1 to 10 of 24 first 1 2 3 last  Show 10 25 50 100 sessions per page