Data Analyst Apprenticeship
Your future career, after completion
Advance by Analytics
What is Advance by Analytics?
We’ve re-imagined our data & analyst apprenticeship programmes, thinking bigger, and using the apprenticeship opportunity to deliver change. We have added new features, new team members, new tools, optional qualifications, and real-world insight that allows apprentices to drive your data & analytics vision and be at the heart of your organisation’s journey towards superior performance.
The programmes are based on existing, fundable apprenticeship standards but have been enhanced, and can now be tailored to include 3rd party vendor qualifications, workshops, private events with insight and updates from our analytics specialists.
Interested in becoming a Data Analyst apprentice? Find all the information you need below…
Data Analyst| Quick links
- What is the role of a Data Analyst Apprentice with PowerBI?
- What's the cost & will I be paid?
- What are the entry requirements?
- What technical knowledge will I learn?
- What qualifications will I gain?
- What skills will I develop?
- What is included in the Data Analyst apprenticeship with PowerBI?
- What happens after completion?
What is the role of a Data Analyst apprentice with PowerBI?
This apprenticeship’s core occupational deliverables include, but are not limited to: requirement-gathering and inspecting, cleansing, transforming and modelling data. Apprentices will be provided with support to develop their behaviours and attitudes to succeed in an evolving workplace environment.
If you like analysing and managing data then the Data Analyst apprenticeship could be for you. The roles you might expect to be applying for after your 15-18 month Data Analyst apprenticeship are Data Analyst, Data Manager, Data Scientist, Data Modeller, Data Architect, Data Engineer and many others.
Virtual classroom training
It is a statutory requirement that 20% of an apprentice’s working hours are allocated to training. A proportion of this time will be spent attending training workshops, with the rest made up by independent learning, guided distance learning and tutor sessions in the workplace. For Data Analyst Level 4 apprentices, relevant training workshops will be placed between the apprentice and their mentor & tutor, according to individual needs. Workshops will be delivered virtually by Zoom or Microsoft Teams and will be delivered on the following topics:
Workshop 1
Data-driven culture
Duration: Monday – Thursday 9.30am – 4.30pm
- Data sources
- Data collection
- Data normalisation
- Data visualisation & analysis
- Data driven decision
- Data in the process model
Workshop 2
Managing data with SQL
Duration: Monday – Thursday 9.30am – 4.30pm
- Understanding databases
- Regulations
- Developing knowledge of performing queries
- Data cleansing
Workshop 3
Excel & PowerBI data analytics
Duration: Monday – Thursday 9.30am – 4.30pm
- Learning Excel foundations
- Statistics with Excel
- Acquiring knowledge of data mining
- Predictive analytics
- Advanced analytics with Excel
- PowerPivot
- PowerQuery
- Data visualisation & analysis
- PowerBI Foundations
- PowerBI Data Visualisation
Workshop 4
Programming languages and data storytelling
Duration: Monday – Thursday 9.30am – 4.30pm
- Presenting results
- Summarising insights
- Driving change
- Deployment
- Python Foundations
- R Foundations
Optional workshop for PowerBI qualification
- 2 days
- Additional fee applies
- Certified Microsoft Data Analyst Associate
- More information about the Certified Microsoft Data Analyst Associate
Mentors
- Previous roles in managing databases, strategic planning with data, business intelligence, data warehousing experience
- Tools required from the employer
- MySQL/SQL, latest Microsoft Excel, PowerBI or Tableau
As a Data Analyst apprentice, you will NOT pay anything towards your apprenticeship.
You can find out more about your investment and wages here >>
Entry requirements to become a Data Analyst apprentice
Individual employers will set the selection criteria.
Apprentices must have:
- The right to work in the UK
- Lived in the UK continuously for the past 3 years
- GCSE English and maths at grade 4 or above (or equivalent)
- Relevant qualifications and or work experience at a lower level
- A demonstratable enthusiasm to work as a Data Analyst-NowSkills
requires that apprentices provide work or evidence that shows that they are
passionate about all things data analysis
Having a passion for IT will help Data Analyst apprentices gain the most out of their apprenticeship programme.
OUR ACCREDITATION PARTNERS
What technical knowledge will I learn as an Data Analyst apprentice with PowerBI?
- Be able to undertake the following in line with organisational procedures and under supervision
- 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 organisations data and also information security standards, policies, and procedures for 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 also ad-hoc queries
- Use a range of analytical techniques such as data mining, time series forecasting and modelling techniques to identify and also predict trends and patterns in data
- Assist production of performance dashboards and reports
- Assist with data quality checking and also 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
What qualifications will I gain?
- Level 4 Data Analyst Apprenticeship, awarded by the Institute for Apprenticeships and Technical Education
What skills will I develop?
- Logical and creative thinking skills
- Analytical and problem-solving skills
- Ability to work independently and to take responsibility
- Using own initiative
- Taking a thorough and organised approach
- Ability to work with a range of internal and external people
- Ability to communicate effectively in a variety of situations
- Maintaining a productive, professional, and a secure working environment
We are proud to work with the following employers:
Your future earning potential as a Data Analyst:
What's included in the Data Analyst apprenticeship with PowerBI?
Included: Induction
Within the first month, all apprentices and employers will receive a thorough induction to the apprenticeship training program from a dedicated NowSkills tutor. This will involve:
- “Workplace Health, Safety & Wellbeing Assessment”,
- Completion of enrolment documentation
- The signing of the “Commitment Statement” and an “Apprenticeship Agreement”.
- The completion of initial assessments/diagnostics for English and maths
- Agreeing the Professional Development Plan (POP), which will detail: The sequencing and content of learning key milestones (for submitting portfolio evidence, exams etc.)
- Details of how to access any online learning platforms arrangements for safeguarding
- Inductions usually take a working day to complete dependent on the individual apprentice and employer
Included: Ongoing Professional Development
Apprentices will be guided by a NowSkills tutor and their workplace mentor, throughout the duration of the infrastructure technician apprenticeship. For a level 3 apprentice this must equate to 1/2 a working day for every week they aren’t attending training in centre, and will likely consist of:
- Mentoring sessions with the nominated employer mentor
- Training in the workplace, relevant to the standard
- Producing/collating evidence for the apprentice’s summerative portfolio
- Work shadowing
- Industry visits
- Attendance at competitions
- Online learning
- Studying or researching
Included: Tutor 1:1s
These take place monthly, either at the workplace or live online with the tutor. The will involve:
- Coaching sessions, in areas of training need agreed with the tutor
- Professional Development Reviews (PDRs), which employers must partake in. These allow for a meaningful discussion between all 3x parties about the apprentice’s achievements, areas for improvement and progress made to date
- Updating of the Professional Development Plan (POP)
- Provision of ongoing careers education, information, advice & guidance
(CEIAG) - Feedback on an apprentice’s work
- English, maths, and wider digital skills development
- Support in understanding and applying: safeguarding; fundamental British values; health, safety, & wellbeing; and equality, diversity, and inclusion
In addition to tutor 1:1s, all apprentices and employers must also partake in a monthly Professional Development Review (PDR):
- A meaningful discussion about the apprentice’s achievements
- Identifying areas for improvements, and agreeing a consequent target plan
- Looking at progress made to date
Included: Gateway to End-Point Assessment
This is the period in which the decision is made whether the apprentice is ready to cross the threshold phase, from learning to the end-point assessment phase.
The EPA will be completed in a three-month period, beginning when the EPAO confirms that all gateway requirements have been met. At the gateway, any supporting documentation that supports an EPA assessment technique must be submitted.
Successful completion!
Congratulations! You will have completed your Data Analyst Apprenticeship! You will have learned the skills, knowledge, attitudes, and behaviours to embark on a rewarding IT & digital career.
What happens after I successfully complete the Data Analyst apprenticeship?
Upon successful completion of the Data Analyst Level 4 Apprenticeship, further progression opportunities are available:
- Promotion in the workplace, or a movement into a managerial role
- Study at a higher level of apprenticeship (dependent on occupation)
- Enrolling in a degree (full or part-time) or even a degree apprenticeship
- Continuing in the role, but undertaking additional, related qualifications to further development
NowSkills tutors and support staff are trained to advise you on the wide range of career options available after your apprenticeship. For many apprentices this may be continuing employment in a permanent with their apprenticeship employer; for others, it may be new education or career opportunities.
