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. We have added new features, new team members, new tools, optional qualifications, and real-world insight.
Funding band | £15,000
This cost is paid by the employer, 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
+ Data normalisation
+ Data visualisation & analysis
+ Developing knowledge of data sources
+ Enhancing knowledge of data collection
+ Understanding the process of data normalisation
+ Understanding data visualisation & analysis
+ Data-driven decision
Analysing Data with Excel
Duration | 3 Days
+ Building reports using Data Mining & Data Transformation
+ Data Cleansing with PowerQuery
+ Combining data with PowerQuery
+ Single pivot table
+ PowerPivot table+ Statistical analysis with Excel
+ Creating data visualisation
+ Designing an interactive dashboard
Data Visualisation with PowerBI
Duration | 3 Days
+ Introduction to PowerBI
+ Explore Visulisations, components, filters & data exportation
+ Connecting Data from different File formats & folders
+ Merging, appending, cleansing, and modelling data
+ DAX Calculations to Agreggegate, Slice & Summarise data
+ Report Design & Visualising data
+ Dashboard Creation, collaboration with PowerBI
Data Visualisation with Tableau
Duration | 3 Days
+ Tableau components
+ Tableau capabilities & applications
+ Comparison between Tableau & traditional data tools
+ Data sources for Tableau
+ Data exploration with Tableau
+ Creating a statistic with Tableau
+ Report design
+ Combine data from different sources
+ Dashboards and data stories for collaboration
Managing Data with SQL
Duration | 4 Days
+ Understanding databases
+ Regulations
+ Developing knowledge of performing queries
+ Data cleansing
Python for Data Analysts
Duration | 4 Days
+ Introduction to Python
+ Python Programming
+ Data wrangling & visualisation
+ Data cleaning with Pandas
+ Analysing data for insights
+ Introduction to AI
Power BI for Data Analysts
NowSkills Data Analyst apprentices will learn how to use Microsoft’s PowerBI: a data visualisation product with a focus on business intelligence. Apprentices will be able to analyse data, prepare reports, share insights and empower everyone in your organisation to quickly make data-driven decisions that drive strategic actions.
Power BI has a growing library of 500+ free connectors, including Dynamics 365, Azure SQL Database, Salesforce, Excel, and SharePoint.
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 in our Expert Series. 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:
![APPRENTICESHIPS[1]](https://nowskills.co.uk/wp-content/uploads/elementor/thumbs/APPRENTICESHIPS1-qd0r471x4tyc6i65joxzhzoon0shxbj698v72bx0q0.png "Data Analyst Apprenticeship 45")
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.
