Data Analysis with Python and SQL
Pandas, SQL, and the workflow of a working analyst.
What you’ll learn
- SQL queries you will actually use at work
- Pandas for loading, cleaning, and transforming data
- Building a repeatable analysis workflow
- Visualisation with Matplotlib and Plotly
- Communicating findings to non-technical stakeholders
About this course
A practical data analysis course for people who want to do this for a living. We start with SQL and Pandas, move through visualisation, and end with a real project analysing Indian e-commerce data. No academic statistics — just the tools and workflow of a working analyst.
Curriculum
8 modules · 72 lessons · 24h
1SQL for analysis
2 lessons
SQL for analysis
2 lessons
Window functions, CTEs, and the queries you will write every day.
- Joins done rightPreview18 min
- Window functions22 min
2Pandas for real data
2 lessons
Pandas for real data
2 lessons
Loading, cleaning, and transforming messy data.
- Reading CSVs and Parquet14 min
- Groupby and aggregations20 min
Requirements
- Basic Python (variables, loops, functions)
- No prior SQL needed
Who this course is for
- Aspiring data analysts
- Business analysts wanting to learn Python
- Career switchers into data roles
Your tutor
Principal Data Scientist at Swiggy · Bengaluru
ML practitioner focused on recommendation systems and forecasting. Built Swiggy’s delivery-time prediction model and the menu ranking system. Teaches ML with a strong emphasis on production realities — drift, monitoring, and the boring parts that actually matter.
Student reviews
4.7
134 ratings
Sahil Verma
14 Aug 2024
Landed an analyst role
The project at the end of this course was the talking point in my interview. I got the offer and I attribute a big part of that to this course.
Frequently asked questions
Do I need a statistics background?
Which database do we use?
More in Data Science & AI
Machine Learning in Production
From notebook to deployed model — drift, monitoring, and the parts nobody teaches.
By Meera Krishnan
Forecasting and Time Series with Python
ARIMA, Prophet, and practical forecasting for business.
By Meera Krishnan