Our Data Analyst Level 4 apprenticeship develops people to collect, organise and study data to provide business insight. It prepares learners to work across a variety of projects, providing technical data solutions to a range of stakeholders and customers.

Our programme is completely unique, delivered through a leading-edge, innovative approach to challenge-based learning.

This Data Analyst apprenticeship programme is developed using the latest research into effective learning and practical application of skills. Providing a flexible learning journey using online learning, practical exercises, video content, coaching and workshops to enable accelerated and proficient skills development. This apprenticeship programme offers the opportunity for learners to manage learning amongst their other priorities.

To determine whether this programme is suitable for learners you must be able to answer “yes” to the following questions:

  • Are they in a full time Data Analyst role (or another similar role as listed in the overview section? (Data analysis must be their full-time role, not just part of their responsibilities).
  • Will they be using multiple data analysis tools, not just limited to spreadsheets/Excel?
  • Will they be using data visualisation tools to present data?
  • Will they be collecting and compiling data from different sources – e.g. databases, spreadsheets and reports?
  • Will they process, cleanse, analyse (including statistical analysis) and present data on a regular basis?
  • Will they be running ad-hoc and standard data analysis reports and working on/assisting with performance dashboards in their role?
  • Would data mining and forecasting be an integral part of their role?
  • Will they be working on and processing large amounts of data on a regular basis?
  • Are they comfortable looking at detailed and complex information?
  • Do they have strong English and maths skills?

Minimum software requirements:

All the above software is compulsory. Please ensure that it has been installed, and is ready for the learner, ahead of their first day on-programme.

On successful completion of the programme the following qualifications are gained:

  • Data Analyst Level 4 Apprenticeship
  • BCS Level 4 Certificate in Data Analysis Tools
  • BCS Level 4 Certificate in Data Analysis Concepts

Evidencing 20% off-the-job learning

During the programme, learners will be required to spend 20% of work time committed to off-the-job learning. This 20% off-the-job learning is an apprenticeship requirement. It must be completed in working hours. Our programme facilitates off-the-job learning. We blend online learning, on-the-job learning, and classroom training in a seamless way. We are the apprenticeship experts and can advise you on this topic.

The modules in our Data Analyst apprenticeship equip learners with the advanced technical skills they need for their role. Each module develops the core set of skills they must be able to do well to be competent in their role.

Our programme modules follow our challenge-based learning approach, they combine multiple modes of learning (classroom, self-paced, and practical learning). Seamlessly delivered through a ‘blend’ of online and classroom learning events.

Our approach is underpinned by the latest learning theory. Learner-centric approaches (where the focus is on how people learn, rather than which technology to use) have been shown to be more effective in promoting productive learning. The advent of new technology has fundamentally changed the way people create, change, share and interact with information, and the way they interact with each other. Methods are collaborative and hands-on – and so is our programme.

Crucial to our challenge-based approach are the remote module tasks, which require learners to work with their peers, tutors and mentors to learn and come up with a solution to a challenge. The cooperative and applied nature of this type of training makes it perfect for learners of all ages.

This apprenticeship is typically 18 months long. The minimum duration of the practical period is 15 months, and then 3 months for EPA. Some learners may finish their programme in less time if their EPA is completed quickly.

The modules included in this programme are:

Getting Started Modules

Module 1: Data Analysis and Visualisation

Programme Launch

  • Programme outline and structure
  • Your first data analysis activity
  • Assessments, certification and qualifications
  • included
  • Typical workflow
  • Time commitment
  • Calendar planning for the apprenticeship
  • Setting of expectations
  • Introduction of Bud, and other technology requirements

Discover. Practice. Apply.

  • Understanding what does a Data Analyst do?
  • Understanding why data analysis is important?
  • Using powerful tools such as PowerBi and Excel
  • to visualise data for various audiences
  • Understanding statistics, and how to use them to
  • analyse data
  • Presenting data in an effective manner and
  • communicating findings
  • Understanding what a hypothesis is
  • Understanding laws such as GDPR and how they affect their work

Technical Modules

Module 2: SQL and Data Modelling

Learners will:

  • Understand how databases work
  • including database types, relational models and RDBMS characteristics
  • Use SQL Server Management Studio
  • Create new databases
  • Perform database queries
  • Understand Data Modelling and performance of databases

Module duration: 8 weeks

Classroom attendance: 5 days

Module 3: Data Analysis with Python

Learners will understand how to use Python to connect to a data source and use iBid features within it. This will include:

  • Understanding what role Python plays in Data
  • Analysis
  • Using Python data analysis libraries such as NumPy
  • and Pandas
  • Using Python to connect to SQL to run data analysis
  • Perform data extraction, cleaning, manipulation, analysis, and visualisation in Python
  • Understanding statistic concepts such as Regression

Module duration: 8 weeks

Classroom attendance: 5 days

Module 4: Data Architectures

Learners will:

  • Model and implement a basic data warehouse
  • Use skills such as Logical/Physical modelling, SQL data population, primary keys, foreign keys, data drilling, loading data onto tables and table joins.
  • Use a Cloud data model and exploring different cloud platforms
  • Usage of a Hadoop ecosystem

Module duration: 8 weeks

Classroom attendance: 5 days

Module 5: Introduction to Data Science

Learners will:

  • Understand more about hypothesis testing
  • Use R and R Studio for data analysis on various data sets
  • Implement machine learning models
  • Understand Time Series Analysis, General Linear Modelling, Logistic Regression and Clustering
  • Understand characteristics of Big Data
  • Use Cloud tools for Big Data Analysis

Module duration: 8 weeks

Classroom attendance: 5 days

Module 6: Data Analysis Tools and Concepts Assessment

This module will be used as consolidation module for learners to recap and complete the 2 BCS exams required for the Apprenticeships.

Learners will:

  • Recap on previously learnt concepts
  • Attempt the BCS Data Analysis Tools Exam
  • Attempt the BCS Data Analysis Concepts Exam

Module duration: 8 weeks

Classroom attendance: 3 days

Gateway and End-Point Assessment:

Consolidation, preparation and assessment (online)

This final component will get learners ready to go through the ‘gateway’. The apprenticeship gateway is an internal QA process. It will ensure that your learner’s work is ready to be assessed by BCS. This exists to increase their chances of success.

At this pre-gateway stage learners will:

  • Consolidate and submit their portfolio
  • Consolidate and submit their final employer reference
  • Work with a DLC and identify potential real-work case studies to use in their synoptic project
  • Conduct a mock EPA

In addition to the items above, learners must have successfully completed:

  • All the knowledge modules
  • All the BCS exams
  • All the Functional skills exams (except exempted learners)

Once learners have met all the above criteria, they will go through the gateway. When approved, it takes 3 months from gateway to achievement. During this time, learners will:

  • Complete their synoptic project
  • Complete their interview

Duration: 7 days + EPA

Our apprenticeship programmes

This apprenticeship programme is part of a wider offering, ranging from Level 3 apprenticeships all the way to Level 7 Masters degrees.

Our programmes

= Required
= Certification
Average salary: £ *

5 days

Key for bundle contents
= Exam Preparation
= Exam
= Practice Exam
= Exam Voucher
= Tutor Support
= Pre Course Work
*This is based on QA research

Find out more

This part of our site/enquiry form is designed for businesses and people who are already in work. Looking to start your career with an apprenticeship? Click here