Data Warehousing, Knowledge Management and The Year 2000

Data Warehouse Technology:
Building Knowledge Management and Surviving the Year 2000

Ken Orr

Chicago - July 21-23, 1997

What's Happening

Three major trends are impacting IT organizations everywhere: (1) the need for high-quality, timely information, (2) the need to build and support knowledge management and (3) the need to survive the Year 2000. This seminar shows that Data Warehousing can be a critical tool in addressing each of these areas.

Data Warehousing emerged initially to provide integrated information from multiple legacy databases. This process has proved to be extremely successful in improving Decisions Support Systems (DSS) and providing Knowledgeworkers with a wide range of new analysis tools. Now organizations are extending Data Warehousing Strategies to deal with integrating and making huge amounts of non-traditional forms of data (memos, documents, multi-media etc.) available as an "enterprise knowledge base." Finally, Data Warehousing has become an important technology to deal with the unique Year 2000 Decision Support Pespecially vulnerable to Yearroblems. Traditional Decision Support Systems are 2000 problems because they have been traditionally developed using 4GLs and supported by end-user rather than central IT organizations.

About This Seminar

Data Warehousing has evolved from it's infancy (DW Phases 0 and I) in recent years into a major information technology (DW Phase II). Organizations around the world are currently moving to implement Data Warehousing applications on a large scale. At the same time new technologies and new issues are coming into clearer focus. Data Marts, both departmental and personal, data mining, and data visualization are playing larger and larger roles in Data Warehousing plans. The first part of this seminar discusses how these technologies play off against each other and how organizations need to plan to take advantage of the power these technologies provide.

Knowledge Management is the next natural extension of the Data Warehousing. Knowledge Management involves integrating the data in the Data Warehouse with all the other information in the organization and delivering that to the Knowledge Worker in the field. A recent study of 33 companies showed strong business performance improvements in 82% of those organizations actively involved in Knowledge Management. As a result, organizations are now moving to integrate email, groupware, and Internet access to provide their knowledge workers with access to the organization's knowledgebases. The second part of this seminar discusses how Knowledge Management is going to change how we move forward with our information delivery systems.

Finally, every organization in the world is having to convert all their existing systems and databases to deal with the Year 2000. As the Year 2000 approaches, more and more organizations will be faced with what to do with their existing Decision Support Systems. Decision Support will be especially hard hit by the Year 2000, since in most organizations, Decision Support Systems have been largely the responsibility of End User Departments and often lack centralized support. The third part of this seminar deals with coming up with a Year 2000 Decision Support Plan that takes advantage of Data Warehousing Architecture and Tools.

Who Should Attend

CIOs
Systems Managers
Data Warehousing Project Managers
Data Administrators
Data Architects
Knowledge Officers
Year 2000 Project Managers

What You Will Learn

How to develop a Data Warehousing and Knowledge Management Strategy for integrating the whole spectrum of enterprise information: legacy data, external data and unstructured data.
How to develop an incremental implementation strategy for "reengineering" existing decision support environments.
How to design, develop and implement high-quality data warehouses.
How to modify your Data Warehousing development strategies to help solve the critical Year 2000 Decision Support Problem.

Benefits to Your Company

Analyze the existing Decision Support Environment and develop a Data Warehousing Strategy that will provide your company with the biggest impact.
Improve your business performance by learning to develop an integrated Data Warehousing/Knowledge Management Strategy for your enterprise.
Incrementally develop strategic versions of the Data Warehousing/Knowledge Management program to help solve your critical Year 2000 Decision Support problem.
Define Users Requirements and develop Prototype Data Warehouses and Data Marts to be able to target high-payoff DSS applications in your organization.
Achieve success by developing the ability to support Year 2000 Decision Support Programs for the enterprise.

Benefits of Attending

Maximize effectiveness by understanding the distinction between Decision Support, Data Warehouses, Data Marts and Knowledge Management.
Meet performance guarantees by developing a Data Warehousing/Knowledge Management Strategic Plan.
Learn to design and develop an incremental Data Warehouse or Data Mart to implement your Data Warehousing/Knowledge Management Strategic Plan.
Successfully implement your plan by learning the latest tools in Data Warehousing and Knowledge Management.
Discover how to use Data Warehousing to protect legacy DSS in the face of the Year 2000.

Seminar Outline

Data Warehousing Technology and Methodology
1. Phase 0 - The origins of Data Warehousing
2. Phase 1 - Data Warehousing takes off
Enterprise Data Architecture
1. Interface Layer
  1. Data Locator Tools
  2. Query Tools
  3. Desktop Database Tools
  4. Decision Support Systems
  5. Executive Information Systems
  6. Data Mining Tools
  7. Data Visualization Tools
  8. Business Simulation Tools
2. Data Sources
  1. Legacy Databases
  2. External Databases
  3. Non-operational Data
3. Data Access Layer
4. Core Data Warehouse Layer
5. Meta-data Layer
6. Systems/Process Management Layer
7. Data Staging and Quality Layer
8. Data Mart Layers
  1. OLAP Tools
  2. Bitmapped Indexing Tools
Data Warehousing Technology
1. Tools
2. Strategies
A Framework for Data Warehouse Design
1. Multiple Approaches
2. A Two-phased Approach
3. Incremental Data Warehouse Development
4. Beyond Star Schema
  1. Measures, Dimensions and Pointers
  2. Data Warehouse Design
  3. Data Mart Design
  4. Star Schema, Snowflakes, Avalanches, etc.
Managing Data Warehouse Development
1. Valuing Information
2. Developing a Business Case
3. Data Warehouse Project Management
4. Pilot Projects
5. Organizing for Data Warehousing
6. Lessons Learned
Key Data Warehousing Technologies for the Future
Moving to Knowledge Management
1. What is Knowledge Management?
2. Managing Knowledge as an Asset
3. How does Knowledge Management fit with Data Warehousing?
4. How to develop a Knowledge Management Strategy
Data Warehousing and the Year 2000
1. Understanding the Year 2000
2. The Impact of the Year 2000 on Data Warehousing
3. The Impact of Data Warehousing on the Year 2000
4. Surviving the Year 2000

About Your Instructor

Ken Orr is a principal researcher at The Ken Orr Institute and one of the world's leading authorities on advanced technology and business management. Over the last three decades, Mr. Orr has developed, managed and consulted with some of the largest organizations in the world, including IBM, Olivetti, Pacific Bell, Santa Fe Railroad, Washington University (St. Louis), Xerox and dozens of federal and state agencies. Mr. Orr has written three books and authored dozens of articles on advanced systems development, data warehousing, business process reengineering and the Year 2000. Mr. Orr is a co-developer of the Warnier-Orr Development Methodology, a keynote speaker at DCI's Database and Data Warehousing Conferences and co-chairman of DCI's Year 2000 Issues and Answers Conference. Each year, Mr. Orr gives seminars throughout the world.

Meeting Site and Hotel Information

Chicago, July 21-23, 1997
The Wyndham Hotel
(630) 773-4000

Register Now!