Domain Knowledge + Capstone Projects
The program closes by applying everything learned to a real, end-to-end analytics project — framing a business problem, working with stakeholders, and presenting a portfolio-ready case study across a real industry domain.
What You Will Learn
A detailed, industry-aligned breakdown of every topic covered in this module.
- Applying analytics to real business domains
- Framing a business problem as an analytics project
- End-to-end capstone project execution
- Data collection through final presentation
- Working with stakeholders & requirements
- Presenting findings to a non-technical audience
- Building a portfolio-ready case study
- Preparing for analytics interviews
Tools You Will Use
Hands-on time with the same tools used by working business and data analysts today.
Excel
Spreadsheet tool used for quick data analysis, calculations and lightweight reporting.
SQL
Query language used to extract, filter and aggregate data from relational databases.
Power BI
Microsoft's business intelligence platform used to build interactive dashboards and reports.
Tableau
Business intelligence platform used to build interactive, drill-down data visualizations.
Hands-On Labs
Production-style data analytics lab scenarios, built using real business datasets.
Frame a real business problem as a structured analytics project.
Collect, clean and analyse data for a domain-specific case study (retail, finance, healthcare or marketing).
Build a dashboard and report presenting the capstone project's findings.
Present the capstone project's findings to a non-technical stakeholder audience.
Prepare and rehearse answers for common data analytics interview questions.
Assessment
Knowledge Assessment
Quiz covering project framing, stakeholder management and portfolio presentation practices.
Practical Evaluation
Students must execute and present a complete, end-to-end analytics capstone project from raw data to a business recommendation.
Projects
Industry-style deliverables added directly to your project portfolio.
End-to-End Data Analytics Project (Capstone)
Take a business problem from raw data to a data-driven business recommendation.
What This Module Builds
Students apply everything learned to a real, end-to-end capstone project — building a portfolio-ready case study that demonstrates job-ready analytics skills.
Questions about Domain Knowledge + Capstone Projects
Which industries can I choose for the capstone project?
The case study is set in a real business domain such as retail, finance, healthcare or marketing. Pick the domain closest to the jobs you want, because interviewers from that sector will recognise the problem straight away.
What does the capstone cover from start to finish?
You frame a business problem as an analytics project, collect and clean the data, analyse it with Excel and SQL, build a dashboard in Power BI or Tableau, and finish with a business recommendation that you present to a non-technical audience.
How is the capstone assessed?
A quiz covers project framing, stakeholder management and portfolio presentation. The practical evaluation is the capstone itself: you take it from raw data to a business recommendation and present your findings.
Does this module help with job interviews?
Yes. One lab is set aside for preparing and rehearsing answers to common data analytics interview questions, and the finished capstone becomes a case study you can walk an interviewer through from problem to recommendation.
Can I take the capstone without the earlier modules?
It isn't designed that way. The capstone pulls together every earlier module, from Excel and SQL to dashboards and business reporting, so it runs last, over 1 week (10 hours), once those skills are in place.
