How to Become a Data Analyst in Amritsar — Complete Step-by-Step Roadmap 2026
Amritsar mein baith ke data analyst banna possible hai kya? Not just possible — it's one of the most practical career moves available to graduates in this city right now. This guide gives you a complete, no-fluff roadmap: what to learn, in what order, how long it takes, and how to land your first job.
Let's get into it.
---
Step 0: Understand What a Data Analyst Actually Does
Before learning anything, understand the job. A data analyst's core work:
- •. Collect data — from databases (SQL), spreadsheets, APIs, or business tools
- •. Clean data — remove errors, handle missing values, standardise formats
- •. Analyse data — find patterns, trends, anomalies
- •. Visualise data — build charts and dashboards (Power BI, Tableau)
- •. Communicate insights — tell stakeholders what the data means in plain language
You are the bridge between raw data and business decisions. You're not a programmer (though you use SQL and sometimes Python). You're not a statistician (though you understand basic stats). You're a translator — converting numbers into actionable intelligence.
This is why the role is so well-suited to people with business, commerce, or science backgrounds — not just engineers.
---
Step 1: Assess Your Starting Point (1 Week)
Before diving into a course, know where you stand:
Complete beginners (no tech background): Start with Excel fundamentals before the course begins. Spend 1 week on pivot tables, VLOOKUP, basic charts. Most online resources are free (Microsoft Learn, YouTube).
Some Excel knowledge: You're ready to start the full curriculum immediately.
Engineering/BSc background: You may already know some concepts — but don't skip the foundations. Business context is what most engineers lack in data analyst roles.
---
Step 2: The Core Technical Curriculum — What to Learn and in What Order
Phase 1: Excel Mastery (Weeks 1–3) This is your foundation. Don't rush it.
Must-know Excel skills: - Data organisation — tables, named ranges, data validation - Formulas — VLOOKUP, INDEX/MATCH, IFERROR, SUMIFS, COUNTIFS - Pivot Tables — grouping, filtering, calculated fields, slicers - Power Query — loading external data, transformations, merge/append - Charts — column, line, bar, scatter, combo charts - Conditional formatting — heat maps, data bars
Practice project: Build a 12-month sales dashboard for a fictional Amritsar retail business using publicly available data.
---
Phase 2: SQL (Weeks 4–7)
SQL is how you talk to databases — and 80% of data analyst jobs require it. It's not programming; it's structured English queries.
Core SQL skills: - SELECT, WHERE, ORDER BY, LIMIT — basic data retrieval - GROUP BY + aggregate functions (COUNT, SUM, AVG, MAX, MIN) - JOINs — INNER, LEFT, RIGHT, FULL (the most important concept to master) - Subqueries and CTEs (WITH clauses) - Window functions — ROW_NUMBER, RANK, LAG/LEAD (for trend analysis) - Date functions — extracting month/year, calculating date differences
Practice with: MySQL Workbench locally, or free online SQL editors (SQLiteonline, W3Schools SQL Tryit)
Practice project: Analyse 2 years of e-commerce order data. Find: top 10 products by revenue, month-over-month growth, customer retention rate.
---
Phase 3: Power BI (Weeks 8–13)
Power BI is your primary visualisation tool and the one most employers ask for.
Power BI learning path: - Getting started — install Power BI Desktop (free), understand the interface - Connecting data — from Excel, SQL Server, MySQL, CSV, web URLs - Power Query in Power BI — data cleaning, merging tables, creating calculated columns - Data modeling — relationships between tables (star schema basics) - DAX (Data Analysis Expressions) — the formula language of Power BI - Basic: SUM, COUNT, CALCULATE, FILTER - Intermediate: DIVIDE, IF, RELATED, time intelligence (YTD, MOM) - Advanced: RANKX, TOPN, VAR statements - Visualisations — bar/line/donut charts, maps, cards, slicers, tables - Report design — page layout, colour themes, accessibility, mobile view - Publishing & sharing — Power BI Service (cloud), sharing reports, setting up automatic refresh
Practice projects: 1. HR analytics dashboard — headcount, attrition rate, salary by department 2. Financial P&L dashboard — revenue, expenses, gross margin, net profit 3. Marketing campaign analysis — channel performance, cost-per-lead, ROI
---
Phase 4: Statistics Basics (Weeks 8–10, parallel with Power BI)
You don't need advanced statistics — but you need the fundamentals:
- •Descriptive stats: Mean, median, mode, standard deviation, percentiles
- •Data distributions: Normal, skewed, understanding histograms
- •Correlation vs causation — the #1 analytical thinking trap
- •Basic hypothesis testing — understanding p-values (conceptually, not mathematically)
- •A/B testing basics — how companies test which version of a website or ad performs better
Why this matters: Interviewers at good companies WILL ask: "If our conversion rate went up by 2%, how do you know if that's statistically significant?" You need to have a sensible answer.
---
Phase 5: Tableau + Looker (Weeks 14–16)
Secondary to Power BI, but worth knowing:
- •Tableau Public (free version) — connect to Excel/CSV, build charts, publish to Tableau Public
- •Google Looker Studio (free) — build dashboards from Google Sheets, GA4, BigQuery
If you apply to companies using Tableau specifically, you'll need Tableau Desktop (paid) or Tableau Public practice.
---
Phase 6: Google Analytics 4 (Weeks 16–18, if targeting marketing analytics)
For roles in digital marketing analytics, e-commerce analytics, or SaaS: - GA4 interface — users, sessions, events, conversions - Building custom reports and explorations - Setting up goals and funnels - Connecting GA4 to Looker Studio for dashboards
---
Phase 7: Python for Analysts (Optional — Weeks 18–24)
Not required for your first job — but adds ₹2–4 LPA to your salary bracket:
- •Pandas — DataFrames, filtering, merging, groupby
- •Matplotlib / Seaborn — visualisation in Python
- •NumPy — numerical operations
- •Jupyter notebooks — the standard analysis environment
---
Step 3: Build Your Portfolio (Parallel with Learning — Months 4–6)
Your portfolio is more important than your certificate. Every project you complete should go here:
Minimum portfolio: 3 projects 1. End-to-end business dashboard — connect real data, clean it, build Power BI dashboard, publish 2. SQL analysis project — a question answered using SQL on a real public dataset (Kaggle has thousands) 3. Industry-specific project — choose your target industry (retail, finance, healthcare, SaaS) and do a focused analysis
Where to host your portfolio: - GitHub — for SQL queries and Python notebooks - Power BI Service — for published dashboards (shareable link) - Notion or a personal website — for a written case study with screenshots
Amritsar-specific project idea: Analyse publicly available data from Amritsar's Golden Temple visitor statistics, Punjab tourism data, or Punjab agricultural production data. Local relevance gets noticed.
---
Step 4: Certifications (Month 5–6)
These validate your skills and get you past ATS (Applicant Tracking Systems):
- •Microsoft Power BI Data Analyst (PL-300) — THE certification for Power BI, highly respected, ₹4,500 exam fee
- •Google Data Analytics Certificate (Coursera, ~3 months, ₹3,000–4,000/month)
- •SQL for Data Science — various free/paid certifications
PL-300 is the most valuable single certification for data analysts in India in 2026.
---
Step 5: Job Search Strategy from Amritsar
Where to Search - **Naukri.com** — "data analyst fresher Chandigarh" / "data analyst remote Punjab" - **LinkedIn Jobs** — "data analyst remote India" + filter for easy apply - **Indeed India** — "Power BI analyst" + "Mohali" or "remote" - **Company websites** — TCS, Infosys, HCL, Net Solutions careers pages
Target Roles for Freshers - Data Analyst Fresher - Business Analyst Trainee - Power BI Developer (Junior) - MIS Analyst - Reporting Analyst
Interview Preparation Most data analyst interviews have 3 rounds: 1. **Aptitude/online test** — basic stats, SQL queries, logical reasoning 2. **Technical round** — "Build a dashboard with this dataset in 30 minutes" or SQL whiteboard 3. **HR round** — communication, cultural fit, salary negotiation
Prepare 10 SQL query types (GROUP BY, JOINs, window functions) and be ready to explain your portfolio projects in detail.
---
Where to Train in Amritsar: MITS Academy
For structured, mentor-led training that covers this entire roadmap, MITS Academy's Data Analytics course is the most comprehensive option in Amritsar:
- •Location: Lawrence Road, Amritsar (also available in Jalandhar)
- •Duration: 6 months
- •Fees: ₹35,000–₹48,000 (EMI available)
- •Coverage: SQL, Excel, Power BI, Tableau, Looker, GA4, AI tools, Python intro
- •Live projects: Real business datasets, portfolio building
- •Placement support: Resume, LinkedIn, mock interviews, 50+ partner referrals
- •Track record: Multiple analytics graduates placed at Mohali product companies, remote Bangalore SaaS roles
---
Realistic Timeline: When Will You Get Hired?
| Month | Activity |
|---|---|
| Month 1–2 | Excel + SQL foundations |
| Month 3–4 | Power BI + Tableau + statistics |
| Month 4–5 | First 2 portfolio projects |
| Month 5–6 | Certifications (PL-300 prep) + capstone project |
| Month 6–7 | Job applications begin |
| Month 7–9 | First job offer (average: 8–10 weeks of active applying) |
Total timeline from zero to first job: 7–9 months for most people who put in consistent effort.
---
FAQ
Q1. What's the minimum educational qualification to become a data analyst in Amritsar? There is no strict minimum — many successful data analysts are 12th-pass students who built strong skills. That said, a bachelor's degree (any stream) makes it easier to clear HR filters at MNCs. The skills matter more than the degree.
Q2. Do I need to know programming to become a data analyst? Not for your first job. Power BI + SQL + Excel is enough for roles at ₹3.5–6 LPA. Python adds ₹2–4 LPA to your ceiling and is recommended once you're employed.
Q3. What salary can I expect in Amritsar vs Chandigarh vs remote? Amritsar local: ₹3–4.5 LPA. Chandigarh/Mohali office: ₹4–7 LPA. Remote (Bangalore/Mumbai companies): ₹6–12 LPA. Remote roles pay the most and are accessible from Amritsar.
Q4. Is Power BI better than Tableau to learn first? Power BI is the better choice for Punjab job seekers — it's used by more companies in the region, integrates with Office 365 (which most local businesses use), and has a free Desktop version for practice. Learn Tableau as a secondary tool.
Q5. How long is the MITS Academy Data Analytics course and what does it cost? 6 months, ₹35,000–₹48,000. Free demo class available. Both Amritsar and Jalandhar centres run this course.
Q6. Can I get a data analyst job while living in Amritsar without relocating? Yes — remote jobs are the norm for data analysts in 2026. Multiple MITS Academy alumni work remotely for companies in Bangalore, Hyderabad, and Mumbai while living in Amritsar.
Q7. What's the best free resource to start learning SQL before the course? SQLBolt (sqlbolt.com) and Mode SQL Tutorial are both excellent free resources. Spend 2 weeks on these before your course starts to get a head start.
---
Start Your Data Analyst Journey in Amritsar
The roadmap is clear. The demand is real. The salaries are solid. All you need is the right training and consistent effort.
Book a free demo class at MITS Academy: - Amritsar: +91-98157-11115 - Jalandhar: +91-76580-33310 - Website: mitsacademy.in
Demo completely free hai — come see the curriculum, meet the faculty, ask your questions, and make an informed decision.