Gaining Business Intelligence

A white paper on how companies should analyse customer data to gain better business intelligence and how they can use that knowledge.

In an increasingly competitive world, using your client database smartly, to gain a better understanding of your number one asset ? your customers ? can make or break the success of your company.

Most companies use databases to store information about their current customers, previous customers, business partners, and potential customers. The challenge lies in finding a way to harness the useful information contained within these high volume databases in order to produce intelligent business solutions.

Business intelligence (BI) refers to the process for increasing the competitive advantage of a company by intelligent use of available data in decision-making. Business intelligence consists of sourcing the data, filtering out unimportant information, analysing the data, assessing the situation, developing solutions, analysing risks and then supporting the decisions made. This white paper describes the business intelligence process, some elementary methods of data mining, and how you can use business intelligence in your company.

Database Enhancement

The first step towards gaining business intelligence is to start with a 'clean' database. Incomplete and inaccurate data invariably translate into incorrect management decisions. Duplicate data is also a problem as it can wrongly weigh management decisions to one side. Whilst a good quality database does not automatically lead to intelligent management decision-making, it is a pre-requisite for all types of analysis that attempt to elicit intelligent management. We could draw an analogy with cooking, where starting with the right ingredients does not guarantee you will bake a good cake, but there is very little chance you will bake a good cake if you start with the wrong set of ingredients.

One of the primary reasons companies do not fully realise the potential competitive advantages they can gain from their own databases is the lack of proper integration of datasets across departments. Even though all the information might reside within the company, it may remain elusive due to a fragmentation of the data across incompatible databases. Regrouping all internal data into a single dataset or a series of interconnected datasets could be the single most useful step a company might take towards providing a solid foundation on which quality business intelligence can be developped.

In some cases, data entry errors and/or missing data can also severely impair the quality of information that can be derived from corporate databases. Sorting these issues can range from very straightforward fixes (e.g. matching one list against another) to more time consuming processes (e.g. contacting all client companies to update contact details of individuals working there). Ideally, all inaccuracies should be weeded out of the databases. However limited time and monetary constraints dictate that you should bear in mind how this database will be used. The level of accuracy required will vary greatly depending on the expected use for that data.

Data cleansing and database integration can provide significant advantages for a company over the medium to long term. However, they are both extremely time-consuming activities and can create a significant strain on internal resources, making them difficult for a company to justify. Hiring a third-party to do this job is often the best solution, allowing valuable information to be gained, without disrupting day-to-day business activities.

Data Mining

Analysing the information that your company stores in connection with all customer interactions can reveal a lot of remarkable facts about the buying behaviour of your customers, what motivates them and what might make them stop buying from you. It also provides a scientific method to monitor your business performance.

When deciding to mine information from a database, one is faced with a wide number of available techniques. Some of the more popular data mining methods are described below:

Statistical models
Basic statistical measurements ? such as means, variances, and correlation coefficients ? are useful in the early stages of data analysis to gain an overall view of the structure of the data. By revealing simple inter-relations within the data, statistical modelling can show which in-depth technique is likely to bring further information relevant to your interests.

Clustering
Clustering is a technique that aggregates data according to a pre-determined set of characteristics. It can be used to differentiate groups of customers that behave similarly on certain factors, for example it can classify customer behaviours according to credit worthiness, income, age or any other factor of interest.

CHAID Analysis
CHAID, which stands for Chi-square Automatic Interaction Detection, can be seen as the opposite of clustering, in the sense that the CHAID analysis starts with the overall database, and then splits it according to the most important variable until it achieves homogeneous sub-groups that cannot be split any further. A major advantage of this technique is that the results can be presented as an easy-to-read classification tree; each split in the tree being accredited to a single variable (e.g. credit worthiness, income, age, etc).

Propensity models
Propensity models ? also known as predictive models ? have proven to be very valuable in predicting which customers are most likely to purchase a certain product based on a set of current customers. The results of such a model can be directly used to develop more appropriately targeted marketing campaigns.

Other recognised techniques to extract information from datasets are database segmentation, neural networking, and wavelet analysis among others. It can be intimidating to choose which method will provide the best results. As shown above, analysis tools can differ greatly in their approach of the problem. It is therefore very important for a company to consult someone with extensive experience in data mining processes before going ahead with a business intelligence project. The best method to use will vary greatly depending on the time available to do the analysis, what the results will be used for, and the type of data that is available for the analysis.

An important point to consider is whether your analysis is guided by pre-defined questions or not. Predefined points of analysis are aimed at understanding certain types of behaviours by analysing relationships between various pre-decided influencing factors. For example, a predefined analysis of customer service Vs sales would illustrate the effect of good and bad customer service on sales, and would answer questions such as how important customer service is to customers and how much it influences future sales. On the contrary, the objective of an open-ended analysis is to discover trends that are not anticipated by ordinary immersion in the day-to-day business. Performing an open-ended analysis internally is often impaired by the expectations brought on by individuals working within the company.

