Education
Table of Contents
Overview Courses:
Standard Courses:
Custom Courses:
O1 - Understanding Business Intelligence
The participant is provided a sound overview of Data Warehousing concepts and theory along with a practical grounding in the critical success factors, costs/benefits, and resources required to implement a strategic decision support environment for Business Intelligence. The business drivers will be described along with practical examples of Business Intelligence applications. This is an excellent overview for business executives and IT managers.
Key Objectives
- Understand the "Best Practices" and business implications of data warehousing
- Understand the different roles and design considerations of the data warehouse and data mart
- Understand fundamental differences between tactical and strategic usage of the technology
- Become familiar with the guidelines for implementing Business Intelligence
- Understand the skill requirements and team dynamics
- Understand the critical success factors and goals for a data warehouse project.
Duration 1/2 Day
Prerequisites None
Course Format Lecture and group discussion
Return to Table of Contents
O2 - Understanding the Corporate Information Factory (CIF) Architecture
Through lecture and discussions, a strategic decision support environment is de-mystified into its component parts. A practical definition for each component as well as observations and tips for its development will be provided. The course is ideal for the manager or executive who is responsible for determining if a data warehouse is appropriate for his / her corporation. Prospective team members will also benefit by gaining a solid understanding of the proper architecture.
Key Objectives
- Understand fundamental requirements for a CIF
- Strategic versus tactical decision support
- Technology components of the CIF
- Team dynamics and roles associated with the CIF
- CIF impact on the management of corporate change
- Methodology for construction of the CIF
- Become familiar with the various productivity improvement tools
- Understand the critical success factors and goals involved
- Understand the types of metadata needed
Duration 1/2 Day
Prerequisites None
Course Format Lecture and group discussion
Return to Table of Contents
O3 - Migrating from Data Mart Chaos
Many companies began building their strategic decision support environments by implementing a small data mart as a proof of concept. While certainly an advisable method to prove the value of these DSS applications, the situation has arisen in which a plethora of data marts, in the absence of a solid data warehouse architecture, has resulted in a chaotic, unintegrated decision support environment rather than the dream that was promised. This seminar will discuss the pros and cons of the data mart only architecture, a comparison of the data mart versus full data warehouse architecture, and the mechanisms to migrate from the "stovepipe" data marts to a truly integrated, corporate-wide data warehouse architecture.
Key Objectives
- Understand the characteristics and implications of the data mart chaos
- Understand alternative paths for migrating to the architected environment
- Understand how to use data models to achieve the migration
- Recognize political and technical issues
- Learn about available tools to aid in the migration
Duration 1/2 Day
Prerequisites None
Course Format Lecture and group discussion
Return to Table of Contents
O4 - Evolutionary Stages of the Corporate Information Factory
Though data warehousing was introduced more than ten years ago by W. H. Inmon, it has only been in recent years that we have seen exponential growth in the number of implementations, techniques and tools. No longer are we discussing the merits for building the data warehouse. We are talking about how data warehousing can be exploited as a core competency in all our companies. Businesses want access to increasing levels of detail over longer period. What techniques, tools and technology are providing the catalyst for this trend? More importantly, how are companies planning to use this data? What role will the data mart and operational data store play in providing a scalable data warehousing solution? What are the operational and administrative challenges? Whether you are planning a gigabyte, terabyte or pedabyte implementation, this session will offer you practical insights into trends and directions that you can exploit in optimizing, scaling and evolving your data warehousing solution.
Key Objectives
- Evolving business demands on the CIF
- Role of the data mart and the operational data store
- Technology trends and direction
- Maturity Stages of the CIF
- Hardware & DBMS
- Data Acquisition tools
- Data Management tools
- Operations and administrative challenges
Duration 1/2 Day
Prerequisites None
Course Format Lecture and group discussion
Return to Table of Contents
S1 - Corporate Information Factory - The Basics
This course will provide a clear understanding of the business drivers for data warehousing and important steps in successfully implementing this valuable environment. As with all new technological implementations, new issues arise - Do you build an Enterprise Data Warehouse? A Data Mart only? A set of Data marts? Where does the Operational Data Store fit in? What skills and resources will you need? What is the methodology used? What are the rights types of models to use for the various components of the Corporate Information Factory? This course has been carefully designed to answer your questions and to provide your entire team with the best practices and technologies for successful implementation.
Key Objectives
- Understand the business drivers of informational processing
- Understand the Information Ecosystem
- Learn about the Business Intelligence components - The Data Warehouse and Data Marts
- Understand the role of Metadata
- Understand the issues in managing the on-going Corporate Information Factory
- Learn about Best Practices for Designing the Data Warehouse
- Learn about Best Practices for Designing the Data Mart
- Learn about the Business Management component - The Operational Data Store
- Learn about CIF technologies and vendors
Duration 2 1/2 Day
Prerequisites None
Optional Prerequisites None
Course Format Lecture and group discussion
Return to Table of Contents
S2 - Corporate Information Factory - Advanced Topics
This course will provide the technical insight needed for a successful CIF implementation. With an in-depth review of the components (technical, organizational, cultural, etc.), this course is a must for participants who want to take their environments to the next level. Completion of this course will ensure that the student has the knowledge to build a sustainable, maintainable environment that can evolve and grow with the business.
Key Objectives
- Understand the different maturity levels in the CIF
- Understand how to maintain and administer a maturing CIF
- Be able to develop appropriate audits and controls
- Understand data warehouse implementation issues
- Understand data mart implementation issues
- Understand operational data store implementation issues
- Understand migration pathways from Data Mart chaos
- Learn about future trends in the CIF
Duration 2 Days
Prerequisites Corporate Information Factory - the Basics, or equivalent education
Course Format Lecture and group discussion
Return to Table of Contents
CC1 - Customized Course
This course exists to give the student the best of all our courses. Sections from the above courses may be chosen, depending on the needs, skills and maturity of the individuals requesting the training.
Key Objectives
- To formulate a course based on the specific knowledge and level of maturity of the students
- Enable a student to select sections from each of our courses that are appropriate for their own needs.
Duration Depends on material to be included
Prerequisites Depends on material to be included
Course Format Depends on material to be included
Return to Table of Contents
