What are the benefits of using an Oracle data warehouse?
How do I create a scope of work agreement for a data warehouse?
What are the stages of evolution in a data warehouse project?
What are the characteristics of successful data warehouse projects?
What are the personnel requirements for a data warehouse project?
- high - medium - low
Architecture and Infrastructure
Business Applications
Business Management
Data Management
IT Management
Donald K. Burleson, independent Oracle database consultant and author, outlines successful strategies for creating and maintaining a robust and functional Oracle data warehouse. Because Oracle is the world's leading database, IT managers need to separate marketing hype from reality once they have an Oracle data warehouse installed. Burleson looks at Oracle data warehouses from the planning stages on. The program covers the management of end-user requirements; creating a scope of work agreement; project and staffing requirements; and how to compute the return on investment for an Oracle data warehouse project. The challenge for IT professionals is to ensure that they are able to leverage Oracle's powerful features to improve the productivity of their organizations. This program will help them meet these challenges, and address the concerns of any managers interested in using Oracle technology.
Viewers of the CD and online versions of the program will have easy access to useful Web sites devoted to data warehousing, including: CIO Magazine's Data Warehouse Research Center, The Data Warehousing Institute, The Data Management Center's Directory of Data Warehouse, Data Mining and Decision Support Resources, The Data Warehousing Information Center and The International Data Warehousing Association. Links to articles include: 'Data Warehouse: Roles and Responsibilities'; 'Data Warehousing: What Is It?'; 'Data Warehousing Concepts,' from the IBM Web site; 'Divide and Aggregate: Designing Large Warehouses' and 'Wash Me,' an article about data cleansing from CIO Magazine. White papers include: 'Critical Success Factors for Data Warehouse Engineering'; 'Eleven Steps to Success in Data Warehousing' and 'Data Warehouses, Ad Hoc Query Tools and Other Ways to Destroy Your Company.'
PROGRAM TOPICS:
INTRODUCTION
AGENDA
ROI
ORACLE DATA WAREHOUSE OVERVIEW
Strengths of Oracle for Data Warehousing
Benefits and Challenges of Managing an Oracle Data Warehouse
The Importance of Effective Project Management in a Data Warehouse Deployment
The Data Warehouse Team Should First Create a Scope of Work Agreement
MANAGING END USER REQUIREMENTS OF A DATA WAREHOUSE
Data Warehouses Evolve as a Progression of Usage Occurs
Stages of Evolution in Data Warehouse: Usage; Basic Analysis; Correlation Analysis; Multivariate Data Analysis; Forecasting; Modeling; Simulation; Data Mining
Give the End User the Ability to Extract and Cross-Aggregate Anything They Want
CREATING A SCOPE OF WORK AGREEMENT
Requirements of a Data Warehouse SOW: End User Management Must Take Part; Document System Requirements as Well as Possible; Include a Description of the Data Sources; Describe the Data Elements Used by End Users; Provide a Description of Dimension Attributes; Determine the Level of Data Granularity; Delineate Choices for Hardware and Software; List Functional Deliverables of the System; Develop a Cost-Benefit Analysis; Develop a Current Project Plan
Set Realistic Expectations for the Data Warehouse
DATA WAREHOUSE PROJECT REQUIREMENTS
Characteristics of Successful Data Warehouse Projects: Measurable Benefits; Properly Trained Staff; Data Quality and Consistency; Ensure Subject Privacy; Start Small and Evolve; Ensure End User Involvement; Properly Planned Infrastructure; Use Data Modeling and Stress Testing; Choose the Right Tools
PERSONNEL REQUIREMENTS
A Data Warehouse Team Uses a Matrix Organization
Roles in a Data Warehouse Team
Data Warehouse Team Members: The Project Sponsor; The Project Manager; The Warehouse Architect; The Systems Administrator; Legacy Database Experts; The Database Administrator; The Operations Manager; The Metadata Specialist; End User Interface Specialists; The Network Administrator; The Oracle Developer; The Statistician
Training Programs and Certifications for Oracle Data Warehouse Professionals
COMPUTING THE ORACLE DATA WAREHOUSE RETURN ON INVESTMENT
Tangible Benefits of a Data Warehouse Project
Intangible Benefits of a Data Warehouse Project
Intangible Benefits of a Data Warehouse Project: Worker Productivity
Intangible Benefits of a Data Warehouse Project: Fast Interpretation of Customer Behavior
Intangible Benefits of a Data Warehouse Project: High Quality of Marketing Efforts
IDC Survey: How ROI for a Data Warehouse Compares to ROI for Other IT Projects
Trends in Data Warehouses: Very Fast Payback Period
Trends in Data Warehouses: Larger ROI Variance
Trends in Data Warehouses: Higher ROI for Data Marts
Trends in Data Warehouses: Application Area Differences
Other Findings of the IDC Data Warehouse ROI Study
TIPS FOR MANAGING A SUCCESSFUL ORACLE DATA WAREHOUSE PROJECT
- high
- medium
- low
