Portals eNewsletters Web Seminars dataWarehouse.com DM Review Magazine
DM Review | Covering Business Intelligence, Integration & Analytics
   Covering Business Intelligence, Integration & Analytics Advanced Search

View all Portals

Scheduled Events

White Paper Library
Research Papers

View Job Listings
Post a job


DM Review Home
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

Buyer's Guide
Industry Events Calendar
Monthly Product Guides
Software Demo Lab
Vendor Listings

About Us
Press Releases
Advertising/Media Kit
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

Business Intelligence:
Why Provide User Training?

online columnist Jonathan Wu     Column published in DMReview.com
May 11, 2000
  By Jonathan Wu

Software companies that develop business intelligence (BI) applications advertise that their products are easy to use. The graphical user interface enables users to request, manipulate and format data in a manner that is consistent with other software with which they are already familiar. Since most BI applications have a look and feel similar to other commonly acceptable software such as a spreadsheet or word processing applications and are easy to use, why provide user training?

Case Study: No User Training

In all of my experiences configuring, implementing and deploying BI applications, we have only encountered one situation where the client decided not to provide user training just prior to deploying the BI application to their users. While this is an isolated case, sharing the experience will be beneficial to others who may not understand or appreciate the need for user training.

During the development of a data warehouse for one of our clients, we began planning for the deployment of the warehouse to approximately 600 users. A BI application was configured and was the primary application for the users to access the data. During the course of planning for the training of these users, the client wanted to reduce the budget of the project and elected to not provide users with any training on the BI application. The rationale for their decision was that their users were very sophisticated, technologically savvy computers users, and the BI application was easy to use.

While we did not agree with the client's decision and explained our position on user training, they requested that we initially produce an eight-page reference guide that eventually was expanded to 65 pages. The reference guide was e- mailed at the same time the BI application was rolled out to all users. During the deployment, very few calls came in from users requesting assistance or complaining about the BI application. Was it a successful implementation and deployment?

A few days after the deployment, the data warehouse support group reported that the usage and activity of data warehouse was minimal. After following up with several users, the client realized that no one was using the BI application. Most of the users did not have the time or the desire to read the reference guide that was e-mailed to them. Most of them were planning on attending a training class prior to using the BI application. As the user complaints for training emerged, the client quickly switched their position and decided to provide user training. While the users eventually received the training that was originally planned, the deployment of the data warehouse and BI application did not receive the fanfare that the client had anticipated.

Standard BI Training

Each software company that develops BI applications offers training courses on their products. The goal of this standard BI training is to demonstrate the features and functionality of the application to the students through lecture and lab exercises. Users may attend one or a series of classes in progressive order to become knowledgeable and skilled in the use of the BI application. In most cases, the standard training classes are accessing demonstration data that may not be representative of the type of data or context the students will use when they return to their organization. Most companies that purchase a BI application will have users attend the standard training that is provided by the BI company because it is readily available and requires very little preparation or planning.

There is a leap of faith that each student, after completing the standard training, will be able to use the BI application in a custom environment to create ad hoc queries and reports for decision-making purposes. To determine whether you should be concerned or not, ask yourself, "Is your BI configured environment simple and contains no business rules or definitions that your users must learn?" If the answer is yes, then standard BI training is probably the most appropriate selection.

Standard BI and Custom Training

The combination of standard BI and custom training is frequently selected by organizations that want users to understand not only the features and functionality of the BI application, but also the data that is available to them in the environment configured specifically to the organization. A typical program for this type of training would begin with one to three days of the standard BI training followed by a half to a full day of custom training. The number of days of training is dependent on the learning objectives, the goals of the client and the user requirements. The follow-on custom training provides users with an understanding of the structure of the BI configured environment, the associated business rules and definitions as well as the data that is available to them. The emphasis of the custom training is to put the learning experience into the context of the data that the users will be accessing for decision-making purposes. In addition, the custom training reinforces the learning experience of the standard training by providing students with the ability to understand the benefits of the BI application in their environment through lab exercises using their own data. This training approach is more encompassing than standard training alone but requires additional preparation and planning.

Custom Training

Developing custom training materials is time-consuming and requires thorough planning. However, it can be very cost-effective for organizations that have more than 100 users who need to be trained on a BI application, and it can be the most beneficial learning experience for students. We have several clients that have chosen this training approach and believe that it can be more effective and streamlined compared to other training approaches for their users. Each training course is developed using detailed learning objectives. The course focuses on the features and functionality of the BI application most important for that client's particular environment. Lab exercises are incorporated in the context that the students are already familiar within that organization.


While each organization has its objectives for providing user training, Figure 1 is a high level summary of learning objectives and training approaches.

Learning Objective Standard Standard & Custom Custom
How to use the BI application. X X X
Understanding the organization's business rules and data definitions.   X X
How to apply the BI application to the organization's configured environment.   X X
Figure 1: Learning objectives and training approaches.

With the learning objectives identified in Figure 1, Figure 2 identifies training approaches and the cost effectiveness given the number of users an organization needs to train.

Cost Effect Training Standard Standard & Custom Custom
< 10 users X    
>10 and < 100 users X X
> 100 users     X
Figure 2: Training approaches and the cost effectiveness.

Having worked with several BI applications, I would agree that they are easy to use once you understand what they can do and how to use them. Training on a BI application is essential if the goal is to quickly understand how to use the software. Additional considerations such as having your users apply their understanding in a manner that will allow them to gather, format and analyze the data they need for decision-making purposes may need to be addressed.


For more information on related topics visit the following related portals...
DW Basics and Business Intelligence (BI).

Jonathan Wu is a senior principal with Knightsbridge Solutions. He has extensive experience designing, developing and implementing information solutions for reporting, analysis and decision-making purposes. Serving Fortune 500 organizations, Knightsbridge delivers actionable and measurable business results that inform decision making, optimize IT efficiency and improve business performance. Focusing exclusively on the information management disciplines of data warehousing, data integration, information quality and business intelligence, Knightsbridge delivers practical solutions that reduce time, reduce cost and reduce risk. Wu may be reached at jwu@knightsbridge.com.

Solutions Marketplace
Provided by IndustryBrains

Data Validation Tools: FREE Trial
Protect against fraud, waste and excess marketing costs by cleaning your customer database of inaccurate, incomplete or undeliverable addresses. Add on phone check, name parsing and geo-coding as needed. FREE trial of Data Quality dev tools here.

Speed Databases 2500% - World's Fastest Storage
Faster databases support more concurrent users and handle more simultaneous transactions. Register for FREE whitepaper, Increase Application Performance With Solid State Disk. Texas Memory Systems - makers of the World's Fastest Storage

Manage Data Center from Virtually Anywhere!
Learn how SecureLinx remote IT management products can quickly and easily give you the ability to securely manage data center equipment (servers, switches, routers, telecom equipment) from anywhere, at any time... even if the network is down.

Design Databases with ER/Studio: Free Trial
ER/Studio delivers next-generation data modeling. Multiple, distinct physical models based on a single logical model give you the tools you need to manage complex database environments and critical metadata in an intuitive user interface.

Free EII Buyer's Guide
Understand EII - Trends. Tech. Apps. Calculate ROI. Download Now.

Click here to advertise in this space

E-mail This Column E-Mail This Column
Printer Friendly Version Printer-Friendly Version
Related Content Related Content
Request Reprints Request Reprints
Site Map Terms of Use Privacy Policy
SourceMedia (c) 2006 DM Review and SourceMedia, Inc. All rights reserved.
SourceMedia is an Investcorp company.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.