Overview

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.

Read more

Prerequisites

Entry requirements:

  • GCSE English and Maths at grade C or above AND,
  • 2x A Levels (1 including Maths, Economics or ICT) OR,
  • An International Baccalaureate at Level 3 in ICT OR,
  • A Level 3 apprenticeship in a similar subject OR,
  • A BTEC Extended Diploma in IT (180 credits)

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.

Read more

Learning Outcomes

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.

Read more

Outline

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

Read more

Why choose a QA apprenticeship

  • 91% of QA apprentices go straight into full-time jobs
  • 2.1 million jobs in the digital economy
  • £42,578 average skilled digital salary

Programme handout

Download the latest information about this QA apprenticeship programme.

Download

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

Frequently asked questions

How do apprenticeships work?

You’ll spend most of the time working (80% in fact). You’ll complete work projects – doing all the things you’re learning, right away on the job. The rest of the time, you’ll be learning. In lots of different ways.

You can take your career and knowledge progression as far as you want to go with our apprenticeships – even up to gaining a Master's degree.

Who can do an apprenticeship?

For most apprenticeships, you need to be aged 16 and over, be eligible to live and work in the UK and have three to five GCSEs.

Maths and English are important skills for any career, so you’ll need to have them under your belt. Here’s where it gets a bit technical. You’ll need to (at least) have Functional Skills qualifications at Level 2 in Maths and English. Don’t worry, we’ll check your qualifications for you when you apply and explain.

But, even if you don’t have them yet – all is not lost. You can complete them during your QA apprenticeship.

Each apprenticeship has different entry requirements. Check the one you’re interested in to see if you’re a match.

Who will support me on my apprenticeship?

You'll have a whole team behind you. We'll help you get the most out of your apprenticeship.

  • Skills coach
  • Classroom tutors
  • Your line manager
  • Learner services team
  • Safeguarding

What will happen after I apply?

We’ll get in touch if it looks like you’re a match for the apprenticeship job. First, we’ll call to get to know you better. Tell us what you’re about, what your goals are. We’ll also get your details.

You’ll get a link to upload some important documents – to check you can do the apprenticeship you’ve applied for. (proof of right to work in the UK, your qualifications etc.) Don’t worry, it won’t take long.

When we have these, we’ll call on WhatsApp to check your ID.

Next, you’ll get a link to complete your profile. This bit is important – your profile is your opportunity to tell potential employers a bit about you. Your skills. Your passion. Why you want this apprenticeship.

We’ll keep in touch about the apprenticeship job you applied for. If any others come up that we think you’d like, we’ll let you know. If you’re keen, we’ll help you prep and we’ll set up that interview.

If all goes well…you’ll get the job. Then you just need to start planning for your first day. Hey presto.

If you’re applying for a job with one of our larger employers, you might be invited to an assessment day – or they might have other special steps to take. Don’t worry, we’ll give you all the details.

Contact Us

Please complete this form and we'll be in touch