📘 DATA ANALYTICS SERIES · CHAPTER 60

Data Analyst Productivity Tools — India 2026

The tools Indian data analysts install, configure, and use daily to work faster — VS Code, DBeaver, Jupyter, Git, Notion, and Python environment management — with setup tips, keyboard shortcuts, and the exact configuration that saves 5+ hours every week.

⏱ 15 min read📅 September 2026📍 India

Your Complete Analyst Toolkit — Free, Day 1

Every tool in this guide is free to install and use. A fully capable data analyst setup — Python, SQL, version control, documentation, and BI — costs ₹0. The investment is time to set it up correctly and learn the shortcuts that make each tool fast.

ToolPurposeCostPriority
VS CodePython + SQL code editorFree⭐ Install first
DBeaver CommunitySQL client — connects to any DBFree⭐ Install first
Anaconda / venvPython environment managementFree⭐ Install first
Git + GitHubVersion control + portfolio hostingFree⭐ Install first
Power BI DesktopBI dashboards and reportsFree⭐ Install first
Jupyter / JupyterLabNotebook-style Python analysisFree (via Anaconda)Week 1
NotionDocumentation, notes, task trackingFree tierWeek 1
TablePlus or DB BrowserLightweight local SQLite toolFree tierOptional
Google ColabCloud Jupyter — no local setup neededFreeGood for beginners
PostmanTesting APIs for data ingestion workFreeIntermediate+

VS Code — The Core Analyst Environment

VS Code is the most versatile free code editor for data analysts. Install these extensions immediately after setup:

