Data Analytics · Hazratganj, Lucknow

Data Analytics Course in Lucknow | SQL, Python, Power BI

Shops, hospitals, colleges and service firms across Lucknow all run on numbers someone has to clean and explain. In 4 months at our Hazratganj centre, or online, you learn Excel, SQL, Python, Power BI and Tableau by working on real datasets.

4 months live
SQL + Python + Power BI
10 capstones
Hazratganj classroom + online
EMI via Bajaj Finance
Google 4.2★ (150 reviews)

Book a Campus Visit Request Syllabus Speak to a Counsellor

SkillCircle graduates with their certificates

Classroom at SkillCircle Hazratganj, Lucknow

Where: 2nd Floor, Hala Complex, 19-A Ashok Marg, opposite Ritz Continental, Hazratganj
Hours: 10:00 AM to 7:30 PM, all 7 days
Modes: Classroom and live online batches
Duration: 4 months of live classes (Skill Degree in Data Analytics)
Why SkillCircle: Founded 2016 · 74,356+ students trained · 15+ centres in 10 states · 750+ hiring partners · Best Vocational Institute 2026 (Entrepreneur India), presented by Union Minister Piyush Goyal

Visit us

Visit us at Hala Complex

Walk in for counselling and a look at the classroom. The Gomti Nagar centre is closed; Hazratganj is our Lucknow centre.

Address & contact

Address2nd Floor, Hala Complex, Plot No. 1, 19-A Ashok Marg, Sapru Marg, opposite Ritz Continental Restaurant, Hazratganj, Lucknow, Uttar Pradesh 226001
AreaHazratganj, Lucknow (Ashok Marg, opposite Ritz Continental; Hazratganj metro station on the Red Line)
Phone+91-7800574005
Hours10:00 AM to 7:30 PM, all 7 days

Book a Campus Visit Get Directions Speak to a Counsellor

Campus

Inside our Lucknow centre

The building, reception, classroom and team at Hazratganj.

SkillCircle Lucknow centre building and signboard in Hazratganj — The building and signboard in Hazratganj

Reception area at the SkillCircle Lucknow centre in Hazratganj — Reception

Classroom session at SkillCircle Lucknow, Hazratganj — A classroom session in progress

Students celebrating together at SkillCircle Lucknow, Hazratganj — Students celebrating at the centre

SkillCircle Lucknow team with students at the Hazratganj centre — Our team with students

Getting here

Analytics learners come in from across Lucknow

Hazratganj station on the Lucknow Metro Red Line is the closest, with direct rides from Charbagh, Indira Nagar, Munshi Pulia and Alambagh.

Hazratganj metroHazratganj station on the Lucknow Metro Red Line. The centre is on Ashok Marg, opposite Ritz Continental Restaurant.
CharbaghRed Line from Charbagh to Hazratganj.
Indira Nagar & Munshi PuliaRed Line towards Charbagh and get off at Hazratganj.
Alambagh & the airport sideRed Line via Charbagh to Hazratganj.
Gomti NagarOur Gomti Nagar centre is closed. Classroom batches run at Hazratganj, so come by road or ask the counsellor for the best route.
Kanpur, Prayagraj & VaranasiLearners from these cities usually join the live online batches.

Call +91-7800574005 for directions.

Why Lucknow

Analytics, Lucknow style

From Gomti Nagar reviews to Aminabad shop floors, Lucknow businesses make plenty of decisions on gut feeling, and the ones that start tracking numbers get an edge. An analyst who can build a clean dashboard and explain it in plain Hindi or English is useful in more places than people expect.

The Hazratganj centre suits college students, freshers and people who work nearby, and the live online batches suit learners from Kanpur, Prayagraj and Varanasi. We do not publish Lucknow hiring numbers we cannot verify.

Who it’s for

Who joins data analytics in Lucknow

Non-IT graduates do well when they practise consistently.

Commerce & BBA graduates

Numbers-comfortable freshers

Turn Excel habits into SQL and BI skills with a portfolio of 10 capstones.

Working professionals

Accounts, sales and operations

Add SQL and dashboards to your profile without leaving your job.

Business owners

Shops and service firms

Read your own sales data properly.

Student value

What analytics students get at Hazratganj

Classroom, 10 capstones and practical interview prep.

Classroom

Hala Complex, Hazratganj

Classroom batches plus online; ask which are running.

Tools

Excel to Tableau

Excel, statistics, Python, MySQL, Power BI, Tableau.

Portfolio

10 capstones

Two each from BFSI, FMCG, healthcare, automobile and entertainment.

Interview prep

HR from naukri.com

SQL and case questions drilled before you apply.

National backing

15+ centres · since 2016

74,356+ students trained and 750+ hiring partners across SkillCircle.

Community

#JobCircle

Openings shared on our job portal.

Book a Campus Visit Request Syllabus

