sqlsathistory

Nr: 56

Back to Main list

SQLSaturday #56 - Dallas (BI Edition) 2010

Start Time (24h)	Speaker	Track	Title
00:00:00	Anand Pandya	Room: MPR1200	Answers at the Speed of thought with SSAS
00:00:00	ANDREW MINKIN	Room: MPR4025	Predictive Analytics Lifecycle Management - Part 1
00:00:00	ANDREW MINKIN	Room: MPR4025	Predictive Analytics Lifecycle Management - Part 2
00:00:00	Bryan Smith	Room: MPR4005	MDX Boot Camp - Long
00:00:00	David Stein	Room: Visual Basic	Creating Interactive Dashboards with PowerPivot
00:00:00	David Stein	Room: Windows	Who, What, Where. The Power of SSRS Parameters
00:00:00	Erin Welker	Room: MPR4005	High-performance Data Warehouses
00:00:00	Forrest Dermid	Room: MPR4025	BI Dashboarding End to End
00:00:00	Jose Chinchilla	Room: MPR1200	Business Intelligence: Decaffeinated Please!
00:00:00	Jennifer McCown	Room: Visual Basic	Ground Zero SSRS
00:00:00	John Welch	Room: MPR4025	Implementing a Data Cleansing Component for SSIS
00:00:00	John Welch	Room: Visual Basic	Using the Excel PivotTable as an OLAP Client
00:00:00	John Sterrett	Room: MPR4005	SQL Server 2008 for Developers
00:00:00	Leonard Mwangi	Room: MPR4005	Business Intelligence from data to presentation
00:00:00	Mark Verret	Room: MPR1200	My First Report
00:00:00	Ranjan Muttiah	Room: MPR4005	SQL Spatial
00:00:00	Russel Loski	Room: MPR4025	SSIS and SSRS Better Together - Long
00:00:00	Microsoft Presenter	Room: Office	Enhanced contextual help for Reporting Services
00:00:00	Microsoft Presenter	Room: Office	Analysis Services Supporting User workflow -SQL 11
00:00:00	Microsoft Presenter	Room: Office	Integration Services -- Migrating to the Cloud
00:00:00	Microsoft Presenter	Room: Office	Azure Reporting - early look
00:00:00	Microsoft Presenter	Room: Office	High Availability, Disaster Recovery - SQL11
00:00:00	Microsoft Presenter	Room: Office	Impact and Lineage Analysis
00:00:00	Sean McCown	Room: Windows	Intro to SSIS: Part 1
00:00:00	Sean McCown	Room: Windows	Intro to SSIS: Part 2
00:00:00	Sean McCown	Room: Visual Basic	SSIS Package Architecture
00:00:00	Sriram Ganapathy	Room: Visual Basic	Using powerpivot to create quick effective cubes
00:00:00	Sriram Ganapathy	Room: Visual Basic	How to integrate BI services with SQL Azure
00:00:00	Dr. Suresh Rajappa	Room: MPR4025	Efficient Data Warehouse Design
00:00:00	Tim Mitchell	Room: Windows	Loops, Lookups and Splits: Intermediate SSIS
00:00:00	Tim Mitchell	Room: Windows	Dynamic SSIS with Expressions and Configurations
00:00:00	Tim Mitchell	Room: Windows	Scripting in SSIS
00:00:00	Tim Costello	Room: MPR1200	Tableau: Delivering Self-Serve BI
00:00:00	Thomas LeBlanc	Room: MPR1200	Transition from DBA to BI Architect

SessionID: 28647

Answers at the Speed of thought with SSAS

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: MPR1200

Speaker: Anand Pandya

Title: Answers at the Speed of thought with SSAS

Abstract:

Microsoft SQL Server Analysis Services is the semantic layer in the Microsoft BI technology platform that allows users to see and interact with their information in a faster and more dynamic way compared to static reports. In this event we will take an in-depth look at Analysis Services which provides business users the ability to perform analysis and mine their Data to understand and uncover business issues/drivers leading to better decisions and new business opportunities.

