Two Events: Advanced Excel for Analytics and Mapping for Earthquake Relief

Last Tuesday we hosted a second session by Prof Bill Gerrard, specialist in sports analytics at LUBS, for a working session on how to use Excel for data analytics. This was a very popular event, as Lawrence’s tweet below can show you…

Though we like R and Python at Leeds Data Soc, we know when we reach the big wide world of work, most people are wedded to Excel. Trusted tool and diviner of computer competency in the workplace for at least a decade now, there’s no getting away from the spread sheet. Bill guided us through some of the more advanced parts of excel such as Pivotables and how to use the analytics add in, which can be enabled through the options menu.

Everyone enjoyed the event and quite a few stayed with us to cool their brains down at The Victoria pub on Great George St. afterwards.

JP and Ecuador Earthquake side by side image

With much shorter notice, we also hosted a small event to show people how to contribute to OpenStreetMap, a huge open source map of the world which can be edited by users. OpenStreetMap is also used by charities and governments in natural disasters, because it’s entirely free to use – Google Maps puts a limit on the number of requests that you can make to it. This means that during major events, authorities can use it as a reliable mapping tool to reach isolated communities. A guide to getting started with openstreetmap and the hot tasking manager has been built by Andy Evans, who also guided our session earlier in the year about using Python for data analysis. It was originally built to help after the Nepalese earthquake in 2015, but by using the  HOT tasking manager, you can see which projects are running at a given time.

Hot Tasking Mgr

After a brief demonstration, we set about contributing to maps of Ecuador and Japan, both of whom have been recently affected by major earthquakes – you can see that tasks for Ecuador have been assigned the highest priority in the HOT tasking manager.