NUMBERTELLING, a fellow Codebase tenant, approached Bad Dinosaur to build one of the components of a larger Tableau-based project they were doing for NHS Education for Scotland.
As Microsoft Azure professionals, we jumped at the chance to build the console based application that would sit between data exports from the NHS' internal systems, and the data visualization tool, Tableau, that NUMBERTELLING are experts in. The application retrieves data extracts that are dropped into a cloud storage area on a regular basis, runs post-processing data cleansing methods and then inserts into a Microsoft Azure SQL server instance for Tableau to read from.
Some of the biggest challenges of this project entailed handling the various data cleansing and data manipulation requirements that were asked of us. We managed deployment of the production release and wrote up full documentation for their end-client to refer back to when using the importing tool. We're hoping this is just the first of many partnerships we'll make with NUMBERTELLING - they're great.