SessionID: 28769

Predictive Analytics Lifecycle Management - Part 1

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: MPR4025

Speaker: ANDREW MINKIN

Title: Predictive Analytics Lifecycle Management - Part 1

Abstract:

This session will introduce techniques of integrating algorithm output with production data. Example code and lab will use data sets beyond Adventureworks.Topics include: Applying multiple models Developing a scorecarding system Assessing the most effective model Track population stability and algorithm performance over time.

SessionID: 28770

Predictive Analytics Lifecycle Management - Part 2

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: MPR4025

Speaker: ANDREW MINKIN

Title: Predictive Analytics Lifecycle Management - Part 2

Abstract:

This session will introduce techniques of integrating algorithm output with production data. Example code and lab will use data sets beyond Adventureworks. Topics include: Applying multiple models Developing a scorecarding system Assessing the most effective model Track population stability and algorithm performance over time.

SessionID: 29314

MDX Boot Camp - Long

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: MPR4005

Speaker: Bryan Smith

Title: MDX Boot Camp - Long

Abstract:

The purpose of this class is to provide you the basics of the MDX language and introduce you to the foundational functions you need to know to build solid MDX queries. Participants should bring their laptops with the Adventure Works DW 2008, Adventure Works DW 2008 R2, or MDX Step-by-Step sample Analysis Services databases installed in order to follow along with the instructor-led demonstrations.

SessionID: 29751

Creating Interactive Dashboards with PowerPivot

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Visual Basic

Speaker: David Stein

Title: Creating Interactive Dashboards with PowerPivot

Abstract:

Will demonstrate how to use PowerPivot to dynamically control several different charts as an interactive dashboard. Presenter will also discuss the pitfalls of allowing users access to this new technology

SessionID: 29752

Who, What, Where. The Power of SSRS Parameters

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Windows

Speaker: David Stein

Title: Who, What, Where. The Power of SSRS Parameters

Abstract:

SQL Server Reporting Services parameter creation and use will be discussed. Aspects such as multi-value parameters, setting default values, and dealing with nulls will be covered.

SessionID: 30088

High-performance Data Warehouses

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: MPR4005

Speaker: Erin Welker

Title: High-performance Data Warehouses

Abstract:

This session will address the things to consider when architecting a large, high-performance relational data warehouse. We’ll discuss strategies for improving ETL and query performance, which frequently conflict with one another. The discussion will touch on partitioning, indexing strategies and pre-aggregation, among other SQL Server 2008 features.

SessionID: 30209

BI Dashboarding End to End

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: MPR4025

Speaker: Forrest Dermid

Title: BI Dashboarding End to End

Abstract:

During this session you will learn how to leverage the Microsoft platform to deliver information to the corporate and at the personal level. We will review SQL Server Reporting Services 2008 R2, SQL Server Analysis Services 2008 R2, SQL Server 2008 R2, SharePoint 2010 and several services like PerformancePoint Services 2010, Excel 2010, and Excel 2010 PowerPivot Add In. The intended audience is for IT and Information Workers who are looking for new ways to leverage the Microsoft platform to deliver information in a concise and meaningful way.

SessionID: 30604

Business Intelligence: Decaffeinated Please!

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: MPR1200

Speaker: Jose Chinchilla

Title: Business Intelligence: Decaffeinated Please!

Abstract:

For many Database Administrators, Data Analysts and other IT and Business Professionals, Business Intelligence (BI) and Data Warehousing (DW) may be a new and uncharted territory with no clear path towards the destination. Others, who have already jumped head-on into the Business Intelligence journey, may be facing challenges that can potentially put their efforts at the risk of failure.In this session I will go over some of the basic concepts that are key in understanding BI and DW. I will also go over the natural roadmap towards BI success, its maturity stages and some of the factors that influence a successful BI project. I will exemplify all these concepts by showcasing a successful real-world BI and DW solution.

