To make informed, high impact decisions, organisations need quick access to critical information and data across their whole line. The range of different systems used within companies makes the information hard to find. Customer information may be stored in one database, accounting and sales information in another and information about competitors may be found on the web.

Data collection

A business intelligence tool like QlikView will let you gather and analyse data from any source.

Tired of Reports, Reports, Reports.... 
Often management is drowning in reports. Everyone wants to produce as good a report as possible resulting in endless time being spent trying to persuade the reader that their department is the most important within the business. QlikView and QlikWeb reduces the need for reports to a minimum.

An ordinary database or ERP system (Enterprise Resource Planning) gives you the opportunity to print a wide variety of different reports. These reports are predefined lists of data, hopefully sorted the way you want it. The problem is that they do not give you more than a static list of some assorted data. If you want any other information you have to print another report and then try to analyse the information manually or using Excel or some other tool.

With QlikView you will be able to analyse any subset of data and any type of relation within that data just by clicking on the item you want to analyse. Four "clicks" in QlikView often equals between 4-16 hours of work using ordinary reporting.

Raising profits 
What means are there to raise the enterprise profits? 
• Cutting costs 
• Increasing productivity 
• Targeting the right customers 
• Finding the right products 
• Finding the right suppliers

How do you know which costs to cut? What is the difference between the profitable sales team and the team with poor performance? Who is the best supplier if you compare both price, delivery and quality?

Graphically presenting information visualises the information

With a good Business Intelligence Application you will get answers to all these questions. You will truly get to know the essence of you business

Saving time Managers across the organisation normally spend days preparing all sorts of reports and top management is drowned in reports. Most reports do not get read. The amount of time/money spent on this is enormous. 

• Weekly reports 
• Monthly reports 
• Project reports 
• etc...

A good business intelligence tool will virtually diminish the time spent to prepare reports throughout the whole enterprise. Top management will have the same insight as middle management, thus eliminating the need for time consuming data gathering. Lower management reporting can instead include more of improvement proposals and concentrate on trying t o come up with means to rectify and explain any findings.

The choices available to companies looking to add business intelligence, reporting and analysis to their operations can be overwhelming. There are literally hundreds of product offerings to choose from: a Google search for “business intelligence software” will yield more than 24 million responses – and perhaps more critically – more than 50separate vendors using adwords tagged to just that phrase! Further, most of the products in the Business Intelligence are technically similar. Throw in technical jargon and marketing speak and making relevant differentiations becomes quite difficult.

To cut through the clutter and streamline their decision-making process, most companies build a short list of preferred vendors based on some set of criteria, and then invite those short-listed companies to compete for their business. Often this involves an elaborate RFI process, with extensive spreadsheet-based checklists where different products are compared across potentially hundreds of attributes and factors. These processes tend to favour larger vendors – those with product scope necessary to achieve a check in the “yes” box for the most features. This type of process also tends to favour complex products – as those products are most likely to have the most features. Needless to say, a long list of checked boxes contributes little toward understanding the benefits and complications created by using a particular product. The typical RFI process often produces an extremely homogenous short list – “winners” that all clump together with look-alike features and attributes.

So how to choose? Companies can both simplify and greatly improve the quality of their short-list selection process by taking a different approach – rather than creating a master list of all possible features and then checking off feature after feature in an attempt to “keep score,” companies should focus on the business value and ongoing expenses that different solutions create – measured across a few key variables. This article is intended to outline key criteria that companies should consider when creating their shortlists – and making their ultimate selections.

Speed of Implementation for the Whole Solution– Analytics Applications To the Desktop

Just as product marketers talk about delivering the “whole product” rather than just a piece of the overall technology, companies should look at the time required to implement a complete working solution – one that makes it possible for business users to answer business questions. There are two measures to watch here: Time till the first application is deployed to an end-user, and total deployment time for the entire project.

According to a recent survey of DM Review readers, only 5% of companies were able to deploy a usable, working analytics application within 1 month – and the average time to first application deployment was 5 months. More than a quarter of the companies surveyed took more than 6 months to deploy a single working application, and the average time to completion for projects was 17 months – just shy of 1 ½ years.

Many of the BI solutions available today are “infrastructure heavy” with extensive pre-application deployment work paving the way to the actual end-user products. Companies should be aware of the timelines that their BI vendors require when they make their selections, and how those timelines match up with their expectations and requirements for the project. During vendor evaluation, companies should be sure to include at least one vendor with a track record of delivering rapid deployments (1 months or less start to finish) so that they can weigh the benefits and tradeoffs in their evaluation process.

Key Metrics:

1. How long does it take to deploy the first analytics application?
2. What is the average or typical total project deployment time for this product?

Flexibility – Are We Building With Cement or Something a Little More Pliable?

There’s an old saw about ERP software: “It’s just like cement – you can pour it to look like anything you want, but once it dries, you’re stuck with it.” Many of today’s business intelligence solutions involve extensive infrastructure projects – building rigid data warehouses and small armies of OLAP hyper-cubes over a period of several months– with actual applications reaching the end-users only at the very end of the project.

While these implementations can provide real business value, their success depends on a clear understanding of the business drivers and requirements at the beginning of the project. Unfortunately, analytical design tends to be an iterative process. For companies where the business changes rapidly or where no clear analysis program has been in place before, the ability to modify analytics applications quickly after they have been deployed will have a significant impact on the project’s success. The same survey mentioned above found that 75% of all analytics applications needed to be modified within 6 months of their initial deployment. Companies should look at their business intelligence system as a living, changing set of applications – and consider the time and cost required for making changes to existing applications as a critical element of their evaluation.

Key Metrics:

1. After an application is deployed, how long does it take to add a completely new data source to the application?
2. Once a new analysis area is identified, how long does it take to prototype and deploy a completely new finished production application?

Ease of Use – Can Our Employees Learn to Use It?

Your company can build the most powerful, sophisticated business intelligence system in the world. But if no one in the company uses it because it is too complicated to figure out, the system will be worthless. Ease-of-use takes two forms – for the IT department that maintains and modifies BI applications, and for the end-users who actually use the applications. Both have a significant impact on the long-term success of your business intelligence initiative. Despite this, ease-of-use is often overlooked during the business intelligence selection process. Perhaps because it is an attribute that is difficult to measure (check yes or no – does this product have “ease-of-use” in it?) the standard checklist RFI process rarely even attempts to address this issue.

Companies need to consider what it will take for their employees to use the systems they deploy.

Key Metrics:

1. How long would it take the typical line of business manager to learn to use this product? Measure in hours, days, or weeks.
2. How many days of training do other customers using this product recommend for end-users? For IT staff?
3. How long would it take a power user from our company – either IT or business analyst – to learn to develop new applications with this tool?

By addressing these three factors – speed of implementation, flexibility, and ease of use – during the RFI process, companies can significantly improve the quality of their business analytics and reporting product selections.