# JASANZ Certification Data Analysis Process — December 2022

## Overview
This document outlines the step-by-step process used to consolidate and analyse JASANZ certification data for the **December 2022** snapshot, covering four ISO management system standards: ISO 9001 (Quality), ISO 14001 (Environmental), ISO 45001 (OH&S), and ISO 27001 (Information Security).

---

## Step 1 — Source Data Ingestion

### Source Files
Four CSV files were obtained from the JASANZ register. The December 2022 data uses a richer schema with 16 columns (including `id`, `city`, `country`, `status`, `expiryDate`, `certificateNumber`, etc.).

### QES Standards

| File | Standard | Records |
|---|---|---|
| `CB_14001.csv` | ISO 14001:2015 (Environmental) | 6,070 |
| `CB_45001.csv` | ISO 45001:2018 (OH&S) | 6,266 |
| `CB_9001.csv` | ISO 9001:2015 (Quality) | 12,062 |

### ISO 27001

| File | Standard | Records |
|---|---|---|
| `CB_27001_1.csv` | ISO/IEC 27001 (combined) | 861 |

### Schema Normalisation
Source columns were mapped to the standard schema:
- `certificationBody` -> **CertifiedBy**
- `organizationName` -> **OrgName**
- `city` -> **City**
- `expiryDate` -> **ExpiryDate**

Remaining columns (`id`, `country`, `status`, `typeOfCertification`, `certification`, `certificationStandard`, `certificationCode`, `originalIssueDate`, `dateCertified`, `certificateNumber`, `certificateUrl`, `tradingName`) were dropped.

Note: `CB_9001.csv` did not include the `id` column but was otherwise identical in structure.

---

## Step 2 — QES Merge into Single Workbook
The three QES source files were concatenated into a single Excel workbook.

- **Output file**: `QES_Merged_Dec_22.xlsx`
- **Sheet name**: `Merged_Full`
- **Total records**: 24,398
- **Columns retained**: CertifiedBy, OrgName, City, ExpiryDate

---

## Step 3 — QES Split Data by Certification Body
The merged QES dataset contains **51 unique Certification Bodies**. Each CB was given its own sheet tab.

---

## Step 4 — QES Unique Client Count per Certification Body

### Method
- Iterated through each of the 51 CB sheets
- Extracted all `OrgName` values (Column B), stripped whitespace
- Applied deduplication (case-sensitive, exact match after trim)
- Wrote summary on each sheet in **Column M** (CB name) and **Column N** (Unique Client Count)

### Results — QES Unique Client Count by Certification Body

| # | Certification Body | Total Records | Unique Clients |
|---|---|---|---|
| 1 | SAI Global / Intertek | 3,974 | 2,578 |
| 2 | Compass Assurance Services | 2,041 | 1,095 |
| 3 | Global-Mark | 1,991 | 956 |
| 4 | Equal Assurance | 1,436 | 664 |
| 5 | QMSCS / QMS Certification Services | 1,422 | 655 |
| 6 | Best Practice Certification | 1,435 | 650 |
| 7 | Bureau Veritas Australia | 907 | 535 |
| 8 | Sustainable Certification | 932 | 514 |
| 9 | TQCSI-Yaran | 913 | 480 |
| 10 | DNV Business Assurance Australia | 774 | 440 |
| 11 | Global Compliance Certification | 824 | 400 |
| 12 | LRQA | 507 | 335 |
| 13 | Compliance Australia Certification Services | 618 | 321 |
| 14 | SGS Australia | 421 | 291 |
| 15 | Sci Qual International | 488 | 288 |
| 16 | Quality Control Services (Environmental) | 590 | 279 |
| 17 | DLCS | 603 | 269 |
| 18 | BSI Group (Australia and New Zealand) | 378 | 257 |
| 19 | ECAAS Pty Ltd | 455 | 253 |
| 20 | Business Systems Certification | 694 | 236 |
| 21 | Global Registrar of Systems | 370 | 148 |
| 22 | Management Systems Certification Global | 250 | 127 |
| 23 | QSERC | 314 | 119 |
| 24 | Southpac Certifications | 236 | 117 |
| 25 | Integrated Quality Certification | 251 | 115 |
| 26 | ATLAS Certification | 248 | 104 |
| 27 | Certifi International | 192 | 100 |
| 28 | PricewaterhouseCoopers Compliance Services | 150 | 70 |
| 29 | Certification Partner Global | 118 | 70 |
| 30 | Institute for Healthy Communities Australia | 62 | 62 |
| 31 | DQS Certification AUSNZ | 85 | 58 |
| 32 | Obsequentia | 121 | 55 |
| 33 | Certex International | 62 | 53 |
| 34 | HDAA Australia | 51 | 51 |
| 35 | BSCIC Certifications | 83 | 36 |
| 36 | Guardian Independent Certification | 68 | 34 |
| 37 | ICG Compliance | 33 | 33 |
| 38 | Global Certification | 49 | 28 |
| 39 | Adaptive Certifications | 63 | 27 |
| 40 | Ashburton Assurance Australasia | 38 | 23 |
| 41 | Global Management Certification | 52 | 20 |
| 42 | Telarc | 29 | 16 |
| 43 | ApprovalMark International | 15 | 15 |
| 44 | Intertek Certification International Sdn Bhd | 17 | 13 |
| 45 | Quantum Certification Services | 12 | 12 |
| 46 | RSHQ / Simtars | 8 | 8 |
| 47 | Certification Oceania | 5 | 4 |
| 48 | AVA Certification | 6 | 2 |
| 49 | Australasian Certification Authority | 2 | 2 |
| 50 | QMS Certification Services Pvt. Ltd. | 2 | 2 |
| 51 | ComplyNet | 3 | 1 |
| | **TOTAL** | **24,398** | **13,021** |

