Continuous Integration has not yet been fully integrated into our BI standards and methods. Tool support is still somewhat unsatisfactory. Let’s look into requirements for a SSAS solution and on ways to approach your self-made solution.
With increasing speed in relational query execution classical analytical solutions get challenged more and more. Why loose time for processing data into multi-dimensional databases? Why analyze outdated data if you can have fresh data instead?
The Analysis Services model used in both Power BI Desktop and SSAS allows solving of very complex modelling issue. In this session we will look at solving several complex modelling problems like many-to-many and RLS.
Learn to build Analysis Services models in the cloud
An IoT analytics solution addressing real-life issues with SCADA data from a network of 600 Waste Water Treatment Plants and 100s of Pumping Stations. An end-to-end solution with Azure Data Warehouse, Azure Data Factory, Azure Analysis Services and PowerBI
Learn to use the M language to load data into the next version of SQL Server Analysis Services Tabular.
Think you know MDX? This session will show you some advanced, little-known but nonetheless practical tips and tricks for writing complex calculations and making your queries run faster.
Continuous Integration is not normally associated with data warehouse projects due to the perceived complexity of implementation. John will be showing how modern tools make it simple to apply Continuous Integration techniques to data warehouse projects
Learn from a real customer how they developed and deployed a series of BI Office solutions to support various business functions including: Finance, Web Analytics Supply, Pricing.
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.
<<123456789>>