? Data Warehouse Training | Business Intelligence Training | Data Warehouse Courses | BI Courses

Home > Solutions > Training Services


Knowledge Discovery (Malaysia) is offering in-depth Business intelligence & Data warehousing public courses. These courses will be held in most South East Asia countries such as Malaysia, Singapore, Indonesia, Thailand and Philippines.

Please << click here >> to view the training schedules and brochures.

With certification, Data Warehouse Practitioners can be assured of high paying Data Warehouse/ Business Intelligence jobs while enjoying job recognition

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


To attend the course, please

Strategies and Techniques in Implementing a Successful Business Intelligence Project

Course Overview

In a today's highly competitive world, the ability to carefully analyze information is key to the company's overall success or failure. By implementing a Data Warehouse, decision makers and executives can quickly analyze large multidimensional data sets for competitive advantage. When implemented correctly, data warehouse can improve the bottom line performance of the organization.

In this course, participants will gain practical information needed to design, manage, build and use data warehouses for virtually any type of business application. Employing many real-life case studies of data warehouses, the course provides clear guidelines on selecting the right architecture, right methodology and the right modeling techniques to implement data warehouse project successfully. The successful delivery of a data warehouse or business intelligence project also requires a combination of strong project management skills and a good understanding of the unique challenges of data warehouse projects. This course is designed to equip delegates with the necessary skills required to effectively manage a data warehouse. This course consists of both theoretical and practical sessions and unlike others is product independent.

What Will You Learn

This course is designed to answer the following:

  • Basic concepts of business intelligence and data warehousing
  • Critical success factors & risks
  • Data warehousing & business intelligence development processes
  • Best practices and Industry trends
  • Basic architectural concepts for business intelligence and data warehousing
  • Various data warehouse architectures and how to select the one suitable for your organization
  • Dependencies between data warehousing architecture and development methodology
  • How to assess the cost and value implications of various architectures
  • How to assess the time-to-delivery implications of various methodologies
  • Project management implications of various approaches
  • How to determine the best-fit architecture and methodology for your data warehousing program

Who Should Attend

This course is designed to answer the following:

  • Business Intelligence/Data Warehouse Project Managers
  • Business Intelligence/Data Warehouse Developers
  • Business Intelligence/Data Warehouse Consultants
  • Business Intelligence/Data Warehouse Architects


  • 3 days

Course Content

Overview, Concepts & Architecture

  • Definitions and Industry Terminologies
  • Business justification for BI/DW
  • Architectural concepts for BI/DW
  • Hub-and-spoke, federated, and independent architectures
  • Data Warehouse and Data Staging
  • Dependent and Independent Data marts
  • Extract, transform, load (ETL) Concepts and Principles
  • Understanding OLAP, ROLAP and MOLAP
  • Choosing the right data warehousing approach for your organization
  • Logical design vs. Physical design
  • Data cleaning techniques
  • Meta-data management
  • SOA concepts in Data Warehouse

Methodologies, Implementation Process & Project Management

  • Data warehousing & business intelligence development processes
  • Scoping your BI requirements
  • Top-down, bottom-up, and hybrid data warehousing methodologies
  • Time boxing data warehouse project
  • Data warehousing roles and responsibilities
  • Mitigating risk in data warehousing projects
  • Case Studies & Lessons Learned

Data Modeling Techniques

  • Dimensional vs Normalized modeling design
  • Star Schema and Snowflake design
  • Slowly changing dimensions
  • Multi-valued dimensions
  • Fact table delivery

Managing Performance of Data Warehouse

  • Running Complex Queries
  • Data warehouse database performance design
  • De-normalization Techniques
  • Physical design considerations

Selecting the right Business Intelligence Software/Tool for your environment

  • Dashboard, OLAP and Reporting Tool
  • ETL/ELT and Data Cleansing Tools

To attend this course, please

Introduction to Business Intelligence for Executives and Managers

Course Overview

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.


1 day

Course Objectives

* 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.

Who should attend*

* 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.


To attend this course, please