Agenda
18:45 - 19:00 - Introduction, Networking and Food
19:00 - 19:45 – BI Fundamentals: Building an Enterprise ETL Framework in SSIS
Adam Morton (adammorton121@yahoo.co.uk)
SSIS is a powerful ETL tool with many features. But how do you utilise this functionality to best effect in order to create a seamless ETL Framework?
Adam will demonstrate some key techniques of a SQL Server metadata driven ETL framework covering the following;
- Administering the ETL using SQL Server
- Configurations (Environment & Runtime)
- Package Restartability
- Auditability
19:45 - 20:00 – Break
20:00 - 21:00 - Data Warehouse Design: notes from field & best practices
Alex Whittles (www.purplefrogsystems.com)
In this
session we will cover;
OLTP vs OLAP
Kimball vs
Inmon
How to
approach designing a warehouse
Data
quality
Excel 2007
as a cube querying tool