Tutorial
Hands-on walkthroughs for SQL, Python, Excel and visualisation tools — every example is runnable, not a screenshot.
119 articles in Tutorial · Page 9 of 14
Relative vs Absolute Cell References in Excel (What $ Does)
Learn the difference between relative and absolute cell references in Excel. Discover what the dollar sign ($) does, when to press F4, and how to stop autofill drift.
Excel Charts for Analysts: Pick the Right Visual and Use Aggregation Intentionally
Choose the right Excel chart for the message. Learn column, line, pie, and combo visuals — and how Excel aggregates values before plotting.
Excel for Data Analysts: Interface Tour in 6 Minutes
New to Excel for analytics? Tour the ribbon, grid, formula bar, and file basics that prevent silent errors — and find the right tab in seconds.
Best Free Datasets for Data Analyst Practice
Curated list of free datasets perfect for building your portfolio. From beginner-friendly to advanced real-world data.
Market Basket Analysis in Python: Support, Confidence, Lift & Apriori Explained
Master Market Basket Analysis and Association Rule Mining in Python. Learn the mathematical intuition behind Support, Confidence, and Lift, one-hot encode transaction baskets, and implement Apriori and FP-Growth using Pandas and Mlxtend.
REST APIs for Data Analysts in Python: Authentication, Pagination & JSON Normalization
Master REST API data extraction in Python. Learn how to handle Bearer tokens and API keys, loop through offset and cursor pagination, flatten nested JSON with pd.json_normalize(), and build fault-tolerant pipelines with automatic retries.
Python Exploratory Data Analysis (EDA): The Complete Step-by-Step Workflow
Master the complete 6-stage Python Exploratory Data Analysis (EDA) framework. Learn structured data inspection, missing value imputation, IQR outlier detection, distribution analysis, correlation heatmaps, and feature profiling.
Python Pandas for Data Analysis: Getting Started Guide (2026)
Learn Python Pandas for data analysis from scratch. DataFrames, filtering, groupby, merging, data cleaning, and 5 one-liners every data analyst should know.
Product Analytics in Python: Funnel Conversion, Drop-off & User Journey Mapping
Master product funnel analysis in Python with Pandas and Plotly. Calculate step-by-step conversion rates, drop-off percentages, time-to-convert distributions, and interactive Sankey user journeys.