Python (Microsoft)
IntelliSense, linting, debugging for .py files. Required.
Pylance
Faster type checking and autocomplete over base Python extension.
Jupyter
Run .ipynb notebooks natively inside VS Code — no browser tab needed.
SQLTools + driver
Write and run SQL queries directly in VS Code. Supports PostgreSQL, MySQL, SQLite.
GitLens
Inline Git blame, history, and diff — see who changed what line and when.
Rainbow CSV
Colour-codes CSV columns — makes visual inspection of data files instant.
indent-rainbow
Coloured indentation guides — prevents Python indentation errors in long scripts.
Excel Viewer
Preview .csv and .xlsx files inside VS Code without opening Excel.
VS Code keyboard shortcuts every analyst should memorise
Ctrl + `Open integrated terminal
Ctrl + Shift + PCommand palette — run any command
Shift + Enter (Jupyter)Run cell and move to next
Ctrl + / Toggle comment on selected lines
Alt + ↑ / ↓Move line up or down
Ctrl + DSelect next occurrence of selection
Ctrl + Shift + KDelete current line
F2Rename variable across file

DBeaver — SQL for Every Database

DBeaver Community connects to MySQL, PostgreSQL, SQL Server, SQLite, BigQuery, Snowflake, and 80+ other databases with the same interface. Essential for analysts who work across multiple databases at different companies.

⚡
Use Script tabs, not the single query box
Ctrl + Enter runs only the query where your cursor is — so you can keep 10 queries in one file and run them individually without selecting.
⚡
Set result row limit to 1000 during exploration
Prevents accidentally fetching 10 million rows. Set in Preferences → Data Editor → Maximum result-set size.
⚡
Save connection profiles with aliases
Name connections clearly: "Prod — ReadOnly", "Staging — Full Access". Prevents running a DELETE on production accidentally.
⚡
Use Ctrl + Space for column autocomplete
After typing a table name and dot, Ctrl + Space shows all columns. Faster than alt-tabbing to the schema browser.
⚡
Export results directly to CSV or Excel
Right-click any result set → Export → CSV. Saves the open/copy/paste cycle when delivering data to a stakeholder.

Python Environment Setup — venv vs Anaconda

Anaconda
Best for: Beginners, data science heavy workflows, Windows users
✅ One installer bundles Python + Jupyter + 250 packages. No command-line knowledge needed to start.
⚠️ 3 GB install. Slower. Can conflict with pip packages. Overkill for analysts who only use 5 libraries.
venv (built-in)
Best for: Clean workflows, professional environments, VS Code users
✅ Built into Python 3. Lightweight. One venv per project — no package conflicts between projects.
⚠️ Requires command line basics. Must install each package manually with pip.
# Create a venv for a project (run in terminal)
python -m venv analytics-env

# Activate (Windows)
analytics-env\Scripts\activate

# Activate (Mac/Linux)
source analytics-env/bin/activate

# Install common analyst packages
pip install pandas numpy matplotlib seaborn scikit-learn jupyter openpyxl sqlalchemy

# Save your packages to requirements.txt (share with teammates)
pip freeze > requirements.txt

# Recreate environment from requirements.txt on another machine
pip install -r requirements.txt

Jupyter Notebook — Shortcuts That Double Your Speed

Shift + EnterRun cell, move to next
Ctrl + EnterRun cell, stay in place
A / B (command mode)Insert cell above / below
DD (command mode)Delete current cell
M (command mode)Convert cell to Markdown
Y (command mode)Convert cell to Code
EscEnter command mode from edit mode
TabAutocomplete variable or function name
Shift + TabShow function docstring / parameters
Ctrl + Shift + - Split cell at cursor
Notebook best practices for portfolio projects
  • Start every notebook with a Markdown cell: project title, objective, dataset source, date
  • Add a Markdown cell before each analysis section explaining what you are doing and why
  • Clear all outputs before committing to Git (Cell → All Output → Clear) — keeps the repo clean
  • Keep a requirements.txt in the same folder so the notebook is reproducible
  • Name cells descriptively: "1_load_data.ipynb" > "analysis.ipynb"

Git — The 7 Commands Every Analyst Needs

You do not need to master Git. Seven commands cover everything an analyst uses daily:

# 1. Create a new local repository
git init

# 2. Connect to GitHub (after creating repo on github.com)
git remote add origin https://github.com/yourusername/project-name.git

# 3. Stage changes (add all modified files)
git add .

# 4. Commit with a message
git commit -m "Add customer churn SQL analysis"

# 5. Push to GitHub (first time)
git push -u origin main

# 6. Push after first time
git push

# 7. Pull latest changes from GitHub (e.g., after editing on another machine)
git pull

# Bonus: check what has changed before committing
git status
git diff
Analyst-specific Git tip: Create a .gitignore file in every project. Add: *.csv, *.xlsx, .env, __pycache__/. Never commit raw data files with customer PII — share dataset sources in README instead.

Notion — Documentation That Gets Used

Indian data analysts who document their work stand out visibly — most do not. Notion free tier is sufficient for an individual analyst. Build these three pages and update them weekly:

Data Dictionary
Table name → column → data type → description → example value → last updated. Keeps you from re-asking "what does this column mean?" every time you return to a dataset.
⏱ 10 min to create; 2 min to update
SQL Snippet Library
Common queries you reuse: date truncation, YoY calculation, retention cohort template, deduplication pattern. Tag by database type. Saves 20+ minutes every week.
⏱ 5 min per snippet; update as you write new ones
Analysis Log
Date → request → approach → finding → recommendation → stakeholder. A searchable record of every analysis you have done. Invaluable at performance review and promotion time.
⏱ 5 min per analysis to log

Frequently Asked Questions

What software does a data analyst need on their laptop in India?

The essential toolkit for a data analyst in India: VS Code (free code editor for Python and SQL), DBeaver Community (free SQL client for any database), Jupyter Notebook or JupyterLab (Python analysis environment), Git (version control), Power BI Desktop (free), Excel with Power Query enabled, and a Python environment managed with either Anaconda or venv. All of these are free to install. The total setup takes about 2 hours.

Is VS Code good for data analysis?

Yes — VS Code with the Python, Pylance, and Jupyter extensions is now one of the most popular Python data analysis environments in India. Key advantages: free, fast, runs .ipynb notebooks natively, has a built-in terminal, excellent Git integration, and IntelliSense code completion. The main trade-off versus dedicated tools like PyCharm is that VS Code is lighter and more general-purpose, which suits analysts who switch between SQL, Python, and Markdown within one session.

Why should data analysts learn Git?

Git solves three analyst problems: (1) Version control — never lose a working SQL query or Python script because you overwrote it. (2) Portfolio — GitHub is where Indian tech hiring managers look for work samples. (3) Team collaboration — sharing analysis code via Git instead of emailing .py files is standard in product companies and startups. You do not need advanced Git — five commands cover 90% of analyst use: git init, git add, git commit, git push, git pull.

What is the best SQL client for data analysts in India?

DBeaver Community is the most versatile free SQL client for Indian analysts — it connects to MySQL, PostgreSQL, SQL Server, BigQuery, Snowflake, and SQLite with the same interface. For company-specific tools: SQL Server users often use SSMS (free, Windows only). BigQuery analysts use the Google Cloud Console query editor. For quick local SQL practice, DB Browser for SQLite is lightweight and simple.

Learn These Tools in a Live Classroom — Not Alone

Evika Academy, Noida Sector 51, teaches Python, SQL, Power BI, and Git as part of the hands-on curriculum — so you leave with a working setup, not just theory.

📱 Book Free Demo on WhatsApp
🎓 Free Demo Class — Online & Offline · Noida Sector 51