Monday, April 18, 2016
12:00 PM - 12:30 PM
A data warehouse is an extremely valuable enterprise resource but they are still too expensive and slow to build - the business is still starved of data at the speed that they need. In many cases the business will try to go round IT to get direct access to the data because IT can not keep up in the data warehouse.
New technologies have not replaced the need for a centralized, consistent, available set of data to drive analytics and reporting.
Data Warehouse automation tools reduces the time to value when building a data warehouse by blending development tasks and generating code based on templates.
Requirements are guidelines at best when designing / building the data warehouse
The data warehouse design will change when trying to populate it and when the users use it. Parts of the warehouse will keep on changing.
Douglas has worked in data warehousing for 15 years, working as a developer, consultant, project lead and architect for banks, airlines, retailers and universities. Over that time he has seen what works and what doesn't in data warehouse projects. Agile development done right works, other approaches introduce risk. But agile needs to be applied appropriately to data warehousing.