Nottingham City Transport (NCT) runs 300 buses in the city and its surrounding areas, with a sizeable amount of data being produced every day. One million passenger transactions occur each week, creating 20 million data points; all held in a database and reported through Crystal reports and spreadsheets. NCT knew which buses were running where and when, but other data couldn’t easily be interpreted or perform as they wanted. In the last few years, access to the data and drafting reports became slower. As a result, NCT needed an analytics solution with instant and visualised data to help performance and planning.