The Roadmap for Data Warehouse Implementation
EXCLUSIVE EDUCATION EVENT
Running in Conjunction with DCI’s Database & Client/Server World
There is no doubt that Data Warehousing technology needs to be considered by almost every organization today. What we need now is a proven method to understand and to implement the processes involved in the successful deployment of Data Warehousing projects. This is the three day seminar that does it! The Roadmap for Data Warehouse Implementation consists of three proven stages: (1) Planning and Design, (2) Building, and (3) Roll-out and Maintenance. The steps address the issues pertaining to the project management, project estimation, impact of data warehousing solutions on the business organization, risk assessment and determination of building a datamart or a data warehouse.
Internationally renowned consultant and lecturer, Shaku Atre lays out the twelve steps necessary for the implementation of a successful data warehouse. Attendees to this three-day certification seminar receive one Continuing Education Unit (CEU).
- Chairman Address
Roadmap for Data Warehouse Implementation
- Shaku Atre, President, Atre, Inc.
- Business Justification and Risk Assessment for the Data Warehouse
- Shaku Atre, President, Atre, Inc.
- Determining Hardware and DBMS Engine Platforms for the Data Warehsouse or Data Mart
- Peter Storer, Vice President Consulting, Atre Associates, Inc.
- PANEL DISCUSSION: Hardware Platforms and DBMS Engine Considerations for a Data Warehouse
- Moderator, Shaku Atre, President, Atre, Inc.
- Data Modeling with Access and Usage Issues for the Data Warehouse (Logical and Physical)
- John Rome, Data Administrator, Arizona State University
- Building a Metadata Repository
- Peter Storer, Vice President Consulting, Atre Associates, Inc.
- Data Cleansing, Data Moving and Data Warehouse Population
- Peter Storer, Vice President Consulting, Atre Associates, Inc.
- PANEL DISCUSSION: Design Issues, Data Quality, Middleware, Metadata, Acess and Usage Issues
- Moderator, Shaku Atre, President, Atre, Inc.
- Analysis of Data: OLAP, ROLAP, Querying and Reporting, Data Mining and Prototyping
- Shaku Atre, President, Atre, Inc.
- Next Step Issues in Data Warehouse Development
- Cecil Wade, An OLAP User/Developer
- Growth, Change, and Management (and Wrap-Up)
- Shaku Atre, Peter Storer, Atre Associates, Inc.
Chairman Address
1. Roadmap for Data Warehouse Implementation
Shaku Atre, President
Atre, Inc.
Tuesday, 11:00 a.m. - 12:15 p.m.
Ms. Atre lays out the twelve steps necessary for the implementation of a successful data warehouse. These steps will be expounded upon by the other speakers in this seminar.
1. Determine Users’ Needs, Data Sources, Data Warehouse
Justification and Risk Assessment
2. Determination of Hardware Platform for Data Warehouse
3. Determination of DBMS Server for Data Warehouse
4. Data Modeling with Access and Usage Issues
5. Building of a Metadata Repository and Determination of a Datamart
or a Data Warehouse
6. Data Cleansing, Reconciliation, Enhancements, Summarization, Aggregation
7. Data Transportation and Data Warehouse Population
9. Building a Data Warehouse Prototype: Querying and Reporting
10. Multi-Dimensional Analysis with OLAP and ROLAP
11. Data Mining
12. Enterprise-Deployment with System Management, Growth and Change Management
Objectives:
At the end of this program, you should be able to:
- Understand all components of Data Warehouse (DW)
justification, design and construction
- Install an appropriate infrastructure for a successful DW
implementation
- Make sound decisions about implementing the type of DW
that needs to be implemented
- Estimate and learn to control the costs of DW implementations
- Assess and minimize risks involved with technology, complexity, integration, organizational support, project team and financial investment
- Prepare logical and physical architecture of a DW
- Select appropriate products and applications for implementing the DW and understand the development process
- Develop prototypes of the DW
- Integrate and roll-out a DW
- Implement appropriate security measures
- Understand factors involved in an enterprise-wide deployment of the DW
- Manage growth and maintain adequate performance of the DW
[Top]
Shaku Atre, President
Atre, Inc.
Tuesday, 1:30 p.m.
This session identifies the business potential of the Data Warehouse to your firm’s corporate objectives and defines what business intelligence can be unlocked using data warehousing technology. This business approach will gain your users’ confidence and help you win the approval for your Data Warehousing project.
- Identify the Corporate Goals and Objectives
- Formulate the Business Analysis Issues and Information Components to Meet the Corporate Objectives
- State the Information Requirements for the Business
- Estimate Costs in Building and Maintaining a Successful Data Warehouse
- Assess Risks Involved so that You Can Be Proactive
[Top]
Peter Storer, Vice President Consulting,
Atre Associates, Inc.
Tuesday, 3:00 p.m.
Most organizations implementing a Data Warehouse have a number of hardware platforms to consider. Determination of the hardware platform has to fit in the existing hardware configuration. Determination of a Data Warehouse DBMS is equally important as it must perform well as the number of users grows.
- Which Hardware Platform Fits the Existing Configuration?
- Is There Interoperability Between the Various Hardware Platforms?
- Which DBMS Engine Fits the Existing Environment?
- Cost Considerations and ROI
[Top]
PANEL DISCUSSION:
Moderator, Shaku Atre, President
Atre, Inc.
Tuesday, 5:00 p.m.
In this interactive panel discussion, the key issues for considering the hardware platform and DBMS engine for your data warehouse are covered. Our panel of "experts" share their varying points of view, as well as the pros and cons of the many options in this very important phase in data warehouse implementation. Panelists include representatives from companies such as NCR, Sybase, Informix, Red Brick Systems, Microsoft, and IBM.
Data Modeling with Access and Usage Issues for Companies such as NCE, Sybase, Informix, Red Brick Systems, Microsoft, and IBM.
[Top]
John Rome, Data Administrator
Arizona State University
Wednesday, 8:30 a.m.
John Rome discusses the key issues for data modeling.
- Develop the Data Architecture: Design the Conceptual Schema for the Data Warehouse
- Determine Whether a Star Join Schema Will Work With Your DBMS
- Determine Data Placement
- Partition Tables Effectively Across Multiple Disks
- Staff Qualifications and Training Needs
- Time and Cost Considerations
[Top]
Peter Storer, Vice President
Atre Associates, Inc.
Wednesday, 9:30 a.m.
Metadata helps you locate, manage and use the data in the data warehouse. Departmental data differences need to be
reconciled and cross-departmental politics needs to be resolved. Steps to develop effective metadata include:
- Identify Ways that Data Warehouse/Metadata Solutions
Can Benefit the Company and/or a Department
- Define What Information Will Be Stored in the Data Warehouse
- Determine the Most Common Queries Your Users Will Have and Pre-Build Icons or Descriptive Terms in the Metadata Tool to Handle Routine or Simple Queries
- Pull Users into the Process
- Determine the Storage Needs for Both the Data Warehouse and Metadata
Data Cleansing, Data Moving and
[Top]
Peter Storer
Atre Associates, Inc.
Wednesday, 2:00 p.m.
From the business users perspective, the quality of the decision made by using the data warehouse is critically related to
the quality of the data stored and delivered from the Data Warehouse. This session explores some of the data quality issues from the implementation perspective:
- Quality Vs. Integrity
- How to Develop Business Rules and Buy/Build Tools
to Improve the Data Quality
[Top]
PANEL DISCUSSION:
Moderator, Shaku Atre, President
Atre, Inc.
Wednesday, 5:00 p.m.
This panel discussion explores the key issues regarding design, data quality, middleware, metadata, access and usage. Panelists describe what should be considered in determining whether to implement a data warehouse or a data mart, what is the cost of quality, should middleware provide openness, and what are the main considerations for OLAP/ROLAP deployment? Panel members represent companies including Carleton Corporation, DB Star, Cognos, Cross Access, Prism, and Smart Corporation.
[Top]
Shaku Atre, President
Atre, Inc.
Thursday, 8:30 a.m.
An OLAP environment should support the five fundamental criteria: integration of query, report and analysis; power;
interoperability and openness; deployability; and ease of use. This session presents the designing of OLAP and ROLAP implementations.
- Multiple Dimensions for Analysis
- Use of Repository
- Three-Tier Architecture
- Object Based Technology that Supports the Needs of Users from Novice to Expert with Reusable Queries and Reports
[Top]
Cecil Wade, An OLAP User/Developer
Thursday, 1:30 p.m.
This talk focuses on the next step design issues such as data access control, data update management and control, and aggregation implications.
- Should Everybody Have Access to Everything in the Warehouse? Are You Sure?
- Dealing with the Data Structure Changes That Occur
Over Time
- How Does the User Know That the Retrieved Data is Complete, Correct and Consistent?
- Update Granularity, Edit Rules, and Error Notification Issues
11. Growth, Change and Management
(and Wrap-Up)
Shaku Atre, Peter Storer
Atre Associates, Inc.
Thursday, 2:30 p.m.
As the Data Warehouse stores more and more historical data, the size of the data warehouse negatively impacts storage and maintenance costs and degrades performance. Eventually this can lead to management dissatisfaction with ROI and business user dissatisfaction with practical usage. This session discusses ways to manage historical data, storage methods and query response times, by leveraging both technology and the business users’ pragmatism.
[Top]