For people who want to learn data analytics only — no Spark, no Kafka, no cloud pipelines. A crash course built the way hiring actually works in 2026: SQL-heavy, project-driven, and live. Excel, SQL, Python, Statistics and Power BI + Tableau in 18 classes — with your resume, mock interviews and job push handled after.
This track runs inside the same weekend batch as our Data Engineering cohort — same start date, same 7 AM slot, same LMS and the same instructors. You attend the analytics classes only.
4.7★ · 53 learner ratings from Cohorts 1–3 · founders @ 7-Eleven · Refund till your 2nd class, max 7 days
Cohort 1 Price
One-time payment for the complete 54-hour program.
Want 40% off? Message Durgesh on WhatsApp for the Data Analytics cohortIncluded: the starter kit and 1 month of Job Seeker, starting the day after your last class (7 December 2026)
The complete material bundle lands in your first class. Job Seeker switches on 7 December 2026 and runs for a month, so it covers the job hunt instead of running out while you are still in class. It is what the job hunt runs on: Resume Score and Rewrite My Resume, Find Jobs, Find Referrals, Auto Apply (up to 40 Naukri applications a day) and AI Mock Interviews.
One batch · five skills · three projects
Duration
2 months
3 October 2026 – 6 December 2026
Format
100% live
+ same-day recordings
Timing
Sat & Sun
7:00 – 10:00 AM IST
Level
Zero to hero
no prerequisites
Practice
Daily tasks
weekday assignments
Festival break
7–8 Nov
Diwali weekend off
Batch size
40
Small by design. Every learner gets doubt support and their projects actually reviewed.
We didn't guess the weightage. We read what employers are asking for in 2026 — including a review of 328 real Indian data analytics job descriptions — and built the hours around it.
Syllabus weightage — hours follow hiring demand, not tradition
*Rounded to whole 3-hour classes. Power BI + Tableau reaches its full 20% with the bonus recorded Tableau crash module in your repository access, and the capstone class is dashboard-first. Statistics is also woven into the Python EDA classes, where it belongs.
80%+
of data analyst postings mention SQL (Jobright, 2025–26 data)
Most analyst loops run a SQL screening round, and a weak SQL round usually ends the process on the spot. Joins across 3–4 tables, window functions for rankings and rolling metrics, and cohort-style queries are called out by name in hiring guides. That's why SQL gets 7 of 18 classes and its own end-to-end project.
81%
of 328 Indian analytics JDs list Excel (AccioJob, Jul 2026)
It appears in more JDs than any other tool — but it's also the fastest to learn to a working level. Two focused classes cover the core that companies actually use: functions, lookups, pivots, cleaning and a dashboard. Depth then shifts to SQL, where interviews are won.
41%
of those JDs ask for Python — and it signals higher pay (AccioJob)
The demand is for analyst Python: pandas, NumPy, cleaning messy data, EDA and charts — not software engineering. Four classes take you from zero syntax to a complete, GitHub-ready analysis.
43%
of Indian JDs name Power BI vs 2% for Tableau (AccioJob)
You learn Power BI deeply — Power Query, data modeling, DAX, publishing — then a Tableau bridge session plus a bonus recorded Tableau module, so your resume matches either keyword. (Globally Tableau still ranks high, which is exactly why we don't skip it.)
2 of 18
classes on the round nobody prepares for
Mean vs median, p-values, correlation vs causation and A/B testing come up in analyst interviews far more often than candidates expect. We teach the applied version, with Excel and Python, and skip the textbook derivations.
Sources read for this syllabus: AccioJob, “Most in-demand data analytics skills in 2026”, analysis of 328 job descriptions (Jul 2026) · Jobright, “The data analyst job strategy (2026)”, based on LinkedIn/Indeed posting data · Coursera, “In-demand data analyst skills” (2026) · Dataquest, “12 data analyst skills that will get you hired in 2026”. Figures are theirs, not ours — we just built the course around them.
Everything below happens live, on weekend mornings, before your day begins. Miss a class and the recording reaches you the same day. Expand a class to see exactly what it covers and what you leave able to do.
Module 1 · Excel · 10%Quest 1 of 5Starts from zero
Classes 1–2 · the tool you'll touch every single day as an analyst — learned fast, used properly.
ProofYou leave able to take a raw, messy sales sheet and turn it into a clean, summarized table.
Why it's first
Excel appears in more Indian analytics job descriptions than any other tool (81% of 328 reviewed), and it is the fastest of the five to reach a working level. Two classes, then the depth moves to SQL.
Module 2 · SQL · 40%Quest 2 of 5The core of this course
Classes 3–9 · taught on MySQL; every concept carries straight over to PostgreSQL, SQL Server and the SQL round of any interview.
Why 40%
80%+ of data analyst postings mention SQL. Most analyst loops run a SQL screening round, and a weak SQL round usually ends the process on the spot — so SQL gets 7 of 18 classes and its own end-to-end project.
Module 3 · Python · 20%Quest 3 of 5
Classes 10–13 · pandas, cleaning, EDA and charts — the Python that 41% of analytics JDs ask for, minus the software engineering you don't need yet.
Why it's here
41% of the reviewed Indian analytics JDs ask for Python, and it signals higher pay. The demand is for analyst Python: pandas, NumPy, cleaning messy data, EDA and charts — not software engineering.
Module 4 · Statistics · 10%Quest 4 of 5
Classes 14–15 · applied statistics with Excel and Python demos — built around the questions analysts actually get asked, not textbook derivations.
Why only two classes
Statistics also runs through the rest of the course — describe() and distributions inside the Python EDA project, aggregate thinking all through SQL, and metric design in the Power BI capstone. These two sessions gather it into interview shape.
Module 5 · Power BI + Tableau · 20%Final bossThe Capstone
Classes 16–18 · 9 live hours + bonus Tableau recordings · Power BI deep because Indian JDs ask for it most; Tableau bridged so no JD keyword blocks you.
Why Power BI leads
43% of the reviewed Indian JDs name Power BI against 2% for Tableau — so you learn Power BI deeply, then get a Tableau bridge session plus a bonus recorded Tableau module, and your resume matches either keyword.
Tools you'll work in — every one of them free to install
Each project is built live in class, shipped to GitHub the same weekend, and turned into a resume bullet and a LinkedIn post with our templates. This is the proof of work recruiters look for.
Class 9 · Sat 31 Oct
A multi-table store database — customers, orders, order items, products, payments, returns. You answer around 30 real business questions the way an analyst would for a founder: revenue trends, repeat purchase rate, average order value, top products, monthly cohorts and simple RFM segments.
You ship: Query file on GitHub · written findings summary · a resume bullet drafted with us in class.
Class 13 · Sat 21 Nov
A food-delivery orders dataset with all the problems real data has: missing values, broken types, duplicates, inconsistent labels. You clean it, transform it, chart it, and close with a short insight deck — what's growing, what's leaking, and what you'd tell the business to do about it.
You ship: Jupyter notebook on GitHub · 8–10 charts with written insights · a LinkedIn post draft.
Class 18 · Sun 6 Dec
From raw files to a published, interactive dashboard: Power Query cleanup, a proper star-schema model, DAX measures for YTD, month-over-month and margins, and a layout a manager could use on day one. You present it live in the final class, the same way you'd walk an interviewer through it.
You ship: Published Power BI report link · dashboard walkthrough · a project pitch script for interviews.
And beyond these three: your enrollment includes access to the 100+ project library, so once the guided builds are done you can keep adding domain projects — banking, HR, retail, marketing — in whichever direction you want your resume to point.
All classes live, 7:00–10:00 AM IST. Every recording reaches you the same day and stays with you for one year.
Diwali's main day falls on Sunday 8 November 2026, with the festival running 6–10 November — so that whole weekend is off. We're not making anyone choose between family and class.
The same LMS as the Data Engineering batch you are sitting inside, filtered to the tracks your seat covers and organised by track. Access starts the moment your payment lands.
SQL, Python, Power BI and Excel — the four tracks this seat covers — laid out in order rather than as a folder of files, so you always know what comes next.
When a class starts, the join link is on the same page you study from. No hunting through email or WhatsApp for a Zoom link at 6:58 AM.
Miss a class and the recording reaches you that day and stays for a full year. Joining after the first class? You get the recordings of every class you missed, so you can catch up with the batch. The complete back-catalogue of recorded lectures is open from day one too, so you can run ahead or revise.
All the notes, the 50+ end-to-end PDF guides and the question banks — downloadable, and yours to keep referring to.
To be exact about what this seat opens: the Excel, SQL, Python, statistics and Power BI tracks — and only those. The engineering sessions in the same batch — Spark, Kafka, Snowflake, AWS, the pipeline modules — are not part of it and will not appear in your LMS. Your progress and leaderboard rank are measured against your own tracks, so you are never scored on lectures your seat does not include. If you want those modules, the Data Engineering cohort is the seat to buy.
One fee. No upsells mid-course. The support continues after the last class, when the job hunt actually begins.
Every session live on weekend mornings, 7–10 AM IST. Recordings of all live classes free for 1 full year.
Small by design, so every learner gets doubt support and their projects actually reviewed.
Practice tasks after every class plus weekday drills, so skills build between weekends instead of fading.
The full recorded lecture library — SQL, Python, Power BI and Excel — open from the day you pay. Revise a topic or run ahead whenever you want.
Every note, question bank and guide in the PrepNPlaced notes vault, downloadable and yours to keep referring to.
Keep building after the course: guided projects across banking, retail, HR, marketing and more.
Notes, question banks and end-to-end guides, open from the day you pay.
End-to-end resume creation by our team, written to get shortlisted at top companies — not a template dump.
Full-length mocks with detailed feedback, so your first real interview isn't your first interview.
Switches on 7 December 2026 and runs for a month, so it covers the job hunt instead of running out while you are still in class. Resume Score, Rewrite My Resume, Find Jobs, Find Referrals, Auto Apply and AI Mock Interviews.
Once you finish, we find openings where your profile has a genuine shot — the applications most likely to convert to calls.
Up to 40 Naukri applications a day on Job Seeker, for the month after your last class.
The complete material bundle, handed over in the very first class.
Straight talk: no placement guarantee
Nobody can honestly guarantee you a job, and we won't pretend otherwise. What we do guarantee is the work on our side: the training, the projects, the resume, the mocks, the curated openings and the auto-applies. The interviews are yours to crack — and everything here exists to make sure you crack them.
The 7 AM weekend slot exists precisely so the course fits around college and office hours. If you can give two mornings a week plus weekday practice, you're in scope.
People who want to learn data analytics ONLY — Excel, SQL, Python and Power BI, and nothing beyond that
Final-year students and freshers who want a data analyst role
People from non-tech backgrounds — commerce, mechanical, support, operations — switching into data
Working professionals who need the skills without quitting their job — the 7 AM weekend slot exists precisely for this
Anyone who can give two mornings a week plus weekday practice
Anyone who wants the engineering stack — Spark, Kafka, Snowflake, AWS, data pipelines. None of it is in this track; the Data Engineering cohort is where it lives
Anyone looking for a passive certificate without assignments or project work
Candidates expecting a guaranteed job — we do not offer one, and say so plainly below
Founder & lead instructor
Senior Data Engineer @ 7-Eleven · ex-Target, Coforge · Instructor @ Scaler, Bosscoder, Newton School, GeeksforGeeks, Masai & Analytics Vidhya
Bosscoder
4.85/5
535 ratings · 160 learners
Live cohort teaching
Newton School
4.7/5
Python lecture series
Live lectures
Topmate
4.3/5
503 ratings · 350+ reviews
1-on-1 mentorship
Durgesh isn't just a mentor, he's more like a brother to me. His wisdom and kindness have taught me things money can't buy. I've grown so much under his guidance — he knows how to make it click for each person individually.
An amazing, eye-opening experience for anyone confused as a fresher or experienced person about what to learn or which domain to switch into. Durgesh gave a clean, clear view, understood everything with patience, and shared very useful tips to crack companies within 3-4 months.
The most informative and best session. Durgesh genuinely tries to guide you according to your preferences — his candid suggestions and precise insights are value-driven. It was an absolute delight talking to him.
The way he guides you and shows you the right path using his knowledge and experience is really amazing. You feel charged up after a chat with him. I'd really recommend this for anyone who wants to make a mark in this domain.
A wonderful and amazing session — so informative and motivating throughout. Thanks for helping me with the whole roadmap of data analytics and your guidance. I would recommend a 1-on-1 session with Durgesh!
A great conversation with Durgesh. He gave me a clear guidance path as well as free resources for self-learning. Hats off to the work you're doing for novice aspirants who want to come into this data world.
Co-founder & lead instructor
Co-Founder, PrepNPlaced · Data Engineer @ 7-Eleven · SQL, PySpark, Power BI & Excel Instructor
Bosscoder
4.9/5
127 class ratings · 83% perfect 5★
Live DSML & DE cohorts
Topmate
4.5/5
697 ratings · 518 reviews
1-on-1 mentorship
Newton School
4.8/5
Live lecture series
Live lectures
Learning with PR as my SQL trainer has been an absolute game-changer. As a complete novice I approached SQL with trepidation, but her expertise, patience and dedication transformed my experience entirely — a rare combination of deep knowledge and the ability to make it click.
Practical live lessons are very useful and the teaching method is clear and straightforward — the interview-based questions with every topic are very useful!
Had a very insightful session within a stipulated time. Her experience helps in bringing tough SQL concepts simpler even for a layman.
I like her teaching. She explains everything very well and clears every doubt.
The demo session was truly amazing — I loved it. I'm really looking forward to this course and would love to keep the session to revisit in future.
Pragya's way of teaching is so good. She explained all the topics in depth with simpler examples. JUST AMAZING.
Both instructors work with production data at 7-Eleven and teach because they're good at it — with public ratings you can go and check.
Founder · Senior Data Engineer @ 7-Eleven
Previously at Target and Coforge. Has taught 10,000+ engineers — as an instructor at Scaler, Bosscoder, Newton School, GeeksforGeeks, Masai and Analytics Vidhya, and through his own communities — plus 500+ rated 1:1 sessions. Builds most of what you see on this site.
Co-Founder · Data Engineer @ 7-Eleven
Made the switch from a non-tech background herself, which is why the teaching starts from zero. Has taught 127 live classes (rated 4.9/5) and leads the AI-Powered Data Engineering cohort.
Who teaches what: Pragya leads SQL, Excel and Power BI — the 70% of this syllabus that decides your first job. Durgesh leads Python, statistics and the three projects. Both are in the room for doubt support.
Times Square · February 2026
In February 2026, Topmate featured Durgesh & Pragya's cohorts among its High Impact Cohorts on a Times Square billboard. The clip is the billboard itself.
Career switchers from operations, electrical engineering, edtech and career gaps who moved into data roles. Every story below is on prepnplaced.com/success-stories with their name and profile.
Senthilkumar
Deloitte
From
Operations and Accounts
To
Data Analyst
Ritesh Gandhare
Infor
From
Electrical Engineering
To
Senior Data Analyst
Lipika Gupta
Target
From
EdTech Domain
To
Data Analyst
Om Rai
People INC.
From
Service Company
To
Data Analyst
Mohit Dudeja
Wells Fargo
From
Ericsson
To
Data Analyst
Sneha Kulkarni
7-Eleven
From
Career Gap
To
Data Engineer
These learners came through PrepNPlaced cohorts and 1:1 mentorship. They are not a claim about what this batch will do for you — see the no-guarantee note above.
Your seat includes 1 month of Job Seeker, starting the day after your last class (7 December 2026). That is where the resume tools, the AI mock interviews and the auto-applies run for your job hunt.
Turn your three projects into honest resume bullets the week you build them.
Check the finished resume against a real analyst job description.
Practice explaining SQL queries, dashboards and your EDA findings out loud.
Live analyst openings, filtered to what your new profile actually matches.
Warm up on SQL and Excel before Class 1, at no cost.
Twelve programmes sold in India on fee, hours, refund and placement wording, with this one in the table.
Real feedback from learners across cohorts, live sessions, and mentorship calls.
Jahnavi P
Structure
The Cohort is well structured to learn the new tools and provide an extensive platform access which helps you to boost you career.
S Venkata Sai Prudhivi Kumar
Practical Approach
I liked the structured learning and practical approach of the cohort. It made learning much easier and more engaging
Gowtham Chandrasekaran
Curriculum
Structured curriculum & learning path
Hemanth Korubilli
Small Batches
Less people per cohort like 0-30 and mic access (this is the best) and clear explanation
Naveen
Basics To Advanced
You can learn from basics to advanced topics
Prasanna G
Explanation
Topics are well explained.
Shaik Sameer Malik
Teaching
The way teaching is done.
Tanush
Experience
Teaching skills nd experience
Shanu
Depth
explain in detail
Mohan Sahu
Assignments
assignments
Ronak
Live Classes
Live class
Hamad Mohammed Bahadi
Mentors
Durgesh and Pragya have shown up, consistently, for people at their most vulnerable career moments. That kind of patience and reliability builds more than skills — it builds confidence. Still a long way to go
Darshani Teltumbade
Course Value
Honestly, I don't know what Durgesh was thinking while pricing this course. Power BI, SQL, Python, EDA, projects, interview prep — all in one super-affordable package. This is not a course, it's a full data analytics universe. Other institutes charge a fortune for half this content.
Moumita Debbarma
Big Data Session
The session on Big Data was extremely insightful. Durgesh explained complex concepts in a simple, beginner-friendly manner. I now feel much more confident about exploring Big Data further. Highly recommended for anyone starting their journey.
Shreyansh Panwar
SQL Teaching
Durgesh sir is the best teacher — the way he teaches complex SQL queries so easily is very commendable. He teaches with such ease that everyone can understand. Once you study from him, there is no looking back.
Taniya Loomba
Course Structure
I really love the structure in which the course is designed. I feel even a complete beginner can learn it very well.
Anonymous
Clarity
Durgesh explains every concept in depth and with great clarity. The session was really interesting and helpful, and it motivated me to learn even further.
Also enrolling · Cohort 4 · enrolment closes 30 October 2026
The full stack — SQL to Spark to Snowflake to Kafka to AWS, ending in Agentic AI. 192 live hours, ₹59,000, and it includes 6 months of Pro Auto-Pilot. Same batch, same weekends — the engineering cohort is simply the full syllabus rather than the analytics half of it.
4.4
Trustpilot
across all 14 reviews of prepnplaced.com
4.4
Topmate
1,190+ ratings · 850+ testimonials, both instructors
4.7★
Our cohorts
53 learner ratings from Cohorts 1–3
4.85
Bosscoder
535 ratings on live cohort teaching
“Pragya Rathi is amazing teacher for SQL”
Sat–Sun · 7 AM–10 AM IST · live. Enrolment is open till 30 October 2026. Join after the first class and you get the recordings of every class you missed. Reserve your seat and get the starter kit and the setup guide the day you join.
Batch size: 40 · Refund until your 2nd live class (max 7 days)
Want 40% off? Message Durgesh on WhatsApp for the Data Analytics cohortIn their own words
4.5 · Excellent · 21 reviews on Trustpilot4.5 out of 5 is Trustpilot’s own score across all 21 reviews. Below are 15 of them in full — every card links to the original.
The course by PrepNplaced is comprehensive, easy to understand and the notes are concise. It is must course for all serious aspirants.
Awsome, no words, learn from Durgesh and feel the difference. You will find yourself on depth level.
Very good experience with PrepNPlaced.The topics are well structured and easy to understand
Effective Platform to learn and Grow in Data Analytics Good Job Man 👍
Its a good experience learning from Durgesh.Got a chance to learn Data Modelling from Durgesh.Its a detailed session helped me to learn Business understanding and gave a perspective to understand the concepts in a detailed breakdown .
Really great using their platform, i learned a lot and used their platform bought their course and it was great
I had a Very Good learning experience. People who interested in Transition the career to Data Analyst and Data Engineering it will be helpful for them.
Prepnplaced is a best website in the market, where you can find everything in it, the courses are led by Durgesh, one of the best tutors, i strongly recommend Prepnplaced.
Prepnplaced is a good start point if you want to transition your career into data engineering or data analytics. Best tutor and best way to explain the concept.
All sessions are very helpful. Durgesh is very supportive and provide resolution with lot patience to all queries.
Awesome platform to learn and upskill. Great explanation by mentors with interactions and engaging during the live sessions. Good part is all the sessions are live and handon.
I am a non Tech Student I have never done any Tech Degree just done class 12 If I can learn from them anybody can learn instructors here are not like all instructors in big institute they are real teachers which help and support you I really Thanks Prep placed Team
…And Along with Course I got Job Hunt Product which changed the way I seek for Jobs in 2026
It's a great platform, provide you complete guidance and support. And Pragya Rathi is amazing teacher for SQL 💯
This platform has been a great support in improving my resume and interview preparation. Bringing so many valuable resources together in one place is truly commendable. Congratulations and appreciation to the entire team for their hard work and dedication.