Wednesday, April 20, 2016
10:45 AM - 11:30 AM
An Enterprise Data Warehouse (EDW) is a critical factor in getting a leg up on the competition. Organizations invest millions of dollars and thousands of person hours designing, implementing and maintaining their EDW. Far too often, those responsible for the EDW are disappointed that the EDW does not provide a competitive advantage and costs to maintain it keep climbing.
This presentation will explore the reasons why so many EDW implementations don't live up to expectations. We will also discuss some ways to have a high probability of success in implementing an EDW at a low initial cost and a low total cost of ownership (TCO) through Data Warehouse Automation (DWA) technology.
We will discuss:
- How DWA significantly reduces time and cost, while at the same time increasing quality and user satisfaction
- Identify the industry leaders
- Discuss how DWA by itself does not necessarily guarantee success
- Discuss how Enterprise Database Design Patterns coupled with DWA help ensure success
We will close with a demo of how DWA technology works by building a data mart for Sales with slowly changing dimensions and incremental loading, generating the data warehouse relational tables as well as cubes, populating the data warehouse and cubes and running some reports.
Joe Oates is Senior Data Warehouse Architect for TimeXtender. He provides architecture and consulting services to clients, as well as being involved in new product development for TimeXtender. Joe has more than 30 years' experience in developing and managing data warehouse implementations. He has developed three commercial data warehouse products. He has successfully designed and implemented data warehouses in numerous vertical industries for some of the largest companies in the world. Prior to TimeXtender, Joe worked as Senior Managing Consultant at IBM, Chief Architect for the Sybase Business Intelligence Division, Director of Data Warehouse Worldwide at General Motors, Enterprise Data Architect at The Bill & Melinda Gates Foundation, Senior Program Manager at Microsoft, a Partner in a European data warehouse consultancy, and Consulting Manager at Deloitte, Haskins & Sells.