PASS BA April 2015 “What If Scenarios” – Slide deck and Sample Code

I gave a presentation about “What If Scenarios” at the PASS Business Analytics Conference in April 2015. Here are the slide desk and the zip file containing the code samples
The zip file contains:

  • the spreadsheet for the historical analysis of population and emissions. This includes the PowerPivot model and the Power View visualisations.
  • the R code to project emissions in 2010 through to 2050 under various scenarios
  • the “GC building blocks” spreadsheet that contains examples of the common Excel formulas used in the Global Calculator (SUMIF(s), INDIRECT, INDEX and MATCH)

The global calculator can be found including the online tool, downloadable Excel spreadsheet and lots of great documentation.