PASS Summit for SQL Professionals is coming up next week, October 11th through October 14th in Seattle and we wanted to take an opportunity to highlight the BI-focused sessions at the event. So what can you expect to learn at PASS Summit from a BI perspective? This blog post has you covered.

Below is an overview and schedule of all the BI related sessions at this year’s PASS Summit. Please note some of these sessions occur at the same time so if you’re attending the summit, you may have to pick and choose which to attend.

If you plan on attending make sure you register or if you’ve already registered check out the PASS Summit Schedule Builder here. If you are on Twitter, be sure you follow @SQLPass and join the conversation with the hash tag #SQLPass. The Microsoft BI social team will be tweeting live from the summit and we hope to see you there!


Session Code

Session Day

Session Time

Session Name





10:15 AM

What’s New in SQL Server Code Name “Denali” Reporting Services

In SQL Server 2008 R2, we introduced PowerPivot, the self-service BI experience that enables information workers to build, share and collaborate on their personal and team BI applications within the familiar environment of Excel and SharePoint. In SQL Server “Denali”, we’re bringing some of the breakthrough technologies in PowerPivot into Analysis Services to support Corporate BI applications. At the same time, we’re also bringing some of the more sophisticated BI capabilities in Analysis Services and making them available to information workers in PowerPivot v2. This session will bring you up to speed on the new developments in Analysis Services and PowerPivot for the Denali release.

Pej Javaheri, Thierry D’Hers



3:00 PM

End-User alerting with SQL Server Code Name “Denali” Reporting Services

SSRS introduces alerting for end-users with Denali, enabling users to set up their own alerts directly against the elements of a report. We'll cover this new capability, what you need to know for configuring and implementing, and how to manage alerts within your environment

Lukasz Pawlowski



4:45 PM

Reporting with Crescent [Your organization]’s Got Talent

Demos, demos, and more demos of Project Crescent end user capabilities including optimizing models.

Cindy Song, Olivier Matrat



10:15 AM

Cloud BI – SQL Azure Reporting

Come learn about Microsoft's investment in Cloud BI - SQL Azure Reporting is ready for production implementations. Learn how to deploy reports in the cloud, consume cloud data from SQL Azure via premium tools and how to use Windows Azure Datamarket to your business advantage.

Michael Kiselman, Yi Liao



10:15 AM

Deep Dive Into New Features of PowerPivot in SQL Server Code Name “Denali”

A Deep dive into the new tabular data model in Denali covering the new features and changes in PowerPivot for Excel 2010, including the new measure grid, hierarchies and KPIs, as well as new DAX expressions.

Julie Strauss



10:15 AM

Configuring SQL Server “Denali” Reporting Services with SharePoint 2010

An overview of what’s new for Reporting Services SharePoint mode in Denali and best practices for configuring Reporting Services for SharePoint.

Carl Rabeler, Prash Shirolkar



10:15 AM

Tips and Tricks for Building Rich Reporting Services Reports

Tips and tricks for building reports using SSRS (from 2008 to Denali). Will show you how to create and solve solutions using features like Tablix, and tips on how best to author and manage reports

Bob Meyers



1:30 PM

Deploying and Managing SQL Server Code Name “Denali” PowerPivot v2 for SharePoint

A deep tour of the PowerPivot v2 with SharePoint that is coming in Denali including architecture, capacity planning, deployment and management.

Dave Wickert, Kay Unkroth



1:30 PM

SQLCAT: Tier-1 BI in world of Big Data

This session will highlight issues, best practices, and lessons learned from a select group of SQL Server's Enterprise customers. Issues to be covered include scaling out, distinct count, design, IOPs, and other Big Data scenarios.

Denny Lee, Thomas Kejser



3:00 PM

Developing and Managing a Business Intelligence Semantic Model in SQL Server Code Name “Denali” Analysis services

Use the new features in SQL Server "Denali" to develop and manage a BI Semantic Model in Analysis Services. We will discuss the new capabilities in creating your BI Semantic Models, using PowerPivot as a starting point, and how to troubleshoot your models.

Cathy Dumas



5:00 PM

Project Crescent Solution Configuration

Everything you need to do know to get Crescent up and running with SharePoint along with end to end security configuration and options.

Bob Meyers, Dave Wickert



5:oo PM

Building the Perfect BI Semantic Model for Crescent

In this session we’ll cover the new BI Semantic model capabilities and how you can create the right models for users to create their own insights using Project Crescent, the new Self-Service reporting technology as part of SQL Server Denali.

Kasper de Jonge, Carl Rabeler



10:15 AM

Enriching your BI Semantic Models with Data Analysis Expressions (DAX)

In this session we will present what is new in Data Analysis Expressions (DAX) coming with the Denali release. We will show measures and calculated columns and DAX as a Query language using many demos.

Howie Dickerman, Kasper de Jonge



1:00 PM

SQLCAT: Configuring and Securing Complex BI Applications in a Sharepoint 2010 Environment with SQL Server “Denali”

Have you struggled to configure SharePoint 2010 security to backend data sources with Excel Services, Reporting Services, PowerPivot and PerformancePoint in complex topologies? Would you like to discuss security Kerberos and non-Kerberos security options for these scenarios? Would you like to know what changes are coming in this area with Denali to reduce the reliance on Kerberos for connections to Analysis Services data sources, especially with respect to crossing domain boundaries? This session will discuss a variety of complex topologies and security solutions with both SQL Server 2008R2 and with Denali. We will also demonstrate how to use PowerShell scripts to configure the Microsoft BI stack, with and without Kerberos.

Carl Rabeler, Chuck Heinzelman