Continuous Delivery for Data Warehouses and Marts

Most data warehouses are in a constant state of flux. There
are new requirements coming in from the business, updates and improvements to
be made to existing data and structures, and new initiatives that drive new
data requirements. How do you manage the complexity of keeping up with the
changes and delivering new features to your business users in a timely manner,
while maintaining high quality? Continuous delivery is an approach for managing
this. It focuses on automation of many steps in the process, so that time is
spent on adding new functionality, rather than repetitive steps. Attend this
session and learn how Continuous Delivery can be applied to your data projects.
Presented by John Welch at SQLBits XII
Tags (no tags)
  • Downloads
    Slide deck available Slide Deck 1.3 MB
    Video available MP4 Video HD 538 MB
  • SpeakerBIO

    John Welch works at Pragmatic Works, where he manages the development of a suite of BI products that make developing, managing, and documenting BI solutions easier. John has been working with business intelligence and data warehousing technologies since 2001, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), an award given due to his commitment to sharing his knowledge with the IT community, and 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), and others. He has also contributed to multiple books on SQL Server, including "Smart Business Intelligence Solutions with Microsoft SQL Server 2008" and the “SQL Server MVP Deep Dives” series.

    John writes a blog on business intelligence and SSIS topics at He is active in open source projects that help ease the development process for Microsoft BI developers, including ssisUnit (, a unit testing framework for SSIS.
  • Video