Benchmarking against National Data
One of the features I was really pleased to add to Bromcom Analytics in BI was the ability to choose between various attendance and KS4 Performance benchmarks from national data. DfE publication is still a little scattergun (although it has vastly improved in the last couple of years) and if you hunt around a bit you can find national, local authority and school level performance at KS4, absence and persistent absence rates and Ofsted ratings. I've collated this data into a sheet you can download here . Be aware that it's 2016-17 data though as that was the latest available when I made it. My aim was to produce a drop down selector that allows the user to place a target indicator alongside their performance. Green dotted lines show the selected benchmark. The Visual is from the BI Marketplace and called 'Data Bar KPI' Put National Data in the Cloud To do this, I first uploaded my national data set to Google and converted it into a Google Sheet. Now as it&