Skip to content

Data Analyst Diploma: Data Analysis with Python, Microsoft Excel, SQL, Power BI, ML
Apex Learning

16 in 1 CPD Accredited Courses | 16 Free Digital Certificates | Lifetime Access | Python, Microsoft Excel, Power BI

Summary

Price
Save 64%
£36 inc VAT (was £100)
Offer ends 21 July 2025
Study method
Online
Course format
Video
Duration
79 hours · Self-paced
Access to content
Lifetime access
Qualification
No formal qualification
CPD
300 CPD hours / points
CPD What's this?
Achievement
Endorsed by The Quality Licence Scheme
Certificates
  • CPD Accredited Digital Certificate - Free
  • CPD Accredited Hard Copy Certificate - Free
  • Data Analysis in Excel at QLS Level 5 Hardcopy Certificate - £119
Assessment details
  • Assessment (included in price)
Additional info
  • Tutor is available to students
960 students purchased this course

Add to basket or enquire

Overview

Get Access to 16 courses with our Data Analyst (Data Analytics) Bundle!

★★★ Enrolment Gifts Included: Hard Copy Certificate (Title Course) + 16 Digital PDF Certificates + Transcript + Student ID Card — all worth £200 - Enrol Now! ★★★

This Data Analysis Diploma is the ultimate training solution for anyone looking to break into data analysis, business intelligence, or data science.

This expertly structured Data Analyst Diploma teaches you essential skills in Python, Microsoft Excel, SQL, Tableau, Power BI, and Machine Learning, equipping you to extract, analyse, interpret, and present data effectively.

Over the past five years, demand for data analysts has soared by over 230%, outpacing most other job sectors in the UK. With average analyst salaries rising above £64,000, this course gives you the competitive edge to thrive in today’s data-driven job market.

You’ll receive 16 high-value online courses, free digital certificates, a hard copy CPD certificate for the title course, and a verified student ID — all included in one lifetime-access bundle.

This Data Analyst (Data Analytics) Bundle consists of the following Premium courses:

  • ➽ Course 01: Diploma in Data Analysis in Excel at QLS Level 5
  • ➽ Course 02: Python for Data Visualization: The Complete Masterclass
  • ➽ Course 03: Data Manipulation in Python: Master Python, Numpy & Pandas
  • ➽ Course 04: Data Analytics with Tableau at QLS Level 6
  • ➽ Course 05: SQL Programming Masterclass
  • ➽ Course 06: SQL NoSQL Big Data and Hadoop
  • ➽ Course 07: Complete Microsoft Power BI
  • ➽ Course 08: Master Microsoft Power BI in 90 Minutes!
  • ➽ Course 09: Google Data Studio at QLS Level 3
  • ➽ Course 10: Interactive Dashboards with Data Studio
  • ➽ Course 11: Excel: Formula, VLOOKUP & Power Query at QLS Level 4
  • ➽ Course 12: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
  • ➽ Course 13: Machine Learning for Aspiring Data Scientists: Zero to Hero
  • ➽ Course 14: Data Science & Machine Learning with R at QLS Level 7
  • ➽ Course 15: Spatial Data Visualization and Machine Learning in Python Level 4
  • ➽ Course 16: Statistics & Probability for Data Science & Machine Learning at QLS Level 7

This bundle provides an in-depth overview of the data analyst’s role, tools, and responsibilities. You’ll learn how to process, clean, analyse, and present data with clarity and purpose. Whether working with spreadsheets, databases, dashboards, or large-scale datasets, you’ll build the analytical mindset and tool proficiency expected in data roles.

With interactive learning materials, guided projects, and topic-specific lessons, you’ll grow confident using:

  • Python and R for scripting, EDA, and machine learning

  • SQL for querying relational databases

  • Excel for advanced reporting, automation, and dashboard building

  • Tableau, Power BI, and GDS for visualising and presenting insights

  • Big Data tools, NoSQL concepts, Hadoop, and cloud-based data processing

