Category Archives: Blog

The problem of multicollinearity in Key Driver Analysis

Intro Key Driver Analysis is a statistical technique that quantifies the importance of a series [...]

Using Survival Analysis to estimate product lifetime

We needed to estimate the average number of years after purchase various consumer products broke [...]

Payroll Tool for Commission Calculation and Reporting for Recruiters

For teams of recruiters keeping track of commissions is a laborious process often done with [...]

Data Visualisation tools for BI and analytics: Six typical scenarios and possible solutions for SMEs and big corporations

There are many vendors and solutions for data visualisation for Business Intelligence (BI). How do [...]

The problems with spreadsheets

Spreadsheets, in particular, Excel are probably the most widely used types of data analysis software. [...]

Automating the production of dashboards from bookings and point of sale data

A common issue for many organisations is how to streamline the production of their dashboards. [...]

Key Driver Analysis Techniques

Key Driver (Relative Importance) Analysis Key Driver Analysis or Relative Importance Analysis, is the generic [...]

Working with Social Media Analytics APIs

Over the past few months, we have developed a system for a client to automate [...]

SPSS Vectors and multi-coded questions

Using vectors to deal with multi-coded questions in SPSS There are two common ways that [...]

Name ranges in VBA

Name ranges are an exceptionally useful way to manage blocks of data on Excel workbooks. [...]