Case study - Data Analysis

John Painter runs a decorating business. In this example I show how I would help organise his supplies ordering operations.

Collect the data

Let's say John has receipts like this for the last month of supplies


The first step is to enter the details from the receipts onto a spreadsheet. This could be done by myself or the client, with or without my supervision.


Adding the details to a spreadsheet is a good first step, but we want to get more from it than this. Click here to see how I would create a spreadsheet from this information that will help John with his buying.