# JASANZ Certification Data Analysis Process — December 2023

## Overview
This document outlines the step-by-step process used to consolidate and analyse JASANZ certification data for the **December 2023** 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
Two data files were obtained from the JASANZ register. The December 2023 data is the earliest snapshot in this analysis series and uses a different column naming convention.

| File | Format | Standards Covered | Records |
|---|---|---|---|
| `Jasanz raw data - QES.csv` | CSV | ISO 9001, ISO 14001, ISO 45001 (combined) | 27,501 |
| `Jasanz raw data - 27001.xlsx` | XLSX (no header) | ISO/IEC 27001:2013, 27001:2022, 5377 | 1,218 |

### Schema Normalisation
The QES CSV used different column names:
- `name` -> **CertifiedBy**
- `company` -> **OrgName**
- `scopes` -> **Scope**
- `status` -> (dropped — all records are "Active")

The 27001 XLSX had no column headers — headers were assigned programmatically.

Note: `City` and `ExpiryDate` were not available in the December 2023 source data.

### QES Scope Breakdown
| Scope | Records |
|---|---|
| iso9001 | 12,903 |
| iso45001 | 7,784 |
| iso14001 | 6,814 |
| **Total** | **27,501** |

### 27001 Scope Breakdown
| Scope | Records |
|---|---|
| iso27001:2013 | 998 |
| iso27001:2022 | 175 |
| iso5377 | 45 |
| **Total** | **1,218** |

---

## Step 2 — QES Merge into Single Workbook
The QES data was already provided as a single combined file. It was loaded directly into the workbook.

- **Output file**: `QES_Merged_December_23.xlsx`
- **Sheet name**: `Merged_Full`
- **Total records**: 27,501

---

## Step 3 — QES Split Data by Certification Body
The QES dataset contains **49 unique Certification Bodies**. Each CB was given its own sheet tab. The `Merged_Full` sheet was preserved unchanged.

---

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

