Skip to main content
techtonic-lab-logoTechtonic-Lab

6 months · ₹49,999 · Next batch 21 September 2026

Data Analyst Course in Nagpur — Job-Ready Training and Placement Preparation

Six months of hands-on training in Advanced Excel, SQL, Power BI or Tableau, Python and applied statistics, plus a month of corporate grooming. Classroom, online and weekend batches in Nagpur.

Isometric illustration of analytics dashboards and bar charts in the Techtonic Lab lime-on-black style

Quick facts about the Data Analytics course

Duration
6 months — 5 months training + 1 month grooming
Mode
Classroom / Online / Weekend
Next batch
21 September 2026
Fee
₹49,999 all-inclusive · EMI available
Prerequisites
None. The course opens with SQL and Excel and introduces Python gradually.
Certification
Techtonic Lab completion certificate, plus guidance towards Microsoft PL-300
Placement support
Yes — assistance, not a guarantee
Language
English, with Hindi and Marathi explanation on request
Campuses
Somalwada and Jaitala Road, Nagpur

Who it is for

Who is the Data Analytics course for?

Three groups enrol in every batch. If you do not see yourself here, say so on the call and we will tell you honestly whether this is the right route.

College students

In your final year and want a skill that gets interviews rather than another certificate on a resume. Weekend and evening batches mean you do not have to choose between this and your degree. You leave with an end-to-end project on GitHub, which matters far more to a hiring manager than your marks.

Fresh graduates

Graduated in commerce, science, engineering or arts, and analytics is the fastest route into a technical role that does not demand a computer-science degree. This is the single largest group in every batch, and the Excel-and-SQL-first sequence exists specifically for them.

Working professionals

Already pulling reports, maintaining sheets or raising tickets, and want the title and the salary that go with doing it properly. The weekend batch runs the same syllabus with the same faculty, so nothing about it is a lighter version.

Curriculum

What you will actually build, module by module

7 modules across 6 months. Every module lists the topics, the tools and the thing you finish with.

Full syllabus with hours
01

Introduction to data analysis

Weeks 1–2

Topics covered

  • What data and data analytics are, and the global scope
  • Analytics across domains, and the BI landscape
  • Understanding stakeholder vision and asking effective questions
  • Data Analyst vs Business Analyst, and the analyst road map
  • Types and methods of data analysis, and the analysis process

Tools

You finish with

Frame a real business question and design the analysis around it

02

SQL and databases

Weeks 3–7

Topics covered

  • DBMS vs RDBMS, MySQL setup, DDL/DML/DQL/TCL/DCL
  • Constraints, keys, operators and set operators
  • All join types, subqueries and correlated subqueries
  • CTEs, recursive CTEs, and window functions (rank, lead/lag, running totals)
  • Stored procedures, functions, views, cursors and triggers
  • Data modelling, ER diagrams and normalisation (1NF–BCNF)

Tools

  • MySQL
  • MySQL Workbench

You finish with

Answer a set of business questions against a normalised retail database

03

Power BI and Tableau

Weeks 8–12

Topics covered

  • Power Query editor, connections and transformations
  • Full visual library, data modelling and relationships
  • DAX: aggregation, filter, relationship, date and time-intelligence functions
  • Report filters, drill-through, row-level security and publishing
  • Tableau: connections, in-built and advanced charts, calculations and filters

Tools

  • Microsoft Power BI
  • Tableau Desktop

You finish with

Build a stakeholder-ready executive dashboard and present it live

04

Python for data analysis

Weeks 13–16

Topics covered

  • Python fundamentals, data structures, loops and functions
  • Exception handling, classes and objects
  • NumPy arrays, broadcasting and universal functions
  • pandas for reading, cleaning and manipulating data
  • Matplotlib and Seaborn for statistical and exploratory plots

Tools

  • Python
  • pandas
  • NumPy
  • Jupyter

You finish with

End-to-end exploratory analysis of a public dataset, written up as a notebook

05

Applied statistics

Weeks 17–19

Topics covered

  • Descriptive and inferential statistics
  • Population vs sample, variables and distributions
  • Hypothesis testing, Type I and Type II errors
  • T-test, ANOVA and Chi-square
  • Covariance and correlation

Tools

  • Python
  • Excel

You finish with

Design and evaluate a hypothesis test on a real dataset

06

Advanced Excel

Weeks 20–22

Topics covered

  • Lookup family — VLOOKUP, HLOOKUP, XLOOKUP, INDEX/MATCH, OFFSET
  • Data validation, PivotTables and slicers
  • Dashboard creation and formatting
  • Power Query and Power Pivot
  • Macros and VBA — subs, ranges, conditions and loops

Tools

  • Microsoft Excel
  • Power Query
  • VBA

You finish with

Build an interactive Excel dashboard from a raw export

07

Cloud bonus, capstone and corporate grooming

Month 6

Topics covered

  • Introduction to cloud services (AWS / Azure)
  • End-to-end capstone project
  • Resume and LinkedIn rebuild, GitHub portfolio
  • Three recorded mock interviews and aptitude practice
  • Salary negotiation

Tools

  • AWS / Azure
  • GitHub
  • LinkedIn

You finish with

A defended end-to-end capstone with written feedback

Portfolio

Four projects, not forty exercises

Each one is documented, reviewed and defended out loud. A hiring manager reads projects far more closely than a certificate.

01

Retail sales performance dashboard

Clean a messy multi-region sales export, model it, and build a Power BI dashboard a regional manager could actually run a meeting from.

Tools
Power Query, Power BI, DAX
Dataset
Synthetic retail transactions, 40k rows
02

Customer churn exploration

Work out which customers leave and why, using SQL to segment and Python to visualise. Ends in a written recommendation, not just a chart.

