Kimball University: Educate Management to Sustain Data Warehouse/BI Success - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management

Kimball University: Educate Management to Sustain Data Warehouse/BI Success

Data warehousing and business intelligence success cannot be taken for granted. You must create an ongoing education and communication program to maintain your success and extend it across the organization.

Most large organizations have fairly mature data warehouse/business intelligence (DW/BI) systems in place, and many of these have met with some measure of success. Unfortunately, in this “what have you done for me lately” world, success is not a single event you can gloat about as you kick back with your feet on the desk. Continued success is a constant process of building and maintaining a solid understanding of the value and purpose of the DW/BI system across the organization. We call this education, but many of the techniques involve marketing and organizational strategies. Call it what you will, you must actively and constantly promote the DW/BI system.

First, you need to know who your stakeholders are and make sure you have standard communications tools in place, like status notes, newsletters and quantitative usage reports. There are also a few qualitative and organizational tools you can use to educate management about the value and purpose of the DW/BI system.

Gathering Evidence

While usage statistics are interesting, they show only activity, not business value. Simple query counts tell you nothing about the content or business impact of those queries. Unfortunately, there’s no automated way of capturing the value of each analysis from the DW/BI system. You still have to get this information the old-fashioned way, by talking to people. Someone on the DW/BI system team has to go out into the user community on a regular basis and ask people to describe what they are doing, assess the business impact it has had and document it.

Most of the time, the impact of any given analysis isn’t all that stunning. People do useful things that make a big difference in their work, but it’s not a multi-million dollar hit. Every so often, you will find an analysis or operational-BI application that has had a significant impact. The analyst may have identified a pattern of calls in the customer care data that led to a simple change in the documentation and reduced the call volume by 13 percent (at $6 per call, that’s over $140,000 per year for a company that takes 500 calls per day). Or they may have analyzed the donor database in a small non-profit organization and identified donors who had dropped out. This led to a special program to reconnect with these people that yielded a 63-percent response rate and close to $200,000. The operational-BI application may offer ring tone recommendations on a Website based on customer purchase history. Each ring tone may fetch only a $1, but a 30-percent increase in ring tone downloads could add up to real money. You get the idea.

Educating the Business: The User Forum

Finding high-impact examples requires a bit of work. One effective technique Kimball Group has used to identify and leverage qualitative examples of value is called a user forum. The user forum is a DW/BI event designed for the business community. Your main business sponsor should kick off this 90-minute meeting with a short speech about how important the DW/BI system is to the organization’s success. The first agenda item is a brief presentation from the team about the recent accomplishments, current state and short-term plans of the DW/BI system. The bulk of the meeting is dedicated to two presentations from business analysts who used the BI system to generate significant value for the organization. They talk about what they did, how they did it, and what kind of impact it had.

Senior managers like these events because they see the impact. Often the head of one department will see what another department has done and realize his group is missing an opportunity. Middle management and analysts like the presentations because they include enough detail so people can see exactly how the analysis was accomplished. They learn new techniques and approaches to the analytical process. The three examples of business value described abouve would be great feature presentations at a user forum.

A good meeting doesn't happen by accident. Carefully plan the meeting over six months. Find good presentation candidates with high business value by canvassing users on a regular basis. Once you find a good example, work with the user to create a clear, compelling presentation with lots of good screen captures and a summary page that shows the dollar impact of the analysis. Rehearse the presentation with them, especially if they are not experienced presenters. This helps you, and them, get the timing down so your audience doesn't miss the punch line because the meeting went too long. Email a reminder a day or two ahead of time, and call everyone you'd like to be there to make sure they are going to make it to the meeting. If key folks, like the CEO or VP of Marketing, can’t make it, consider rescheduling rather than have them miss out. If they are already on your side, it's good to have the show of support (see related article, "Habits of Effective Sponsors"); if they are not converts yet, they could learn something by being at the meeting.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Previous
1 of 2
Next
Comment  | 
Print  | 
More Insights
Commentary
Gartner Forecast Sees 7.3% Shrinkage in IT Spending for 2020
Joao-Pierre S. Ruth, Senior Writer,  7/15/2020
Slideshows
10 Ways AI Is Transforming Enterprise Software
Cynthia Harvey, Freelance Journalist, InformationWeek,  7/13/2020
Commentary
IT Career Paths You May Not Have Considered
Lisa Morgan, Freelance Writer,  6/30/2020
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Key to Cloud Success: The Right Management
This IT Trend highlights some of the steps IT teams can take to keep their cloud environments running in a safe, efficient manner.
Slideshows
Flash Poll