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:

  • Level 3 Qualification in ICT or a similar subject + at-least 12 months of work experience* & Robust On-boarding plan (learner must work in the organisation for 3 months before sign up)
  • OR 2x A Levels (including Maths or ICT)
  • OR Non Business related Degree + at-least 6 months of work experience*
  • OR Existing Staff member with 2+ years of work experience**

PLUS

  • GCSE English and Maths at grade 4 (C) or above
  • Learners should not be entered for a qualification of the same type, content and level as that of a qualification they already hold.

*Work experience relates to any valid work experience

**Existing staff work experience should not be in Data Analyst role. The minimum of 2 years must include working in an environment that requires some kind of analysis. This would include creation of reports and usage of spreadsheets. Career changers would be coming in from diverse experience backgrounds. The candidate should typically be keen on working with numbers, processing and articulating data and information.

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:

  • Tableau Public – download here – current version 2021.1.x
  • Power BI Desktop – download here – current version 2.x
  • UMLet (free VISIO alternative) – download here - current version 14.3.
  • SQL Server– download here – current version 2019 Express Edition
  • SQL Server Management Studio – download here – current version 18.x
  • Visual Studio Community Edition – download here – The Python and R options should be added
  • The latest Python – download here

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

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 17 months long. The minimum duration of the practical period is 14 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: Principles of Data

  • Programme Launch
  • Live virtual session to commence learning
  • Discover and Practice, linking the apprenticeship to the workplace
  • Apply, demonstrating the learner’s knowledge of their workplace and personal development planning for the programme and generating portfolio evidence

Discover. Practise. Apply.

Discover the principles of all things Data Analyst.

This module provides learners with fundamental knowledge on legislation, security and ethics alongside understanding core data theory including the principles of data, types of data and data lifecycles.

This module enables learners to develop their understanding of data principles and builds the foundations for the following modules.

  • Legislation, security and ethics
  • The data lifecycle
  • Structured and unstructured data
  • Data tools

Live Session: 0 Days

Module Duration: 4 Weeks

Technical Modules

Module 2: Data Architecture & Cloud

This module progresses on to core concepts of data architecture and cloud technologies.

Topics covered in this module include Data Warehousing, Business Intelligence, Big Data and Cloud architectures.

Discover Activities for this module:

  • Introduction to Data Architectures
  • What is Cloud Computing?
  • Data Flows in Azure
  • Databricks and Data Lake Storage
  • Data Warehouses with SQL
  • Data Warehouses with PowerBI
  • Creating Tables in SSIS
  • Privacy by Design

Live Session: 5 Days

Module Duration: 10 Weeks

Module 3: Customer Focus & UX

This module focuses on user experience, understanding customer requirements and risk management.

This module will enable learners to appreciate who their users are and understand the ‘why’ behind their data analysis roles.

Discover Activities for this module:

  • Introduction to UX
  • UX and the Data Analyst
  • Persona Mapping
  • User Journey Mapping
  • Creating User Stories
  • Requirement Engineering
  • Stakeholder Mapping
  • Quality of Data in UX
  • Risk Management

Live Session: 2 Days

Module Duration: 10 Weeks

Module 4: Data Modelling & Machine Learning

This module introduces learners to databases, working with SQL, Data Modelling and the fundamentals of Machine Learning.

Discover Activities for this module:

  • Data Modelling Types (Conceptual, Logical and Physical)
  • Data Models and Business Requirements
  • Applying Normalization Techniques
  • Modelling for OLAP and BI/DW Including the star schema
  • SQL Language – CRUD
  • Analytical Techniques (Probability, Statistical Distributions, Inferential Statistics, Inference for Numerical Data and Inference for Categorical Data)
  • Machine Learning Algorithms and Methodologies

Live Session: 3 Days

Module Duration: 10 Weeks

Module 5: Data Manipulation & Visualisation

This module explores accessing and manipulating data from different sources, and how to visualise and present data to stakeholders.

Discover Activities for this module:

  • Populations and Sampling
  • Hypothesis Testing
  • Introduction to Data Analysis in Excel
  • Charts and Visualisations in Excel
  • Hypothesis Testing by Simulation in Excel
  • Analysing for a Hypothesis
  • Importing Excel into Power BI
  • Conditional Logic in Power BI
  • Relationships in Power BI
  • Visualisations in Power BI

Live Session: 3 Days

Module Duration: 10 Weeks

Module 6: Data Analysis & Statistics

The Data Analysis and Statistics module progresses learning to explore analytical techniques, methods and statistical analysis methodologies.

Learners are also introduced to the programming languages, Python and R. Learners who wish to expand their knowledge of Python and R can access a range of optional learning courses on Cloud Academy.

Discover Activities for this module:

  • Data Analysis Techniques
  • Introduction to Statistics
  • Statistical Methodologies (Descriptive and Inferential)
  • Correlation Coefficient
  • Linear and non-linear regression
  • SLR and MLR
  • Data Analysis with Power BI
  • Statistical Analysis with Power BI
  • Fundamentals of R
  • Fundamentals of Python
  • Statistics in Python
  • Statistics in R

Live Session: 5 Days

Module Duration: 10 Weeks

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 the EPAO. This exists to increase their chances of success.

At this pre-gateway stage learners will:

  • Consolidate and submit their portfolio
  • Throughout the program apprentices have completed mock professional discussions to prepare them for the EPA process

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

  • KSB’s have been clearly evidenced
  • 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 up to 3 months from gateway to achievement. During this time, learners will:

  • Complete their professional discussions, which is underpinned by their portfolio
  • Complete their project and presentation with questioning

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 guide

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