Skip Main Navigation
Page Content

Save This Event

Event Saved

Real-World ETL Design Patterns using SSIS and Biml

SQLSaturday Nashville

Friday, January 12, 2018 from 8:30 AM to 4:00 PM (CST)

Real-World ETL Design Patterns using SSIS and Biml

Ticket Information

Ticket Type Sales End Price Fee Quantity
Regular full-day:   more info Jan 10, 2018 $129.00 $9.25
BOTH Days (1 half-day & 1 full-day | 1.5 days of training)   more info Jan 10, 2018 $165.00 $11.25

Share Real-World ETL Design Patterns using SSIS and Biml

Event Details

Real-World ETL Design Patterns using SSIS and Biml


ETL can be one of the most difficult and time-consuming parts of building a Data Warehouse. In this full-day workshop, you will learn best practices, techniques and design patterns that will help you steer away from common pitfalls that are made early in the ETL design process.


We will start with an overview of ETL architectural approaches and SSIS frameworks, then show you how you can automate your SSIS development by using Biml. Next, we will go through load patterns for Staging and Data Warehouse layers, including incremental loads and slowly-changing dimensions. Finally, we will look at how to log, configure, orchestrate and tune our solution.


Part 1: ETL Architecture and Design Considerations

  • Staging Design Patterns
  • Data Warehouse Design Patterns
  • SSIS Frameworks


Part 2: Automating SSIS with Biml

  • Introduction to Biml and BimlScript
  • Biml Code Management
  • Designing and Consuming Metadata


Part 3: Staging Load Patterns

  • Sources and Data Profiling
  • Data Cleansing and Transforming
  • Incremental Loads


Part 4: Data Warehouse Load Patterns

  • Handling Data Change
  • Data Enrichment
  • Fact and Dimension Loads


Part 5: Operations and Performance

  • Logging and Error Handling
  • Configuration, Deployment and Orchestration
  • Optimizing and Tuning


Whether you are new to SSIS or have years of experience, you will leave this workshop with new techniques to build your first Data Warehouse or enhance your current ETL solution.

Jason Horner

Jason Horner is a Microsoft Certified Master of SQL Server and has worked with it for more than 10 years. He began work as a DBA/Application Developer in 1999. He made the transition to delivering BI solutions in 2002 and began working with spatial data in 2008. Jason’s latest focus has been architecting large-scale spatially enabled BI solutions.


Catherine Wihelmsen

Cathrine loves teaching and sharing knowledge. She works as a consultant, technical architect and developer, focusing on Data Warehouse and Business Intelligence projects. Her core skills are ETL, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she's active in the SQL Server and PASS communities as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.


Don't forget to visit for details about SQLSaturday Nashville!

Have questions about Real-World ETL Design Patterns using SSIS and Biml? Contact SQLSaturday Nashville

Save This Event

Event Saved

When & Where

MTSU *Business & Aerospace Building (BAS) Room S275
1301 East Main Street
Mufreesboro, TN 37132

Friday, January 12, 2018 from 8:30 AM to 4:00 PM (CST)

  Add to my calendar
Real-World ETL Design Patterns using SSIS and Biml
Things to do in Mufreesboro, TN Class Science & Tech

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.