The Covid-19 pandemic has meant that data-driven decisions have influenced all our lives over the last two years.  But decisions made without proper data foundations, such as well constructed and updated data models, can lead to potentially disastrous results.

For example, the Imperial College London epidemiology data model was used by the UK Government in 2020 to justify lockdown policy decisions based on a forecast that 500,000 deaths would occur if no action was taken. But questions have been raised about these data modelling predictions and the need for such stringent lockdown measures in the early days of the pandemic.

The problem was not the data but how it was interpreted. The same issues occur for businesses.

All decisions are underpinned by data so it is important for the right data to be available to decision-makers and for that data to be high-quality and trustworthy. Data modeling enables this through a series of data models (conceptual, logical & physical) that start at a high-level, driven by the decision-maker’s business needs, and evolve into greater technical detail for how data is to be stored, organised and managed.

This creates a common language across an organisation which is the starting point for a “single source of truth” for data and the effective flow of data within an organisation.

Data modelling therefore:

This consistency is essential for any data analytics, business intelligence or artificial intelligence application that supports an organisation’s business operations.  Without it, an organisation’s data foundations will be fragile.

The detail behind data modeling is highly technical and complicated and it is recommended that organisations turn to subject matter experts that have a deep understanding of metadata (which sits at the heart of enterprise data management) and data modelling tools. For example, Envitia’s Data Modelling Toolkit has been used extensively by the UK Hydrographic Office to deliver a complex digital transformation project around maritime data. The benefits pay dividends once completed. This includes:

This journey does not need to be a long or expensive process and the benefits can quickly outweigh costs.

This article was first published in The Data Administration Newsletter