Data Analytics

Data Analytics Roadmap for Beginners in 2026

Step-by-step roadmap to become a data analyst from scratch — no prior experience needed.

Data Science vs Data Analytics vs Data Engineering

A comprehensive guide to data science vs data analytics vs data engineering — written for learners at every level.

How to Become a Data Analyst From Scratch

A comprehensive guide to how to become a data analyst from scratch — written for learners at every level.

Top 10 Data Science Projects for Your Portfolio

A comprehensive guide to top 10 data science projects for your portfolio — written for learners at every level.

Pandas for Beginners: A Complete Tutorial

A comprehensive guide to pandas for beginners: a complete tutorial — written for learners at every level.

SQL Tutorial for Beginners with Examples

Master SQL with simple examples and real-world queries. Perfect for aspiring data analysts.

How a Teacher Switched to Data Analytics in 8 Months

A comprehensive guide to how a teacher switched to data analytics in 8 months — written for learners at every level.

From Cricket Fan to Python Developer: An Illustrative Learning Journey

This is a composite illustrative journey — based on the real paths taken by many self- taught developers — showing how a passionate cricket fan used IPL data t…

From Teacher to Data Analyst: An Illustrative 8-Month Transition

This composite illustrative story follows how a secondary school maths teacher used her existing analytical skills to transition into a data analyst role — sta…

NumPy for Data Science: Arrays and Vectorisation

NumPy is the foundation of Python's scientific computing stack. This guide covers ndarrays, vectorised operations, broadcasting, linear algebra, and why NumPy…

Learn Data Science Through Bollywood Box Office Analytics

Bollywood produces hundreds of films a year and generates rich box office data. This project uses real film data to teach pandas groupby, matplotlib charting,…

SQL Tutorial for Beginners: With Real Examples

SQL is the language of data — used by data analysts, backend developers, and data scientists every day. This tutorial covers SELECT, WHERE, ORDER BY, GROUP BY,…

Matplotlib and Seaborn: Data Visualisation in Python

The best data insight is worthless if no one understands the chart. This guide covers matplotlib's core API, Seaborn's statistical plots, best practices for cl…

Scikit-Learn for Beginners: Machine Learning in Python

Scikit-learn is the most widely used Python library for classical machine learning. This guide covers the fit-predict workflow, train/test splits, classificati…

What are Window Functions in SQL?

A window function computes a value across a set of related rows (its window) for each row individually, without collapsing those rows into a single output row…

ROW_NUMBER vs RANK vs DENSE_RANK: What is the Difference?

ROW_NUMBER assigns a unique, strictly increasing integer to every row with no ties, RANK assigns the same rank to tied rows but then skips the following rank n…

What Does PARTITION BY Do in SQL?

PARTITION BY divides the rows visible to a window function into independent groups, so the function's calculation restarts from scratch for each group instead…

What are LEAD and LAG Functions in SQL?

LAG and LEAD are offset window functions that let a row directly access a column's value from a preceding row (LAG) or a following row (LEAD) within the same o…

How Do You Calculate a Running Total with Window Functions?

A running total is calculated with SUM(column) OVER (ORDER BY sequence_column), which sums the target column across all rows from the start of the window up to…