Business intelligence

Business intelligence delivers the means to analyse performance of an organisation, it's  customers and products. If you are familiar with spreadsheets, you may have used a pivot-table to analyse figures. Business intelligence provides a similar form of analysis.

Spreadsheets can be difficult to maintain and are prone to error. Business intelligence provides a robust and reliable method to provide summarised and detailed data.

Business intelligence can also be applied to other areas of a business such as stock control, logistics, financial management. It is increasingly being used to manage the performance of websites and on-line communities.

Analysis differs from conventional reporting. Rather than just providing a list of top customers or products by revenue. It allows users to explore and discover performance trends and patterns:

  • Which region produced the most sales?
  • In that region, which product category accounted for the greatest sales?
  • For that category, which product was the most profitable?
  • Which customers purchased this product?
  • How frequently to they buy it?

A well designed business intelligence deployment will deliver the answers.

The data is packaged into cubes to provide the user with intuitive navigation. Requirements are expressed in terms of measures e.g. sales, quantity, margin and dimensions e.g. customers, products etc. The dimensions provide summarisations e.g. all products, categories and product item.

A cubes may comprise many dimensions and measures.

Users can easily navigate discrete areas of data. They can re-arrange the orientation and drill-down to lower levels of detail. As a result they gain insight into the dynamics of their business.

The OLAP Cube

Slice and dice the data to achive the required view

The data cube is just like a Rubik's cube, remember them?

User can review Customer sales and then re-orientate the puzzle. The result providing a new perspective.

 

One of the benefits of this technology is that the cube can be defined in business terms. This aligns IT with the business and reduces potential misunderstanding of errors.

A new perspective provides insight

Business Intelligence is sometimes referred to as OLAP (On-Line Analytical Processing) or Cubes the term used here.

Free guide to delivering business intelligence

Most businesses have customer data stored in sales systems, CRM and websites. These systems provide a fantastic resource for managing business performance.

  • Are you seeking ways to deliver management information?
  • Would you like guidance on how to deliver business intelligence?

This guide provides a step-by-step guide to delivering business intelligence.

View our free guide to delivering business intelligence

Phone: 07956 650 404

contact@information-drivers.com

Visit David Willis' Data Blog

Hello and thank you for visiting Information Drivers, I'm David Willis and this is my consultancy.

I've been helping businesses improve their sales and marketing performance for over 20 years.

To find out how to improve your organisations performance read my Data Blog.

Client Feedback

"The fusion of our customer data with targeted market research has provided real insight. Confirmation of long-held beliefs has been just as useful as the truly new understanding.

The MarketGEM project laid a few ghosts to rest. It enabled us to focus on innovative strategies for business growth and membership satisfaction." ~ Brian Ford, Director of Marketing and Communications, The Chartered Institute of Purchasing & Supply

Client Project

b-live is an innovator in the UK secondary education sector. They help students research and plan their careers using an exciting, stimulating and secure website environment.

They have over 100,000 students on-board with student registrations growing fast. With rapid growth, b-live needed to manage retention rates and student activity.

We delivered a Business Intelligence solution to support b-lives continued growth and success.