Getting Started with your
Junior Data Analyst Apprenticeship
Welcome to your Junior Data Analyst Apprenticeship with The JGA Group. This page will help you get started with your apprenticeship.
On this page:
Apprenticeship Overview
The Junior Data Analyst apprenticeship programme is an 24-month programme and the standard is made up of 9 core modules. There will also be project work and time allocated for EPA preparation. Seminars are held remotely via Teams or Zoom, supplemented with online learning tools and self-study materials. Progress is recorded via an online tool (OneFile).
It is a requirement of the government that over the course of the apprenticeship you spend at least 20% of your time completing activities which are not part of your day-to-day job role. This is called off-the-job training. If you do not have GCSE/O Level grades A-C/4-9 in English and maths, JGA will provide you with teaching to achieve an equivalent Functional Skills qualification.
Module Summary
- The types, sources and formats of data
- Access and extraction of data and the role of data in a complex digital world
- Describing data in a sales and marketing context
- How data adds value to business and marketing activities
- Data storage methods
- The impact of data protection legislation on storage and distribution of data
- Exploring the ethical use of data
- How to collate and format data in line with industry standards
- Data cleansing and use of tools such as OpenRefine
- Industry trends and use of formatting tools, for example Excel, Access, CRM, Google Analytics, Hubspot
- Test and assess confidence in the data and its integrity
- Presenting data for review and analysis by others, using a range of formats, media and methods of communication
- The importance of collaborative working
- Assessing the different formats and techniques used for communication
- Analysing the different communication needs for internal and external stakeholders/customers
- Explain data and initial thoughts and interpretation
- Discuss and debate different ways of presenting results
- Using database queries to interrogate data
- How interrogation can enable personalised marketing and customer retention
- Blending data sets from multiple sources and presenting in a format appropriate to the objective
- Manipulating and linking data sets
- Using tools and techniques to identify data trends and patterns
- Cleaning data ready for blending and analysis
- Using algorithms to find solutions, solve problems and identify trends and patterns in data
- Automation and its use in data analysis
- Basic statistical methods to identify trends and patterns in data
- Filtering details to the needs of the project and relevance of the data
- Using data modelling to extract relevant data and normalise unstructured data
- Common quality issues that can arise when working with data
- Review different methods of validating data
- Know the importance of taking corrective action
- Apply cross-checking techniques for identifying faults and data results to project requirements
- Conduct data audits
- How to format data for analysis
- Use of tools to communicate results
- Producing clear and consistent technical documentation
- Explaining data results to audiences in a way that aids understanding
- Cleansing data ready for blending, manipulation, interrogation and analysis
- Conducting analysis of data
Your Tutors & Coaches
Explaining the Roles
There are three key roles in the team which will support your apprenticeship. Some members of staff cover more than one of these.
Your coach will meet with you each month to help develop and evidence your skills and behaviours within the workplace. Your line manager will attend part of this session. They will help you gather evidence to demonstrate your overall competency.
Your learner progress adviser will help provide additional support where needed and monitor your progress. You will meet with them, and your line manager, every three months.
Your E-Portfolio: OneFile
We use One File as our e-portfolio system. This is where your assignments will be set, you will submit your work and you will log your off-the-job training.
Your regular reviews will be stored on here as will some resources for your course. You will complete a learning journal, be able to monitor your progress towards your Knowledge, Skills and Behaviours and refer to your workplace training plan.
Our training video will demonstrate all the key features of OneFile you need to know. Ongoing support will also be provided when it is needed.
Mandatory Units
The JGA Group is strongly committed to practices that protect children, young people and adults from the risk of abuse, neglect or significant harm. Staff recognise and accept their responsibility to develop an awareness of the risks and issues involved with Safeguarding.
Therefore, as part of your enrolment process for your apprenticeship, we require you to complete the JGA Safeguarding – ETF Learners Side-by-Side Courses. Which will introduce you to key topics within Safeguarding.
Side-by-Side is a Prevent resource for learners from the Education and Training Foundation.
The modules will cover:
- Radicalisation and Extremism
- Staying Safe Online
- What can you trust?
- British Values
Please create a login and complete the Side-by-Side training.
You will be required to complete the module and assessment (short quiz) for the topics in order for you to unlock your certificate.
When you have achieved all four modules mentioned above, please download your certificates, attach and submit them to your assigned task named: JGA Safeguarding (This task will be assigned to you on OneFile after attending your OneFile training session).
Once your certificates have been checked, you will complete your JGA Safeguarding learning aim and it will appear as 100% completed.
Workplace Training Plan
A Workplace Training Plan is developed with you, your Line Manager and JGA to agree the off-the-job training provided. It will include any specific role related training needs you have to connect with your KSB’s (Knowledge, Skills and Behaviours) and career aspirations.
Delivery to meet the 20% off the job is defined in detail within the workplace training plan. It is a key tool to individualise the apprenticeship to your needs and that of the business.
Programmed Activities
Safeguarding, Prevent, Welfare & British Values
