Data Analysis with SQL and PowerBI – Skills Bootcamp | Purple Beard

Skills Bootcamp

Data Analysis with SQL and Power BI

The Skills Bootcamp in Data Analysis with SQL and Power BI

Part of the Government’s Lifetime Skills Guarantee and Plan for Jobs

There are more Data Analysis jobs than skilled professionals, and the average entry-level salary in Data Analysis with proficiency in SQL and Power BI is £39,000.

What are Skills Bootcamps?

Skills Bootcamps are flexible courses of up to 16 weeks, allowing people to build up sector-specific skills and fast-track an interview with a local employer.

The Government has developed Skills Bootcamps in partnership with employers, providers and local authorities to help people develop the skills in demand in their local area and get better jobs. They are a part of the Lifetime Skills Guarantee and Plan for Jobs strategies.

The task is to raise awareness and drive uptake of these exciting new courses nationally, so the most significant number of people can benefit. So the public, employers and stakeholders can see momentum building around this innovative reskilling model.

About

This Bootcamp is designed to kickstart your data analyst career by learning the core principles of data analysis and gaining hands-on practice. 

Who is it for?

This bootcamp does not require any prior programming or statistical skills and is suitable for learners with or without an undergraduate degree.

Pre-requisites

  • Maths and English GCSE grades A to C
  • Must have an interest in developing as a Business Analyst  

Modules

  • Pre-course
  • Introduction to Data Analysis
  • Advanced Excel
  • Cleaning, summarising and Summarising Datasets
  • Intro to SQL
  • SQL-base Project
  • Data Forecasting, Modelling and Hypothesis Testing
  • Introduction to Power BI
  • Data Visualisation, Presenting and Dashboards
  • Capstone Project

Core Tools and Technologies

  • SQL
  • Excel
  • Power BI

In Addition

  • Presentation skills
  • Portfolio development
  • Employability and interview skills
  • CV writing and LinkedIn visibility skills
  • Communication skills
  • Soft skills such as – teamwork, empathy, problem-solving, critical thinking

Suppose you’re unemployed or looking to switch careers. In that case, we’ll put you forward to a guaranteed interview upon completion, support you with preparation, write references, and refer you to our partners and employers to maximize your chances of landing a job.   

What is Data Analysis with SQL and PowerBI?

The course will start with the basics of SQL and PowerBI along with object-oriented programming concepts (OOP) with the addition of statistics.  

Learners who complete will be proficient in using SQL and PowerBI for Data Visualisation. Along with the use of Regular Expressions for Data Cleaning.    

What does a Data Analyst do?

A data analyst collects, cleans, and interprets data sets to answer a question or solve a problem. They work in many industries, including business, finance, criminal justice, science, medicine, and government.

Data Analyst Salaries

The average entry-level salary in the UK ranges from £22,000 - £39,000 per annum, with more experienced Data Analyst professionals earning more than £100,000.

Why choose a Data Analyst career:

  • there are more jobs than skilled professionals
  • highly in-demand
  • impressively high salaries (due to the skills gap)
  • many progression pathways are available
  • secure job
  • high impact on the IT sector

Funded Areas

Skills Bootcamps are 100% free for UK residents or those willing to look for work in the following areas.

  • East Midlands (Nottinghamshire, Derbyshire, Leicestershire, Lincolnshire)
  • Newcastle, North Tyneside and Northumberland

Who Can Apply?

  • Residents of East Midlands
  • Residents of Newcastle, North Tyneside, and Northumberland
  • Unemployed within the past 12 months
  • Furloughed
  • Self-employed
  • Employed and not supported by the employer

The Funding Criteria

Skills Bootcamps are 90% funded for SMEs and 70% for larger employers looking to refer their existing employees.

Employers and employees referred/supported by their employer working or living in the eligible areas, the remaining 10 - 30%.

You must also fall under the following:

  • 19+ years old 
  • You must either live and work in one of the eligible areas
  • Have the right to work in the UK
  • Be able to commit to the 11 weeks Skills Bootcamp
  • Must not be an international student

If you do not Meet the Funding Criteria

  • You can still sign up for the Bootcamp and self-fund it.
  • The total price for the Bootcamp ranges from £2500 - £3000 + V.A.T.

