Continuous Integration and the Data Warehouse

2016

TL; DR

Continuous Integration is not normally associated with data warehouse projects due to the perceived complexity of implementation. John will be showing how modern tools make it simple to apply Continuous Integration techniques to data warehouse projects

Session Details

Continuous Integration is not normally associate with data warehouse projects due to the perceived complexity of implementation. John will be showing how modern tools make it simple to apply continuous integration techniques to data warehouse projects. In particular, the session will cover:

Setting up SQL Server Data Tools for automated deployments
Creating DAC Publish profiles
The many actions of SQLPackage.exe
Automating your build and deployments with PowerShell and psake
Guide to configuring TeamCity as your build server
Automated Integration and Regression testing of your Data Warehouse
Automating cube and tabular model deployment

3 things you'll get out of this session

Dr John Tunnicliffe's previous sessions

DevOps, CI and the Data Warehouse

DevOps and continuous integration provide huge benefits to data warehouse development. John will be showing how you can use VSTS and Octopus Deploy to build, test and deploy your data warehouse

Designing a database to best support multidimensional OLAP

Data warehouse designers often ignore the specific needs of an OLAP database. In this session, John will outline the best ways to optimise your relational database to support your multidimensional OLAP cubes

Incremental processing of SSAS Multidimensional databases

Processing of SSAS OLAP databases can be a tricky business, particularly when it comes to incremental processing of dimensions. John will give you real life examples of why certain approaches work and others do not.

Building an infrastructure to support real-time OLAP

Users love flexible analytics but hate to wait for the data to be loaded into a traditional data warehouse. John will describe how to build an infrastructure to support real-time loading of your OLAP cubes so your user's get exactly what they want

Building a dynamic OLAP environment

This session will present the tools and techniques used to create OLAP cubes and supporting data marts on-the-fly from a mere set of data files and configuration metadata.