Learning Outcomes of Data Analysis Diploma

Upon completion of the Data Analyst (Data Analytics) programme, you will have:

  • Apply data analysis techniques using Python, NumPy, and Pandas
  • Use Microsoft Excel, Power Query, and VLOOKUP to organise and interpret data
  • Clean, transform, and visualise datasets using Tableau, Power BI, and Google Data Studio
  • Write complex SQL queries using JOINs, GROUP BY, subqueries, and aggregation functions
  • Interpret business data and build interactive dashboards for decision-making
  • Conduct machine learning and predictive analysis with Python and R (QLS Level 7)
  • Perform statistical analysis including hypothesis testing, regressions, and probability modelling
  • Understand Big Data tools, NoSQL systems, and Hadoop architecture
  • Analyse spatial data and build location-based visualisations
  • Automate data reports using Excel VBA and dynamic dashboards

Benefits you’ll get choosing Apex Learning for this Data Analyst Course:

  • One-time payment for lifetime access to all 12 CPD courses
  • Free CPD-accredited Digital + Hard Copy Certificates
  • Free student ID card and transcript
  • Flexible online learning – mobile, desktop, tablet
  • Expert tutor support, Monday to Friday
  • 2025-updated curriculum aligned with real job skills
  • Learn at your own pace, anytime, from anywhere

Achievement

Certificates

CPD Accredited Digital Certificate

Digital certificate - Included

CPD Accredited Hard Copy Certificate

Hard copy certificate - Included

You will get the Hard Copy certificate for the title course (Data Analysis in Excel) absolutely Free! Other Hard Copy certificates are available for £14.99 each.

Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Data Analysis in Excel at QLS Level 5 Hardcopy Certificate

Hard copy certificate - £119

Upon successful course completion, you can order your Quality Licence Scheme (QLS) Endorsed Certificate. Pricing details are as follows:

  • 119 GBP for delivery within the UK.
  • 119+10 GBP (inclusive of postal charges) for international delivery.

Assessment details

Assessment

Included in course price

CPD

300 CPD hours / points
Accredited by CPD Quality Standards

Course media

Resources

Description

Begin your journey with Apex Learning right away!

The bundle incorporates basic to advanced-level skills to shed some light on your way and boost your career. Hence, you can strengthen your Data Analyst (Data Analytics) expertise and essential knowledge, which will assist you in reaching your goal.

★★★ Course Curriculum of Data Analyst Bundle ★★★

➽ Course 01: Diploma in Data Analysis in Excel at QLS Level 5

  • Module 01: Modifying a Worksheet
  • Module 02: Working with Lists
  • Module 03: Analyzing Data
  • Module 04: Visualizing Data with Charts
  • Module 05: Using PivotTables and PivotCharts
  • Module 06: Working with Multiple Worksheets and Workbooks
  • Module 07: Using Lookup Functions and Formula Auditing
  • Module 08: Automating Workbook Functionality
  • Module 09: Creating Sparklines and Mapping Data
  • Module 10: Forecasting Data

➽ Course 02: Python for Data Visualization: The Complete Masterclass

  • Module 01: Setup & Installation
  • Module 02: Plotting Line Plots with matplotlib
  • Module 03: Plotting Histograms & Bar Charts with matplotlib
  • Module 04: Plotting Stack Plots & Stem Plots
  • Module 05: Plotting Scatter Plots with matplotlib
  • Module 06: Time Series Data Visualization with matplotlib
  • Module 07: Creating multiple subplots
  • Module 08: Plotting charts using seaborn
  • Module 09: Plotly and Cufflinks

➽ Course 03: Data Manipulation in Python: Master Python, Numpy & Pandas

  • Module 01: Python Quick Refresher (Optional)
  • Module 02: Essential Python Libraries for Data Science
  • Module 03: Fundamental NumPy Properties
  • Module 04: Mathematics for Data Science
  • Module 05: Python Pandas DataFrames & Series
  • Module 06: Data Cleaning
  • Module 07: Data Visualization using Python
  • Module 08: Exploratory Data Analysis
  • Module 09: Time Series in Python

