COURSE SUMMARY

Our training underpins the knowledge, skills and behaviours required of a successful Data Analyst, including: data architecture, data migration, data manipulation, and presentation. Throughout the programme, you’ll learn to use cutting-edge tools and techniques, helping you maximise the potential of data for your organisation.

This Level 4 apprenticeship is an excellent work-based professional development route for junior data professionals, and is suitable for anyone who works closely with data in their day-to-day role.

Key Responsibilities:

This apprenticeship is suitable for roles that involve the following duties:

  • Collecting, compiling and migrating data from different sources
  • Performing routine statistical analyses and responding to ad-hoc queries
  • Using a range of analytical techniques such as data mining, time series forecasting and modelling techniques to identify patterns and predict trends in data.
  • Assisting with data quality checking and cleansing
  • Summarising and presenting the results of data analysis; making recommendations to stakeholders.

FIND OUT MORE

Level
level-4-icon

HIGHER

Programme Duration
programme-duration-4-icon

18 MONTHS

Training Method
training-method-4-icon

SMART CLASSROOM

CONCEPTS
SKILLS AND COMPETENCIES

Over the course of the apprenticeship we will equip learners with the following skills and competencies:

  • Data Architecture
  • Collecting and Compiling Data
  • Data Migration
  • Data Manipulation
  • Data Analysis Security
  • Data Quality
  • Performing Queries
  • Analytical Tools & Techniques
  • Statistical Analysis
  • Reporting Data
  • Presenting Data
UNIT 1
DATA ANALYSIS CONCEPTS

This module will provide a solid foundation in the core concepts of data analysis. We will cover types of data, the data lifecycle, handling structured and unstructured data, data quality, and core data analysis tasks.

This module is designed to ensure all learners have a firm understanding of the key concepts that we will build upon throughout the programme. This foundation will enable learners to recognise industry best practice, acquire new skills more quickly and apply appropriate data analysis tools and techniques to their current work projects.

This unit is delivered over two separate weeks, via the SMART Classroom, followed by an exam.

UNIT 2
DATA ANALYSIS TOOLS

This module provides a deep dive into data analysis tools and techniques.

We will cover everything from data integration and preparation to programming languages for statistical analysis and making the most of proprietary software tools for data analysis.

Learners will develop their understanding of preparing, processing and manipulating data and conducting analysis projects using industry-standard tools and techniques.

Our hands-on technical training will provide the opportunity to learn, practice, and troubleshoot advanced data analysis techniques.

This unit is delivered over two separate weeks, via the SMART Classroom, followed by an exam.

 

UNIT 3
IMPLEMENTING DATA ANALYSIS CONCEPTS & TOOLS

Taking the theory from the previous training units, course participants will implement what they have learned, applying their new skills to a detailed Data Analysis project. This instructor-led course helps learners to put their theory into practice, refine their technique, and improve their understanding ahead of the Synoptic Project stage of their final assessment.

This unit takes place over one week.

ADDED EXTRA
ADDITIONAL VENDOR QUALIFICATIONS

As an added extra, apprentices can choose to complete one of the following vendor qualifications:

  • Microsoft DP-201: Designing an Azure Data Solution

  • Microsoft DP-100: Designing and Implementing a Data Science Solution on Azure

  • Microsoft DP-200: Implementing an Azure Data Solution

FUNCTIONAL SKILLS
  • Level 2 - Maths
  • Level 2 - English

Learners who require Functional Skills, will be supported via SMART Classroom, support sessions will last half a day each. Exams will be held in a local test centre.

END POINT ASSESSMENT

The End Point Assessment is completed in the last few months of the apprenticeship. It includes an Employer Reference, Summative Portfolio, Synoptic Project and an Interview.

Workplace Curriculum

On this programme, an apprentice is required to evidence the following activities in the workplace:

  • Identify, collect and migrate data to/from a range of internal and external systems
  • Manipulate and link different data sets as required
  • Interpret and apply the organisation’s data and information security standards, policies and procedures to data management activities
  • Collect and compile data from different sources
  • Perform database queries across multiple tables to extract data for analysis
  • Perform routine statistical analyses and ad-hoc queries
  • Use a range of analytical techniques such as data mining, time series forecasting and modelling techniques to identify and predict trends and patterns in data
  • Assist with data quality checking and cleansing
  • Apply the tools and techniques for data analysis, data visualisation and presentation
  • Assist with the production of a range of ad-hoc and standard data analysis reports
  • Summarise and present the results of data analysis to a range of stakeholders making recommendations
  • Works with the organisation's data architecture

Employer Blog:

Catalyst for Change: Meet our North East Engagement Team

Written on: 15th October 2020

Read blog post

Apprentice Blog:

A Career In Data: Q&A with Steve Caughey

Written on: 19th October 2020

Read blog post

GROW YOUR TEAM

If you're an employer looking to grow your team with a tech apprentice, or, if you're looking to join the fastest growing industry in the UK, then speak to our team today.