Course Description A comprehensive overview of data warehousing and data marts. In one day, this course takes data warehousing staff and CIOs from ground zero to functional understanding of mission, architecture, design, lexicon, process, tools, project management and key success factors. This course assumes no prior knowledge of data warehousing concepts and physical implementations, and uses plain language to explain the concepts and practical implementation realities of designing and implementing a data warehouse or data mart. Grounded in the experiences of real world implementations of data warehouse and data mart designs, tools, and technologies, this course provides the necessary prerequisites for successful, valuable, and leverageable data warehouse and data mart implementations.
 
Agenda Doug Hackney
The Data Warehouse Mission

Data Warehouse Architecture and Design
•  Short history of Decision Support Systems (DSS)
•  The data warehousing architecture
•  Meta data fundamentals
•  Data fundamentals
•  Architecture elements and their roles
•  Data flow and process 
•  Subject based data modeling
•  Star schema design fundamentals
•  Schema design variations and roles

Data Warehouse Tools
•  Extract, mapping and transformation 
•  Scrubbing
•  Repositories
•  Suites

Data Warehouse Project Management
•  Sponsorship
•  Key cultural issues
•  Budgeting
•  Managing expectations
•  Where the work is 

“This course should be a prerequisite for anyone beginning a data warehouse project”
- Mary Atwood, John Hopkins Medical Service Corp

 •  Initial subject areas: key variables
•  Initial subject areas: pre-requisites
•  The meta data conundrum
•  Team formation and sustenance
•  Maintenance and sustenance: the real challenges
• How long/how much

End User Data Access
•  Understanding users roles
•  Importance of end user tools
•  Historical tool classification
•  Modern toll classification
•  Key trends and technologies
•  Leveraging meta data

System Physical Topologies
•  System physical topology basics
•  Network implications
•  Resource implications

The Holistic View
•  What data warehousing is not
•  What data warehousing is

“This course helped me to understand critical data warehousing concepts and the criteria which distinguish successful implementations”
- Mark Schurmeier, Freddie Mac

“A must for everyone interested in implementing a data warehouse”
Fernando Rivera, Triple-C

 Doug Hackney has over seven years of experience designing and implementing data warehouse and information delivery system solutions for Fortune 500 organizations. He offers clients practical knowledge of the challenges and critical success factors involved in building and managing data warehouses across a variety of industries and business applications. Doug’s vast background in business operations, coupled with his years of working “in the trenches” with data warehouse implementers, enables him to speak the language of both business management and the IS community. This unique ability to gain a multi-faceted organizational perspective, and to effectively merge its various needs and interests, is one of the keys to the success of a data warehouse or data mart project.