Sifting a Riverbed of Data for Insight

Pizza-flavored cheddar cheese—good business opportunity? Yes, as Cabot Creamery determined. Does osteoporosis more often hit wine drinkers or teetotalers? Imbibers, as Kaiser Permanente can tell you. Will women who buy lace dresses by mail also buy lace bras that way? Not really, as Victoria’s Secret knows.

Business intelligence software revealed the answers to these questions by synthesizing data that already existed at these companies, sometimes mixing it with outside demographic information, then analyzing it six ways to Sunday. The companies then made business decisions based on the results. Cabot started selling a new cheese, Kaiser looks for bone problems in heavy drinkers and Victoria’s Secret knows not to push brassieres on certain customers.

PDF Download

Yet it isn’t easy to sort through the hundreds of business intelligence products for sale. SAS Institute, the biggest vendor in this market and a specialist in statistical analysis tools, itself sells more than 50 products.

Some key categories include: tools to query back-end databases and build reports based on the results; data mining tools to pull specific variables from data sets; and online analytical processing (OLAP) tools, which are statistics tools that rely on multidimensional databases. Even everyday spreadsheets can do a lot of this work. Bankers, especially, love the spreadsheet method.

Product lines of the major vendors overlap in some areas and stand alone in others. Business Objects, for example, is known for easy-to-use query tools. Cognos has more complicated query tools, plus OLAP. Hyperio offers both an OLAP database and analysis applications designed specifically for finance tasks. Information Builders has a report writer and tools for gathering data from different sources.

Different tools are needed, depending on the kind of data available and what you want to find out.

For example, analysts would use OLAP to discover that there is a general tendency for two or more things to happen together. Beer, for instance, might sell better on hot summer days to men in their 20s. Identifying the population of those people in a geographic area to initiate a marketing campaign calls for mining of a demographics database.

Kaiser Permanente and other health care and pharmaceutical firms use statistics tools from SAS and various OLAP products. They study complex drug trials and patient medical information, involving dozens of variables that require traditional statistics techniques. As Sue Emmons, director of data intelligence projects at the Vancouver Coastal Health Authority, puts it, “We’re not into widget management.”

But other companies are, in essence. CVS Pharmacies, for example, tracks product sales at its 4,200 stores with an application built on Hyperion’s OLAP database. Six hundred managers use it to find trends and streamline inventory.

Feeling stuck in self-doubt?

Stop trying to fix yourself and start embracing who you are. Join the free 7-day self-discovery challenge and learn how to transform negative emotions into personal growth.

Join Free Now

Picture of Kim S Nash

Kim S Nash

TRENDING AROUND THE WEB

If you grew up fearing your parents, you probably display these 8 traits (without realizing it)

If you grew up fearing your parents, you probably display these 8 traits (without realizing it)

The Blog Herald

If a man doesn’t believe you’re intellectually equal to him, he’ll often display these 8 subtle behaviors

If a man doesn’t believe you’re intellectually equal to him, he’ll often display these 8 subtle behaviors

Global English Editing

8 everyday behaviors of men who have very little self-respect and dignity

8 everyday behaviors of men who have very little self-respect and dignity

Personal Branding Blog

8 cheat codes that will help you to find your life partner, according to a relationship expert

8 cheat codes that will help you to find your life partner, according to a relationship expert

Small Business Bonfire

If a man displays these 10 behaviors, he wants to spend his life with you

If a man displays these 10 behaviors, he wants to spend his life with you

The Vessel

People who flourish in their later years tend to follow these 8 practices

People who flourish in their later years tend to follow these 8 practices

Jeanette Brown