Data Analytics using Python
“From raw data to boardroom-ready insight — the complete analyst's workflow.”
A complete, hands-on, international-standard data analytics programme. Learn to collect, clean, explore, visualise and communicate data using industry tools — Python, Pandas, SQL, Power BI and Tableau — and finish with a portfolio-ready capstone. Aligned with the IBM Data Analyst and Google Data Analytics professional certificates. No prior coding experience required.
📜 Aligned with: IBM Data Analyst Professional Certificate · Google Data Analytics Certificate · BCS Data Analysis guidelines
What you'll be able to do
Course syllabus
Ten modules take you from your first line of Python to a portfolio-ready capstone. Work at your own pace.
Set up a professional analyst's environment and write clean Python for reading files, automating reports and version control.
Source data from spreadsheets, databases, web pages and live APIs, and bring it into Python for analysis.
Turn messy, inconsistent data into analysis-ready tables: cleaning, merging, grouping, reshaping and time-series handling.
Profile, summarise and uncover patterns: descriptive statistics, outliers, correlation and automated profiling.
Choose the right chart and design it well with Matplotlib, Seaborn and Plotly — then ship an interactive Streamlit dashboard.
Make confident, defensible conclusions: distributions, hypothesis testing, confidence intervals and A/B testing.
Write professional SQL — joins, subqueries, CTEs and window functions — and run it from Python with SQLAlchemy.
Frame KPIs and build executive dashboards in Power BI and Tableau; automate Excel reports with Python.
Business-focused forecasting: regression, simple classification, model evaluation and time-series forecasting — explained in plain English.
The end-to-end analytics workflow, a GitHub portfolio, case-study interviews, and your data-analyst job roadmap.
Take a real dataset end-to-end — collect, clean, explore, visualise and present — and submit a portfolio-ready project with a written report and a short recorded walkthrough.
Who this course is for
- Aspiring data analysts with little or no coding experience
- Business, finance, operations and marketing professionals who work with data
- Students and graduates building a job-ready analytics portfolio
- Excel users ready to step up to Python, SQL and BI tools