Become a Data Analyst

Data Analytics

Work through 12 real Indian business projects across FMCG, e-commerce, fintech, retail, and agriculture. The data is messy. The questions are open-ended. You decide the approach.

7 months

12 Projects + 2 Capstones

Live Course

ExcelPower QuerySQLPythonPandasNumPySeabornMatplotlibStatisticsPower BITableau

Roles you'll be ready for

Data AnalystBusiness AnalystBI AnalystReporting AnalystMIS Analyst

Industry range: ₹4–8 LPA(fresher, India — market benchmark, not a guarantee)

Modules

Duration

7 months

Mode

Live Online

Projects

12 Projects + 2 Capstones

Support

Career Prep

Curriculum

10 modules. Each module includes a hands-on project. The final module contains your capstone assignments.

🚀 Opening Weeks

Opening Weeks — Python & SQL Foundations

18Topics

No prior coding knowledge assumed. These four weeks build the Python and SQL foundation the entire track runs on.

Installing Anaconda and launching Jupyter Notebook — the analyst's working environment

Variables — integer, float, string, boolean — and why data types matter for data work

if, elif, else — conditional logic; comparison operators: ==, !=, >, <, >=, <=

for loop, while loop, range(), break, continue — repeating operations across data

Defining functions with def, parameters, return, default argument values

Lists — indexing, slicing, append(), remove(), len(), list comprehensions

Dictionaries — key-value access, nested dicts, iteration

File I/O — reading a CSV with open(), writing output to a file

pip install, import — installing and using libraries; try/except for error handling

What is a relational database — tables, rows, columns, primary and foreign keys

SELECT, FROM, WHERE — filtering with all comparison and null operators

ORDER BY, LIMIT, DISTINCT; COUNT, SUM, AVG, MIN, MAX

GROUP BY, HAVING — and the common mistake of using WHERE when you need HAVING

INNER JOIN, LEFT JOIN — understanding the ON clause and what each row represents

CASE WHEN — conditional logic inside a query; COALESCE for null handling

Subqueries in WHERE; WITH clause (CTE) — naming a subquery and reusing it

Top N per group pattern, period comparison patterns

Connecting Python and SQL — sqlite3, loading query results into a DataFrame

Module 1

Foundations of Data & Excel

1 Sample Project20Topics

The foundation every analyst uses on day one. Covers data literacy and Excel from core functions through Power Query — the skill that separates manual work from automated workflows.

Module 2

SQL for Data Analysis

1 Sample Project16Topics

Business-driven SQL from fundamentals through window functions and CTEs. Covers the exact interview patterns that appear at Indian analytics companies.

What you will learn

Clean and transform messy real-world datasets using Excel Power Query and Python Pandas

Write business-driven SQL queries — CTEs, window functions, query optimisation

Perform structured exploratory data analysis and communicate findings in plain language

Apply A/B testing, cohort analysis, and RFM segmentation to real business problems

Build Power BI dashboards with DAX, data modelling, and Power BI Service publishing

Create and publish Tableau dashboards with a live Tableau Public portfolio URL

Use modern productivity tools within the analyst workflow accurately and responsibly

Structure and deliver insights in executive summaries and stakeholder presentations

Job outcomes

Data AnalystBusiness AnalystBI AnalystReporting AnalystMIS Analyst

Industry range:₹4–8 LPA

Frequently asked questions

Ready to start your Data Analytics journey?

Attended and not satisfied? Apply for a full refund within 7 days of purchase.