Tools
MySQL, Python, pandas
Dataset
Telecom churn, public
03

Statistical analysis report

Read a dataset properly — sample, significance, and the honest answer when the result is inconclusive.

Tools
Python, Excel
Dataset
Public survey data
04

End-to-end capstone

Take one problem from raw data through SQL, Python, statistics and a Power BI dashboard, documented and defended.

Tools
MySQL, Python, Power BI
Dataset
Your choice, guided

Careers

Where this course leads

Indicative salary bands for Nagpur and the wider Vidarbha region. These are market observations, not offers — and they move with your project quality far more than with your marks.

Roles and indicative salary ranges after the Data Analytics course
RoleEntry level2–4 years
Data Analyst₹3.0L – ₹4.5L₹6L – ₹9L
Business Analyst₹3.5L – ₹5L₹7L – ₹11L
Reporting Analyst₹2.8L – ₹4L₹5L – ₹8L
Power BI Developer₹3.5L – ₹5L₹7L – ₹12L

Who teaches it

Faculty for the Data Analytics course

The people who will actually be in the room, named, with the years behind each of them.

Meet the faculty
Sudhir Talekar, Faculty — Data Analytics & Data Science at Techtonic Lab

Sudhir Talekar

Faculty — Data Analytics & Data Science · 12+ years

Over a decade across data, business intelligence and corporate strategy. Runs the Data Analytics and Data Science tracks — from SQL, Power BI and statistics through Python, machine learning and applied AI — and mentors every learner through their capstone project.

Batch schedule

When the next intakes start

Published in advance so you can plan around a notice period or a semester.

Every batch across all three courses

21 September 2026

Open
Mode
Online
Timing
Mon–Fri, 7:00 pm – 9:00 pm
Campus
Live online
Seats left
14

29 September 2026

Open
Mode
Classroom
Timing
Mon–Fri, 4:00 pm – 6:00 pm
Campus
Somalwada
Seats left
14

18 October 2026

Open
Mode
Weekend
Timing
Sat–Sun, 10:00 am – 1:00 pm
Campus
Jaitala Road
Seats left
14

2 November 2026

Open
Mode
Online
Timing
Mon–Fri, 7:00 pm – 9:00 pm
Campus
Live online
Seats left
15

Fees

₹49,999, itemised

One price for the whole 6 months. No registration fee, no examination fee, no certificate fee, and no tier above this one.

₹49,999all-inclusive

or ₹8,334 × 6 months on EMI · no hidden charges

  • 5 months of core training
  • All learning material and datasets
  • End-to-End industry portfolio projects
  • 1 month corporate grooming
  • 3 recorded mock interviews
  • Placement preparation and referrals
Full fee breakdown and EMI terms

FAQ

Data Analytics — questions people actually ask

If yours is not here, WhatsApp it to us. We answer within the hour on working days.

How long is the data analyst course at Techtonic Lab?

The Data Analyst course runs for 6 months, covering SQL, Power BI or Tableau, Python, statistics and Advanced Excel, and ending with a cloud bonus module, an end-to-end capstone and a month of corporate grooming. Classroom, online and weekend batches all cover the same syllabus with the same faculty.

Do I need coding experience to join the data analyst course?

No coding background is required. The course begins with SQL and Excel, then introduces Python at a beginner-friendly pace. Learners from commerce and arts backgrounds complete the programme in every batch.

What is the fee for the data analyst course in Nagpur?

The fee is ₹49,999 for the complete six-month programme. A no-cost EMI is available at roughly ₹8,334 per month over six months. The fee includes all learning material, project datasets, the corporate grooming month and placement preparation. There is no separate registration, examination or certificate charge.

Which tools will I learn in the data analyst course?

SQL on MySQL, Microsoft Power BI and Tableau, Python with pandas and NumPy, and Advanced Excel including Power Query and VBA. Applied statistics runs alongside them, plus an introduction to AWS or Azure as a bonus module.

Does Techtonic Lab offer placement assistance for data analysts?

Yes. The programme includes a resume and LinkedIn rebuild, three recorded mock interviews with written feedback, aptitude practice and referrals to hiring contacts. Techtonic Lab provides placement assistance, not a placement guarantee.

What salary can a data analyst expect in Nagpur?

Entry-level data analyst roles in Nagpur and the wider Vidarbha region typically start between ₹3.0 lakh and ₹4.5 lakh per year, moving to ₹6 lakh and above with two to three years of experience. Roles with Power BI or SQL depth tend to sit at the upper end of that band.

Is a data analyst course hard to learn?

It is demanding but not mathematically hard. The real difficulty is consistency — around 6 to 8 hours of practice a week outside class. The concepts are business logic rather than advanced mathematics.

Can I attend the data analyst course online from outside Nagpur?

Yes. The fully online live batch runs the same syllabus, faculty and project reviews as the classroom batch. Students from Wardha, Bhandara, Chandrapur, Amravati and across Vidarbha attend either online or in the weekend classroom batch.

How many projects will I build?

Several across the six months, culminating in an end-to-end capstone documented on GitHub and defended in a review session. A hiring manager reads projects far more closely than a certificate.

When does the next data analytics batch start?

The next Data Analytics batch begins on 18 August 2026, with classroom, online and weekend options. Batch dates for the rest of the year are published on the batches page.

Enquire

Ask about the Data Analytics course

We call within four business hours, Monday to Saturday. No sales script — if a different route suits your background better, we will say so.

Next batch starts 21 September 2026 · Classroom / Online / Weekend

We call within 4 business hours, Monday to Saturday.

Ready to start the Data Analytics course?

Book a free 20-minute consultation, or come and sit in on a live session before you decide. Both are free and neither commits you to anything.