Video lessons
Turn each question into a plain-English pandas sentence, try the code yourself, then watch it built live and compare.
Course 5 of 6 · The Data Analytics pathway
pandas, Charts & Business Insights
Analyse real business data with pandas and Plotly in Google Colab. Explore, clean and combine data, chart it clearly and find who comes back and who is worth most, answering requests from the fictional Kettle & Bean team.
Free preview lesson
What you will learn
A free Google account and a modern web browser. Everything runs in Google Colab, so there is nothing to install on Windows, Mac or Chromebook. No Python experience is needed: Section 1 is a brisk refresher of the essentials.
What's included
Turn each question into a plain-English pandas sentence, try the code yourself, then watch it built live and compare.
A handbook for every section, so you can review the ideas and examples at your own pace.
Short checks at the end of each section to confirm you have understood the key ideas.
A challenge brief to work through on your own in each section, then a solution walkthrough to compare your work with.
Three years of sales, customer and returns data from the fictional company, with a starter notebook for each lesson.
Built-in checks in every notebook tell you whether your answer is right without giving it away.

Inside the handbook
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 2 cover and the Lesson 2.2 page on select and filter.
Course content
Open Colab, meet your notebook and refresh the Python essentials, then load your first data with pandas.
Select, filter, sort, calculate, count, group and summarise with DataFrames.
Read CSV, Excel and JSON files, query a database with SQL, call an API and scrape a page legally.
Handle missing values, types, text and duplicates, merge tables and check your data.
Resample, measure growth against last month and last year, and add rolling averages.
Choose the chart from the question, build Plotly charts and apply a house style.
Track new and returning customers, build a cohort retention matrix and RFM segments.
Work with AI in Colab and check it, build a reusable notebook and share your analysis.
In Section 8 you load, clean and check the data, then analyse growth, channels, new and returning customers, cohort retention and RFM segments. You finish with a re-runnable notebook report with charts and three recommendations.

The learning scenario
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
Priya
Grace
Marcus
Tom
Ellie
Created by Virtavis Learning
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.
On the pathway
Questions
If your question isn't answered here, send it to us and the Virtavis team will reply by email.
Contact us ›See how the lessons work before you choose.