SQLSaturday #56 - Dallas (BI Edition) 2010 10/23/2010 12:00:00 AM SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. #sqlsat56 Dallas TX 75309 http://www.sqlsaturday.com/images/sqlsaturday_gb_icon.png http://www.sqlsaturday.com/images/sqlsaturday_gb_image.png Conference Information general True 1 default Maps maps False 2 default Schedule of Events schedule True 3 default Sponsors List sponsorslist True 4 default Twitter twitter True 5 default Todo List todo False 6 default My Schedule myschedule True 7 default Feedback feedback False 8 default Key Events keyevents False 9 default Share share True 10 default 2338 Suresh Rajappa Room: MPR4025 MPR4025 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 10/23/2010 8:30:00 AM 10/23/2010 9:30:00 AM 2340 Anand Pandya Room: MPR1200 MPR1200 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. 10/23/2010 8:30:00 AM 10/23/2010 9:30:00 AM 2349 Sriram Ganapathy Room: Visual Basic Visual Basic 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 10/23/2010 9:45:00 AM 10/23/2010 11:00:00 AM 2351 Drew Minkin Room: MPR4025 MPR4025 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. 10/23/2010 2:45:00 PM 10/23/2010 4:00:00 PM 2352 Thomas LeBlanc Room: MPR1200 MPR1200 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. 10/23/2010 9:45:00 AM 10/23/2010 11:00:00 AM 2375 Mark Verret Room: MPR1200 MPR1200 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. 10/23/2010 11:15:00 AM 10/23/2010 12:15:00 PM 2381 Sriram Ganapathy Room: Visual Basic Visual Basic 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 10/23/2010 8:30:00 AM 10/23/2010 9:30:00 AM 2410 Bryan Smith Room: MPR4005 MPR4005 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. 10/23/2010 9:45:00 AM 10/23/2010 11:00:00 AM 2435 Tim Costello Room: MPR1200 MPR1200 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. 10/23/2010 1:30:00 PM 10/23/2010 2:30:00 PM 2442 Ranjan Muttiah Room: MPR4005 MPR4005 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. 10/23/2010 8:30:00 AM 10/23/2010 9:30:00 AM 2454 John Sterrett Room: MPR4005 MPR4005 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… 10/23/2010 11:15:00 AM 10/23/2010 12:15:00 PM 2478 Jose Chinchilla Room: MPR1200 MPR1200 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. 10/23/2010 2:45:00 PM 10/23/2010 4:00:00 PM 2618 Erin Welker Room: MPR4005 MPR4005 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. 10/23/2010 1:30:00 PM 10/23/2010 2:30:00 PM 2625 Leonard Mwangi Room: MPR4005 MPR4005 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. 10/23/2010 2:45:00 PM 10/23/2010 4:00:00 PM 2646 Russel Loski Room: MPR4025 MPR4025 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. 10/23/2010 11:15:00 AM 10/23/2010 12:15:00 PM 2689 John Welch Room: MPR4025 MPR4025 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. 10/23/2010 1:30:00 PM 10/23/2010 2:30:00 PM 2691 John Welch Room: Visual Basic Visual Basic 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. 10/23/2010 4:15:00 PM 10/23/2010 5:15:00 PM 2763 Drew Minkin Room: MPR4025 MPR4025 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. 10/23/2010 4:15:00 PM 10/23/2010 5:15:00 PM 2764 David Stein Room: Visual Basic Visual Basic 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 10/23/2010 11:15:00 AM 10/23/2010 12:15:00 PM 2765 Forrest Dermid Room: MPR4025 MPR4025 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. 10/23/2010 9:45:00 AM 10/23/2010 11:00:00 AM 2766 Microsoft Presenter Room: Office Office 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. 10/23/2010 8:30:00 AM 10/23/2010 9:30:00 AM 2767 Microsoft Presenter Room: Office Office 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. 10/23/2010 9:45:00 AM 10/23/2010 11:00:00 AM 2768 Microsoft Presenter Room: Office Office 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 10/23/2010 11:15:00 AM 10/23/2010 12:15:00 PM 2769 Microsoft Presenter Room: Office Office 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? 10/23/2010 1:30:00 PM 10/23/2010 2:30:00 PM 2770 Microsoft Presenter Room: Office Office 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. 10/23/2010 2:45:00 PM 10/23/2010 4:00:00 PM 2771 Microsoft Presenter Room: Office Office 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. 10/23/2010 4:15:00 PM 10/23/2010 5:15:00 PM 2799 Sean McCown Room: Windows Windows 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. 10/23/2010 8:30:00 AM 10/23/2010 9:30:00 AM 2800 Sean McCown Room: Windows Windows This session will pick up where the 1st one left off and continue discussing the basics of SSIS. 10/23/2010 9:45:00 AM 10/23/2010 11:00:00 AM 2801 Tim Mitchell Room: Windows Windows 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. 10/23/2010 11:15:00 AM 10/23/2010 12:15:00 PM 2802 Tim Mitchell Room: Windows Windows 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. 10/23/2010 1:30:00 PM 10/23/2010 2:30:00 PM 2803 Tim Mitchell Room: Windows Windows 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. 10/23/2010 2:45:00 PM 10/23/2010 4:00:00 PM 2804 Sean McCown Room: Visual Basic Visual Basic 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. 10/23/2010 2:45:00 PM 10/23/2010 4:00:00 PM 2806 David Stein Room: Windows Windows 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. 10/23/2010 4:15:00 PM 10/23/2010 5:15:00 PM 2832 Jennifer McCown Room: Visual Basic Visual Basic Beginning SSRS and beyond 10/23/2010 1:30:00 PM 10/23/2010 2:30:00 PM