Schedule

Here is our schedule for the upcoming event. We've done our best to provide a good mix of topics and skill levels, we hope you'll find something of interest throughout the day. Our thanks to the speakers listed below for volunteering their time, we couldn't do it without them. If there are schedule changes we will make them here as they happen. We encourage you to check back a few days before the event just in case we have had to move one of your favorite sessions.

Note: Session titles with an '*' have a download available.

Start TimeETL - Room: DAnalysis - Room: BPresentation - Room: CxMisc - Prof Dev, DBA, Powershell - Room: A
7:00 AMSQL Saturday Team .

Registration

Level: Beginner
   
8:00 AMJames McAuliffe

Lookup Between The Lines is Data Late Than Never

Level: Intermediate
Adam Jorgensen

Analysis - 0 to SSAS

Level: Beginner
Angel Abundez

Unleash the Tablix*

Level: Intermediate
Max Trinidad

SSIS - Analyzing your data integrating PowerShell

Level: Intermediate
9:00 AMJohn Welch

Do More (ETL) with Less (Effort) - Automating SSIS

Level: Intermediate
Rob Collie

PowerPivot: BI & Massive Data Analysis for Humans

Level: Beginner
Chris Albrektson

Introduction to SSRS Dashboards

Level: Beginner
Andy Warren

Building a Professional Development Plan

Level: Beginner
10:00 AMBrian Mitchell

Applying FastTrack & PDW Best Practices to your DW

Level: Intermediate
Adam Jorgensen

BI with SharePoint 2010 and Performance Point

Level: Beginner
Dustin Ryan

Reporting on a Cube with SSRS 2008

Level: Intermediate
Daniel Taylor

Useful tools SSMS Tips&Tricks for DBA & Developer

Level: Beginner
11:00 AMJames McAuliffe

SSIShare The Code, Man

Level: Advanced
John Welch

Tuning Analysis Services Processing Performance

Level: Advanced
Sanjay Soni

Delivering BI to the masses at Microsoft

Level: Beginner
Bradley Ball

Page and Row Compression How, When, and Why

Level: Intermediate
12:00 PMSQL Saturday Team and Experts .

Lunch & Ask the Experts

Level: Beginner
   
02:00 PMJohn Welch

Handling Advanced Data Warehouse Scenarios in SSIS

Level: Intermediate
Jen Underwood

What's New for Business Intelligence in "Denali"

Level: Intermediate
Michael Hinckley

BI to SharePoint and vice versa

Level: Beginner
Jose Chinchilla

SQLServer 2012 PowerView "Crescent" Dashboards

Level: Beginner
03:00 PMJoe Celko

Nested Sets model for Trees & Hierarchies

Level: Beginner
Mark Tabladillo

Data Mining with Excel 2010 and PowerPivot*

Level: Intermediate
Melissa Coates

Dashboards...How to Choose Which MSBI Tool?*

Level: Intermediate
Richie Rump

Intro to Project Management for BI Professionals*

Level: Beginner
4:00 PMJohn Welch

Do You Know the Data Flow?

Level: Beginner
Marc Miller

BI in the Cloud*

Level: Beginner
Phillip E. Rosen

Biz Intel Dashboards W/Excel OLAP formulas

Level: Intermediate
Todd Davis

SELECT job FROM firm WHERE hired = 'Yes'

Level: Beginner
5:00 PMJoe Celko

Modeling Time in SQL

Level: Intermediate
Juan Soto

Using MS Access as a BI Tool with SQL Server

Level: Intermediate
Michael Antonovich

SQL - External Data Source for SharePoint & Office*

Level: Intermediate
Mark Tabladillo

Social Marketing 2011 for Microsoft Professionals*

Level: Beginner
6:00 PMSQL Saturday Team .

Raffles and Event Wrap-up

Level: Beginner
   
7:00 PMSQL Saturday Team .

After Party

Level: Beginner
   


Submitted Sessions

Here is the list of sessions submitted so far. Our goal is to feature as many different speakers and topics as possible, but space limitations prevent us from accepting every session. This list is also a great way for those thinking about speaking to see what might be on the agenda and enter a session that doesn't collide with an existing one.