### Method
- Iterated through each of the 49 CB sheets
- Extracted all `OrgName` values (Column B), stripped whitespace
- Applied deduplication using a set (case-sensitive, exact match after trim)
- Wrote summary on each sheet in **Column M** (Certification Body 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 | 4,037 | 2,522 |
| 2 | Compass Assurance Services | 2,340 | 1,216 |
| 3 | Global-Mark | 2,160 | 974 |
| 4 | Equal Assurance | 1,838 | 777 |
| 5 | Best Practice Certification | 1,570 | 685 |
| 6 | QMSCS / QMS Certification Services | 1,524 | 675 |
| 7 | Sustainable Certification | 1,447 | 562 |
| 8 | Bureau Veritas Australia | 976 | 556 |
| 9 | TQCSI-Yaran | 978 | 512 |
| 10 | Global Compliance Certification | 991 | 462 |
| 11 | DNV Business Assurance Australia | 768 | 412 |
| 12 | ECAAS Pty Ltd | 743 | 371 |
| 13 | LRQA | 555 | 347 |
| 14 | SGS Australia | 613 | 328 |
| 15 | Compliance Australia Certification Services | 718 | 323 |
| 16 | BSI Group (Australia and New Zealand) | 484 | 308 |
| 17 | Sci Qual International | 499 | 288 |
| 18 | DLCS | 678 | 286 |
| 19 | Business Systems Certification | 800 | 271 |
| 20 | Quality Control Services (Environmental) | 479 | 227 |
| 21 | Global Registrar of Systems | 396 | 159 |
| 22 | ATLAS Certification | 383 | 152 |
| 23 | QSERC | 381 | 148 |
| 24 | Management Systems Certification Global | 259 | 120 |
| 25 | Certifi International | 225 | 115 |
| 26 | Integrated Quality Certification | 246 | 112 |
| 27 | Certification Partner Global | 142 | 75 |
| 28 | Adaptive Certifications | 182 | 74 |
| 29 | JAS-ANZ Demonstration Services | 134 | 70 |
| 30 | PricewaterhouseCoopers Compliance Services | 134 | 68 |
| 31 | Certex International | 70 | 60 |
| 32 | Obsequentia | 136 | 59 |
| 33 | DQS Certification AUSNZ | 86 | 55 |
| 34 | Guardian Independent Certification | 95 | 48 |
| 35 | HDAA Australia | 48 | 48 |
| 36 | BSCIC Certifications | 82 | 35 |
| 37 | Global Management Certification | 81 | 30 |
| 38 | Ashburton Assurance Australasia | 47 | 27 |
| 39 | ICG Compliance | 27 | 27 |
| 40 | ApprovalMark International | 20 | 18 |
| 41 | Quantum Certification Services | 14 | 14 |
| 42 | Telarc | 21 | 13 |
| 43 | Certification Oceania | 17 | 11 |
| 44 | Intertek Certification International Sdn Bhd | 13 | 11 |
| 45 | QMS International Certifications | 23 | 9 |
| 46 | RSHQ / Simtars | 9 | 9 |
| 47 | ComplyNet | 15 | 5 |
| 48 | AVA Certification | 13 | 5 |
| 49 | Australasian Certification Authority | 4 | 3 |
| | **TOTAL** | **27,501** | **13,682** |

### 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
- Extracted CB name and unique client count from each CB sheet (Column M/N, Row 2)
- Sorted all 49 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**: 49, sorted largest to smallest

---

## Step 6 — ISO 27001 Data Merge

### Source Data
| File | Standard | Records |
|---|---|---|
| `Jasanz raw data - 27001.xlsx` (combined) | ISO/IEC 27001:2013 + 27001:2022 + 5377 | 1,218 |

### Method
- Loaded the single 27001 file (no header, columns assigned programmatically)
- Created sheet `27001_Merged` (positioned after `CB_Summary`)
- **Total records**: 1,218

---

## Step 7 — ISO 27001 Split by Certification Body

### Method
- Identified **20 unique Certification Bodies** in the 27001 dataset
- 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 | 365 | 357 |
| 2 | SAI Global / Intertek | 231 | 223 |
| 3 | Global Compliance Certification | 147 | 139 |
| 4 | Best Practice Certification | 99 | 97 |
| 5 | Sustainable Certification | 63 | 62 |
| 6 | LRQA | 55 | 53 |
| 7 | TQCSI-Yaran | 50 | 50 |
| 8 | Global-Mark | 43 | 35 |
| 9 | Equal Assurance | 29 | 29 |
| 10 | DNV Business Assurance Australia | 23 | 22 |
| 11 | BSI Group (Australia and New Zealand) | 22 | 22 |
| 12 | Bureau Veritas Australia | 19 | 19 |
| 13 | QMSCS / QMS Certification Services | 16 | 16 |
| 14 | PricewaterhouseCoopers Compliance Services | 14 | 14 |
| 15 | DLCS | 13 | 13 |
| 16 | QSERC | 12 | 11 |
| 17 | Certification Partner Global | 10 | 10 |
| 18 | Integrated Quality Certification | 3 | 3 |
| 19 | BSCIC Certifications | 2 | 2 |
| 20 | Business Systems Certification | 2 | 2 |
| | **TOTAL** | **1,218** | **1,179** |

### Key Observations
- The ISO 27001 market in December 2023 had 1,218 records / 1,179 unique clients
- **Compass Assurance Services** leads with 357 unique clients (30.3% of market)
- The 27001 data includes 45 records scoped as `iso5377` (a related information security standard)
- **QMSCS / QMS Certification Services** and **Best Practice Certification** appear prominently — both are absent from later snapshots (likely rebranded or acquired)
- 20 of the 49 QES certification bodies also operate in the 27001 space

---

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

### Method
- Extracted CB name and unique client count from all 20 `27k_` sheets
- 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**: 20 (one per CB), sorted largest to smallest

---

## Workbook Structure
`QES_Merged_December_23.xlsx` contains **73 sheets**:
1. `Merged_Full` — QES complete dataset (27,501 records)
2. `CB_Summary` — QES master summary (49 CBs)
3. `27001_Merged` — ISO 27001 complete dataset (1,218 records)
4. `27001_CB_Summary` — ISO 27001 master summary (20 CBs)
5. 49 QES individual CB sheets
6. 20 ISO 27001 individual CB sheets (prefixed `27k_`)

---

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

---

*Document generated: 2026-02-06*