Study Plan: Pass the Certified Data Analysis Practitioner (CDAP) Exam by 20 June 2027
The goal and how I will know I reached it
Goal: Pass the Certified Data Analysis Practitioner (CDAP) exam on 20 June 2027.
Success means:
- I sit the exam on 20 June 2027 and score at or above the pass mark of 70%.
- Before the exam, I can complete two full past papers under timed conditions and score at least 75% on each β a buffer above the pass mark.
- I can answer any question in the four exam areas (data handling in SQL, spreadsheet analysis, descriptive and inferential statistics, and interpreting results) without looking anything up.
Where I start from
| Area | Current level | Gap to close |
|---|---|---|
| SQL | Basic: SELECT, WHERE, simple JOINs, GROUP BY | Window functions, subqueries, data cleaning queries |
| Excel | Basic: formulas, sorting, simple charts | Pivot tables, lookup functions, regression tool, what-if analysis |
| Statistics | None | Everything: descriptive stats, probability, distributions, hypothesis testing, correlation and regression |
| Exam technique | None | Timing, question styles, common traps |
Statistics is the biggest gap, so it gets the most hours.
Materials
- Course videos β the CDAP online course, 42 lessons across six modules, roughly 20 hours of viewing.
- Statistics textbook β Statistics for Analysts (Helena Marsh, 3rd edition), chapters 1β12.
- Past exam papers β five papers (2022β2026) with mark schemes.
- Supporting tools β a free SQL sandbox (PostgreSQL) and Excel, both already installed.
Weekly schedule
Time available: 6 hours per week, from 5 January to 19 June 2027 β 24 weeks, about 144 hours in total.
| Day | Time | Activity |
|---|---|---|
| Tuesday | 19:00β20:30 | Watch course videos and take notes (1.5 h) |
| Thursday | 19:00β20:30 | Textbook reading and practice problems (1.5 h) |
| Saturday | 09:00β12:00 | Hands-on exercises, past paper questions, review of the week's notes (3 h) |
Mondays, Wednesdays, Fridays and Sundays are free. If a weekday session is missed, it moves to the free evening in the same week, not to the next week.
Module plan
| Weeks | Dates | Module | Main sources |
|---|---|---|---|
| 1β3 | 5 Jan β 24 Jan | Module 1: Data handling and advanced SQL | Videos 1β8, SQL sandbox |
| 4β6 | 25 Jan β 14 Feb | Module 2: Spreadsheet analysis | Videos 9β15, Excel exercises |
| 7β10 | 15 Feb β 14 Mar | Module 3: Descriptive statistics and probability | Videos 16β22, textbook ch. 1β5 |
| 11β14 | 15 Mar β 11 Apr | Module 4: Distributions and hypothesis testing | Videos 23β30, textbook ch. 6β9 |
| 15β18 | 12 Apr β 9 May | Module 5: Correlation, regression and interpretation | Videos 31β38, textbook ch. 10β12 |
| 19β21 | 10 May β 30 May | Module 6: Exam practice and revision | Videos 39β42, past papers 2022β2024 |
| 22β24 | 31 May β 19 Jun | Full timed past papers (2025, 2026), weak-area review, light revision | Past papers, notes |
Week 24 is deliberately light: a final review on Saturday 12 June, then rest before the exam on Sunday 20 June.
Checkpoints
There is a checkpoint at the end of every module. Each one is passed by meeting the stated test; if not, the first Saturday of the next module is used to fix the gap before moving on.
| Checkpoint | Date | Test |
|---|---|---|
| End of Module 1 | 24 Jan | Complete 10 SQL questions from past papers with at least 8 correct |
| End of Module 2 | 14 Feb | Build a pivot-table dashboard from a sample dataset without notes |
| End of Module 3 | 14 Mar | Score 70%+ on the statistics section of the 2022 paper |
| End of Module 4 | 11 Apr | Explain p-values and confidence intervals in writing and solve 10 textbook problems |
| End of Module 5 | 9 May | Score 70%+ on the full 2023 paper (untimed) |
| End of Module 6 | 30 May | Score 75%+ on the 2024 paper under exam timing |
| Final | 12 Jun | Score 75%+ on the 2026 paper under exam timing |
Each checkpoint result is recorded in a one-page progress log with the date, the score and one sentence on what needs more work.
What to do when I fall behind
- Behind by a few days: use a free evening that week to catch up. Keep the module end date unchanged.
- Behind by up to a week: shorten the current module by skipping the optional end-of-chapter exercises in the textbook, but still do the checkpoint test.
- Behind by more than a week:
- Drop all optional exercises for the rest of the plan and do only the core video lessons, required textbook problems and past paper questions.
- Book a tutoring session with the course's tutoring service within seven days, focused on the module that caused the delay.
- Re-plan the remaining weeks so that Modules 6 and the final past papers are protected β exam practice is never cut.
- Behind at the end of Module 5 (9 May): if the 2023 paper score is below 60%, book a second tutoring session and spend the first two weeks of Module 6 on statistics only, using the 2022 and 2023 papers for revision.
The guiding rule: content can be trimmed, but the checkpoints and the last three weeks of timed practice stay fixed.