I am an Employer

looking to upskill or develop ambitious learners


I want to learn a new skill

and become an apprentice for a fantastic company

Get Hired

Data Analyst


Level 4


17 months

One-to-one support:

Every 4 weeks

You will achieve:

Level 4 Data Analyst BCS

Common job roles

  • Data Analyst
  • Data Manager
  • Data Scientist

Roles you may progress into

  • Product Manager
  • Business Analyst
  • Data Engineer

Programme delivery

Phase 1



Before your induction, a member of Estio’s Apprenticeship Onboarding team will contact you and your employer representative to discuss your job role and the apprenticeship standard. During this initial consultation, you will also begin your personalised Vocational Scorecard, which assesses your current skill levels against the apprenticeship standard.

The scorecard ensures we fully understand your starting point, so that we can work with your employer to develop an individual learning plan that is tailored to your needs, and gives you the best opportunity to achieve at the highest level.



Your induction will take place within the first two weeks of starting your employment and will be facilitated by the Onboarding team at your nearest Estio training centre. You will go through an overview of your chosen apprenticeship programme and be given details of what dedicated support is in place for you throughout your learning journey. In addition, you will receive login details for our Virtual Learning Environment, which you will use to complete both mandatory and optional training modules as part of your programme. Any outstanding diagnostic assessments and enrolment documents will be completed, and you can ask any last questions you may have before you formally begin your training.

Functional skills

Functional skills

We use BKSB tests to determine your current level of knowledge, to assess if you need further support with English and/or Maths.

If you do, our Functional Skills Training team will work with you to supply these skills. You will be supported through remote training sessions and workshops, which run for 3 days (for each).

Once you feel comfortable, you can sit the Level 2 Maths and/or English exams. These qualifications are equivalent to an A* – C (4-9) grade at GCSE, they are fully certified by City & Guilds and can be used to further enhance your CV and skillset.

Phase 2


Introduction to Power BI

What you will learn

  • Introduction to Power BI Software
Foundation Maths

What you will learn

  • Essential mathematics skills to reach a minimum required standard for data analysis
Data Analyst Concepts

What you will learn

  • Types of data
  • Structured and unstructured data
  • Introduction to Big Data
  • The data life cycle
  • Requirements for data analysis
  • Compliance & audit considerations
  • Data architecture
  • Data structures
  • Database design, implementing and maintenance
  • Good quality data
  • DA process life cycle and tasks
  • Domain context for DA
Data Analysis Tools

What you will learn

Part 1

  • Processes and tools used for data integration, including purpose and outputs
  • Unifying data from multiple sources
  • Applying SQL to data integration
  • Data qualify and preparing for analysis

Part 2

  • Nature and challenges of data volumes
  • How a programming approach can help
  • Understanding testing requirements

Part 3

  • Industry standard tools and methods for data analysis
  • Statistical programming languages
  • Capabilities and functions of languages
  • R, Python, SQL, Excel
  • How statistical programming languages are used in preparing data for analysis and within analysis projects
Advanced Analytics, Theory and Methods

What you will learn

Part 1

  • Exploratory DA – visualisation tools
  • Hypothesis Testing
  • Student’s and Welch’s T-Test
  • Wilcoxon test

Unsupervised Methods

  • K-Means Clustering
  • Association Rules

Supervised Methods

  • Linear Regression
  • Logistical Regression

Part 2

  • Classification
  • Decision trees
  • Naive Bayes classifier
  • Time Series analysis
  • Text analysis
Advanced Analytics, Technologies and Tools

What you will learn

In-database Analytics:

  • Analytics for unstructured data
  • Mapreduce and Hadoop
  • Hadoop Ecosystem
  • Advanced SQL and MadLib for in-database analytics
Python for Data Science (Optional)

What you will learn

  • Using Python for data science and machine learning
  • Implementing machine learning algorithms
  • Pandas for data analysis
  • Seaborn for statistical plots
  • SciKit-Learn for machine learning
  • Random forrest and decision trees
  • Neural networks
  • Spark for Big Data
  • NumPy for numerical data
  • Matplotlib for Python plotting
  • Plotly for interactive dynamic visualisations
  • Natural language processing
Statistical Analysis Methods (Optional)

What you will learn

  • Structural equation modelling
  • Item response theory
One-to-one support

One-to-one support

You will have a Technical Specialist and a Progress Management Co-ordinator (PMC) assigned to support you throughout your apprenticeship.

Your PMC will contact you every 4 weeks to discuss your progress made to date, check you’re understanding your training modules, and support you with gathering evidence for your portfolio. Every 12 weeks a review meeting will take place between you, your employer representative and your PMC to assess how your new learning and skills development is being applied in your job role and its impact on your wider industry skills.

The Technical Specialist will work with you to develop your portfolio of evidence for End Point Assessment, and with your employer representative to agree the various workplace projects you will be required to undertake. They will also support your employer representative to complete your Employer Reference, a document which highlights key behaviours you have demonstrated for the final assessment as part of the End Point Assessment.

In every one-to-one session, we will agree actions and SMART targets for you to complete, so that you can progress confidently and with the right support.

Your portfolio

Your portfolio

Throughout the apprenticeship, you will contribute evidence towards your online e-portfolio. We use e-portfolios as they are accessible from anywhere, and enable you to track your progress throughout your apprenticeship.

You’ll have access to your personal dashboard, which shows you a number of key milestones and deadlines coming up, such as the training you have completed, work that is due, and any gaps in your portfolio of evidence.

Your Technical Specialist and Progress Management Co-ordinator will be available to contact at any point throughout the apprenticeship and will advise you how to provide the best evidence.

Off-the-job training

Off-the-job training

Off-the-job (OTJ) training is comprised of, but not limited to activities such as: training with Estio, shadowing, journal entries and projects for e-portfolio. Completed within working hours as agreed with the employer but average at 6 hours per week (20% of your time on your apprenticeship).

You can track your OTJ progress on your e-portfolio.

Phase 3

Assessment Gateway, preparation & administration week

Assessment Gateway, preparation & administration week

Dedicated one-to-one sessions to support the learner as they head towards assessment, putting them in the best possible position for achievement.

Phase 4

End Point Assessment

End Point Assessment

You will be assessed by an End Point Assessment Organisation chosen by your employer. EPA can take up to 3-4 months to complete. This involves a professional discussion underpinned by a portfolio and a project presentation and Q&A.

The Independent Assessor will feedback the results (Pass, Merit or Distinction) and the ESFA will provide your certificate.

Where can this apprenticeship take me?

The Level 4 Data Analyst apprenticeship will give you the skills and experience to work effectively in roles such as Data Analyst, Data Manager, Data Scientist, Data Modeller, Data Architect, or Data Engineer.

After achieving a recommended minimum of 1 years experience within your role after completion (this is subject to employers) you can begin a Level 6 Data Scientist apprenticeship.

Level 6 Data Scientist roles

Data Scientist, Informatics, Data Engineer

More information about this apprenticeship can be found on the institute for apprenticeships website.

University study

Level 4 apprenticeships are the equivalent to a foundation degree. If you wish to study further whilst staying in work, some universities will offer the ability to learn remotely. If you wish to take a break from work, you may need to apply for a student loan whilst you study.