➽ Course 04: Data Analytics with Tableau at QLS Level 6

  • Module 01: Introduction to the Course
  • Module 02: Project 1: Discount Mart (Sales and Profit Analytics)
  • Module 03: Project 2: Green Destinations (HR Analytics)
  • Module 04: Project 3: Superstore (Sales Agent Tracker)
  • Module 05: Northwind Trade (Shipping Analytics)
  • Module 06: Project 5: Tesla (Stock Price Analytics)
  • Module 07: Bonus: Introduction to Database Concepts
  • Module 08: Tableau Stories

➽ Course 05: SQL Programming Masterclass

  • Unit 01: Introduction
  • Unit 02: Setting up Course Tools
  • Unit 03: Browsing & Filtering Data
  • Unit 04: Filter Data with AND, OR, NOT Operators
  • Unit 05: Math Operations
  • Unit 06: String Concatenation
  • Unit 07: Tidy Up Your Results: Sorting, Alias Names, Limit Records
  • Unit 08: NULL, DISTINCT & CASE Statements
  • Unit 09: Functions in SQL: Multiple-Row Functions
  • Unit 10: Functions in SQL: Single-Row Functions
  • Unit 11: Nested Queries
  • Unit 12: Casting & Data Conversion
  • Unit 13: Combination Relationships
  • Unit 14: Joins in SQL
  • Unit 15: Data Manipulation (DML)
  • Unit 16: SQL Data Definition Language (DDL)

➽ Course 06: SQL NoSQL Big Data and Hadoop

  • Module 01: Introduction
  • Module 02: Relational Database Systems
  • Module 03: Database Classification
  • Module 04: Key-Value Store
  • Module 05: Document-Oriented Databases
  • Module 06: Search Engines
  • Module 07: Wide Column Store
  • Module 08: Time Series Databases
  • Module 09: Graph Databases
  • Module 10: Hadoop Platform
  • Module 11: Big Data SQL Engines
  • Module 12: Distributed Commit Log
  • Module 13: Summary

➽ Course 07: Complete Microsoft Power BI

  • Module 01: Introduction
  • Module 02: Preparing our Project
  • Module 03: Data Transformation - The Query Editor
  • Module 04: Data Transformation - Advanced
  • Module 05: Creating a Data Model
  • Module 06: Data Visualization
  • Module 07: Power BI & Python
  • Module 08: Storytelling with Data
  • Module 09: DAX - The Essentials
  • Module 10: DAX - The CALCULATE function
  • Module 11: Power BI Service - Power BI Cloud
  • Module 12: Row-Level Security
  • Module 13: More data sources
  • Module 14: Next steps to improve & stay up to date

➽ Course 08: Master Microsoft Power BI in 90 Minutes!

  • Module 01: Power BI - Introduction
  • Module 02: Your First Power BI Dashboard
  • Module 03: Your Advanced Power BI Dashboard With Real Live Data

➽ Course 09: Google Data Studio at QLS Level 3

  • Section 01: Introduction
  • Section 02: Google Sheets
  • Section 03: Google Data Studio

➽ Course 10: Interactive Dashboards with Data Studio

  • Module 01: Introduction to GDS
  • Module 02: Data Visualization
  • Module 03: Geo-visualization
  • Module 04: A Socio-Economic Case Study

---------------------- And 6 Additional Courses ----------------------

How will I get my Data Analyst (Data Analytics) Bundle Certificate?

After successfully completing the Data Analyst (Data Analytics) course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.

  • PDF Certificate: Free (Previously, it was £9.99*16 = £159)
  • Hard Copy Certificate: Free (For The Title Course: Previously it was £14.99)

Sign up for this Data Analyst (Data Analytics) Bundle course today and start your journey with Apex Learning.

