D.Modelling

Owned by Graham Kennedy
Last updated: Sept 07, 2022
2 min read

Data modeling is the process of creating a visual representation of either a whole information system or parts of it to communicate connections between data points and structures.
Data modelling focuses on logical representation of the enterprise's data in the form of a model. This model entails the business concepts, how they are related to each other, and it defines rules, default values and naming conventions.

Attribute Name

Description

SFIA Skills

Attribute Name

Description

SFIA Skills

D.Modelling - Lvl 1

Consultant on this level has a basic understanding of DM process and can describe different DM levels:

  • Conceptual Data Model

  • Logical Data Model

  • Physical Data Model
    Able to formulate definitions of what is entity, relationship and ER diagram.

DTAN

VD.Modelling - Lvl 2

Consultant on this level has a basic understanding of relational modeling and data normalization, able to describe its benefits and draw-backs, as well as common use cases.
Comfortable with 3NF and familiar with at least one data modeling tool.

DTAN

D.Modelling - Lvl 3

Consultant on this level can easily define key differences between OLAP and OLTP systems and can clearly articulate the purpose each of them. Familiar with basics of OLAP modelling techniques and confident with OLTP modeling techniques.

DTAN

D.Modelling - Lvl 4

Consultant on this level is comfortable with Kimball's Dimensional Modelling principles, able to model data marts for certain parts of the business and in some cases design data models across multiple subject areas. Comfortable working independently or a part of the team.

DTAN

D.Modelling - Lvl 5

Consultant on this level is comfortable with Inmon's DataWarehousing and/or Data Vault modeling techniques, holds respective certification or has substantial equivalent experience. Able to drive conversation with Customer and present solution to the audience of specialists.
Comfortable working independently or leading the team.

DTAN

D.Modelling - Lvl 6

Consultant on this level is able to design enterprise-wide data models for data warehouses and/or applications. Can clearly communicate with the team of data specialists as well as broader audience.
Comfortable working independently or leading large internal or external team.

DTAN

 

 

Â