DDatalytIQsExam Competency Hub
Menu
Sign in
KASNEB · CPA PRACTICAL PAPER

CA35P Business Data Analytics

Move systematically through the syllabus, practise computer-based analytical work and track your competency development.

Create learner accountExplore the syllabus

Topics 1–3 are free. Each topic includes guided lessons, practice questions, a scored quiz and a practical assignment.

PROGRAMMECA35PKenya Accountants and Secretaries National Examinations Board
ACCESSFree tierTopics 1–3 available
ACCESSIBLE PROGRESS—Sign in and enrol to track progress
REFERENCECA35Pprovisional-2022 · confirm current examination requirements with KASNEB
STRUCTURED COVERAGE

Syllabus and learner progress

The first three topics are included in free membership. Premium topics remain visible for planning but require an active entitlement.

01
1.0 · FREE ACCESS

Introduction to Excel

available

Efficient and controlled spreadsheet use for analysis and financial modelling.

3 subtopics and learning outcomes
  1. 1.1 Excel productivity and navigationKeyboard shortcuts and efficient workbook navigation.
  2. 1.2 Excel analytical structuresData tables, pivot tables and commonly used analytical functions.
  3. 1.3 Advanced formulas and financial modelsAdvanced formulas and functions supporting robust financial models.
Learning outcomes
  • Use keyboard shortcuts efficiently
  • Analyse data with tables, pivot tables and common functions
  • Use advanced formulas and functions in financial models
Open the guided workspace and record each evidence gate.Open topic workspace →
02
2.0 · FREE ACCESS

Introduction to Data Analytics

available

Analytics foundations, data lifecycle, big data, tools and visual communication.

4 subtopics and learning outcomes
  1. 2.1 CRISP framework and data lifecycleConceptual, logical and physical models; sourcing, requirements, acquisition, recording, decision use and removal.
  2. 2.2 Big data and analytics typesBig-data definition, the five Vs and descriptive, predictive and prescriptive analytics.
  3. 2.3 Analytics technology landscapeCleaning, storage, database, cloud, reporting and visualisation tools.
  4. 2.4 Data visualisation in ExcelBenefits, comparison, composition and relationship charts, and quality principles.
Learning outcomes
  • Apply the CRISP framework
  • Explain data models and lifecycle stages
  • Distinguish descriptive, predictive and prescriptive analytics
  • Select appropriate analytics and visualisation tools
Open the guided workspace and record each evidence gate.Open topic workspace →
03
3.0 · FREE ACCESS

Core Application of Data Analytics

available

Financial reporting and financial-management analytics.

2 subtopics and learning outcomes
  1. 3.1 Financial accounting and reporting analyticsStatements, ratios, common-size and trend analysis, forecasts, scenarios and dashboards.
  2. 3.2 Financial management analyticsCash flows, time value, amortisation, NPV, IRR, sensitivity, scenarios and dashboards.
Learning outcomes
  • Prepare and analyse financial statements
  • Forecast under stated assumptions
  • Perform sensitivity and scenario analysis
  • Evaluate investments and communicate results through dashboards
Open the guided workspace and record each evidence gate.Open topic workspace →
04
4.0 · PREMIUM

Application of Data Analytics in Specialised Areas

locked

Applied analytics for management accounting, auditing, taxation and public financial management.

3 subtopics and learning outcomes
  1. 4.1 Management accounting analyticsCost estimation, pricing, margins, break-even, budgets, variances, scenarios and flexible budgets.
  2. 4.2 Audit analyticsTrend analysis, three-way matching, fraud detection, controls testing, sampling and model validation.
  3. 4.3 Taxation and public-finance analyticsTax computations, wear-and-tear schedules, public statements, budgets, debt, revenue and reporting.
Learning outcomes
  • Model costs, prices, margins, budgets and variances
  • Apply audit analytics and sampling
  • Compute tax and analyse public-sector financial information
Subscription required for this topic.Unlock programme →
05
5.0 · PREMIUM

Emerging Issues in Data Analytics

locked

Ethics, data protection, analytical limitations and adoption challenges.

3 subtopics and learning outcomes
  1. 5.1 Adoption challenges and scepticismConstraints affecting confidence in and adoption of analytics.
  2. 5.2 Ethics, security and data protectionEthical use, security safeguards and data-protection responsibilities.
  3. 5.3 Analytical tool limitationsPerformance and operational limitations within analytics tools.
Learning outcomes
  • Evaluate ethical and security risks
  • Recognise scepticism and implementation challenges
  • Assess performance limitations of analytical tools
Subscription required for this topic.Unlock programme →
ASSESSMENT CENTRE

Practise, submit and receive feedback

Each accessible topic contains dataset missions, self-check calculations, case questions, a scored quiz and an assessor-reviewed practical. The full online mock is available to learners with full programme access.

TOPIC PRACTICE

Work from source data

Complete 15 dataset missions, check 10 calculations immediately and work through 20 original cases across five topics.

30 self-checks and cases · 25 scored quiz itemsTry a calculation →
PRACTICAL WORK

Spreadsheet competency tasks

Prepare models, analyses and decision outputs against a clear assignment checklist and 20-mark rubric.

Assessor reviewedOpen an assignment →
FULL ONLINE MOCK · ASSIGNMENT

CA35P Full Online Mock · Evidence and Decision Case

180 minutes · 100 marks · pass mark 50% · two attempts available with full access.

20 decisions · 4 practicals · 100 marksOpen mock assignment →
PERFORMANCE PROFILE

Six assessable competencies

Your evidence profile will consolidate topic practice, practical submissions and mock-assessment performance.

BDA-AUD

Audit analytics

Analyse trends, three-way matching, fraud indicators, segregation of duties, samples and model validity.

BDA-FAR

Financial reporting analytics

Prepare, analyse, forecast and visualise company and group financial statements.

BDA-FM

Financial management analytics

Model time value, loan amortisation, capital projects, scenarios and dashboards.

BDA-FND

Analytics foundations

Apply CRISP, data models, lifecycle concepts, big-data principles, visualisation and emerging-issue analysis.

BDA-MA

Management accounting analytics

Estimate costs and margins; perform break-even, budget, variance and flexible-budget analysis.

BDA-TAX-PFM

Tax and public-finance analytics

Compute tax and wear-and-tear schedules; analyse public financial statements, budgets, debt and revenue.

FULL PROGRAMME ACCESS

Complete the entire CA35P preparation pathway

Unlock specialised analytics, emerging issues, all practical activities and the complete assessment pathway.

Request full access