Data Analytics · CP, New Delhi

Data Analytics Course in Connaught Place

From messy spreadsheets to dashboards your manager will actually open. In 4 months of live classes you'll learn Excel, stats, Python, SQL, Power BI and Tableau, a few minutes' walk from Rajiv Chowk.

  • 4 months live
  • Excel → SQL → Power BI
  • 10 industry capstones
  • Hybrid batches
  • 5-interview guarantee*
Get batch detailsSee the syllabus

Is this course for you?

If any of these sound like you, you're in the right place:

  • You're in your final year at DU and every job post seems to ask for SQL and Power BI
  • You already work near CP, in a bank, an agency or a consulting office, and spend your day in Excel without really analysing anything
  • You're switching careers and want a field where your work speaks for itself
  • You like puzzles more than presentations, but want to get good at both

The toolkit, in the order you'll learn it

Excel

IF, COUNTIF, SUMIF, VLOOKUP, pivot tables, charts and your first dashboards.

Statistics

Descriptive stats, distributions, sampling, hypothesis tests (t, z, chi-square, ANOVA) and probability.

Python

From syntax to OOP, then NumPy and Pandas for real exploratory data analysis.

Visualisation

Matplotlib, Seaborn and Plotly, including maps and 3D charts.

MySQL

SELECT to JOINs, GROUP BY, HAVING and subqueries: the questions every analyst interview asks.

Power BI & Tableau

Power Query, data modelling, DAX measures and dashboards people actually use.

Module-by-module syllabus

Taken from our Skill Degree in Data Analytics (14+ modules).

Intro to data analytics
What analytics is, how it differs from data science, and how it's used across industries.
Analytics with Excel
Formatting, calculations, automation, sorting and filtering, IF/COUNTIF/SUMIF/VLOOKUP, then pivot tables and dashboards.
Statistics for analytics
Variable types, sampling techniques, central tendency, dispersion, the normal distribution, skewness, kurtosis, hypothesis testing and the central limit theorem.
Python (basic → advanced)
Variables, data types, data structures, loops, functions, lambda/map/filter, classes and objects, file handling and exceptions.
EDA with NumPy & Pandas
Arrays, reshaping, filtering, Series and DataFrames, cleaning, merging, grouping, pivots and time-series basics.
Visualisation
Matplotlib subplots and annotations, Seaborn statistical plots, and Plotly interactive, geographic and 3D charts.
MySQL
Databases, CRUD, aggregation, GROUP BY and HAVING, joins and subqueries.
Power BI & Tableau
Data sources, Power Query, relationships, DAX basics, measures and interactive visualisations.

10 capstones across 5 industries

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

HR analytics: attrition

Find out why people quit, and what might keep them.

Sales & revenue forecasting

Predict next quarter's numbers from real data.

Customer segmentation

Group customers so marketing can stop guessing.

E-commerce order analysis

Orders, returns and delivery patterns, decoded.

About placements

Analysts get hired on proof. Your capstones and dashboards become your portfolio, and our team helps you present them.

5-interview guarantee, or we teach you free for 1 year. Placement support covers resume and LinkedIn help, mock interviews with an HR professional from naukri.com and openings on our in-house #JobCircle portal.

Honest note: placement support helps you prepare and connects you with openings; getting hired depends on your skills, effort and interviews.

*T&C apply. Ask your counsellor for eligibility.

FAQs: data analytics in Connaught Place

Do I need to know coding first?
No. Python is taught from the basics, and you'll start with Excel. Most beginners feel comfortable within a few weeks of steady practice.
Data analytics or data science: which should I pick?
Analytics is about understanding what happened and why, using Excel, SQL and BI dashboards. Data science goes further into machine-learning models. Short on time, or want a job sooner? Start with analytics.
How long does it take?
4 months of live learning, plus time to finish your capstones.
Can I study while working near CP?
Yes. We run hybrid batches, and the centre is easy to reach after office hours. Ask a counsellor for current timings.
Will I learn Power BI or Tableau?
Both. You'll learn Power BI in depth (Power Query, modelling, DAX) and Tableau for advanced visual analytics.
What does the certificate cover?
The programme has 14+ modules with globally recognised certification. A counsellor can show you sample certificates.
What are the fees and EMI options?
Ask a counsellor for the current fee and EMI options for your batch.
What happens if I'm not placed after the course?
Interviews are guaranteed. You can keep applying to openings shared on #JobCircle, and our counsellor will explain the placement support available after your course ends. If you don't clear 5 interviews, we'll coach you free for 1 year, no questions asked (T&C apply).

Drop by the CP centre

We're in Indra Palace Tower, Block H, above the Bank of India building. Come in to see a class, ask questions, or just check out where you'd be studying.

Address

2nd Floor, Indra Palace Tower, Block H, 16, Exit Gate 2, above Bank of India Building, Connaught Place, New Delhi, Delhi 110001

Call / WhatsApp

+91 98991 40180

Get directionsBook a centre visit

Stop guessing. Start analysing.

Let's find you a batch that fits around your college or your 9-to-6.

Talk to a counsellor

Explore: Skill Degree in Data Analytics · Digital Marketing Course in Connaught Place