PCAD-31-02 Certified Associate Data Analyst with Python — Exam Overview
Quick Facts
The PCAD – Certified Associate Data Analyst with Python (PCAD-31-02) is an Associate-level exam of 48 questions to be completed in 60 minutes plus NDA time, with a 75% passing score, priced from $195 (Exam + Retake from $225; Practice Test $49), valid for 6 years, in English and delivered via TestNow. It was released on July 15, 2025, replacing PCAD-31-01, and has no formal prerequisites, though PCAP and PCED are recommended.
Who this exam is for
Aspiring and practicing data analysts with Python and SQL skills who want to validate associate-level competence in acquiring, cleaning, analyzing, modeling, and communicating data.
Exam Domains
Data Acquisition and Pre-Processing — 29.2%
Covers data collection methods, ethics, anonymization, and multi-source aggregation, plus storage in warehouses, lakes, CSV, Excel, and cloud formats. It also covers cleaning and standardization including missingness mechanisms MCAR, MAR, and MNAR, imputation, normalization and scaling, encoding, outliers, validation, integrity, and extraction including web scraping with BeautifulSoup and requests.
Programming and Database Skills — 33.3%
Covers Python syntax, control flow, data structures, functions, module and PIP management, exception handling, and object-oriented programming for data modeling. It also covers SQL queries with SELECT, JOINs, WHERE, GROUP BY, HAVING, ORDER BY and LIMIT, SQL CRUD operations, and Python-database connections using sqlite3 and pymysql.
Statistical Analysis — 8.3%
Covers descriptive statistics including measures of center and spread and the interpretation of distributions and correlation. It also covers inferential statistics including hypothesis testing, p-values, and confidence intervals for drawing conclusions from samples.
Data Analysis and Modeling — 18.8%
Covers analysis with Pandas, NumPy, Matplotlib, and Seaborn, including DataFrame manipulation, grouping, merging, and handling missing values. It also covers foundational machine learning with regression, train/test evaluation, error metrics, and overfitting.
Data Communication and Visualization — 10.4%
Covers choosing and building effective visualizations for distributions, comparisons, trends, and relationships. It also covers audience-tailored reporting that leads with insights, labels measures and units clearly, and avoids misleading design choices.
Preparing for PCAD-31-02
Work through the practice questions in study mode first, read every explanation, then switch to timed practice. Weight your revision by the domain weightings above and revisit the topics you score lowest on until your practice scores are consistent.
Write Your Review on PCAD-31-02 Certified Associate Data Analyst with Python
PCAD-31-02 Customer Reviews
No reviews yet
Be the first to share your experience with this exam.