< Data Warehousing Training, Certification, Free Java J2EE Training, Free C++ Training
Home > Solutions > Training Services > Data Warehousing Training

Data Warehousing Training Services

Data Warehousing and Business Intelligence Courses

The following are the Data Warehousing and Business Intelligence courses offered:


Introduction to Business Intelligence for Executives and Managers

Business Intelligence is important and is rapidly becoming a major source for organizations to achieve competitive advantage in a fierce competitive market place. But most Business Intelligence training conducted in the market is very technical in nature. Executives and Project Managers need to know the fundamentals on Business Intelligence projects in terms of pre-requisite, resources, timeline, costing and lessons learned before embarking one.

You Will Learn
  • The basic principles of business intelligence and also takes a more detailed look at the Specific aspects of design and architecture.
  • Exposure to hands-on sessions, real life case studies and success factors which is must to drive value and profitability in your organization.
Geared To
  • Senior executives to assist in understanding all aspects of business intelligence and more importantly gives a detailed insight on the proven best practices and methodologies for implementation.
Training Methodology
  • The emphasis is interactive learning by facilitation and practical hands-on exercise.
  • Interactive group exercises and active participation
  • Business games through group learning
  • Interactive workshop format and solution presentation
  • Sharing of real-life experience via case studies on ‘how to’ do it.


Data Warehousing Concepts and Principles

This introductory level course provides an overview of the activities, processes, and products of building a data warehouse. From business architecture to databases and access tools, the course examines the deliverables of data warehousing programs and discusses the resources and skills needed to produce them.

While much of the data warehousing effort is expended in development projects, this course broadens the perspective from project to program and examines architecture and operations deliverables as well as those of development projects. The course emphasizes common language, concepts, and understanding that are necessary to enable effective teamwork and achieve data warehousing success.

You Will Learn
  • Basic concepts of data warehousing
  • Common language, terminology, and definitions in data warehousing
  • Key factors that contribute to data warehousing success
  • Risk factors for data warehousing projects
  • Common approaches to data warehousing architecture
  • Data warehousing roles and responsibilities
  • Data warehousing development concepts and best practices
  • Data warehousing operations and administration considerations
Geared To
  • Anyone new to data warehousing;
  • Data warehousing teams that need to develop a common base of concepts and terminology;
  • Data warehousing team members who need to understand the roles and responsibilities of others on their team.

Data Warehousing Architectures: Choosing the right data warehouse approach

This course sorts out the confusion about data warehousing architectures and methodologies. Many data management architectures [huv versus bus] can be used to successfully deploy Business Intelligence and many approaches may be used to develop the Data Warehouse. Choosing the right architecture and development approach for your organization is a challenge influenced by many factors. This course provides guidelines and techniques to assess your requirements and make informed choices.

Pre-requisite

This course assumes basic understanding of data warehousing.

You Will Learn
  • Various data warehousing architectures such as Hub n Spoke, Bus Architecture, Independent Data Marts, Centralized (no independent data marts), Federated.
  • Data Staging architectures such as Persistent Data Staging, Transient Data Staging & Semi-persistent Data Staging.
  • To distinguish between top-down, bottom-up and hybrid methodologies
  • The dependencies between architecture and methodology
  • To assess cost, value and time –to delivery implications of various approaches
  • A systematic approach to determine the best fit architecture and methodology for your data warehousing program.
Geared To
  • BI/DW program and project managers; Data Architects;
  • Anyone who participates in making architecture and methodology decisions;
  • Anyone who needs to understand differences between the various approaches.


Dimensional Data Modelling Primer: From Requirements to Business Analytics


Dimensional data is a core component of modern business intelligence and data warehousing implementations. Dimensionally organized data offers a more effective and adaptable solution to business analytics needs than can be achieved with relational data structures. Virtually anyone involved in business intelligence and data warehousing projects needs to have fundamental knowledge of the pathway from business questions to business analytics. This course traces that pathway.

The course begins with a comparison of relational and dimensional data organization and provides an example of business questions not readily answered using more traditional data structures of relational modelling. It then illustrates the steps to design analytic solutions starting from business questions and concluding by demonstrating an OLAP solution. These steps encompass techniques to capture business questions, represent them as a business solution, translate them to a technology solution, and deliver them to those who need information.

You Will Learn
  • Concepts of dimensional data modeling
  • The relationship between business metrics and dimensional data
  • Similarities and differences between relational and dimensional data models
  • Requirements gathering techniques for business metrics and dimensional data
  • How to build a logical dimensional model
  • How to translate a logical dimensional model to a star-schema design
  • How dimensional data is used to deliver business analytics and OLAP capabilities
Geared To
  • Data architects, data mart developers, business analysts, business intelligence and data warehousing program and project managers.


Certification of Business Intelligence Professional (CBIP)


The Certified Business Intelligence Professional - Practitioner Level is awarded when a person passes the following three ICCP Examinations at the 50% or higher score: CORE Information Technologies Examination, Data Warehousing, plus one of I.T. Management (Leadership and Management track), Business Information Systems (Business Analytics Track), Data Management (Data Analysis & Design Track), Systems Development (Data Integration Track), Systems Security or Database Administration (Administration & Technology Track).

The Certified Business Intelligence Professional - Mastery Level is awarded when a person passes the following three ICCP Examinations at the 70% or higher score: CORE Information Technologies Examination, Data Warehousing, plus one of I.T. Management (Leadership and Management track), Business Information Systems (Business Analytics Track), Data Management (Data Analysis & Design Track), Systems Development (Data Integration Track), Systems Security or Database Administration (Administration & Technology Track).

Note: These programs are jointly administered by the ICCP (www.iccp.org ) and the TDWI (The Data Warehousing Institute (www.tdwi.org ) and a joint certificate is issued by the two organizations.

» back to top

More information (PDF Files)