Data Analytics & AI
Develop the skills needed to turn complex data into clear, actionable insights that support business decision-making.
~15 months
Level 4 Data Analyst
£15,000
What you’ll be able to do
Tools you'll learn
Curriculum
7 Modules · 15 Sprints01Module 1: Data Foundations3 sprints
01Module 1: Data Foundations3 sprints
Sprint 1: Structured Approach to Data Analytics
Build a strong foundation in how data analytics works by exploring key principles, analytical workflows, essential tools, AI applications and introductory statistical concepts.
Sprint 2: Utilising Spreadsheets for Data Analytics
Develop practical skills in Google Sheets or Excel by creating charts and tables, cleaning data and applying analytical techniques to uncover insights.
Sprint 3: SQL and Databases
Get introduced to SQL across platforms such as BigQuery or Azure, gaining confidence with SQL fundamentals, core logic and relational database structures.
02Module 2: Programming & Data Processing2 sprints
02Module 2: Programming & Data Processing2 sprints
Sprint 1: First Steps in Programming
Develop essential programming skills by working with variables, functions, loops, conditionals and data structures, and combining these elements into structured programmes.
Sprint 2: Data Processing with Pandas
Apply Python to real datasets by working with files, using Pandas for exploratory analysis and completing a project that reinforces practical data-processing skills.
03Module 3: Data Visualisation2 sprints
03Module 3: Data Visualisation2 sprints
Sprint 1: Visualising Data Using BI Tools
Create dashboards in Tableau or Power BI by connecting datasets, adding interactive elements and using visual storytelling to communicate insights effectively.
Sprint 2: Data Visualisation with Python
Create visualisations using Python, progressing from basic to intermediate charting, applying data cleaning and completing a practical analysis project.
04Module 4: Main Analysis Types1 sprint
04Module 4: Main Analysis Types1 sprint
Sprint 1: Probability, Statistical Inference, Hypothesis Testing and A/B Testing
Move from descriptive to inferential statistics by applying probability, hypothesis testing and A/B testing to support evidence-based decision making.
05Optional Module: Other Analysis Types – Part IOptional · 1 sprint
05Optional Module: Other Analysis Types – Part IOptional · 1 sprint
This optional module lets learners extend into predictive modelling, building regression and classification models to support forecasting and decision-making.
Sprint 1: Machine Learning
Build regression and classification models with scikit-learn and statsmodels to support predictive analysis.
06Optional Module: Other Analysis Types – Part II: Customer AnalyticsOptional · 3 sprints
06Optional Module: Other Analysis Types – Part II: Customer AnalyticsOptional · 3 sprints
The optional modules give learners the chance to extend their analytical skills beyond the core programme, covering areas such as cohort analysis, retention and churn, funnel analysis, customer segmentation and Customer Lifetime Value. These modules allow organisations to carry out more detailed analysis and explore their data in greater depth.
Sprint 1: Retention, Cohorts and Churn
Use cohort analysis to understand customer behaviour and measure retention and churn.
Sprint 2: Funnels
Analyse conversion journeys to identify drop-off points and optimisation opportunities.
Sprint 3: CLV, Customer Segmentation and RFM
Group customers by shared characteristics, then work out their Customer Lifetime Value and RFM scores to understand long-term customer value.
07End Point Assessment (EPA)3 months · 3 topics
07End Point Assessment (EPA)3 months · 3 topics
When the employer, the learner and the Personal Tutor all agree that the learner is ready, they pass through ‘Gateway’. This means the training is completed and the learner registers for their End Point Assessment (EPA). The EPA consists of: - A professional discussion, underpinned by a portfolio of evidence - Scenario Demonstrations with questioning - Learners will be observed by an independent end point assessor completing two scenario demonstrations which will be supplemented by questioning.
Professional discussion with portfolio of evidence
Scenario Demonstrations with questioning
Level 4 Data Analyst Apprenticeship Certificate