About This Programme
The same full programme at a subsidised rate through Coseng's partial scholarship scheme. Limited places — apply early.
Coseng Scholarship — you save £820 on the full price
What's Included
- ✓All content identical to Full Programme
- ✓Partial scholarship — saving £820
- ✓CPD certificate included
- ✓Interview preparation and CV support
- ✓Limited places available
Programme Modules
1
Weeks 1–6 — Excel, Power BI & Data Cleaning
- Excel: formulas, functions, VLOOKUP, INDEX/MATCH, PivotTables and dashboards
- Power BI: building reports, dashboards and Power Query
- DAX basics: calculated columns and measures
- Data cleaning and quality management with real datasets
2
Weeks 7–10 — SQL for Data Analysis
- Relational databases: tables, keys and relationships
- SELECT, WHERE, GROUP BY, ORDER BY, HAVING
- Joins: INNER, LEFT, RIGHT, FULL OUTER
- Subqueries, CTEs and window functions
- Analysing real business datasets using SQL
3
Weeks 11–16 — Python for Data Analysis
- Python fundamentals: variables, control flow and functions
- pandas: reading, exploring and transforming DataFrames
- NumPy for numerical computation
- Data visualisation: matplotlib and seaborn charts
- Automating reports and data pipelines
4
Weeks 17–20 — Machine Learning Fundamentals
- What is machine learning and where it is applied
- Supervised learning: regression and classification
- Unsupervised learning: clustering and dimensionality reduction
- Building and evaluating models with scikit-learn
- Interpreting model results and communicating findings
5
Weeks 21–24 — Advanced Analytics & Capstone
- Advanced Power BI: enterprise features, Row-Level Security and dataflows
- Combining SQL, Python and Power BI in a single workflow
- Portfolio capstone project: full end-to-end analytics case study
- Peer review and tutor feedback session
- CPD assessment, certificate submission and career guidance
Ready to enrol?
Submit an enquiry and an advisor will call you within 24 hours, or pay online to secure your place immediately.
£380one-time fee
Enrol Now