SessionID: 30704

Ground Zero SSRS

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Visual Basic

Speaker: Jennifer McCown

Title: Ground Zero SSRS

Abstract:

Beginning SSRS and beyond

SessionID: 30954

Implementing a Data Cleansing Component for SSIS

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: MPR4025

Speaker: John Welch

Title: Implementing a Data Cleansing Component for SSIS

Abstract:

To ensure consistency across data integrated from multiple systems, the application of standard data cleansing routines is a best practice. Examples of data cleansing include translation of NULL values to defaults, trimming string values, and consistent formatting for textual data such as telephone and social security numbers. While these routines can be implemented using standard SSIS components, the resulting logic must be duplicated for each source and column which creates a development and maintenance burden. This session will walk through the process of creating common data cleansing routines in a custom component to enable code reuse with minimal effort across many packages.

SessionID: 30956

Using the Excel PivotTable as an OLAP Client

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Visual Basic

Speaker: John Welch

Title: Using the Excel PivotTable as an OLAP Client

Abstract:

Almost everyone in the business world has Excel, and it is one of the most popular tools for business analysts to use for analyzing data. Excel PivotTables work very well against an Analysis Services data source, and deliver very powerful analytic capabilities. But, as with any tool, it comes with some tradeoffs as well. During this session, we’ll walk through some of the capabilities of Excel PivotTables with OLAP, review the tradeoffs, and explain how you can optimize your OLAP cubes for Excel clients.

SessionID: 31105

SQL Server 2008 for Developers

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: MPR4005

Speaker: John Sterrett

Title: SQL Server 2008 for Developers

Abstract:

Are you still on SQL Server 2005 and wonder what you are missing? Did you upgrade to SQL Server 2008 and haven’t had the time to check out the new features? In one hour you will see demos that give an overview of the new features for developers included with SQL Server 2008. This presentation will include Management Studio (SSMS) Enhancements, T-SQL enhancements, Table Value Parameters, Merge and more…

SessionID: 31496

Business Intelligence from data to presentation

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: MPR4005

Speaker: Leonard Mwangi

Title: Business Intelligence from data to presentation

Abstract:

Data is the backbone of every business and providing the decision makers with accurate and up-to-date information can go long ways for every organization. With SQL Server being the backbone of Microsoft driven Business Intelligence (BI) Solution we will look at how you can build a BI solution from ground up mashing data from different sources and creating a data model that will streamline your environment data collection while provide a visual dashboard with KPI’s, Scorecard, Reports and Filters and presenting them in a SharePoint 2010 environment.

SessionID: 31588

My First Report

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: MPR1200

Speaker: Mark Verret

Title: My First Report

Abstract:

SQL Reporting Services has become a powerful and flexible tool for delivery of information. What tools and skills are needed to utilize this sytem? In this session I will walk through creating your first report using Microsoft's free Report Builder. We will walk through many examples moving from a basic report expanding to more complex functionality.

SessionID: 32039

SQL Spatial

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: MPR4005

Speaker: Ranjan Muttiah

Title: SQL Spatial

Abstract:

Introduction to spatial analysis of data using SQL Server 2008. Aspects

from spatial data processing to generating actionable information for businesses. Description of projections, implementation in SQL Server 2008, data mashups using mapping services API, spatial analysis with BI stack.

SessionID: 32710

SSIS and SSRS Better Together - Long

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: MPR4025

Speaker: Russel Loski

Title: SSIS and SSRS Better Together - Long

Abstract:

SQL Server Integration Services (SSIS) and Reporting Services (SSRS) are two pillars of Microsoft's Business Intelligence stack: SSIS gathering the data and SSRS displaying the data. Do you know that SSRS provides a set of Web Services that SSIS can use to manage and even render SSRS reports? In this session we will develop an SSIS package that exports an SSRS report to pdf format using these Web Services. Then we will use the SSRS Web Services in a Data Flow Script Component to get data from a report.

