compendium

13 Lessons

Visualisation in Python: Matplotlib, Seaborn & Plotly

13 Lessons

Merging, Joining & Reshaping Data Frames

13 Lessons

Grouping, Aggregating & Pivoting in Pandas

13 Lessons

Arrays & Vectorisation: Why Loops Are Slow

13 Lessons

Cleaning Data with Pandas: Types, Missing Values & Duplicates

13 Lessons

Pandas Basics: Loading, Selecting & Filtering Data

13 Lessons

Python Essentials an Analyst Actually Uses

13 Lessons

Setting Up Python for Analysis: Notebooks, Environments & Libraries

11 Lessons

Automating Repetitive Spreadsheet Work

11 Lessons

Case Study: Building an Analysis Workbook a Manager Can Trust

11 Lessons

Spreadsheet Auditing: Errors, Traceability & Version Control

11 Lessons

Charts in Excel, and When Not to Use Them

11 Lessons

Data Modelling Inside a Spreadsheet

11 Lessons

Pivot Tables: Fast Aggregation and Its Limits

11 Lessons

Power Query for Repeatable Data Cleaning

11 Lessons

Dynamic Arrays and the Modern Formula Set

11 Lessons

Logical & Conditional Aggregation Functions

11 Lessons

Lookup & Reference Functions Done Properly