EXASOL’s MPP In-Memory Database has proved fastest in industry tests, so BrightBee wanted to showcase this technology in a way that enabled a range of audiences to see the value of analysing large datasets.
We decided to try EXASOL’s database for ourselves so we sourced and analysed 602 million rows of prescription data. We knew European Antibiotic Awareness Day (EAAD) was taking place in November. So, to tie into the news agenda, we approached Antibiotic Research UK, a charity dedicated to the issue of antibiotic resistance and worked with them to ask the most interesting questions of the data.
We analysed the data for general trends, seasonal variations and for any correlations between prescribing and deprivation. This last analysis required the use of an additional dataset.
BrightBee used the data to provide journalists with striking headlines and the first ever heat maps to accompany the story.
Results after phase one