Chapter 01: Plan Overview, Role Understanding & Tool Setup

1. What Does a Data Analyst Actually Do?

A Data Analyst turns raw data into business decisions. The work sits at the intersection of three skills: extracting and manipulating data, analyzing it statistically, and communicating the results clearly. For a fresher, the emphasis is on the foundations — SQL, Excel, basic Python, statistics, and a visualization tool.

The core workflow

Almost every analyst task follows the same five-step loop:

Collect — pull data from databases, files, or reports.
Clean & validate — handle missing values, duplicates, and inconsistencies.
Analyze — find trends, patterns, and anomalies.
Visualize & report — build dashboards and summaries.
Recommend — translate findings into business action.

🌐

Real World: A typical first-week task might be: "Pull last quarter's branch-wise transaction summary, highlight any branch where month-over-month volume dropped more than 10%, and put it on a dashboard." That single sentence uses SQL (extraction), Excel or Python (analysis), and a dashboard tool (visualization).

📋 Stable content — Reviewed: August 2026

2. The Typical Selection Process

Most fresher Data Analyst hiring drives follow a similar sequence. Understanding what each stage actually tests lets you prepare with intention.

Stage	What It Tests	How to Prepare
1. Shortlisting	Resume, academics, relevant projects	Strong resume with 2–3 data projects
2. Technical Assessment	SQL, Excel, Python, analytics fundamentals	Core prep — sessions S02–S30
3. Technical Interview	Concept depth + hands-on problem solving	Explain concepts + practice out loud
4. Group Discussion	Communication, reasoning, teamwork	Mock GDs — session S35
5. HR Interview	Fitment, motivation, soft skills	STAR stories — session S36

📝

Note: The technical assessment is the biggest filter. Roughly 70% of your prep effort should go into SQL, Excel, and Python before you touch anything else.

📋 Stable content — Reviewed: August 2026

3. Setting Up Your Practice Environment

Set all three tools up now so you can follow along in every later session.

3.1 SQL — a free environment

You don't need to install a database server to practice SQL. Use any of these:

SQLite (DB Browser) — a lightweight, file-based database. Great for local practice.
Online practice platforms — HackerRank, LeetCode, SQLZoo, StrataScratch.
Mode.com SQL Tutorial — excellent for window functions.

3.2 Python

Install Python 3.10+ and the core data libraries:

# Create and activate a virtual environment
python -m venv da-env
# Linux/macOS
source da-env/bin/activate
# Windows
# da-env\Scripts\activate

# Install the data stack
pip install pandas numpy matplotlib seaborn jupyter

3.3 Excel & Visualization

Excel — use any recent desktop version (2019+ or Microsoft 365).
Power BI Desktop — free download, or use Tableau Public (free).

💡

Pro Tip: Track every session and problem you solve in a simple spreadsheet or notebook. At the end of 8 weeks, this log becomes your revision sheet and a great talking point in interviews.

4. Your 8-Week Roadmap

The full plan is split into five phases. Bookmark this and return to it as you progress.

Weeks	Phase	Focus
1–2	Foundations & SQL	S01–S09
3	Excel	S10–S15
4–5	Python	S16–S24
6	Statistics & Visualization	S25–S30
7–8	Business & Mock Rounds	S31–S36

Hands-On Project: Set Up Your Workspace

Before Session 02, verify your full environment works. This "project" is about removing friction now so later sessions are smooth.

Steps

Install Python and create a virtual environment (commands above).
Run python -c "import pandas; print(pandas.__version__)" — confirm no errors.
Open your SQL environment and run SELECT 1; — confirm it returns a result.
Open Excel and create a small table with 5 rows; insert a Pivot Table from it.
Write down (in your tracker) your target interview date and daily study window.

View Solution / Walkthrough

Checklist of a working setup:

# 1. Python installed?
python --version            # → e.g. Python 3.12.x

# 2. Data libraries import cleanly?
python -c "import pandas, numpy, matplotlib, seaborn; print('all good')"

# 3. SQL environment opens and runs a trivial query
#    (DB Browser / online platform) →  SELECT 1;

If all three pass, you are ready. If anything fails, fix it now — every later session assumes these tools work. A five-minute setup fix today saves an hour of frustration tomorrow.

Key Takeaways

A Data Analyst converts raw data into business decisions — collect, clean, analyze, visualize, recommend.

The technical assessment is the biggest filter — commit ~70% of prep to SQL, Excel, and Python.

Set up SQL, Python, and Excel now — every later session depends on a working environment.

The 8-week plan has five phases: SQL → Excel → Python → Statistics/Viz → Mock rounds.

Plan Overview, Role Understanding & Tool Setup

Learning Objectives