SQLRALLY.com PASS SQLRally 2011 www.sqlpass.org Twitter Facebook LinkedIn

BI Platform Architecture, Development and Administration Track

The following sessions were chosen to be presented at PASS SQLRally Nordic 2011. Click on the links to view specific abstracts or scroll down to see them all:


Selected Sessions

Title: Designing High Performance ETL for Data Warehouse. Best Practices and approaches
Speaker: Marcel Franke & Alexei Khalyako
Abstract: In today’s business the amount of data is growing constantly. Data Warehouses are getting bigger and bigger but the loading windows stay constantly and Data Loads during the day become very common. Achieving the right performance for Data Loads becomes a very crucial steps for the success of a Data Warehouse solution. This sessions gives an overview of design principles and best practices how to best load a Data Warehouse with SQL Server Integration Services in case of performance.


Title: Security in Analysis Services 2008R2 and BISM
Speaker: Chris Webb
Abstract: This session will cover how to implement security in Analysis Services 2008 R2, including more advanced topics such as dynamic security and security on parent/child hierarchies. It will also look at how security can be implemented in the Tabular model in BISM and compare functionality with the Multidimensional model.

Title: Top five features in Crescent, Microsoft's new Denali Reporting Tool
Speaker: Thomas Ivarsson
Abstract: This session is focused on presenting the new self service reporting tool in Denali and SharePoint 2010, Crescent. The first part will describe the role of Crescent in the Microsoft BI stack of reporting tools and compare it to Excel 2010, Reporting Services and Report Builder. Topics are supported data sources, Crescent and Sharepoint 2010 and Crescent's reporting language DAX. The second part will demo the five most important features in Crescent like how to design the report, the abstraction of the data model, support for pictures and the possibility to show data changes over time in charts. Finally a few shortcomings in the first release will be mentioned.

Title: The New Possibilities in Microsoft Business Intelligence
Speaker: Johan Åhlen & Tim Peterson
Abstract: Microsoft is bringing us new opportunities in Business Intelligence. This session introduces all of these new opportunities: the BISM model in Denali with the possibility of creating in-memory cubes, near-real time BI with StreamInsight, large scale data warehousing on a new level with the Parallel Data Warehouse, BI in the cloud with Azure, and the beautiful new self-service Business Intelligence tool in Reporting Services - Crescent. The purpose of this demo-intensive session is to give an inspiring overview of the possibilities that are becoming available. When should you use each of these new technologies? How can you prepare for implementing each one? How can you migrate from your current Microsoft BI system to the new systems that are available or will soon be available? This session will provide you with some of the answers.

Title: BISM Introduction
Speaker: Marco Russo
Abstract: BISM (BI Semantic Model) is the new model that will be available in Analysis Services "Denali" for all end user experiences in BI applications. It will merge the multidimensional experience (formerly known as UDM) and the tabular experience provided by the new Vertipaq engine, now embedded in Analysis Services and previously introduced by PowerPivot. This new model will be support both MDX and DAX and will preserve existing investment, offering new tools and opportunities to BI applications of any size. This session will show how this long term roadmap will be implemented in the future versions of Analysis Services, analyzing the impact on existing applications and the opportunities offered by new features and new tools.

Title: Programming Patterns with BISM Tabular
Speaker: Alberto Ferrari
Abstract: BISM, the new way of modeling data in SSAS, implements the DAX programming language as one of the options to author complex calculations. Moreover, in BISM there is the new Tabular data model, inpair with the Multidimensional data model we are used to adopt since the birth of SSAS. Both these environments are quite new and somehow inexplored. In this session the speaker is going to analyze some common data modeling scenarios,take a quick view at the Multidimensional implementation and then perform a deepdive into the Tabular/DAX solution of the same data model, paying attention to the main differences in the approach of the two methodologies. Using examples of various complexity, the goal is to show how to leverage the DAX programming language and the Tabular data model to solve common scenarios.

Title: Planning and forecasting with SQL Server, Excel 2010 and SharePoint 2010
Speaker: Simon Lidberg
Abstract: When Microsoft discontinued PerformancePoint 2007 Planning many thought that Microsoft left the planning space to partners and competitors. This session will cover how you can build a complete planning solution using the new write-back capabilities in Excel 2010 together with Analysis Services and SharePoint Server to create a complete planning solution.

Title: Data Visualisation: Are You Winning the Red Queen's Race?
Speaker: Jen Stirrup

Is your enterprise reporting like the Red Queen's Race, running madly on the spot, and can't move forward? Reporting is an essential and highly-visible part of running a business. If datavisualisation best practices are not followed, then reports can be mislead even the smartest business decision makers. To help you win the Red Queen's Race and move enterprise reporting forward, this presentation will discuss best practices around data visualisation, using SQL Server 2008 R2.

We will discuss a variety of topics, including:- Best Practices in Data Visualisation -guidelines from Tufte, Few and Cognitive Psychology Research- Applying Best Practices to Visualising Large Data Sets - Applying Best Practices to Multivariate Statistics Demonstrations will be carried out using SQL Server 2008 R2. This presentation will assume a basic familiarity of Reporting Services. This session is aimed at Business Intelligence specialists with some familiarity with Reporting Services. Ultimately, it is intended for those who would like to produce effective reports by working smarter rather than harder. Come and learn how to win the Red Queen's Race by moving your reporting forwards, not running on the spot!

Title: Delivering KPIs with Analysis Services
Speaker: Peter Myers
Abstract: Key Performance Indicators (KPIs) are important measurements that influence behavior and allow an organization to evaluate whether they are meeting target for specific objectives. This session will commence by introducing how KPIs are defined in Analysis Services, in both the Unified Dimensional Model (UDM) and the upcoming release of PowerPivot, and then made available for consistent reporting using Excel, Excel Services, Reporting Services and PerformancePoint Services. Next, consideration will be given to where the KPI sources its target data from. The session will explore additional capabilities of the UDM to collect planning data, specifically by using cube write-back, and Data Mining to seed planning values. Finally, the session will introduce how the Excel 2010 What-If Analysis feature can be used to support the collection of planning data from users.


Title: Slowly Changing Dimensions
Speaker: Benjamin Sigursteinsson
Abstract: This session will give examples of different approaches to loading Slowly Changing Dimensions (SCD), type 1 and type 2.  This is one of the bottlenecks in loading data warehouses and pros and cons of the most common approaches will be explored. Tools used will be SSIS (3rd party solutions and Microsoft‘s own SCD Wizard) and T-SQL. For those not familiar with SCD‘s, a quick introduction will be made. 

RegisterToAttend Agenda


Welcome to PASS SQLRally Nordic 2011!

Presenting Sponsor


Enterprise Sponsors











SQL Service


Standard Sponsors


Red Gate