ETL from Good to Great
The Data Warehouse has gone mainstream. Just about every sizable organization working in a ‘data rich’ industry has embraced Data Warehouse and Business Intelligence technology. Now that ‘everyone has got one’, true competitive advantage is gained by building a better Data Warehouse solution than your competitors. And at the heart of every Data Warehouse solution are the ETL processes that truly differentiate the good from the great.
Since not all ETL was created equally, this presentation will identify and discuss the leading best practices for ETL architecture, design and development. We will explore how to implement these best practices within the constraints of an existing ETL solution.
In this session you will learn best practices in ETL architecture, design and development including:
- How to determine which activities are best suited for your ETL tool
- How to improve ETL through proper use of Staging
- How to maximize reusability in ETL design and development
- How to improve consistency through use of standardized components
- How to handle source data quality issues
Darren Edery is Director of Data Warehousing Services at Adastra. He has extensive experience in the data warehousing and data analytics field, which he has developed and applied across the financial services, healthcare, consumer packaged goods, telecommunications, and high tech industries.
On April 20th Adastra is hosting “ETL- The Humble Champion of Data Warehousing Conference” with keynote speaker Stephen Brobst, ETL guru and CTO of Teradata. This is the first ever conference taking place in Toronto and focusing exclusively on ETL.
Questions please contact