Pre-Conference Seminar Abstracts for Voting: BI

The following three abstracts are the finalists in the BI pre-conference seminar category for PASS SQLRally 2011. Vote for your favorite pre-conference seminar now.

Option A:

Title: A Day of SSIS
Speaker: Andy Leonard
Level: Intermediate
Abstract: Get pragmatic advice for developing, maintaining, and managing SSIS in your enterprise. With a focus on developing SSIS packages with maintenance and management in mind, this day-long session covers SSIS Design Patterns for efficiently loading data, developing a centralized custom logging solution, and developing a metadata-driven SSIS package execution solution. Then, Andy demonstrates how to use this suite of applications to perform predictive analytics and continuously improve your SSIS ecosystem.
Take Home Skills:
  1. Incremental Load SSIS Design Patterns
  2. Metadata-driven SSIS Package Execution solution
  3. Centralized custom logging solution
  4. Log Analysis for Predictive Analytics
  5. Log Analysis for Continuous Improvement
Speaker Bio: Andy Leonard is an Architect with Molina Medicaid Solutions, SQL Server database and Integration Services developer, SQL Server MVP, Professional Association of SQL Server (PASS) Regional Mentor, and engineer. He is a co-author of "Professional SQL Server 2005 Integration Services" and "SQL Server MVP Deep Dive," and blogs for His background includes web application architecture and development, VB, and ASP; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000, 2005 and 2008.
Twitter: @AndyLeonard


Option B:



Business Intelligence Workshop

Speaker: Patrick LeBlanc, Devin Knight, Mike Davis, & Adam Jorgensen
 Level: Intermediate
Abstract: In this full-day workshop, you'll learn from the author team of Mike Davis, Adam Jorgensen, Devin Knight, and Patrick LeBlanc how to build a data warehouse for your company and support it with the Microsoft business intelligence platform. We'll start with how to design and data model a data warehouse including the system preparation. Then, we'll jump into loading a data warehouse with SSIS. After SSIS, you're ready to roll the data up and provide the slice and dice reporting with SSAS. The team will walk through cube development and data enrichment with things like key performance indicators, which are essential for your future dashboards. Lastly, we will cover how to report against the data warehouse with SSRS including a primer in how to write MDX queries against the SSAS cube.
Take Home Skills:
  1. Practical knowledge of building a Dimensional Model
  2. Designing a simple ETL process using SSIS
  3. Designing a Cube
  4. Designing simple SSRS Reports
  5. Building an integrated process that fully leverages the entire MS BI stack to load a Data Warehouse
Speaker Bios:

Patrick LeBlanc
Patrick LeBlanc, SQL Server MVP and author, is currently a Business Intelligence Architect for Pragmatic Works. He has worked as a SQL Server DBA for the past 9 years. His experience includes working in the Educational, Advertising, Mortgage, Medical, and Financial Industries. He is also the founder of, and is the President of the Baton Rouge Area SQL Server User Group. Patrick is a regular speaker at various SQL Server community events, including SQL Saturday, User Groups, and SQL Lunch. Patrick is also a regular speaker at various Microsoft events in the US.

Devin Knight
Devin is a Senior BI Consultant at Pragmatic Works Consulting. Previously, he has tech edited the book "Professional Microsoft SQL Server 2008 Integration Services" and was an author in the books "Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services," and "Knight's Microsoft Business Intelligence 24-Hour Trainer." Devin has spoken at past conferences like PASS Summit and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is the Vice President of the local users' group (JSSUG).

Adam Jorgensen
Adam Jorgensen, MBA, MCITP: BI, MCDBA is the President of Pragmatic Works Consulting, and has been delivering SQL Server and Business Intelligence (BI) solutions for over a decade. His passion is finding new and innovative avenues for clients and the community to embrace BI and lower barriers to implementation. Adam is a PASS regional mentor and member of the regional mentor committee, and a Virtual Technology Specialist for Microsoft. He is also an active member of the South Florida SQL Server User Group (SFSSUG) and is a co-founder of (Business Intelligence Developer Network). Adam co-hosts, is a co-chair of the PASS Virtual Chapter for Business Intelligence, and serves on other groups and boards. He regularly speaks in person and virtually at industry group events, major conferences, Code Camps, and SQL Saturday. He has co-authored white papers and books on business intelligence and business topics.

Mike Davis
Mike Davis is a Senior BI Consultant and Trainer at Pragmatic Works. He was an author on the book "Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services." Mike is an experienced speaker and has presented at many events including several SQL Server User Groups across the US, Code Camps, SQL Server launches, and SQL Saturday events. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.

Blog: Patrick:
Twitter: Patrick: @patrickdba
Devin: @knight_devin
Adam: @adam_jorgensen


Option C:



Advanced Reporting Services – How to achieve almost anything

Speaker: Simon Sabin
Level: Intermediate

The Advanced Reporting Services Seminar will enable you to develop visually rich reports that will meet the needs of your business. Almost anything is possible with Reporting Services and in this seminar you will learn how to achieve difficult tasks. The seminar is based on SQL Server 2008 but will, where possible, show you how to achieve the same in SQL Server 2005. We will also highlight what's coming up in Denali.

Topics to be covered:

  1. Handling Parameters: Multi select, defaulting, passing to queries, displaying on a report
  2. Formatting: How to have rich formatted text (fonts, colours, text sizes) on the report, how to combine with data, how to generate formatted data from SQL Server
  3. Nesting of chart items to provide a rich experience: This will include the reference
  4. The chart control in depth: Handling multiple aligned charts, combining chart types, adding trend lines, handling common axes types
  5. Exporting data to PDF and Excel: Common pitfalls and ways to get round them
  6. How to template your report: How to control formatting from outside of the report, customizing logos, etc.

Take  Home

Generate reports that meet the needs of most users:

  1. Provide template reports when formatting can be configured from the database, fonts, logos, etc.
  2. Ensure report works when outputting to different formats
  3. Understand how to use formatted text to generate standard letters and other mail merge type documents
  4. Understand how nested charts can work and how to reference data from different data sets
  5. Be able to use the power of the chart, including multiple aligned charts, multiple legends, combining different chart types
Speaker Bio:

Simon is the principal consultant for SQL Know How a company that delivers SQL Server consulting and training. Simon specializes in performance tuning and mentoring development teams to deliver high performance solutions utilizing SQL Server for clients such as Microsoft and Tesco. He has worked with SQL Server since 1998 and has always focused on high performance reliable systems. He has a particular expertise in the world of search, distributed architectures, business intelligence, application development, making websites and applications run faster through scale out technologies, and performance tuning the database. Simon was recognized as an MVP in 2006. He runs usergroups in London and Cambridge ( and in 2007 founded SQL Bits ( the largest SQL Server conference in the Europe. He is a regular speaker at SQL Server events as well as writing for his blog

Twitter: @simon_sabin
Copyright 2010-2011 by PASS © | Terms of Use | Privacy Policy | Login | Register