Articles

Notes on doing analytics well

Practical writing on SQL, Python, Power BI, Excel and the career side of the job.

article
Careers11 Oct 202611 min read

How to Become a Data Analyst in India: A 6-Month Roadmap

How to become a data analyst in India: a month-by-month plan for Excel, SQL, Power BI, Python, projects and job applications, with honest timelines.

Read articlearrow_forward
article
Careers9 min

Data Analyst Salary in India (2026): Fresher to Senior

Data analyst salary in India for 2026: typical fresher, mid and senior ranges by city and industry, what raises your pay, and how to negotiate better.

11 Oct 2026
article
Skills & Tools11 min

Data Analyst Skills: Technical and Soft Skills You Need

The data analyst skills Indian employers hire for: Excel, SQL, Python, Power BI, statistics and communication. See what level is enough and how to prove each.

11 Oct 2026
article
Skills & Tools11 min

SQL for Data Analysis: A Beginner's Guide with Examples

Learn SQL for data analysis with one e-commerce dataset: SELECT, WHERE, GROUP BY, JOINs, CASE, CTEs and window functions, with queries you can run today.

11 Oct 2026
article
Interview Prep11 min

Data Analyst Interview Questions and Answers: 30 to Practise

30 data analyst interview questions with model answers across Excel, SQL, statistics, case and HR rounds, plus how interviews run in India. Start here.

11 Oct 2026
article
Skills & Tools11 min

Excel for Data Analysis: Functions and Features Analysts Use

Excel for data analysis, explained on one worked sales sheet: XLOOKUP, SUMIFS, IFS, dates, pivot tables, Power Query and FILTER. Copy-ready formulas inside.

11 Oct 2026
article
Skills & Tools10 min

Python for Data Analysis: A Beginner's pandas Walkthrough

Learn Python for data analysis with pandas: load, clean, filter, group, merge and chart one small sales dataset, step by step, with code you can run today.

11 Oct 2026
article
Skills & Tools10 min

Power BI vs Tableau: Which Should Indian Freshers Learn?

Power BI vs Tableau compared on cost, learning curve, job demand in India, DAX vs calculated fields and sharing, with a clear pick for freshers.

11 Oct 2026
article
Careers11 min

10 Data Analyst Portfolio Projects for Indian Businesses

10 data analyst portfolio projects for Indian businesses, from UPI to quick commerce, with datasets, business questions, tools and how to present them.

10 Oct 2026
article
Interview Prep11 min

SQL Interview Questions for Data Analyst Roles: 20 Solved

20 SQL interview questions for data analyst roles, from joins to window functions, each with a correct answer and the traps interviewers look for.

10 Oct 2026
article
Careers9 min

Become a Data Analyst Without Coding or a Non-IT Background

Yes, you can become a data analyst without coding or a non-IT background. See which skills transfer, a 6-month plan, and honest answers to common fears.

10 Oct 2026
article
Careers9 min

Data Analyst Resume for Freshers (Template and Examples)

Build a data analyst resume for freshers section by section, with a plain-text template, ATS keywords and before-and-after project bullets you can copy.

10 Oct 2026