V Skill HF-D7.3-001 sector-specific 9 kompetenser
Data modelling
Describes data and its relationships in a model with entities, attributes and keys that matches the work process.
Hur hrmforce mäter detta
- Bedömningsmetod
- Work sample test · rho 0.33 (SD 0.09)
- hrmforce instrument
- Knowledge test (client-specific), Work sample test
- Kompetens (50-ramverk)
- Conceptual thinking
- Utbildningsbarhet
- high
- Prognos för efterfrågan 2026–2030
- stable
The candidate performs a representative work sample under standardised conditions.
Beteendeankare
| Nivå | Beteende på denna nivå |
|---|---|
| N1 Guided | Extends an existing data model with new fields following the applicable naming conventions and has the work reviewed. works under supervision and follows instruction · routine, one variable at a time · own task |
| N3 Proficient | Designs a logical data model for a defined domain, normalises where needed and discusses choices with users and developers. sets own approach and seeks input proactively · several variables, some ambiguity · own team or process |
| N5 Leading | Sets the organisation's modelling standards and core data model and decides on deviations from them. sets the standard and the policy · strategic, under high uncertainty · organisation, value chain or profession |
N2 och N4 är medvetet inte förankrade. Bedömarna placerar dem mellan förankringarna, i enlighet med konventionen O*NET.
Grundläggande kompetenser
Dessa kompetenser ärver bedömningsvägen och beteendeankarna för detta konstrukt.
| T | Kompetens | Definition | Prognos för efterfrågan 2026–2030 |
|---|---|---|---|
| V | Drawing an entity relationship diagram ERD · Entity relationship diagram | Draws entities, attributes and relationships with cardinalities in a diagram that recognisably reflects the work process. | stable |
| V | Normalising a data model Normalisation | Splits tables up to third normal form to prevent repetition and contradictory data. | stable |
| V | Defining keys and identification Primary key · Foreign key | Chooses primary and foreign keys, decides between a natural or surrogate key and records uniqueness. | stable |
| V | Designing a star schema Star schema · Dimensional modelling | Designs a fact table with dimensions for reporting and determines granularity and measures per fact. | stable |
| V | Setting up slowly changing dimensions Slowly changing dimensions | Records how history in dimensions is preserved so reports about the past remain correct. | stable |
| V | Distinguishing logical and physical models Logical data model | Develops a conceptual model into a logical and physical model and keeps both aligned. | stable |
| V | Creating a data dictionary Data dictionary | Describes meaning, format, allowed values and source per field so users interpret the data identically. | rising |
| V | Modelling semi structured data JSON schema | Models nested data from json or xml with a schema, mandatory fields and versioning of the structure. | rising |
| V | Validating a data model with users Model validation | Walks through a model with subject experts using examples and adjusts it for exceptions found. | stable |