Menu
0345 556 4170 | #nowskillsgivesyoumore
Data Analyst
with PowerBI & Python
Level 4 Apprenticeship
Searching for a Data Analyst apprenticeship that gives you more?
We’ve re-imagined our data analyst apprenticeship programmes, thinking bigger, and using the apprenticeship opportunity to deliver change. Apprentice will gain hands-on experience with advanced tools, learn to interpret real world data, gain optional qualifications and industry insights.
Duration: 20 months
Funding band: £15,000
The employer pays this cost, for SMEs there is up to 100% funding available. For Levy employers, you can find out more here. Apprentices will not contribute to this.
We are proud to work with:
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.
Embedding a Data Culture
Analysing Data with Excel
Data Visualisation with PowerBI
Data Visualisation with Tableau
Managing Data with SQL
Python for Data Analysts
Embedding a Data Culture
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.
Analysing Data with Excel
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
Data Visualisation with PowerBI
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
Data Visualisation with Tableau
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
Managing Data with SQL
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.
Python for Data Analysts
Duration | 4 Days
+ Python Basics for Data Analytics
+ Data Wrangling and Visualisation
+ Analysing Data for Insights
+ Introduction to AI
Power BI for Data Analysts
Our Data Analyst apprentices become experts in Microsoft’s industry-leading Power BI platform. This goes beyond just creating visuals. You’ll leverage Power BI’s intuitive interface to analyse data, craft compelling reports, and share data-driven insights that empower your entire organisation.
Make faster, smarter decisions with features like an ever-expanding library of connectors (over 1,000 now!), seamlessly integrating data from a vast range of sources. AI-powered insights and automation help you discover hidden patterns and automate repetitive tasks, saving valuable time. Plus, Power BI’s real-time data analysis keeps you on top of trends, allowing you to make adjustments based on the latest information.
Flexible, blended learning:
Employer-led and flexible, with no two apprenticeship journeys ever the same. We use a blended approach using the best live online and physical classroom teaching experiences supported with the latest self-paced e-learning. Our monthly 1:1 teaching sessions are flexible, delivered live online or in person, depending on what your organisation needs.
We include additional Social Enrichment Sessions and celebrated speakers join us monthly on NowSkills Insights. Your apprentices also have the opportunity to achieve industry recognised certifications, beyond the scope of the apprenticeship.
More course details
This apprenticeship focuses on key tasks like gathering, inspecting, and modeling 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.
Technical skills, knowledge and behaviours you will gain:
Knowledge
Knowledge
+ 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
Entry Requirements
Qualifications you will gain
Optional Certifications
Entry Requirements
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 4 or above (or equivalent)
+ Apprentices that don’t have GCSE English and maths at the required level undertake mandatory Functional Skills as part of the apprenticeship to achieve Level 2 prior to End Point Assessment – this is at the cost of the employer
+ Relevant qualifications and or work experience at a lower level
Qualifications you will gain
Level 4 Data Analysis Apprenticeship, awarded by the Institute for Apprenticeships and Technical Education
Optional Certifications
Optional Power BI certification: Microsoft PL-300 exam
The teaching and learning included in this Data Analyst apprenticeship covers Power-BI, and learners can use its features competently at completion. However, we can offer a solution for those apprentices wishing to gain an official Power BI qualification. However, the cost cannot be paid using government funding, including the apprenticeship Levy. This restriction is due to government Funding Rules.
The knowledge required to pass the PL-300 exam is beyond the scope of the Data Analyst apprenticeship, therefore an additional, optional, and chargeable 2 days of exam prep learning is required.
Extra, optional Costs
+ PL-300 exam, booked and taken online $165 (Book this independently of NowSkills via Microsoft website) https://docs.microsoft.com/en-us/certifications/exams/pl-300
+ 2-day extra exam prep tuition with NowSkills £600 per person for 2 days. Delivered virtually, 2 dates per year, please ask your tutor for the latest availability and offers.
Please note: the PL-300 exam, replaces the retired DA-100 examination: https://learn.microsoft.com/en-us/credentials/certifications/exams/da-100/
Our partners & accreditations:
Potential future roles as a Data Analyst apprentice:
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
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 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 Data Analyst apprenticeship. For a level 4 apprentice, this must equate to 20% of their working week they aren’t attending training in the centre and will 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 learning and formative assessments 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 process, it is essential to have all of the basic requirements, passed all the knowledge modules and/or vendor or qualifications or professional qualifications and to provide a portfolio of work.
