Data, unveiled · An independent ABS project
From a public spreadsheet to three useful report pages.
You take each step. The data does the talking.
01 / Source
Fetch the original worksheet values, then see what each row and number represents.
Australian Bureau of Statistics
89,715 detail rows · 13 columns
Loads a hosted CSV snapshot of the ABS worksheet. The browser performs the transformation and calculations; this is not a live ABS API.
Source & method
Public data. Visible transformations.
Calculations you can follow.
ABS Schools, 2025, Table 42b, released 5 March 2026. The 2025 census date is 1 August 2025. This site hosts a CSV copy of all 89,715 detail rows and 13 columns from “Table 2 Data table”. Workbook formatting and footnotes remain in the original workbook.
The original workbook hash matches the previously checked project source. Preparation record and file fingerprints · Raw worksheet CSV.
These are full-time and part-time student enrolments (headcounts), not full-time-equivalent places or unique people across twenty years. Each headline count is for one year. Sector share is the proportion of enrolments in that place and year, not a population participation rate.
Change in headcount is a number of students; growth rate is a percentage. Differences between shares are measured in percentage points. Numbers describe change, not the reason for it or the quality of a school. See the ABS methodology.
The workbook’s confidentiality note explains that cells are randomly adjusted. Two detail rows have independently adjusted components that do not add to the published all-student value. The transformation preserves the published all-student field. It groups by year, jurisdiction and sector, producing 480 facts; it does not attempt to “correct” the source.
The walkthrough uses JavaScript to transform data and calculate results. The DAX shown is the equivalent Power BI measure, provided to explain the model and filter context. This is an independent demonstration, not an embedded Power BI report.
Microsoft references: semantic models, star schemas, CALCULATE, REMOVEFILTERS, DIVIDE and SELECTEDVALUE.
Source: Australian Bureau of Statistics, Schools, 2025, Table 42b. Used under CC BY 4.0. CSV extracted and charts created for this independent project; no ABS endorsement is implied. Snapshot prepared 16 September 2026.