DevelopmentNew cohort every month
BeginnerLive cohort
Full-Stack Web Development
Build and deploy production web apps with React, Node.js and PostgreSQL.
10–12 hrs/week
Contact us for pricingView course
DataBeginner
Data Analytics with Python and SQL
Learn the day-to-day toolkit of a data analyst: querying databases, cleaning data in Python, building dashboards and presenting findings. Each week you work on a dataset from a different industry.
- Level
- Beginner
- Weekly effort
- 6–8 hrs/week
- Format
- Hybrid
- Next batch
- New cohort every month
What you'll be able to do
- Write SQL queries with joins, aggregations and window functions
- Clean and reshape data with pandas
- Build interactive dashboards in Power BI
- Apply basic statistics to test whether a change made a difference
- Present findings to non-technical stakeholders
Syllabus
5 modules, each with hands-on assignments reviewed by a mentor.
- 01
Spreadsheets to SQL
- Thinking in tables
- SELECT, WHERE and ORDER BY
- Joins and aggregations
- Window functions
- 02
Python for analysis
- Python essentials
- pandas for cleaning
- Merging and reshaping
- Working with dates
- 03
Statistics you will use
- Distributions and summary statistics
- Sampling and confidence
- A/B test basics
- Avoiding misleading charts
- 04
Dashboards
- Data modelling in Power BI
- Measures with DAX
- Designing a readable dashboard
- Sharing and refresh
- 05
Communicating results
- Structuring an analysis
- Writing a findings summary
- Presenting to stakeholders
- Capstone presentation
Capstone project
A retail sales analysis
Analyse a year of sales data for a multi-store retailer, build a dashboard for regional managers, and present three recommendations backed by your analysis.
Tools you'll use
SQLPostgreSQLPythonpandasExcelPower BIJupyter
Who it's for
- Students from commerce, science or engineering
- Professionals who work with spreadsheets every day
- Anyone preparing for analyst roles
What's included
- Weekly live session plus self-paced lessons
- Mentor feedback on every assignment
- Industry datasets for practice
- Lifetime access to course material
- Certificate on capstone completion
Questions About This Course
Yes. We start with SQL, which is the gentlest introduction to working with data, before moving to Python.
PostgreSQL, Python and Power BI Desktop. We walk through setup in the first session; all are free.
Yes, apart from Power BI Desktop, which is Windows-only. Mac users get access to a cloud Windows environment for the dashboard module.
You Might Also Like
AI & MLNew cohort every six weeks
IntermediateLive cohort
Applied Machine Learning
Train, evaluate and ship machine learning models on real datasets.
8–10 hrs/week
Contact us for pricingView course
AI & MLNew cohort every six weeks
AdvancedHybrid
AI Native Engineering
Build software with AI in the loop: coding assistants, LLM features and evaluation.
8 hrs/week
Contact us for pricingView course
Enrol
Join the next Data Analytics with Python and SQL batch
- A counsellor calls within one working day
- Confirm your batch before paying anything
- New cohort every month, seats capped per batch