the vibe check

How analytics runs at the Lucknow centre

Six things worth knowing before you sign up.

IRL or online

Classroom or live online

Same syllabus whether you sit in class or log in, with recordings when you miss a day.

Order matters

Excel first, then SQL

You build up from spreadsheets to SQL, Python and BI tools, one month at a time.

BI tools

Power BI and Tableau

Power Query, modelling and DAX in depth, and Tableau for advanced visuals.

Portfolio fuel

10 capstones

Two each from BFSI, FMCG, healthcare, automobile and entertainment.

Office-friendly

Hybrid batches

Batch timings that fit around college or office hours; ask the counsellor what is open.

Interview-ready

SQL and case practice

The SQL and case questions analyst interviews keep asking, drilled before you apply.

Compare

SkillCircle Lucknow or another route?

If you are weighing a recorded course or another institute against us, this is how the options usually differ.

	SkillCircle	Typical online-only course	Typical local institute
How classes run	Classroom batches at our Hazratganj centre, plus live online batches	Recorded videos you watch on your own	Classroom only, usually one fixed batch
Doubts	Ask the trainer in class or in the live session	Mostly forums or email	Depends on the trainer
Practice	10 industry capstones across 5 sectors	Often self-checked assignments	Varies
Placement support	Resume help, mock interviews and openings on #JobCircle, our in-house job portal	Usually a job board, or none	Varies, often informal referrals
Fee	₹40,000 – ₹1,60,000 depending on the programme; EMI through Bajaj Finance	Often the cheapest option	Varies

Online-only courses suit people who are self-driven and need full flexibility. If you want fixed class hours and a trainer you can ask in person, a centre helps. Choose what fits how you learn.

Programmes

Data Analytics programmes

Open a programme page for the full syllabus. A counsellor can tell you which intake is open at your centre.

4 months · 14+ modules

Skill Degree in Data Analytics

For: students, B.Com/BBA/BSc grads and anyone who lives in Excel. Excel, statistics, Python, SQL, Power BI and Tableau, with 10 industry capstones.

10–12 months · executive

Executive Certification in AI-Native Data Science & Analytics

For: working professionals who want the longer route, run in collaboration with IIT Patna Vishlesan I-Hub Foundation.

Syllabus

Data Analytics course curriculum

7 blocks from our main data analytics course page. Pick a module to see what it covers.

Download curriculum

Modules: 14+
Duration: 4 months
Capstones: 10
Mode: Classroom + live online

Excel for analytics

Module 1 of 7

Formatting, sorting, filtering
IF, COUNTIF, SUMIF, VLOOKUP
Pivot tables and dashboards

#LearnByDoing

Projects and tools. Work you can show.

Capstones you can walk an interviewer through, built with the tools teams use.

Project 1

HR analytics: attrition

Find out why people quit and what might keep them

Tools

Excel
Power BI

Project 2

Sales and revenue forecasting

Predict next quarter from real data

Tools

Python
Pandas

Project 3

Customer segmentation

Group customers so marketing stops guessing

Tools

Python
SQL

Project 4

BFSI sector analysis

Banking and finance data, sliced the way analysts do it

Tools

SQL
Tableau

Project 5

Supply chain demand forecasting

Predict demand so inventory is not a guess

Tools

Excel
Python

Project 6

Review sentiment analysis

What customers actually think, measured

Tools

Python

Project 7

E-commerce order analysis

Orders, returns and delivery patterns

Tools

SQL
Power BI

Project 8

Inventory management report

The report ops teams check every morning

Tools

Excel
Power BI

Projects and their depth vary by programme and batch.

Tools you will use

Excel
Python
NumPy
Pandas
MySQL
Power BI
Tableau
Matplotlib
Seaborn
Plotly

Roles this prepares you for

Data Analyst
Business Analyst
MIS Analyst
BI Developer
Reporting Analyst

The certificate you take home

Complete the Skill Degree in Data Analytics and you receive a SkillCircle certificate of completion. On the executive programme, the certificate is issued with IIT Patna Vishlesan I-Hub Foundation; the sample below shows that layout.

Sample certificate of completion from SkillCircle and IIT Patna Vishleshan I-HUB Foundation — Sample template. Your name, programme and dates go in the blanks.

Two SkillCircle graduates holding framed certificates at a convocation — SkillCircle graduates with their certificates at a convocation.

Fees

Data analytics course fees in Lucknow and EMI

Fees for SkillCircle programmes run from ₹40,000 – ₹1,60,000 depending on the programme. EMI options are available through Bajaj Finance. Ask the Lucknow counsellor for the exact fee for the Skill Degree in Data Analytics and the current batch dates.

Ask the counsellor for the exact fee

Timings

Analytics batches in Lucknow: weekday and weekend

