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.

Sessions & Content

Mark will explain the use cases for Analysis Services, illustrate how it improves performance for large data sets and eases report writing, and will go through a practical example of building a first Analysis Services solution

In this session we’ll look at a number of different data scenarios and explore ways of remodelling the data to optimise it for cubes and MDX. Sometimes a small ETL change can have a dramatic impact on the cube's functionality and simplicity.

In this session, we will analyze the way DAX solves filtering. Starting from simple queries, we will follow the steps DAX does with the filter context, discovering the internals of the query engine of DAX.

Processing of SSAS OLAP databases can be a tricky business, particularly when it comes to incremental processing of dimensions. John will give you real life examples of why certain approaches work and others do not.

Compare and contrast how multidimensional and tabular achieve the same end result in quite different ways. Features covered can be used in a broad range of scenarios (not only currency conversion), adding valuable knowledge to your SSAS arsenal.

This session will discuss what a modern strategy for data warehousing can be in this era, considering how the use of technologies like PowerPivot or Analysis Services Tabular affect the way you should model your data.

PowerPivot is a breakthrough for self-serve BI but is not easily deployed in the enterprise. Join us for this fast-paced, technical demonstration on how to upgrade PowerPivot into secure and scalable Analysis Services tabular cubes

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.