Paul Brown, DirectorSep 19, 20196 minWorking with Google, YouTube and Facebook Analytics APIs.Over the past few months, we have developed a system for a client to automate the downloading and cleaning, data from Google, YouTube and...

Graham WhiteheadSep 13, 20182 minUsing hash tables to split datasets in SASA common task in data preparation is splitting a dataset based on the values of a column. Whilst there are a variety of ways of accomplis...

Paul Brown, DirectorAug 12, 20181 minAnother vector application in SPSSIn a similar vein to the ‘Using vectors to deal with multi-coded questions in SPSS’ blog piece, here we’ll use use vectors and loops to c...

Paul Brown, DirectorAug 12, 20184 minBack-coding in R instead of SPSS.If you are an SPSS user, you would be used to variables having values and value labels for both ordinal and categorical variables (i.e., ...

Paul Brown, DirectorJul 24, 20182 minSPSS Vectors and multi-coded questionsUsing vectors to deal with multi-coded questions in SPSS There are two common ways that multi-coded questions are recorded in SPSS .sav f...

Paul Brown, DirectorJul 23, 20182 minName ranges in VBAName ranges are an exceptionally useful way to manage blocks of data on Excel workbooks. You can call them in functions thus reducing for...

Graham WhiteheadMay 11, 20182 minEfficiency in assigning macro variables at runtimeOften there is need to run some analysis for each distinct value in a dataset. Furthermore, since the set of values are often not known a...

Paul Brown, DirectorMay 9, 20181 minSharing the knowledgeA major problem for organisations is that analytics consultants conduct (relatively simple) analysis but don’t explain the techniques, or...

Paul Brown, DirectorMay 9, 20182 minSimplifying your workbooksOne of the biggest mistakes people make when constructing large Excel workbooks is they build formulae upon formulae, until they have los...

Paul Brown, DirectorMay 9, 20184 minKey Driver Analysis TechniquesKey Driver Analysis or Relative Importance Analysis, are regression/correlation-based techniques that are used to discover which of a set...

Paul Brown, DirectorMay 9, 20182 minSPSS table trickFor scaled questions, the output of SPSS tables places the mean scores in a separate (adjacent) column to the counts, making them not as ...

Paul Brown, DirectorMay 9, 20181 minSumIfs Vs VLookups / Index-MatchStandard Excel look-up functions suffer from a problem in that they only match on a single criterion or condition to work, i.e., there is...

Paul Brown, DirectorMay 8, 20182 min Quick trick to check whether columns are identicalExcel stores the value for True as 1 and a False as 0. So, if we multiple a cell that contains a Boolean statement by 1, we turn the cell...