Data Analyst with PowerBI & Python
Level 4 Apprenticeship
Funding band: £15,000
Duration: 16 months
Delivery Style: 1:1 In person and online, Live virtual classrooms, 247 on demand learning resources
Apprenticeship training is fully funded. Apprentices are not required to pay. Employers, please visit our Funding, Grants & Payments section.
Searching for a Data Analyst apprenticeship that gives you more?
Data Analyst Blended Learning Masterclass Modules:
As well as learning all of the above using leading VLE platforms, apprentices will attend a series of Masterclass modules, delivered live virtual by our expert tutor team.
Duration | 4 Days
- Identifying different data sources and data types used in organisations.
- Data Collection methods and Data Normalisation
- Organisational Data Architecture and commonly used organisational tools for Data Analysis activities.
- The stages of the Data Analysis Life Cycle and its Application
- The role of data analysis in the decision-making process.
Duration | 3 Days
- Data Mining Fundamentals
- Cleansing, Combining and Transforming Data with Power Query
- Summarising Data using Pivot Tables and Pivot Charts
- Data Modelling with Power Pivot and Introduction to DAX
- Statistical Analysis and Interactive Dashboards
Duration | 3 Days
- The role of a Data Analyst within Power BI in Organisations
- Connecting and Combining Different Data Sources to Power BI
- Data Transformation, Data Modelling and DAX with Power BI
- Statistical Analysis, Reporting and Dashboard for Collaboration with Power BI
Duration | 3 Days
- Connecting and Combining Data Sources and Data Exploration
- Data Visualisation and Reporting with Tableau
- Application of Statistical Methods with Tableau
- Dashboards & Data Stories for Collaboration
Duration | 4 Days
- Understanding different data structures and database designs
- Regulations and Industry Standards for DBMS
- Performing queries with SQL
- Cleaning and Combining Data using advanced queries with SQL.
Duration | 4 Days
- Python Basics for Data Analytics
- Data Wrangling and Visualisation
- Analysing Data for Insights
- Introduction to AI
Power BI for Data Analysts
Trusted by leading employers
Flexible, blended learning:
More course details
This apprenticeship focuses on key tasks like gathering, inspecting, and modelling data. Participants will receive support to develop skills for success in a changing work environment.
If you enjoy analysing and managing data, consider the Data Analyst apprenticeship. After completion, you can pursue roles such as Data Analyst, Data Manager, Data Scientist, and more.
Learner Journey
Technical skills, knowledge and behaviours you will gain:
- + 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 techniques for data analysis, data visualisation, and presentation using analytical tools
- 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
Apprentices must have:
(Entry requirements vary depending on the employer’s requirements.)
- The right to work in the UK
- Lived in the UK continuously for the past 3 years
- GCSE English and maths minimum requirement at grade 3 or above (or equivalent)
Level 3 Data Technician Apprenticeship
Level 3 Data Technician Apprenticeship, awarded by the Institute for Apprenticeships and Technical Education
Optional examination for MO-200: Microsoft Excel
(The following optional certification exam may be taken following completion of all training sessions.)
Optional examination for MO-200: Microsoft Excel
- Additional fee applies, an exam cannot be funded by an apprenticeship fee
- More information about the Certified Microsoft Excel exam
Tutor 1:1s
These take place monthly, either at the workplace or live online with the tutor.
- Teaching delivery sessions, in areas of training need to be agreed upon with the tutor
- Professional Development Reviews (PDRs), which employers must partake in
- Updating of the Professional Development Plan (PDP)
- Provision of ongoing career education, information, advice & guidance (CEIAG)
- Feedback on an apprentice’s work from a skills coach
- English, maths, and wider digital relevant skills development
- A meaningful discussion about the apprentice’s achievements
- Identifying areas for improvement, and agreeing on a consequent target plan
- Looking at progress made to date
Support in understanding and applying:
- Safeguarding; fundamental British values; health, safety, & wellbeing; and equality, diversity, and inclusion
Ongoing professional development
Apprentices will be guided by a NowSkills tutor and their workplace mentor throughout the duration of the Data Technician apprenticeship training. For a level 3 apprentice, this must be 6 hours of their working week and if they aren’t attending training in the centre, it may likely consist of:
- Mentoring sessions with the nominated suitable employer mentor
- Training in the workplace, relevant to the standard
- Producing/collating evidence for the apprentice’s summative portfolio
- Work shadowing
- Industry visits
- Attendance at competitions
- Online learning
- Studying or researching and teaching delivery
Gateway to EPA
This is the period in which the apprentice crosses the threshold phase, from the learning and formative assessment period to the end-point assessment phase. This decision will be made by the employer, training provider, and apprentice based on the apprentice’s progress. To move onto the end-point assessment phase, it is essential to have passed all the knowledge modules and/or vendor qualifications or professional qualifications and to provide a portfolio of work.