Tutorial
Hands-on walkthroughs for SQL, Python, Excel and visualisation tools — every example is runnable, not a screenshot.
109 articles in Tutorial · Page 10 of 13
Excel Pivot Table Dashboard with Slicers: 10-Minute Tutorial
Build an interactive Excel pivot table dashboard in 10 minutes. Learn how to summarize data, connect Slicers across multiple PivotTables, and add PivotCharts.
Python Lists and Dictionaries: 10 Assignments With Answers in Python
Master Python lists and dicts — creating, slicing, appending, merging, and iterating — with 10 graded assignments and solutions.
Market Basket Analysis in Python: Support, Confidence, and What to Do With Them
Build a market basket analysis in Python — basket matrix, co-occurrence, lift scores, and a rule-based recommender from transaction logs.
NumPy Foundations: 30 Questions That Build Array Intuition
Learn NumPy from zero — arrays vs lists, zeros, arange, reshape, broadcasting, and vectorised operations with 30 hands-on questions.
Pandas Advanced Masterclass: Merge, Rank, and Window Functions Like SQL
Advanced Pandas — set_index, merge joins, rank vs dense_rank, shift/lead-lag, and groupby window functions mirroring SQL.
Pandas Cheatsheet: The 7 Sections Every Analyst Memorises
The Pandas cheatsheet analysts actually use — inspect, select, filter, handle nulls, sort, groupby, and merge with one-liner patterns.
Pandas Fundamentals: 40 Questions to Go From List to DataFrame
Pandas fundamentals in 40 questions — Series, DataFrame, head, dtypes, loc vs iloc, filtering, sorting, and null handling.
Pandas Master Workbook: 50 GroupBy, Aggregate, and Merge Drills
50 Pandas drills on groupby, agg, pivot tables, and merges — the repetition that makes aggregation second nature.
Python Basics Workbook: Control Flow and Functions With 20 Drills
Master Python basics — if/elif/else, for/while loops, functions, and return values — with 20 bite-size drills and solutions.