We deliver live virtual sessions via Microsoft Teams. The tools the students need are:

  • a laptop or a computer (excl. Chromebooks)
  • headphones
  • a good internet connection.
  • tablets and phones are not conducive to undertaking the sessions

A Capstone Project will be given to you, which must be completed by the end of the course. Also, there will be optional projects as well whoever wants to work more separately. Before the project, we will have 3-4 sessions for support regarding the project.

You can add your capstone project to your portfolio, which is evaluated towards the end of the Bootcamp.

You’ll receive

  • Skills Bootcamp completion certificate from Purple Beard Training
  • Access to our Alumni 
  • You will also have a chance to take an optional exam

Data Analysis with Python progression

  • Data Analyst Apprenticeship
  • Retail Data Analyst
  • RPA Developer
  • Python Quant Developer
  • Data Quality Analyst
  • Risk Analyst
  • Marketing Automation Engineer
  • Data Scientist
  • Software Developer
  • Digital Insights Analyst
  • AWS Python Engineer
  • Implementation Engineer
  • Commercial Analyst
  • Data Analyst

Here is a comprehensive list of Bootcamps currently running where, if you meet the criteria, you may be able to apply for total funding of the Skills Bootcamp.

YNY Partnership

For the following areas:

  • Richmond
  • Northallerton
  • Thirsk
  • Whitby
  • Scarborough
  • Pickering
  • Malton
  • Ripon
  • Skipton
  • Harrogate
  • York
  • Selby
  • Tadcaster

We offer the following Skills Bootcamps:

D2N2 Partnership

For the following areas:

  • Derbyshire
  • Lincolnshire
  • Nottinghamshire
  • Leicestershire

We offer the following Skills Bootcamps:

NTCA Partnership

For the following areas:

  • Newcastle
  • North Tyneside
  • Northumberland

We offer the following Skills Bootcamps:

FEATURES
_______

Skills Bootcamps are flexible courses of up to 16 weeks, giving people the opportunity to build up sector-specific skills and fast-track to an interview with a local employer.

100% funded for individuals from the eligible areas
70 - 90% funded for employers who refer an existing employee in the eligible areas

Evening time - 11 weeks, Mon-Thu

Live online classes and video recordings

Applications are now open!

FAQs

The Department for Education funds skills bootcamps in the following ways: 70% for SMEs, 90% for larger companies and 100% for those living or employed in certain regions. Please see our funding & eligibility box above for more details.

If you’re from an eligible area and meet the eligibility criteria for 100% funding – then yes, Skills Bootcamp is completely free!

1. Fill out our Initial Interest Form here – please keep in mind filling out this form does not automatically enrol you for the Skills Bootcamp yet.

2. You’ll receive a confirmation email with an option to book a call with us at your most convenient time. If you don’t do it, we will call you within two days – we will then check your eligibility, confirm your interest and answer any questions you might have.

3. Fill out the Enrolment Form – and once this is done, you’re in! 

4. Onboarding, induction and pre-learning – we will send you everything before the Skills Bootcamp

5. Skills Bootcamps commences -have fun!

You don’t need a technical background to join most of our Skills Bootcamps! However, you do need to be able to attend every week, demonstrate a good level of communication and problem-solving skills and want to progress in your current employment or into a new career. 

We aim to ensure learners are work-ready and prepared for a job in their chosen area of tech upon course completion, so reskilling or upskilling to get a new job or advance in your current role should be your goal! In addition, we want our learners to have fun, be sociable and create a community with their peers and alumni. 

We expect three things from our students:

  • be highly motivated
  • be curious
  • be social
  • If this sounds like you, then we’ll be more than happy to have you on board if you pass all the selection process

All you will need to attend is a laptop or desktop computer with a working microphone. The machine should have a working camera for you to get the most out of the virtual sessions. In the first session of the Skills Bootcamp, we always have an ‘InstallFest’ to ensure you’ve got any software you may need.

Previous learners have also found that having two screens is beneficial, so you can complete tasks while following along with the trainer. This could be a second computer screen or TV attached with an HDMI cable or using a tablet as your second screen.

