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.

GAINING BUSINESS INTELLIGENCE

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.

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.

For more information on gaining business intelligence visit http://www.accuracast-marketing-agency.co.uk/business-intelligence.shtml

Other articles by this author »
About Jerome Bergerou

For more information contact:

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


And here is another random article you might be interested in...

Site Design....Site Disaster....What Do Your Visitors See?

So you got your own website now. Exciting isn't it? You're ready to start putting your website to work for you. What will you do first? So many ideas going through your head...you want to make it the best website on the internet. You want to make it unique and different from anyone else's.

So many ideas popping in and out of your head you want to do so much. After all besides things in our home, when do we really get to design anything? Before we know it we have added a little of this and a little of that and maybe some more of this. It's almost like waving a magic wand over everything giving it color and making it pretty. To us, our web site looks great we have color and we have animated graphics we also have a lot of content, after all that is what gets website recognition, isn't it?

But wait, take a closer look, is all that content really necessary? We know google likes content but maybe some of us are confused as to which kind of content google is looking for. I admit, I once thought content is content. But I was very wrong, not all content is created equal. If your website is a business related site then your content should be business related as well. Your content should be interesting and helpful. Something you know your visitors would enjoy. Color and graphics is not useful content.

Many websites have articles on their site. This is probably one of the best contents to have on your site. Most articles are interesting and provide useful information. What makes articles on your site even better? If they are your articles. Articles are not hard to write just pick a subject you are familiar with and write an article about it. Just remember to keep your article topics related to the type of site you have.

Let's talk color, is all that bright color really what our visitors want to see? Some colors are way too bright and can be sensitive to peoples' eyes. If you need to have color make them more down to earth colors not something that is going to make your visitors want to run from your site. Not having any color is also good . Color is optional, just choose it wisely.

Animated graphics, who is guilty of those? I know I am, and it's understandable as they are cute and neat to look at. Or are they? Too many things flashing on your site is not appealing. Also, too many graphics will draw the attention away from what is really important - and that is your text. Your text is your message to your visitors. If you insist on having them on your site then I suggest just having maybe one. Make sure your visitor focuses more on your text, not the graphics.

Another point to keep in mind is "keyword rich text". You want to mention your keywords throughout your website. Every chance you get mention your keywords. Work them into your sentences. When writing articles make sure you add some of your keywords to your article title. This also helps your website get noticed by the SE (search engines).

I write this article because I want everyone to learn from my mistakes. I am guilty of all of the above. It took a new computer to realize how loud my color was (old computer color looked dull) . After realizing how bright it was I panicked. It was like a slap in the face because I thought what an awful color and if I thought that of my own site what were my visitors thinking? I asked the advice of a good friend and thank god this friend is open and honest in her opinions. She helped me to take a step back and really look at my site. My only thoughts were, "What have I been thinking?"

I don't even remember when or how my site got the point it did. I felt like I had this whole other life I knew nothing about and that person was taking over the designing of my site. But thanks to the new computer and my good friend, I have taken the control back of my site and since I have done so the visitors to my site have actually doubled and the length of the visit has also increased. I am back on the road to success.

Other articles by this author »
About Debbie Reyes

This article was written by Debbie Reyes webmaster of http://www.extra-income-work-at-home-mom.com
dreyes36@aol.com