We run weekday and weekend batches, in the classroom and live online. Exact timings change with each intake, so ask the Lucknow counsellor which ones are open.

Batches

Upcoming batches

Batch	Start date	Timing	Mode / Centre	Action
Ask a counsellor for the next start date at your centre. Ask a counsellor

Don’t see a timing that works for you? Talk to our admissions team about classroom or online batches, or see all upcoming batches.

Book a Campus Visit

Videos

See SkillCircle before you visit

Videos from SkillCircle’s own channel and student videos from our convocations. They load only when you press play.

From Data Science to Digital Marketing: Mr. Shubham's amazing journey | Chit Chat with Skillers Ep. 9

SkillCircle convocation — A SkillCircle learner talks about the course

Messages

Messages from our students

Real WhatsApp messages SkillCircle learners sent to founder Shivam Ahuja. These three studied digital marketing with us; they are shown with permission and names as they wrote them.

WhatsApp message from SkillCircle student Shalu to founder Shivam Ahuja saying she got her first job — Shalu messaged to say she landed her first job.

WhatsApp message from SkillCircle student Aniket Sharma to founder Shivam Ahuja about starting his own digital marketing agency — Aniket Sharma told us he started his own digital marketing agency.

WhatsApp thank-you message from SkillCircle student Divyansh Rajput to founder Shivam Ahuja, with an offer letter for a Marketing Head role with the company name redacted — Divyansh Rajput shared a thank-you note and an offer letter for a Marketing Head role (company name redacted).

Placement support, in writing

Last-mile preparation in 3 stages

Placement support: the final stretch before interviews, your profile, your pitch and proof that you can do the job.

Resume

Shaped around your projects and capstones.

A profile that matches the roles you are applying for.

Portfolio

Your capstones, notebooks, dashboards and certificates in one place.

Certifications

Certificates from your programme, listed the way recruiters read them.

Track record

Recognition and track record

SkillCircle founder Shivam Ahuja with Union Minister Piyush Goyal — Shivam Ahuja, SkillCircle founder, receiving a recognition for AI education from Union Minister Piyush Goyal.

Best Vocational Institute 2026 from Entrepreneur India, presented by Union Minister Piyush Goyal
Teaching since 2016, now with 15+ centres in 10 states
74,356+ students enrolled so far
Our homepage lists NASSCOM and Vishleshan i-Hub (IIT Patna) among SkillCircle's industry associations. IBM and Meta certifications are available on selected programmes; ask the counsellor which ones come with your course.

Ministry of Skill Development and Entrepreneurship

Also on the SkillCircle faculty

Trainers who teach our data science and data analytics courses.

Prashant SrivastavaData Science & Analytics Trainer
Aakash VermaData Science & Analytics Trainer
Divyanshu GuptaData Science & Analytics Trainer
Roshan JhaData Science & Analytics Trainer
Mauwaz Ahmed FarooquiData Science & Analytics Trainer
Gaurav NarwalData Science & Analytics Trainer (Freelance)
Krishna AroraAssociate Trainer, Data Science & Analytics
Akshay GujareAssociate Data Analyst

Placement support

Placement support, plainly put

Placement support helps you prepare and connects you with openings on #JobCircle, our in-house job portal; getting hired depends on your skills, effort and interviews. Ask the Lucknow counsellor how interview support works for your batch.

FAQs

Questions about the data analytics course in Lucknow

Are classes offline in Lucknow?

Yes, at our Hazratganj centre in Hala Complex, and we also run online batches. Ask the counsellor which batch is open.

Where exactly is the centre?

2nd Floor, Hala Complex, Plot No. 1, 19-A Ashok Marg, Sapru Marg, opposite Ritz Continental Restaurant, Hazratganj, Lucknow 226001.

Is the Gomti Nagar centre open?

No, it is closed. Everything runs from Hazratganj.

Which metro station is nearest?

Hazratganj on the Lucknow Metro Red Line. Call +91-7800574005 for the easiest route.

What are the centre hours?

10:00 AM to 7:30 PM, all 7 days.

I live in Indira Nagar. How do I get there?

Take the Red Line towards Charbagh and get off at Hazratganj.

Can a non-IT graduate become a data analyst?

Yes. The course starts with Excel and basic statistics before Python and SQL.

SQL or Python first?

You learn both. SQL gets your data out, Python (Pandas) helps you clean and analyse it. Most interviews test SQL first.

Power BI or Tableau?

Both: Power BI in depth (Power Query, DAX, modelling) and Tableau for advanced visuals.

How long is the course?

4 months of live learning.

What placement support is there?

Interview prep with an HR professional from naukri.com, resume reviews and openings on #JobCircle. Hiring depends on your skills, effort and interviews.

Fees?

₹40,000 to ₹1,60,000 depending on the programme, with Bajaj Finance EMI. Ask the Lucknow counsellor for the exact fee.

Explore more