SessionID: 32726

Enhanced contextual help for Reporting Services

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Office

Speaker: Microsoft Presenter

Title: Enhanced contextual help for Reporting Services

Abstract:

Participants will be shown concepts depicting expanding contextual help for Report Builder 3.0 and beyond and be asked to provide feedback to help us choose between competing designs. Previous customer comments and 2 benchmark tests of RB 3.0 have provided those areas that we think could benefit from this approach which we think might be an alternative to Office Ribbon contextual help. Participants will help us determine future of delivery of on-line and local help with inputs to MSDN and TECH Net for the Business Intelligence products.

SessionID: 32727

Analysis Services Supporting User workflow -SQL 11

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Office

Speaker: Microsoft Presenter

Title: Analysis Services Supporting User workflow -SQL 11

Abstract:

Participants will be asked to help us sketch out and better understand the process of what a BI project looks like end to end “in the wild”. Emphasis will be on roles, artifacts, business requirements etc. Special emphasis on work flow of dev, test and production and understanding difference between BI professional grade (BIDS) and Power Pivot oriented BI. Participants’ input affects decisions to be made with regard to how tools and functionality for BIDS and the more Power pivot oriented BI products will be built out.

SessionID: 32728

Integration Services -- Migrating to the Cloud

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Office

Speaker: Microsoft Presenter

Title: Integration Services -- Migrating to the Cloud

Abstract:

Group discussion on how participants see interaction between BI IT pros and IWs changing as a result of moving to the cloud. What might “cloudifying” the existing tools look like for IWs and BI IT pros? Participants’ input will be factored into SQL 11 and next gen planning

SessionID: 32729

Azure Reporting - early look

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Office

Speaker: Microsoft Presenter

Title: Azure Reporting - early look

Abstract:

Demo and Q and A. Participants will be asked to comment on the design, make suggestions particularly as to how they see this fitting into their workflow and environment and how will it be supported by IT?

SessionID: 32730

High Availability, Disaster Recovery - SQL11

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Office

Speaker: Microsoft Presenter

Title: High Availability, Disaster Recovery - SQL11

Abstract:

Concept and story board exploration concentrating on Patching and HADR story for SQL 11. There will be a special emphasis on roles and responsibilities and how those might change/improve. Will be looking to participants to provide input on concept and help us to determine success criteria and fit to user work flow.

SessionID: 32731

Impact and Lineage Analysis

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Office

Speaker: Microsoft Presenter

Title: Impact and Lineage Analysis

Abstract:

Participants will work through use cases and other conceptual material to help us determine terminology and need for Impact and Lineage Analysis as well as critical to success metrics.

SessionID: 32845

Intro to SSIS: Part 1

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Windows

Speaker: Sean McCown

Title: Intro to SSIS: Part 1

Abstract:

This session will take beginners who know nothing about SSIS and teach them what they need to know to get up and running writing their own packages from scratch.

SessionID: 32846

Intro to SSIS: Part 2

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Windows

Speaker: Sean McCown

Title: Intro to SSIS: Part 2

Abstract:

This session will pick up where the 1st one left off and continue discussing the basics of SSIS.

SessionID: 32847

SSIS Package Architecture

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Visual Basic

Speaker: Sean McCown

Title: SSIS Package Architecture

Abstract:

Here we’ll talk about different ways to make your packages more supportable. Be it from choosing the right way to deploy them, to choosing the proper security model, or even moving packages between servers. Let’s stop making this so hard on ourselves.

SessionID: 33138

Using powerpivot to create quick effective cubes

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Visual Basic

Speaker: Sriram Ganapathy

Title: Using powerpivot to create quick effective cubes

Abstract:

