During the London 2012 Olympics the Transport for London (TfL) network needed to manage 18 million local journeys made by spectators. With the evolution of technology changing the way we live and work, it is only a matter of time before governments around the world upgrade their infrastructure to offer citizens efficient services through smart cities, where enormous amounts of data moves within complex information supply chains. Yet, smart cities are not about constantly introducing new technologies. Data sources are everywhere around us, ranging from smart phones and computers, to Global Positioning System (GPS) and social media sites. Effective analysis and utilization of this data is going to be a key factor for success in the smart cities initiative, by making the data available in one place through a framework that is clean, well labelled and allows better processing and consumption.