b

Data Analyst

Course details

Level

shield with tick

Level 4

Duration

calendar

15 months

One-to-one support

handshake

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

Delivery of programme

Phase one

Pre-Induction

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.

Induction

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

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 two

Modules

What you will learn

  • Introduction to Power BI Software

What you will learn

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

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

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

What you will learn

Part 1

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

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

What you will learn

In-database Analytics:

  • Analytics for unstructured data
  • Mapreduce and Hadoop
  • Hadoop Ecosystem
  • Advanced SQL and MadLib for in-database analytics

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

What you will learn

  • Structural equation modelling
  • Item response theory
People icon

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.

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.

20 percent pie chart

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 three

Assessment Gateway, preparation & administration week

The Gateway week is used to finetune your skills and offer a simulated Synoptic Project for systems familiarisation, and to ensure that your Summative Portfolio and Employer Reference are completed before entering into EPA.

Phase four

End Point Assessment

Learners are assessed by an End Point Assessment Organisation, chosen by the Employer. Included in EPA is Evidence Submission (portfolio & certificates), Employer Reference, Synoptic Project and an Interview.
The Independent Assessor will feedback the results (Pass, Merit or Distinction) and the ESFA will provide your certificate.

Learners who also chose Data Analyst...

Callum Mullins is December’s Learner of the Month

Gurdeep Sur is May’s Learner of the Month

Irslan Ahmed is October’s Learner of the Month

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 univeristies 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.

Current vacancies

Get in touch!

Call our team on 01133 500 333 or fill out our enquiry form below