SPECIALISTS IN FINANCIAL MODELLING

Module 4 – Categorising Data Using Tiering Tables

In the previous video 'Design Principles' you’ll find a link to a file called "Fun Run Data" (click on the link to download) which contains (you guessed it!) some Fun Run entrant data from the past seven years.Our job is to give potential sponsors an overview of the types of runners we have entering this race.Sponsors would like to know things like age, gender, location etc., and how the run has grown

In the previous video 'Design Principles' you’ll find a link to a file called "Fun Run Data" (click on the link to download) which contains (you guessed it!) some Fun Run entrant data from the past seven years.Our job is to give potential sponsors an overview of the types of runners we have entering this race.Sponsors would like to know things like age, gender, location etc., and how the run has grown over time.If you are not using PivotTables and would like to manually calculate the age brackets, please review the video below for how to use a close-match VLOOKUP to do this.

Your homework for this module is to review the data and create some impactful visuals from this data, and on next week’s webinar, we’re going to use these to turn them into a single infographic we can display to promote the run.

This week, please be on the lookout for ways to visualise your data.If you have access to data in your work, think about how you can be creative in your presentation and communication of this information.I am happy to review anything you send through to me and will keep it confidential unless you state otherwise.

In this video:

  • Difference between an exact match and close match in lookup functions
  • Flat tiering calculations
  • Using tiered calculations to put population data into age brackets
  • Progressive tiering tables such as income tax calculations