Purple Beard Skills Bootcamps are designed to make learners work-ready from the week of course completion- and Employability is a massive part of the service we offer.

When the Skills Bootcamp ends, you will benefit from our Employability Services, where you’ll have the opportunity to work 1:1 with our Employability Coach, to help you build your portfolio and your Linkedin profile.

We can also help you prepare for technical interviews, connect you with recruiters, and we’ll put you in touch with our outstanding Alumni, who will share their experiences from life after the Skills Bootcamp. 

GAIN THE MOST IN-DEMAND SKILLS
WITHOUT LEAVING YOUR HOME.

100% online virtual classroom learning which you can get at no cost!

Interest form

If the form doesn’t work, please click here

How Skills Bootcamps can help in your career in Data Analysis

Thinking about Upskilling or getting into Data Analysis

A few things you should know

If you’re thinking about a career in Data Analysis, start thinking about what you want to accomplish and what your interests are.

According to Indeed: employer demand still outpaces the number of qualified candidates available.

Searches for the terms data analysis have risen 141% in the past two years

You’ll need to learn: a variety of technologies including SQL, and PowerBI.

Signing up for Skills Bootcamp

During Skills Bootcamp you’ll have to

  • Commit to the program
  • Attend online live classes 
  • Do homework and reading
  • Participate in projects, workshops and presentation
  • You’ll have a chance to take on an optional exam

This course will

  • Provide you with the foundations of Data Analysis
  • Provide you with opportunities and guidance on how to progress further

Post-Bootcamp Completion

You’ll receive support with the following

  • CV check & Interview prep
  • Career progression
  • Job referrals/references
  • Alumni Guide Access
  • Job interview opportunity
  • Networking

Post-Bootcamp Pathways

Your possible career pathways and Progression

  • Data Analyst Apprenticeship
  • Retail Data Analyst
  • RPA Developer
  • Data Quality Analyst
  • Risk Analyst
  • Marketing Automation Engineer
  • Data Scientist
  • Software Developer
  • Digital Insights Analyst
  • Implementation Engineer
  • Commercial Analyst
  • Data Analyst

Meet our Learners

0 %
Learners' Satisfaction Rate
0 %
Overall Skills Bootcamp Rate
0 %
Confidence gained to do more advanced work in the subject

About our Data Analysis with SQL and Power BI Bootcamp

The Skills Bootcamp kickstarts your data analyst career by learning the core principles of data analysis and gaining hands-on practice.  

Learners will work with various data sources, project scenarios, and data analysis tools, including Excel, SQL, and Power B.I., to gain practical experience with data manipulation and applying analytical techniques. 

This Skills Bootcamp does not require prior programming or statistical skills and is suitable for learners with or without an undergraduate degree. 

Who is this Skills Bootcamp for?

The Data Analysis with SQL and Power BI Skills Bootcamp is open for aspiring Data Analysts and those who want to kick off their career in tech.

Participants must be aged 19+ and be based in eligible areas to be accepted for the funding.

Beginners are welcome

However, you’ll need to do some pre-learning before the course as provided by Purple Beard. 

WHY PURPLE BEARD?

We are Purple Beard, an EdTech company on a mission to disrupt the tech sector with challenging, engaging and highly selective learning experiences that are developed and led by industry experts to create employable tech talent and bridge the diversity gap in the tech sector.

At our core we aim to use training models that support individual needs and challenge the older models of education through Government funded programs. Our aim is to make tech education accessible and affordable using a range of technologies and modalities to deliver learning.

Other Skills Bootcamps

Evening time,
virtual classroom

Co-funded for East of England and East Midlands areas – between 70% and 100% funding available

 

Evening time,
virtual classroom

Co-funded for East of England and East Midlands areas – between 70% and 100% funding available

 

Evening time weekdays or Saturdays,
virtual classroom

Co-funded for East of England and East Midlands areas – between 70% and 100% funding available

 

WE CAN'T WAIT TO HEAR FROM YOU!

Speak to our team today

If you’d like to talk about Data Analysis Skills Bootcamp UK, Skills Bootcamps, Apprenticeships, a potential partnership, working with Purple Beard or you have any other questions, please contact us and we’ll get back to you as soon as possible.

[ninja_form id=4]