TitleSpeakerLevel
10 Things all BI System Administrators Should KnowRobert DavisIntermediate
7 Mistakes to Avoid in your next DW ETL ProjectRafael SalasBeginner
After PartySQL Saturday Team .Beginner
Analysis - 0 to PowerPivotAdam JorgensenBeginner
Analysis - 0 to SSASAdam JorgensenBeginner
Applying FastTrack & PDW Best Practices to your DWBrian MitchellIntermediate
BI - Practical Date CalculationsJustin StephensAdvanced
BI for the Common ManMichael AntonovichBeginner
BI in the CloudMarc MillerBeginner
BI to SharePoint and vice versaMichael HinckleyBeginner
BI with SharePoint 2010 and Performance PointAdam JorgensenBeginner
Biz Intel Dashboards W/Excel OLAP formulasPhillip E. RosenIntermediate
Building a Professional Development PlanAndy WarrenBeginner
Configuring your PowerShell environmentMaximo TrinidadIntermediate
Dashboards...How to Choose Which MSBI Tool?Melissa CoatesIntermediate
Data Mining with Excel 2010 and PowerPivotMark TabladilloIntermediate
Delivering BI to the masses at MicrosoftSanjay SoniBeginner
Do More (ETL) with Less (Effort) - Automating SSISJohn WelchIntermediate
Do You Know the Data Flow?John WelchBeginner
Enterprise Data Mining with SQL ServerMark TabladilloIntermediate
EXCELlent AcceSSIS into SQLJames McAuliffeIntermediate
Extend your T-SQL scripting with PowerShellMaximo TrinidadIntermediate
Handling Advanced Data Warehouse Scenarios in SSISJohn WelchIntermediate
How to be a DBA in a BI WorldRobert DavisIntermediate
Implementing a Data Cleansing Component for SSISJohn WelchAdvanced
Intro to Perfromance PointMike DavisBeginner
Intro to Project Management for BI ProfessionalsRichie RumpBeginner
Introduction to SSRS DashboardsChris AlbrektsonBeginner
It’s a Matter of Style: Coding with StylePlamen RatchevBeginner
Long parameter listsJoe CelkoIntermediate
Lookup Between The Lines is Data Late Than NeverJames McAuliffeIntermediate
Lunch & Ask the ExpertsSQL Saturday Team and Experts .Beginner
Lunch & Ask the ExpertsSQL Saturday Team and Experts .Beginner
Lunch & Ask the ExpertsSQL Saturday Team and Experts .Beginner
Lunch & Ask the ExpertsSQL Saturday Team and Experts .Beginner
Modeling Time in SQLJoe CelkoIntermediate
Nested Sets model for Trees & HierarchiesJoe CelkoBeginner
Page & Row Compression Deep DiveBradley BallAdvanced
Page and Row Compression How, When, and WhyBradley BallIntermediate
PowerPivot Basics and Creative ImplementationsJen UnderwoodBeginner
PowerPivot: BI & Massive Data Analysis for HumansRob CollieBeginner
Practical Hierarchies: The Social NetworkPlamen RatchevAdvanced
Presentation - 0 to SSRSDavid LiebmanBeginner
Raffles and Event Wrap-upSQL Saturday Team .Beginner
RegistrationSQL Saturday Team .Beginner
Reporting on a Cube with SSRS 2008Dustin RyanIntermediate
Scaling your BI solutionBrian MitchellIntermediate
SELECT job FROM firm WHERE hired = 'Yes'Todd DavisBeginner
Social Marketing 2011 for Microsoft ProfessionalsMark TabladilloBeginner
Social Networking within the SQL Server CommunityJason BacaniBeginner
SQL - External Data Source for SharePoint & OfficeMichael AntonovichIntermediate
SQL Server Denali HAPrakash HedaAdvanced
SQL Smackdown SSIS vs T-SQLMike DavisIntermediate
SQLServer 2012 PowerView "Crescent" DashboardsJose ChinchillaBeginner
SSIS - Analyzing your data integrating PowerShellMax TrinidadIntermediate
SSIShare The Code, ManJames McAuliffeAdvanced
SSRS Chart Anatomy 101Angel AbundezIntermediate
T-SQL Enhancements in DenaliPlamen RatchevIntermediate
Tuning Analysis Services Processing PerformanceJohn WelchAdvanced
Unleash the TablixAngel AbundezIntermediate
Useful tools SSMS Tips&Tricks for DBA & DeveloperDaniel TaylorBeginner
Using MS Access as a BI Tool with SQL ServerJuan SotoIntermediate
Using Parameters in SSRSMike DavisIntermediate
Using Script Task and Components in SSISMike DavisIntermediate
What's New for Business Intelligence in "Denali"Jen UnderwoodIntermediate


Suggested Sessions

Thinking about participating as a speaker but no ideas for the topic? Often our attendees will have an idea for you! Or, submit a suggestion of your own.

Suggested Session TitleSkill Level
Analysis - 0 to PowerPivotBeginner
Analysis - 0 to SSASBeginner
Analysis - Drillthrough ActionsBeginner
Analysis - KPIs & CalculationsBeginner
Analysis - Learning MDXBeginner
Analysis - SSAS HierarchiesIntermediate
Data Warehousing - Data Warehousing FundamentalsBeginner
Data Warehousing - Relational vs MultidemensionalBeginner
Data Warehousing - Star vs Snowflake schemaBeginner
Data Warehousing - Why denormalize?Beginner
ETL - 0 to SSISBeginner
ETL - SSIS PerformanceAdvanced
ETL - SSIS vs Powershel vs T-SQLBeginner
Presentation - 0 to Preformance PointBeginner
Presentation - 0 to SSRSIntermediate
Presentation - Cube based SSRS Reports Intermediate
Presentation - Excel DashboardsBeginner
Presentation - Performance Point DashbaordsBeginner
Presentation - Sharepoint 2010 BI featuresBeginner
Presentation - SSRS DashboardsBeginner
Professional Development - DBA to BIBeginner
Professional Development - Getting CertifiedBeginner
Professional Development - Improve your ResumeBeginner
Professional Development - Nail the job interviewBeginner