Course Description A fast-paced, practical guide to understanding and successfully implementing data marts, this course contains all the elements necessary to successfully design, construct and implement data marts in today’s enterprise.
 
Agenda Doug Hackney
The Data Mart Trends 
•  Market definition 

Data Mart Drivers 
•  Budget 
•  Tactical solutions 
•  Iterative development 

Evolution of Data Marts 
•  Historical DSS 
•  Data warehouse architecture 
•  Data mart architecture 

Two Paths to Data Marts 
•  DW subsets 
•  DW construction iterative elements 
•  Common risk factors 
•  Common prerequisites for success 

Successful Subsets 

Subset Strategies 

Successful Elements 

Element Design 

Element Strategies 

Critical Implemetation Issues 
•  User tools 
•  Meta data 
•  Training 
•  Support 
•  Disaster recovery 

Sustenance and Maintenance 
•  Monitoring 
•  Managing growth 
•  Customer service metrics 

ROI Measurement 
•  User tool requirements 
•  Marketing example 
 

 “Simply exceptional! New DW/Dmart people desperately need to attend this course. Experienced people need this as a course to stay focused on what is/isn’t a good DW/Dmart and how to achieve one. Congratulations to Doug and TDWI for including this course. It is of exceptional value!” 

- Yolanda Tirado, Mobil Oil 
 
 
 
  

“This course did a terriffic job of describing the need to choose areas for data warehouses and data marts with sufficient need and political support to survive the trial of implementations and the budget knife for its subsequent maintenance and support.” 

- Roxanne Warriers, Coopers & Lybrand

 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.