Course 6 of 6 · The Data Analytics pathway

Statistics for Data Analytics

AB Testing & Machine Learning

Move from "what happened?" to "how sure are we, and what should we do?" Test claims, run and read A/B tests, forecast and use basic machine learning in Python and Excel, turning every result into a decision for the fictional Kettle & Bean team.

View on Udemy ›Get all six in the Bootcamp
  • Course 6 of 6
  • Intermediate
  • Google Colab and Excel
  • Self-paced
Statistics for Data Analytics course thumbnail

Free preview lesson

What you will learn

By the end of the course you can

  • Scope a request: the type of analytics, the right KPI and the right method.
  • Describe data honestly: the right average, the spread and the shape, with outliers investigated.
  • Measure funnels and team KPIs, and spot vanity metrics.
  • Say how sure you are with samples, the normal distribution and confidence intervals.
  • Test a claim with the right test, and tell a real difference from chance.
  • Design, analyse and decide on an A/B test, avoiding the common traps.
  • Model drivers with regression and forecast with seasonal methods, always against a baseline.
  • Build, evaluate and explain a simple classifier and a customer segmentation.
  • Do every statistic in both Python and Excel, and check AI's answers before using them.

Who it is for

This course suits you if

  • You can already summarise data in Excel, SQL or Python.
  • You want to say how sure you are about a result.
  • You want A/B testing, forecasting and machine learning basics for business decisions.
Laptop showing a Statistics for Data Analytics live lesson: a two-proportion z-test in a notebook, with a question from Tom in Marketing
You will need

A free Google account for Google Colab, and Microsoft 365 desktop Excel with the Analysis ToolPak. Machine learning lessons are Python only. No statistics or Python experience is needed: lesson 1.5 is a pandas quick start.

What's included

Everything in this course

Video lessons

Each method explained with an everyday analogy, then shown live in Python and in Excel.

Course handbook

A handbook for every section, so you can review the ideas and examples at your own pace.

Quizzes

Short checks at the end of each section to confirm you have understood the key ideas.

Challenges and solution walkthroughs

A challenge brief to work through on your own in each section, then a solution walkthrough to compare your work with.

The Kettle & Bean data

The shared company data plus new tables for the methods: web sessions, an A/B test, ad and email spend and a customer survey.

Python and Excel side by side

Every statistic is shown in both, so you can use the one your workplace uses.

Two pages of the Statistics for Data Analytics handbook: the Section 6 A/B Testing cover and the Lesson 6.2 page on designing the test

Inside the handbook

A handbook for every section

Each section has its own handbook with the notes, analogies, every worked example with its real result, and space for your answers. Type in the fillable PDF or print it.

Shown: the Section 6 cover and the Lesson 6.2 page on designing the test.

Course content

Nine sections, one final project

  1. 1Section 1

    Think Like an Analyst

    Scope a request, choose the right KPI and method, and get started in Colab and Excel.

  2. 2Section 2

    Describe and Explore

    Choose the right average, measure spread and shape, and investigate outliers.

  3. 3Section 3

    Business Metrics: Funnels and KPIs by Team

    Measure funnels and team KPIs, and spot vanity metrics.

  4. 4Section 4

    Samples and Confidence: How Sure Are We?

    Work with samples, the normal distribution and confidence intervals.

  5. 5Section 5

    Test the Claim: Hypothesis Tests and Correlation

    Choose and run the right test, and read correlation without assuming cause.

  6. 6Section 6

    A/B Testing

    Plan, analyse and decide on an A/B test, and write the decision memo.

  7. 7Section 7

    Regression and Forecasting

    Model what drives results and forecast against a baseline.

  8. 8Section 8

    Machine Learning for Analysts: Classification

    Build and evaluate a simple classifier, and read a confusion matrix.

  9. 9Section 9Final project

    Segmentation, AI and the Final Project

    Segment customers with k-means, check AI's answers and complete the growth plan.

Final project: the 2026 Growth Plan

In Section 9 you describe 2025, test two management claims, read an A/B test and make the ship decision, forecast, predict which customers may not come back and segment customers. You finish with three recommendations for the board, and say how sure you are about each number.

Two pages of the Statistics for Data Analytics final project brief: Amara's request for a 2026 Growth Plan, and the marking table

See inside the course

Real tests, real decisions

Explore slides from the actual lessons, including the live demonstrations. Click or tap any image to see it full size.

Lesson slide: a two-proportion z-test on A/B test results in a Google Colab notebook, with a question from Tom
Section 6: Analyse an A/B test with a two-proportion z-test in Colab.
Lesson slide: the decision memo for an A/B test: ship, don't ship or extend
Section 6: Write the ship, don't ship or extend decision memo.
Lesson slide: the confusion matrix, four ways a prediction can land
Section 8: Read a confusion matrix.

Kettle & Bean Co. is a fictional company created for teaching.

Lesson slide from Section 6: Tom, Marketing Manager, asks whether the website should switch to a one-page checkout

The learning scenario

Answer questions from the Kettle & Bean team

Each lesson starts with a realistic request from a colleague at a fictional UK coffee and tea retailer. You query the data, check the result and explain what it shows.

  • Amara
    Head of Insights
  • Priya
    Sales
  • Grace
    Finance
  • Marcus
    Operations
  • Tom
    Marketing
  • Ellie
    Customer Service
Watch the free preview ›
Sophie Lumpa

Created by Virtavis Learning

Sophie Lumpa

Data and Business Intelligence Specialist, founder of Virtavis Learning

Sophie Lumpa created this course and designed the Kettle & Bean learning scenario, bringing realistic business questions into the learning experience. The Virtavis teaching team provides additional training and learner support through the Bootcamp and live cohorts.

  • BCS Certified Data Analyst
  • BSc (Hons) Business Management and IT
  • Adult education teaching qualification
  • AgilePM
  • Certified Scrum Master

Questions

Questions about the course?

Something else?

If your question isn't answered here, send it to us and the Virtavis team will reply by email.

Contact us ›
Which software does the course use?
Google Colab in your web browser for Python, and Microsoft 365 desktop Excel with the Analysis ToolPak. Machine learning and forecasting with Prophet are Python only.
Do I need statistics or Python experience?
No. No statistics and no Python are assumed, and lesson 1.5 is a pandas quick start. It helps if you can already summarise data in Excel, SQL or Python.
Where do I buy this course?
On Udemy. The "View on Udemy" button opens the course page, where you can see the current price and terms.
Is it included in the Bootcamp?
Yes. The Virtavis Bootcamp brings all six courses together with the full practice dataset, additional templates and learning resources, and email support. A tutor-supported option is also available with four 30-minute one-to-one sessions, subject to the published package terms.
Is this a data science course?
It teaches the statistical methods analysts use to make confident business decisions, including machine learning basics. It is not a full data science or machine learning engineering course.
Do I get a certificate?
Udemy provides its certificate of completion, subject to its terms. As part of our commitment to delivering high-quality professional learning, we are working towards obtaining CPD accreditation for our courses. We look forward to sharing further updates as we progress.

Start with the free preview.

See how the lessons work before you choose.

View on Udemy ›Explore the Bootcamp