The techniques used to analyse data are complex. In order for your company to be able to use the results of the data analysis, it is crucial that the results should not be clouded by the complexity of the calculations but are delivered in a straightforward manner.
Intelligent Marketing

It is important for a company to recognise that a good understanding of its customers is useful only to the extent to which this knowledge can be translated into real business practices. Business intelligence refers not only to the data analysis in itself, but also to how you relate the results from the data analysis to every day business decisions and how you translate the recommended actions stemming from the analysis into live campaigns.

It is therefore important for you to ensure that the marketing department in your company interacts with the data analysts constantly throughout the process. That way, when the data analysis is complete, the marketing personnel will already be in tune with the issues the company is facing, and will be able to develop campaigns to capitalise on opportunities and strategies to mend weaknesses quickly and effectively.

Detailed analysis of your customer data will provide you insight into their needs and wants. The exercise will analyse and segment customers' buying patterns and identify potential services that are in demand. You can use this information to shorten response times to market changes, which then allows for better alignment of your products and services with your customers' needs.

An in-depth understanding of your customers, provided through comprehensive data-analysis, will also allow you to pick and target better prospects, achieve a higher response rate from marketing programs, and at the same time identify reasons for customer attrition and create or alter programs and services accordingly.

Understanding how external market conditions affect your business will enable you to react quickly to future changes in the market. Finally, understanding customer behaviour and the way they use your products and services will enable your company to improve its service to its current client base as well as to target new business more effectively.

Visit http://www.accuracas t-marketing-agency.co.uk/business-intelligence.shtml to learn more about gaining business intelligence.

About AccuraCast

AccuraCast is an integrated marketing, business intelligence and data analysis agency, providing small and medium sized companies in the UK a more accurate picture of their business environment via comprehensive data analysis, business intelligence, and marketing consultancy services.

AccuraCast helps companies gain a better understanding of their customers and market their products and services more effectively. The company uses high-tech data analysis methodologies to investigate client databases smartly, and proven sales and marketing methods to reach the target markets. AccuraCast delivers costumer specific marketing solutions and information based on tailor-made analysis of the databases, allowing companies to gain the necessary edge over the competition.

© AccuraCast Limited 2004

For more information contact:

Jerome Bergerou
AccuraCast
Tel: 0870 240 7847
Fax: 0871 277 1371
Web: www.accuracast.com
Email: j.bergerou@accuracast.com

---

Google News Updated : Sat, 11 Oct 2008 05:49:35 GMT McCain Lauds and Attacks Obama in Same Day - New York Times CBS News McCain Lauds and Attacks Obama in Same Day New York Times - 41 minutes ago Senator John McCain of Arizona and his supporters at a rally on Friday in La Crosse, Wis. By ELISABETH BUMILLER LAKEVILLE, Minn. - After a week of trying to portray Senator Barack Obama as a friend of terrorists who would drive the country into ... McCain Moves to Soften the Tone at Rallies Washington Post John McCain, speaking to supporters, tries to defuse an anti ... Los Angeles Times Reuters - DetNews.com - Austin American-Statesman - The Miami Herald all 304 news articles Publ.Date : Sat, 11 Oct 2008 05:08:14 GMT Genomics project unites four Wisconsin research institutions - Milwaukee Journal Sentinel Genomics project unites four Wisconsin research institutions Milwaukee Journal Sentinel - 19 minutes ago By KATHLEEN GALLAGHER Wisconsin’s four biggest academic research institutions will collaborate on an initiative aimed at giving the state national stature in the fast-emerging field of individualized medicine, Gov. Marshfield Clinic gets biggest donation yet Chicago Tribune Wis. governor unveils gene research triangle Forbes Bizjournals.com - GenomeWeb News (subscription) - WJFW-TV - WISN.com all 51 news articles Publ.Date : Sat, 11 Oct 2008 05:29:44 GMT Paulson Indicates Need to Purchase Bank Equity `Soon as We Can' - Bloomberg Telegraph.co.uk Paulson Indicates Need to Purchase Bank Equity `Soon as We Can' Bloomberg - 1 hour ago By John Brinsley and Rebecca Christie Oct. 11 (Bloomberg) -- US Treasury Secretary Henry Paulson indicated that pumping government funds into banks is a priority and said financial markets will remain volatile. US planning to buy equity in financial institutions Reuters Treasury Weighs Investing In Banks Washington Post International Herald Tribune - MarketWatch - CNNMoney.com - Bizjournals.com all 1,783 news articles Publ.Date : Sat, 11 Oct 2008 04:21:05 GMT Bush: US authority able to solve financial crisis - People's Daily Online Telegraph.co.uk Bush: US authority able to solve financial crisis People's Daily Online - 1 hour ago US President George W. Bush arrives in the Rose Garden at the White House to makes a statement on the economy in Washington, October 10, 2008. President Bush vows action on financial crisis Los Angeles Times Bush's Lullaby to the Markets Washington Post Birmingham Star - Wall Street Journal - CNN - Bloomberg all 1,302 news articles Publ.Date : Sat, 11 Oct 2008 04:12:49 GMT US Near Changing Stance on North Korea as Terrorist - Wall Street Journal BBC News US Near Changing Stance on North Korea as Terrorist Wall Street Journal - 1 hour ago By JAY SOLOMON WASHINGTON -- The Bush administration is hoping to announce as soon as Saturday that it is tentatively removing North Korea from its list of state sponsors of terrorism, in a bid to kick-start a stalled nuclear disarmament agreement, ... AP: US to remove North Korea from terror blacklist The Associated Press US May Remove North Korea From Terrorism List, AP Reports Bloomberg Los Angeles Times - Voice of America - Financial Times - The Miami Herald all 1,714 news articles Publ.Date : Sat, 11 Oct 2008 04:02:40 GMT G-7 Commit to `All Necessary Steps' to Stem Global Meltdown - Bloomberg Voice of America G-7 Commit to `All Necessary Steps' to Stem Global Meltdown Bloomberg - 1 hour ago By Simon Kennedy Oct. 11 (Bloomberg) -- Group of Seven finance chiefs, meeting after stocks plunged and as a global recession looms, vowed to prevent the failure of vital banks while failing to unveil new initiatives for thawing credit markets. Group of 7 Nations Seek Coordination in Rescue New York Times In latest bold step, Treasury will buy bank stakes The Miami Herald CNNMoney.com - The Associated Press - Boston Globe - FN Arena News all 890 news articles Publ.Date : Sat, 11 Oct 2008 04:03:42 GMT Democrats Are Gaining, Registration Data Shows - New York Times Los Angeles Times Democrats Are Gaining, Registration Data Shows New York Times - 2 hours ago By NICHOLAS CONFESSORE and GRIFF PALMER Some longtime Republican strongholds in New York are becoming increasingly Democratic, a striking change driven by demographic shifts, intense voter registration drives by Democrats and allied groups and sagging ... Campus registration drives in full swing KARE Ott, Hook face off for open county office St. Joseph News-Press The News-Press - Winston-Salem Journal - Tampabay.com - Beaufort Gazette all 739 news articles Publ.Date : Sat, 11 Oct 2008 03:20:33 GMT Clickbank RSS Feeds Make Money Online

