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 Facebook Analytics ...

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 accomplishing this task in SA...

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 create a set of calcu...

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., for all types of fac...

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 files. Either there i...

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 formulae size; you can ...

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 at the time that the ...

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 detail precisely how...

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 lost sight of what they...

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 of independent vari...

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 easy to read as thos...

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 no equivalent to th...

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 into a 1 if it was ...