Data modelling, cleansing and enrichment

Citerad från UK GDaD PCF.

Nivåer

1. Medvetenhet

You can:

• show an awareness of different data models and tools, and understand when they could be used
• show an awareness of industry-recognised data modelling patterns and standards

2. Tillämpande

You can:

• produce data models and understand where to use different types of data models
• understand different tools and can compare different data models
• reverse-engineer a data model from a live system
• understand industry-recognised data modelling patterns and standards

3. Erfaren

You can:

• build and review complex data models, ensuring adherence to standards
• use data integration tools and languages to integrate and store data, and advise teams on best practice
• ensure data for analysis meets data quality standards and is interoperable with other data sets, enabling reuse
• work with other data professionals to improve modelling and integration patterns and standards

4. Expert

You can:

• understand different ways to model data to maximise its use and value
• ensure data is modelled appropriately, and modelling standards exist and are complied with
• understand a number of data integration tools and patterns, and ensure your teams have the support and training needed to use the most appropriate methods
• build relationships with other senior data professionals (in fields such as data architecture, data engineering and data science) to share best practice and continually improve data modelling and integration processes and standards

Contains public sector information from the UK Government Digital and Data Profession Capability Framework (https://understand-digital-data-roles-skills.service.gov.uk/), licensed under the Open Government Licence v3.0. © Crown copyright.

Närmaste ESCO-färdigheter

• create data models (nära träff)
• perform data cleansing (snäv träff)
• normalise data (snäv träff)

Contains ESCO v1.2.1 data (https://esco.ec.europa.eu/). © European Union. Reuse authorised under Commission Decision 2011/833/EU.

Rollnivåer som förväntar sig den här färdigheten