Big Data Analytics System for Fact/Data-driven Decision Making

Big Data analytics system has been developed for the London Borough of Lambeth to assist its activities in fact/data driven decision making. The system integrates various historical data from both internal and external sources to provide timely and accurate profiles on multiple measures that the borough council would be concerned. The data integrated from multiple sources includes demographics (Census: Population, ethnicity, disability, gender, tenure, household composition), employment (NOIMS, census, and annual business survey: Working age, unemployment by age and gender, employment by industry, year-on-year change in unemployment, NEETs), deprivation (NOIMS, IMD, census, and school survey: Child and working tax credits, free school meals, IMD scores, DLA claimants), health care (Health stats: Childhood obesity, percentage of people with respiratory problems, number of hospital admissions, live expectancy, deaths), transport (Gov.uk: Road accident instances, year-on-year change in road accident instances), crime (Met police: Average monthly total crimes, year-on-year change in total crimes), etc. The information is presented in an interactive, hierarchical and comparative way by using a map-based visualization dashboard. For a given measure, the borough average value can be obtained and compared with the value of each ward/LSOA code within the borough. The system is available in both Tableau-based and SQL Server-based platforms