Who is this course for?

This Data Analyst Diploma is designed for anyone ready to build job-ready data skills — Whether you're starting from scratch or upskilling for promotion, this 16-course bundle gives you the tools and knowledge to succeed in today’s data-driven job market.

Perfect for:

  • Beginners who want to become data analysts without coding experience

  • Graduates and jobseekers looking to boost employability with in-demand data skills

  • Professionals transitioning into data analysis, business intelligence, or analytics

  • Excel users ready to advance into Power BI, Tableau, and automation

  • Marketers, project managers, and finance staff seeking data literacy

  • Python, SQL, or R learners looking for guided, structured training

  • Freelancers and business owners who want to make data-driven decisions

  • Anyone interested in mastering data analysis, visualisation, and reporting tools

Whether you’re pursuing roles like Data Analyst, Business Analyst, BI Developer, or Junior Data Scientist, this CPD-accredited diploma equips you with the complete toolkit to stand out.

Requirements

With our 24/7 online platform, study anywhere, anytime. Our Data Analyst (Data Analytics) course is open to all, requiring only a passion for learning.

Career path

This Data Analyst (Data Analytics) Bundle is ideal for those who want to take their development to the next level and fast-track their career in any of the following roles:

  • Junior data analyst
  • Data analyst
  • Senior data analyst
  • Data analytics manager
  • Financial analyst
  • Marketing analyst
  • Systems analyst
  • Data scientist
  • Machine learning engineer
  • Data analytics consultant

Questions and answers

No questions or answers found containing ''.

Kathryn asked:

Can I buy the course, but wait until a more convenient time to start?

Answer:

Hi Kathryn, Yes, you can. Once you purchase, you will get lifetime access to the course.

This was helpful. Thank you for your feedback.
Charles asked:

If introduction to data Analysis cost £10, does it means the remaining 10 premium courses cost £10 each to obtain a certificate

Answer:

Dear Charles, Good Afternoon. This is a bundle course that costs £39. It comprises 11 courses with no hidden charges. You will get a hard copy certificate for the title course and free PDF certificates for all courses. You can obtain further hard copies upon paying a fee.

This was helpful. Thank you for your feedback.
Saba asked:

Is access to the programming languages, R and python, part of the package.

Answer:

Hi Saba, Good Afternoon. Yes, you will get access to 11 premium courses if you purchase this bundle.

This was helpful. Thank you for your feedback.
Anon asked:

Is this for beginers who are looking at a career change and want to go into a Data analyst role?

Answer:

Dear Anon, Good Morning. Yes, it will be the perfect choice for someone looking to start from scratch.

This was helpful. Thank you for your feedback.
MB asked:

Hi, will I get access to the software/applications required for this course?

Answer:

Hi, Good Afternoon. The Data Analyst Diploma course does not include access to the software or applications required (Python, Tableau, Power BI, and SQL). You will need to download and install these tools on your own device. The course will guide you on how to set them up and use them effectively. Let us know if you need any further assistance!

This was helpful. Thank you for your feedback.
Nique asked:

Do we get QLS certs for the other courses too?

Answer:

Dear Nique, Good Afternoon. In this bundle, only the courses with "QLS Level" mentioned in their title are QLS-endorsed, and you can obtain QLS certificates for those.

This was helpful. Thank you for your feedback.
Steph asked:

If I buy this bundle before 30 April but finish my learning after April, would I need to pay for each of my PDF certificates?

Answer:

Dear Steph, Thanks for your query. You will get the PDF and hardcopy certificate free of charge whenever you complete the courses. Thanks

This was helpful. Thank you for your feedback.
ABSAI asked:

I am a Statistician . 1. What is the average time one is expected to complete the Diploma?

Answer:

Dear Absai, Good Afternoon. If you study regularly, then you will be able to complete it in 2-3 weeks. Thanks

This was helpful. Thank you for your feedback.
Zakaria asked:

Funny

Answer:

Dear Zakaria, Good Afternoon. Could you please clarify your concern so we can assist you better?

This was helpful. Thank you for your feedback.
Emre asked:

Can I use Google Chromebook for this course, tools etc?

Answer:

Dear Emre, Good Morning. Yes, you can access and complete the course using any internet-enabled smart device.

This was helpful. Thank you for your feedback.
M.W asked:

Hello Once you have started the course how long do you have to complete it?

Answer:

Hi, You will get lifetime access to the course.

This was helpful. Thank you for your feedback.
Barry asked:

I am very interested in this course but I have no background in data analysis is this course suitable for someone of my experience

Answer:

Hi Barry, Thanks for your query. Yes, the course will be suitable for you since the course is designed in a way that anyone from any background can do the course.

This was helpful. Thank you for your feedback.
Kathie asked:

Do you get a certificate in the post or do you have to print at home thank you

Answer:

Dear Kathie, You will receive hardcopy certificate via post for the title course (Data Analyst) and certificate digital copy for rest of the courses.

This was helpful. Thank you for your feedback.
Nique asked:

Hey, does this course come with a diploma for free?

Answer:

Dear Nique, Good Afternoon. Upon successfully completing the course, you'll receive a free digital certificate for each course within this bundle. These certificates are accredited by CPD QS, providing proof of your newly acquired skills.

This was helpful. Thank you for your feedback.
BIMPE asked:

Can I have access to the lesson notes during the training? I would like to read along as the lecture goes on.

Answer:

Hi Bimpe, Yes, you can access the lesson notes during the training, allowing you to read along as the lecture progresses.

This was helpful. Thank you for your feedback.
Francis asked:

Regarding residents and citizens of None-European nation, eg Nigeria: 1. are they eligible to enroll for this course? 2. can they get remote jobs?

Answer:

Hi, Anyone from anywhere can enroll in this course to develop their skills. Successful completion of this course can help you secure better opportunities. Thanks. Have a nice day.

This was helpful. Thank you for your feedback.
ABSAI asked:

Are the exams multiple choice or essay based/short answers? Also, is there a course which has practical exam eg Pyton data analysis ?

Answer:

Dear Absai, Good Afternoon. The assessment is in written assignment format. There is no practical exam for any of the courses.

This was helpful. Thank you for your feedback.
Veronica asked:

Hi I want to buy this course is for begginer? Thank you.

Answer:

Dear Veronica, Good Afternoon. Yes, a beginner can do the course.

This was helpful. Thank you for your feedback.
Stephen asked:

What software/applications are required to complete this course?

Answer:

Dear Stephen, Good Afternoon. The software required to complete this course are, Python R PostgreSQL SQL Electron Tableau Google Data Studio Microsoft Excel ChatGPT

This was helpful. Thank you for your feedback.
Ella asked:

Once enrolled on the course, is there a deadline to complete it?

Answer:

Dear Ella, Good Afternoon. No, you will have lifetime access to the course.

This was helpful. Thank you for your feedback.
Lauren asked:

Hi, can you explain more about the student ID and additional benefits when purchasing this course please?

Answer:

Hi Lauren, Students often get discounts in many national or private outlets and also get access to amusement parks, seminars, exhibitions, or carnivals.

This was helpful. Thank you for your feedback.
SARAH asked:

When is the next start date for this course please?

Answer:

Hi Sarah, Good Afternoon. The course is fully online and it is accessible 24/7, you can start studying as soon as you get enrolled.

This was helpful. Thank you for your feedback.
Harry asked:

I m 29 yrs old can i do this course

Answer:

Dear Harry, Any learner 16 years and above is eligible to enrol in this course.

This was helpful. Thank you for your feedback.
Ask a question

Reviews

4.4
Course rating
86%
Service
86%
Content
93%
Value

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Business analysis courses, Analytics courses, SQL courses, Online courses

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2025. All rights reserved.