PCAD™ – Certified Associate Data Analyst with Python

The Complete Guide to the Certified Associate Data Analyst with Python

The PCAD certification — officially the Certified Associate Data Analyst with Python — is the Python Institute's associate-level credential for people who can already handle the full data analysis workflow: pulling data from real sources, cleaning it, querying it with SQL, analyzing it, and explaining what it means. If the PCED proves you know the basics, the PCAD™ certification proves you can do the job.

This guide covers the current PCAD-31-02 exam in detail — what it tests, what it costs, how it's structured, and what to expect on exam day.

Quick Facts: PCAD-31-02 Exam Overview

• Certification name: PCAD™ – Certified Associate Data Analyst with Python

• Exam code: PCAD-31-02 (current version, last revised July 14, 2025)

• Issuing body: Python Institute (OpenEDG)

• Level: Associate

• Prerequisites: None required, though PCED knowledge is strongly recommended

• Number of questions: 48 (single-select, multiple-select, and scenario-based)

• Time limit: 60 minutes

• Passing score: 75% cumulative average across all exam blocks

• Certification validity: 6 years

• Retake waiting period: 15 days

• Next step in the track: PCPD™ – Certified Professional Data Analyst with Python (in development)

What Is the PCAD Certification?

The PCAD sits in the associate tier of the Python Institute's Data Science track, one step above the entry-level PCED. Where the PCED checks whether you can handle basic, built-in-Python data tasks, the PCAD certification goes further: it tests whether you can run an end-to-end analysis using Python, SQL, and the libraries analysts actually use on the job — Pandas, NumPy, Matplotlib, and Seaborn.

This is the certification's defining feature: it's built around data analysis with Python and SQL together, not Python in isolation. A Minimally Qualified Candidate is expected to connect to real data sources — databases, spreadsheets, APIs, and even HTML pages — collect data using tools like requests and BeautifulSoup, write and organize proper Python scripts, and query relational data with SQL.

PCAD-31-02 Exam Syllabus: The 5 Domains

The exam is organized into five blocks that mirror an actual analyst's workflow:

1. Data Acquisition and Pre-Processing Collecting data from surveys, APIs, and web scraping; choosing appropriate storage (CSV, JSON, databases, data lakes, warehouses); identifying and correcting data errors, duplicates, and outliers; scaling and encoding variables for analysis.

2. Python Programming for Data Analysis Writing clean, well-documented Python using variables, functions, control flow, and core data structures (lists, dictionaries, sets); applying error handling and modular design; managing packages with pip; working with Pandas and NumPy for data manipulation.

3. Working with SQL and Databases Writing SELECT queries, filtering and aggregating data with GROUP BY, understanding JOIN concepts, and connecting Python scripts to databases for combined data analysis with Python and SQL workflows.

4. Data Analysis, Statistics, and Modeling Applying descriptive and inferential statistics, interpreting results in context, and understanding foundational modeling concepts like regression and basic model evaluation — conceptually rather than through heavy math.

5. Communicating Insights and Reporting Building charts and visualizations with Matplotlib and Seaborn, and structuring findings into summaries that different audiences (technical and non-technical) can actually act on.

Who Should Pursue the PCAD Certification?

The Certified Associate Data Analyst with Python credential is built for:

• Associate Data Analyst candidates and junior data analysts who want to prove job-ready skills, not just theoretical knowledge

• PCED-certified professionals looking to advance to the next tier

• Junior data scientists and career switchers moving into analytics roles

• Business professionals and team leads who work with data regularly and want to formalize their skills

• Anyone targeting roles where SQL and Python are both expected day one

Because Python remains the dominant language in data work — the vast majority of data scientists cite it as their primary or secondary tool — pairing it with SQL fluency through the PCAD is a practical, resume-relevant combination rather than an academic exercise.

PCAD Certification Cost

Voucher pricing for PCAD-31-02 through the official OpenEDG Voucher Store generally breaks down as:

• Exam only: around $195

• Exam + retake: around $225

• Exam + practice test: around $215

• Exam + retake + practice test: around $245

Exam vouchers are valid for 12 months from purchase and must be redeemed before expiration. Compared to the PCED, the PCAD costs more — which tracks with it being an associate-level, SQL-and-Python credential rather than an entry-level one.

PCAD Sample Question

Here's a sample question in the style you can expect on the real exam, reflecting the exam's emphasis on combined Python and SQL reasoning:

You need to retrieve the total sales amount per region from a sales table, but only for regions where total sales exceed 10,000. Which SQL clause combination correctly accomplishes this?

A. GROUP BY region HAVING SUM(sales) > 10000 B. WHERE SUM(sales) > 10000 GROUP BY region C. GROUP BY region WHERE SUM(sales) > 10000 D. ORDER BY region HAVING SUM(sales) > 10000

Correct answer: A

Explanation: WHERE filters rows before aggregation and can't reference an aggregate function like SUM(). HAVING is specifically designed to filter groups after aggregation, which is why it pairs with GROUP BY here. This kind of question is representative of the exam's SQL block — practical query logic rather than syntax memorization.

PCED vs. PCAD: Which Should You Take First?

Tools Tested

• PCED: Python built-ins only

• PCAD: Python, SQL, Pandas, NumPy, Matplotlib, Seaborn

Experience Needed

• PCED: None

• PCAD: None required, though PCED knowledge is recommended

Exam Length

• PCED: 45 minutes

• PCAD: 60 minutes

Questions

• PCED: Fewer, foundational questions

• PCAD: 48 questions, including scenario-based items

Best For

• PCED: Your first data credential

• PCAD: Job-ready associate analyst skills

Is the PCAD certification worth it?

For anyone targeting an Associate Data Analyst role, yes — it's one of the few vendor-neutral credentials that specifically validates data analysis with Python and SQL together, rather than testing them as separate skills. That combination maps closely to what junior analyst job postings actually ask for.

Do I need to pass the PCED before taking the PCAD?

No, there's no formal prerequisite. PCED knowledge is recommended because the PCAD builds on those fundamentals quickly, but candidates with existing Python and SQL experience can go straight for the PCAD-31-02 exam.

How long is the PCAD certification valid?

Six years from the date you pass, which is longer than some other entry-level Python Institute credentials that carry lifetime validity but a narrower scope.

What happens if I fail the PCAD exam?

You can retake it after a 15-day waiting period. If your voucher included a free retake, it becomes available automatically in your Exam History section once the waiting period ends; otherwise, you'll need to purchase a new voucher.

What comes after the PCAD certification?

The next step in the Data Science track is the PCPD™ – Certified Professional Data Analyst with Python, which is currently in development. In the meantime, many PCAD holders branch into specialized Python Institute tracks like Automation or Artificial Intelligence to round out their skill set.