BLOG
The problem of multicollinearity in Key Driver Analysis
Intro Key Driver Analysis is a statistical technique that quantifies the importance of a series [...]
May
Using Survival Analysis to estimate product lifetime
We needed to estimate the average number of years after purchase various consumer products broke [...]
Dec
Payroll Tool for Commission Calculation and Reporting for Recruiters
For teams of recruiters keeping track of commissions is a laborious process often done with [...]
Jun
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 [...]
Mar
The problems with spreadsheets
Spreadsheets, in particular, Excel are probably the most widely used types of data analysis software. [...]
Feb
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. [...]
Aug
Key Driver Analysis Techniques
Key Driver (Relative Importance) Analysis Key Driver Analysis or Relative Importance Analysis, is the generic [...]
May
Working with Social Media Analytics APIs
Over the past few months, we have developed a system for a client to automate [...]
Sep
SPSS Vectors and multi-coded questions
Using vectors to deal with multi-coded questions in SPSS There are two common ways that [...]
Jul
Name ranges in VBA
Name ranges are an exceptionally useful way to manage blocks of data on Excel workbooks. [...]
Jul
Simplifying your workbooks
One of the biggest mistakes people make when constructing large Excel workbooks is they build [...]
Jul
Efficiency in assigning macro variables at runtime
Often there is need to run some analysis for each distinct value in a dataset. [...]
May
Sharing the knowledge
A major problem for organisations is that analytics consultants conduct (relatively simple) analysis but don’t [...]
May
SPSS table trick
For scaled questions, the output of SPSS tables places the mean scores in a separate [...]
May
SumIfs Vs VLookups / Index-Match
Standard Excel look-up functions suffer from a problem in that they only match on a [...]
May
Quick trick to check whether columns are identical
Excel stores the value for True as 1 and a False as 0. So, if [...]
May