Data Analytics with Excel, SQL, Power BI & Python Professional Certificate
Build practical skills in excel for analysis, sql for business data, power bi foundations.
Programme overview
Build practical skills in excel for analysis, sql for business data, power bi foundations.
What you’ll study
01Excel for Analysis
Data cleaning, formulas, lookup functions, tables, pivots, charts and structured reporting.
Practical work: Clean and analyse a messy sales workbook.
02SQL for Business Data
Relational concepts, SELECT, filtering, joins, grouping, subqueries and data-quality checks.
Practical work: Answer a set of business questions from a relational dataset.
03Power BI Foundations
Power Query, data model, relationships, DAX basics, measures and visual design.
Practical work: Build an interactive KPI dashboard.
04Statistics & Analytical Thinking
Descriptive statistics, distributions, correlation, sampling, KPI design and avoiding misleading conclusions.
Practical work: Write an executive analysis note from a dataset.
05Python for Analytics
pandas, notebooks, cleaning, transformation, charts and reproducible analysis.
Practical work: Repeat a business analysis workflow in Python.
06Business Analytics Capstone
Problem framing, data preparation, dashboard storytelling, recommendations and presentation.
Practical work: Deliver an end-to-end dashboard and management presentation.
Tools & learning resources
- Microsoft Excel
- SQL database
- Power BI Desktop
- Python/Jupyter
- pandas
- GitHub optional
Practical projects & portfolio
- Excel analysis pack
- SQL query portfolio
- Power BI dashboard
- Analytics capstone
Who can apply?
Basic spreadsheet use and arithmetic. No prior coding required.