W8: How to Build a Data Warehouse in a Day

(moved from S2)

This presentation is for business management or technical staff struggling with the concepts of data warehousing. No, we won't really build a data warehouse in a day, but we will cover the essential ingredients necessary to develop a foundational understanding of this discipline.

Using a simple but representative case study, we will discuss:

• Understanding Data Warehouse Architecture
• User-Driven Analysis and Design
• Modeling and Building the Database
• ETL - The Secret of Successful Data Warehouses
• Business Intelligence - More than Just Reports

Attendees will be able to see a data warehouse project develop while being presented with common problems, opportunities, pitfalls, and objectives. Attendees will have the opportunity to interact and ask questions specific to their current or planned data warehousing environment. The tutorial will cover different technology categories applicable to data warehousing, but specific tools or vendors will not be featured.