V Skill HF-D7.2-001 cross-sector 13 skills
Data analysis
Prepares and analyses data sets to find patterns, relationships and outliers and connects the outcomes to the original question.
How hrmforce measures this
- Assessment method
- Work sample test · rho 0.33 (SD 0.09)
- hrmforce instrument
- Ability Scan, Work sample test
- Competency (50-framework)
- Problem Analysis
- Trainability
- high
- Demand outlook 2026 to 2030
- rising
The candidate performs a representative work sample under standardised conditions.
Behavioural anchors
| Level | Behaviour at this level |
|---|---|
| N1 Guided | Carries out a predefined analysis step on a supplied data set and records the outcome in the agreed format. works under supervision and follows instruction · routine, one variable at a time · own task |
| N3 Proficient | Selects analysis methods for an open question, turns raw data into a working file and supports every conclusion with figures. sets own approach and seeks input proactively · several variables, some ambiguity · own team or process |
| N5 Leading | Sets the organisation's analysis standards, reviews the analyses of others and establishes new analysis methods in the profession. sets the standard and the policy · strategic, under high uncertainty · organisation, value chain or profession |
N2 and N4 are deliberately not anchored. Raters place them between the anchors, following the O*NET convention.
Underlying skills
These skills inherit the assessment route and the behavioural anchors of this construct.
| T | Skill | Definition | Demand outlook 2026 to 2030 |
|---|---|---|---|
| V | Building pivot tables Pivot tables | Summarises large data lists in pivot tables with rows, columns and calculated fields and checks the totals. | stable |
| T | Power Query Power Query | Retrieves data from multiple sources and reshapes it in Power Query as a repeatable cleaning step. | stable |
| T | Writing DAX formulas DAX | Writes measures and calculated columns in DAX and checks that filter context produces the intended figure. | stable |
| V | Writing SQL queries SQL · SQL queries | Queries a database with selections, joins, groupings and subqueries and checks the result on record counts. | stable |
| V | Performing data cleaning Data cleaning | Makes a raw file ready for analysis by aligning formats, removing duplicates and handling missing values. | declining |
| V | Applying regression analysis Regression analysis | Estimates the relationship between predictors and an outcome with regression and assesses assumptions, model and explained variance. | rising |
| V | Cohort analysis Cohort analysis | Follows groups that entered at the same moment over time and compares their retention or behaviour. | rising |
| V | A/B test analysis A/B testing | Analyses the outcome of a controlled experiment with two variants and determines whether the difference is meaningful. | rising |
| V | Time series analysis Time series analysis | Analyses measurements over time for trend, seasonality and level shifts and produces a forecast from them. | rising |
| V | Outlier detection Outlier detection · Anomaly detection | Detects values that deviate strongly from the rest, investigates the cause and decides on removal or retention. | rising |
| V | Cluster analysis and segmentation Clustering · Segmentation | Groups records based on similarity of attributes and describes the resulting segments in understandable terms. | rising |
| T | pandas pandas | Manipulates and analyses tabular data in Python with pandas through filtering, grouping, merging and derived columns. | rising |
| T | R for statistical analysis R | Runs statistical analyses and graphics in R with scripts that are reproducible for colleagues. | stable |