PARLOT::Ebooks, Scripts, Websites, and more...

Adsense websites

Misrepresentation - Through Silence!

We're back to the subject of ethics, more specifically, business... Read More

How To Be A First Class Marketer?

Did you now how to follow up a new customer... Read More

New Years Revolution

No, that's not a typo in the title. Resolutions are... Read More

The Anatomy of Hype

On a copywriting board I frequent, someone expressed bafflement that... Read More

Ten Crucial Questions

Ten Crucial Questions for Your Business Future I'm... Read More

Make Your E-Mail Signature File WORK for You!

You're probably familiar with e-mail signature (or "sig") files -... Read More

4 Dynamic Marketing Tactics

Some of the simplest marketing tactics often produce the most... Read More

Private Practice Marketing: 3 More Things I Wish I Knew When I First Started

1) Create systemsCreate systems for everything you do, especially those... Read More

Optimizing Your Email Marketing

Email CampaignsEmail marketing can be a tremendously valuable tool for... Read More

How to Use Direct Response Post Card Decks as a Valuable Market Research Tool

Market research specialists have discovered a new tool which enables... Read More

Nice Guys Finish First

Volunteering your services can be an excellent way to form... Read More

Profitable Marketing Programs (Part 1)

Deciding whether a particular marketing program is profitable to your... Read More

Five Most Common Mistaken Beliefs About Joint Venture Marketing

Apart from being the fastest, easiest, and most profitable strategy... Read More

The Power of because...

"Do it!", "Do it now!", or "Do it because..."Which of... Read More

6 Article Marketing Smarts: How To Get More Reprints And Exposure

Article marketing is the latest buzzword for marketers... Read More

Why Insight and Flexibility is More Important than Perseverance in Marketing

Marketing successfully requires not only insight into how a product... Read More

Marry Your Marketing Plan

Make a vow to keep up your marketing schedule in... Read More

Are You Losing Business?

As a small business owner, you are grateful for all... Read More

The Importance of a Marketing Plan

There aren't many things in life that you would get... Read More

How to Pick a Winning Business Name

What's in a name?Think of your business name as an... Read More

Two kinds of Advertising for a Marketing Strategy

Advertising is the lifeblood of any business. If you do... Read More

How To Perfect Your Marketing Message!

When it comes to your marketing message, the little things... Read More

The Power of a Survey

How many times have you been asked to participate in... Read More

Are Your Marketing Efforts Working...Or Could They Use A Little Help?

Marketing is a broad business subject that encompasses a range... Read More

Hispanic Market Reality and Purchasing Power

How many Hispanic people live in the US currently. Well... Read More