Enrol Now for the
Full Programme
We are happy to get you started
Complete end-to-end Data Analytics training with live project placement and CPD certificate.
Program ID
training-0102
Price
£1,200
Duration
84 Hours
Program Outline
- Excel, SQL, Power BI and Python
- 84 hours total (20 taught + 64 live project)
- CPD certificate on completion
- Interview preparation and CV support
- Portfolio-ready project output
View Program Modules
Program 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