It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

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.

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

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.

About

SQL Bits was started by a group of individuals that are passionate about the SQL Server product suite.
There is a breadth of knowledge in the SQL Community that will benefit everyone in the community.
We want to spread that knowledge.

We all work with the SQL community, some of us for many years. We have a range of skills and experiences from being given the MVP award by Microsoft, organising user groups and speaking at events around the world.