### Output Location in Workbook
On each CB sheet:
- **Column M, Row 1**: Header — "Certification Body"
- **Column M, Row 2**: The full Certification Body name
- **Column N, Row 1**: Header — "Unique Client Count"
- **Column N, Row 2**: The unique client count (integer)

---

## Step 5 — QES Master Summary Sheet (CB_Summary)

### Method
- Sorted all 51 entries by unique client count descending
- Created `CB_Summary` sheet as the second sheet

### Output
- **Sheet**: `CB_Summary`
- **Column A**: Certification Body (full name)
- **Column B**: Unique Client Count
- **Rows**: 51, sorted largest to smallest

---

## Step 6 — ISO 27001 Data Merge

### Source Data
| File | Records |
|---|---|
| `CB_27001_1.csv` | 861 |

### Method
- Single file loaded and normalised
- Created sheet `27001_Merged` (positioned after `CB_Summary`)
- **Total records**: 861

---

## Step 7 — ISO 27001 Split by Certification Body

### Method
- Identified **22 unique Certification Bodies**
- Created individual sheets prefixed with `27k_`

---

## Step 8 — ISO 27001 Unique Client Count per CB

### Results — ISO 27001 Unique Client Count by Certification Body

| # | Certification Body | Total Records | Unique Clients |
|---|---|---|---|
| 1 | Compass Assurance Services | 257 | 257 |
| 2 | SAI Global / Intertek | 188 | 188 |
| 3 | Best Practice Certification | 84 | 84 |
| 4 | Global Compliance Certification | 65 | 65 |
| 5 | LRQA | 45 | 45 |
| 6 | TQCSI-Yaran | 34 | 34 |
| 7 | Sustainable Certification | 31 | 31 |
| 8 | Global-Mark | 29 | 29 |
| 9 | Equal Assurance | 18 | 18 |
| 10 | DNV Business Assurance Australia | 18 | 18 |
| 11 | PricewaterhouseCoopers Compliance Services | 17 | 17 |
| 12 | QMSCS / QMS Certification Services | 16 | 16 |
| 13 | BSI Group (Australia and New Zealand) | 13 | 13 |
| 14 | DLCS | 12 | 12 |
| 15 | Sci Qual International | 11 | 11 |
| 16 | QSERC | 8 | 8 |
| 17 | Certification Partner Global | 8 | 8 |
| 18 | Business Systems Certification | 2 | 2 |
| 19 | Integrated Quality Certification | 2 | 2 |
| 20 | BSCIC Certifications | 1 | 1 |
| 21 | Bureau Veritas Australia | 1 | 1 |
| 22 | Guardian Independent Certification | 1 | 1 |
| | **TOTAL** | **861** | **861** |

### Key Observations
- The ISO 27001 market in December 2022 had 861 records with a perfect 1:1 records-to-clients ratio — every record is a unique client
- **Compass Assurance Services** leads with 257 unique clients (29.8% of market)
- **QMSCS / QMS Certification Services**, **Best Practice Certification**, and **PricewaterhouseCoopers Compliance Services** all appear — these CBs are absent from later snapshots
- **Global Certification Pty Ltd** and **QMS Certification Services Pvt. Ltd.** appear in QES but not in later snapshots
- 22 of the 51 QES certification bodies also operate in the 27001 space

---

## Step 9 — ISO 27001 Master Summary Sheet (27001_CB_Summary)

### Method
- Sorted by unique client count descending
- Created `27001_CB_Summary` sheet

### Output
- **Sheet**: `27001_CB_Summary`
- **Column A**: Certification Body (full name)
- **Column B**: Unique Client Count
- **Rows**: 22, sorted largest to smallest

---

## Workbook Structure
`QES_Merged_Dec_22.xlsx` contains **77 sheets**:
1. `Merged_Full` — QES complete dataset (24,398 records)
2. `CB_Summary` — QES master summary (51 CBs)
3. `27001_Merged` — ISO 27001 complete dataset (861 records)
4. `27001_CB_Summary` — ISO 27001 master summary (22 CBs)
5. 51 QES individual CB sheets
6. 22 ISO 27001 individual CB sheets (prefixed `27k_`)

---

## Step 10 — (Next) Further Analysis
*Pending — awaiting direction on analysis requirements.*

---

*Document generated: 2026-02-06*