This session will show how to use power pivot functionality in SQL Server 2008 R2 to quickly slice and dice data and create self service cubes and also show you how you can share this information with your team

SessionID: 33140

How to integrate BI services with SQL Azure

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Visual Basic

Speaker: Sriram Ganapathy

Title: How to integrate BI services with SQL Azure

Abstract:

SQL Azure is SQL Server's relational database as a service offering. SQL Azure can be used as a backend for a number of BI applications. This session will demonstrate how SQL Server Integration Services, SQL Server Reporting Services can be used to connect to a SQL Azure database to build applications that use a dynamic and agile data store. The session will also talk about Microsoft® Codename "Dallas" which is a new service allowing developers and information workers to easily discover, purchase, and manage premium data subscriptions in the Windows Azure platform

SessionID: 33273

Efficient Data Warehouse Design

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: MPR4025

Speaker: Dr. Suresh Rajappa

Title: Efficient Data Warehouse Design

Abstract:

Key design issues in desiging the EDW and how to avoild them. For Example, what are the criteria to combine the dimensions or put them saperate, What is the implecation of using RCD (rapidly changing dimensions) etc and how to drive the business value . All these are explained with real world example

SessionID: 33595

Loops, Lookups and Splits: Intermediate SSIS

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Windows

Speaker: Tim Mitchell

Title: Loops, Lookups and Splits: Intermediate SSIS

Abstract:

In this session, we'll explore some of the useful tasks and data flow components of SSIS. Join in as we review the File System Task and the For Each Loop container, as well as data flow components including the Lookup Transformation, the Conditional Split, and the Derived Column. This session will include various demonstrations using SSIS 2008.

SessionID: 33596

Dynamic SSIS with Expressions and Configurations

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Windows

Speaker: Tim Mitchell

Title: Dynamic SSIS with Expressions and Configurations

Abstract:

Never hard-code a connection string or file path again! In this session, we'll look at several ways to introduce dynamic logic into your packages by way of the SSIS expression language, package configurations, and variables. Learn how to reuse tasks, components, and containers by replacing static settings with dynamic and flexible properties.

SessionID: 33597

Scripting in SSIS

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: Windows

Speaker: Tim Mitchell

Title: Scripting in SSIS

Abstract:

In this session, we will explore the two scripting tools in SQL Server Integration Services, the Script Task and Script Component. We'll take a tour through each of these tools, learning how they can add flexibility to your SSIS packages. We'll discuss not only how but when and why to write code in SSIS, and will have a number of demos to illustrate.

SessionID: 33639

Tableau: Delivering Self-Serve BI

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: MPR1200

Speaker: Tim Costello

Title: Tableau: Delivering Self-Serve BI

Abstract:

Rapid-fire visual analysis. Ad hoc query capability. Easy interactive dashboard building. No, this is not going to be an hour of buzzword bingo. This time we will actually deliver on the promise of self service BI. Using SQL in conjunction with a visual analysis tool like Tableau we can help our users find the questions they didn't know they wanted to answer. This session will be demo heavy and will highlight best practices in data visualization and dashboard design.

SessionID: 33717

Transition from DBA to BI Architect

Back to calendar

Event Date: 23-10-2010 - Session time: 00:00:00 - Track: Room: MPR1200

Speaker: Thomas LeBlanc

Title: Transition from DBA to BI Architect

Abstract:

Database Normalization and Dimension Modeling are the same but different. Development in today ‘s larger industries require the design and analysis of Online Transaction Processing (OLTP) to take into account Data Warehousing/OLAP (Online Analytical Processing). My transition from Senior DBA to BI Architect at Amedisys has been a process of sanding the rough edges of my passion from fully normalized databases. The Dimensional Modeling started a re-tooling of my mind to look at end result analytics/statistics from smaller and smaller transactions. From previous experience, I know I am not going to get it right the first time. Lessons learned will mold me into a great BI Guy.

This site is open source. Improve this page.