Education

Understanding Business Intelligence

Course Description

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

 

Understanding the Corporate Information Factory (CIF) Architecture

Course Description

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
  • Distinguish between strategic and tactical decision support
  • Recognize the technology components of the CIF
  • Understand team dynamics and roles associated with the CIF
  • Understand the impact of the Corporate Information Factory on the management of corporate change
  • Become familiar with a methodology for building the CIF
  • Become familiar with the various productivity improvement tools
  • Understand the critical success factors and goals
  • Understand the types of needed meta data

Duration:  1/2 Day

Prerequisities:  None

Course Format:  Lecture and group discussion

 

Understanding the Operational Data Store

Course Description

For all of the advantages of a data warehouse, there are some disadvantages and limitations that must be addressed by another architectural entity – the Operational Data Store (ODS). This seminar introduces the concept of the ODS, its purpose, major differences and similarities to the data warehouse, and so on. With the knowledge gained from this seminar, attendees will be able to determine the need for the ODS and will gain an understanding of how to implement one into their IT environment.

Key Objectives

  • Understand what an Operational Data Store is – and what it is not
  • Understand the distinctive characteristics of an ODS
  • Be able to discriminate among the classes of ODS
  • Understand the development life cycle for an ODS
  • Understand the methodology for implementing the ODS

Duration:  1/2 Day

Prerequisities:  None

Course Format:  Lecture and group discussion

 

Understanding Project Management for the CIF

Course Description

This seminar explains the significant differences between a traditional software development project and the iterative nature of the strategic support environment.  The unique business benefits of tactical and strategic support, the technical implications, and the organization impact will be discussed. The participant will learn the importance of developing and be able to create a scope document and a realistic project plan for their project.  Additionally, the participants will learn how to obtain a strong sponsor, develop a reasonable ROI, and determine which CIF components are appropriate for their environment.

Key Objectives

  • Understand the business benefits and organizational implications of managing data as a resource,
  • Understand the issues for developing a cost/benefit analysis, ROI, etc.
  • What should be defined within the Project Scope document,
  • Understand the process for building the data warehouse or data marts,
  • Understand the roles of the different participants in a data warehouse project,
  • Understand the activities, deliverables, milestones, and dependencies appropriate for the development of a project plan,
  • Understand what critical success factors are important.

Duration:  1/2 Day

Prerequisites:  None

Course Format:  Lecture and group discussion

 

Understanding Meta Data: Current Practices

Course Description

Meta data management continues to play a major role in all Corporate Information Factory (CIF) implementations.  Most people already know what it is and why meta data is very important.  The focus of this seminar will be the presentation of the current techniques and infrastructure supporting the collection, storage and delivery of meta data.  Included is a discussion on the Microsoft Repository offering and the Meta Exchange Coalition standards.

Key Objectives

  • Describe the different types, the capabilities and the value for each type of meta data,
  • Understand the issues for determining the meta data architectures of:
    • Meta data meta model
    • Centralized meta data
    • De-centralized meta data
  • Understand the resource and tool requirements for implementation and maintenance of each type of meta data
  • Understand the current repository and interchange standards in particular:
    • Meta Exchange Coalition standard
    • Microsoft repository
  • Understand the capabilities for meta data delivery including intranet capabilities.

Duration:  1/2 Day

Prerequisites:  None

Course Format:  Lecture and group discussion

 

Administration of the Corporate Information Factory

Course Description

The first implementation of the Corporate Information Factory is complete, users are on-line and are happily productive. Your job is finished – right.   Wrong!  Your job is just starting. Once the CIF environment is delivered, the program focus must include the operations and maintenance activities needed to control and promote the healthy growth of your Corporate Information Factory environment.  In this session, we will talk about the factors affecting growth and the functions needed to administer this evolving environment.  This class is designed to give a overview of the tasks, resources, and responsibilities for monitoring and administration of the Corporate Information Factory (CIF). The class will cover techniques for managing the Data Warehouse administration data, managing the refreshment of data in the data warehouse, and monitoring the usage and content of a data warehouse.

Key Objectives

  • Overview of CIF administration
    • Factors affecting growth, and why
    • Challenges caused by growth
    • Extending the architecture to support administration
  • Management of the Operations within the CIF environment
    • Data Acquisition Management
    • Data Management
    • Service Management
    • Change Management
  • Maintenance activities within the CIF
    • Service level tracking
    • Performance tuning
    • Capacity planning
    • Data quality tracking

Duration:  1/2 Day

Prerequisites:  Nones

Course Format:  Lecutre and group discussion

 

Evolutionary Stages of the CIF

Course Description

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
  • Understand the characteristics and implications of data mart chaos
  • Understand alternative paths for migrating to the architected environment
  • Operations and administrative challenges

Duration:  1/2 Day

Prerequisites:  None

Course Format:  Lecture and group discussion

 

Data Warehouse Methodology Overview

Course Description

This course provides an overview of the methodology needed to develop a data warehouse within a Corporate Information Factory program.  The material first focuses on the program orientation needed for decision support efforts, and the activities included within this phase.  The development process for each project is then described, with the process being divided into four major phases: Project Definition, Getting Information Out, Getting Data In, and Deployment.  The on-going administration and operation activities needed to sustain the program are then described.

Key Objectives

  • Understand the differences between the data warehouse methodology and the methodology used for traditional systems
  • Understand the importance of
  • Understand the importance of approaching the Corporate Information Factory as a program
  • Understand the four major phases for each data warehouse project and the key activities and roles and responsibilities
  • Learn the critical steps needed to manage the data warehouse and data marts

Duration:  1/2 Day

Prerequisites:  None

Course Format:  Lecture and group discussion

 

Customer Relationship Management Overview

Course Description

Does your technology environment facilitate CRM or impede it? How about your organizational structure, your organizational culture, and your overall business strategy? Many organizations implementing CRM focus only on one of these areas without adequately considering the rest. This oversight can have a significant impact on the success of your CRM program.

This overview will provide you with valuable insight on how to incorporate your technology investments with the business process to get the maximum benefit from your CRM initiatives. It will highlight organization structures that foster CRM, business strategies that enable customer loyalty, cultural issues that can impede progress toward CRM, and the role of technology in CRM. It will also provide advice on how to build an integrated technology environment that pushes critical customer information to all points in the organization.

Key Objectives

  • Gain an understanding of the components of a comprehensive CRM environment along with representative best (and worst) practices
  • Gain an understanding of the components of a comprehensive CRM strategy and learn a definition of CRM that places business representatives and technologists on the same page
  • Learn how to use multiple technologies to build an integrated customer information environment that supports both customer contacts and customer analytics
  • Understand the factors that can derail your CRM program and how to recognize and manage these

Duration:  1/2 Day

Prerequisites:  None

Course Format:  Lecture and group discussion