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

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

Sharing the knowledge

A major problem for organisations is that analytics consultants conduct (relatively simple) analysis but don’t [...]

SPSS table trick

For scaled questions, the output of SPSS tables places the mean scores in a separate [...]

SumIfs Vs VLookups / Index-Match

Standard Excel look-up functions suffer from a problem in that they only match on a [...]

Quick trick to check whether columns are identical

Excel stores the value for True as 1 and a False as 0. So, if [...]