John Welch works at SentryOne, where he leads the development of a suite of data and BI products that make developing, testing, managing, and documenting data solutions faster and more efficient. John has been working with data, business intelligence, and data warehousing technologies since 2001. He was awarded as a Microsoft Most Valued Professional (MVP) 2009 - 2016 due to his commitment to sharing his knowledge with the IT community, and is an SSAS Maestro.  John is an experienced speaker, having given presentations at Professional Association for SQL Server (PASS) conferences, the Microsoft Business Intelligence conference, Software Development West (SD West), Software Management Conference (ASM/SM), SQL Bits, and others. He has also contributed to multiple books on SQL Server and business intelligence.

Sessions

Do you have complex dimensions in your data warehouse? Parent-child, late arriving, type 3 or type 6? In this session, we'll cover some SSIS patterns for handling each of these, along with tips for making them perform well.
Unit testing is incredibly beneficial, but is very difficult to do effectively in SSIS. If you have wanted to do this, but aren't sure how, this session will cover the options and demonstrate a free tool for unit testing packages.
Continuous delivery is an approach that enables new functionality to be delivered as needed. This session will cover how this approach can be applied to data warehouses to enable faster time to value for the consumers of the data.
Unit and integration testing for SSIS packages can be challenging. Come to this session to learn how to leverage open-source tools to drive the testing of your packages and the resulting data.
Learn common patterns for testing data, and the anti-patterns that trip developers up.
John_Welch130516.jpg