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 [...]

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. [...]

Simplifying your workbooks

One of the biggest mistakes people make when constructing large Excel workbooks is they build [...]

Efficiency in assigning macro variables at runtime

Often there is need to run some analysis for each distinct value in a dataset. [...]