Skip to main content Skip to sidebar navigation

Data Analyst L4 18mths

Programme Overview
This programme develops your professional skills across
1 accredited unit
through
34 blended sessions.
You will build a portfolio of evidence mapped to all
79 assessment criteria.

1
UNITS
34
SESSIONS
79
ASSESSMENT CRITERIA
92
OTJ TASKS

 
Units Covered
UNIT AI-AUTO
Data Analysis Practitioner Apprenticeship L4
1 Learning Outcome  •  0 Assessment Criteria

 
Programme Structure

1
APPRENTICESHIP ORIENTATION AND EPA OVERVIEW

2
DATA LEGISLATION

3
EXCEL FUNDAMENTALS, EXCEL FORMULAS AND DATA QUALITY

4
PIVOTTABLES, CHARTS AND DASHBOARDS

5
POLICIES, PROCEDURES AND DATA ETHICS

6
PROJECT SCOPING AND CUSTOMER REQUIREMENTS

7
STRUCTURED VS UNSTRUCTURED DATA

8
DATABASE DESIGN AND DATA MODELLING

9
SQL QUERIES AND FILTERING

10
SQL JOINS, AGGREGATIONS AND COMBINING DATA

11
ORGANISATIONAL DATA ARCHITECTURE AND CLOUD DATABASES

12
SQL CONSOLIDATION AND PORTFOLIO WORKSHOP

13
DATA QUALITY AND CLASSIFICATION

14
COMBINING AND PREPARING DATA

15
POWER BI FUNDAMENTALS

16
DATA MODELLING AND DAX IN POWER BI

17
DASHBOARD DESIGN AND VISUAL STORYTELLING

18
PORTFOLIO WORKSHOP: POWER BI AND INTEGRATION EVIDENCE

19
TABLEAU FUNDAMENTALS AND VISUAL ANALYTICS

20
COMPARING VISUALISATION APPROACHES

21
USER EXPERIENCE AND DOMAIN CONTEXT

22
CUSTOMER REQUIREMENTS AND STAKEHOLDER COMMUNICATION

23
WORKING INDEPENDENTLY AND COLLABORATIVELY

24
PORTFOLIO WORKSHOP: UX AND STAKEHOLDER EVIDENCE

25
DESCRIPTIVE STATISTICS AND PROBABILITY

26
HYPOTHESIS TESTING AND EXPERIMENTATION

27
DESCRIPTIVE, PREDICTIVE AND PRESCRIPTIVE ANALYTICS

28
PYTHON AND JUPYTER NOTEBOOK FUNDAMENTALS

29
DATA VISUALISATION AND MODELLING IN PYTHON

30
PORTFOLIO WORKSHOP: STATISTICS AND PREDICTIVE ANALYTICS

31
CHALLENGES, ADAPTABILITY AND ROOT CAUSE ANALYSIS

32
PROJECT REPORT AND PRESENTATION WORKSHOP

33
MOCK PROFESSIONAL DISCUSSION AND EPA PREPARATION

34
PROGRESS REVIEW 6 AND FINAL GATEWAY READINESS (MONTH 18)

 
What You Will Achieve
✓
Demonstrate competence across all KSBs

 
How This Programme Works
Blended Learning
Mix of tutor-led sessions and guided online learning activities
Evidence Portfolio
Submit written evidence for each criterion through topic quizzes
Assessor Feedback
Your assessor reviews every submission with individual written feedback
Accredited Outcome
Successful completion leads to your recognised qualification certificate

Build Professional Data & Analytics Skills
Develop practical skills across Excel, SQL, Power BI, Tableau, statistics,
Python, data modelling, visualisation and predictive analytics while building
a portfolio of workplace evidence throughout your apprenticeship.

Course Content

1 of 2
Not Enrolled
This course is currently closed

Course Includes

  • 34 -
  • 65 Topics
  • 92 Modules
Tooltip Text