Skip links and keyboard navigation
Skip to content
Skip to site navigation
Skip to footer
Use tab and cursor keys to move around the page (more information)
Health alerts:
Listeria
Site header
Contact us
|
Help
Site navigation
Public health & wellbeing
Health and wellbeing
Cancer screening
Disaster management
Health topics
Subsidies and support
Information for specific groups
Industry and environmental health
Schools and early childhood
Notifiable incidents and conditions
Forensic and Scientific Services
Pathology Queensland
Clinical practice
Clinical guidelines and procedures
Service referrals
Informed consent
Databases and tools
Clinician engagement
Clinical innovation
Health system & governance
Suppliers & procurement
Performance
Policies and standards
Legislation & bills
Strategic direction
Health system & services
Health licences
Health records and privacy
Contact us
Careers & employment
Job search
Work for us
What it's like to work for us
Clinical placements
Research & reports
Research
Reports
Population health data and statistics
News & alerts
News archive
Media contacts
Department of Health media releases
Minister for Health media statements
Campaigns
Queensland Health Events
Health Blog
Newsletter
Podcast
You are here:
Home
Statistical Services Branch
Data Linkage Training Resources
Data Linkage Training Resources
These resources are provided by the Statistical Analysis and Linkage Unit, Queensland Health for researchers and users of linked data.
Introduction
The ultimate aim of working with linked data...
Let's navigate data linkage
(animated video)
Relational data
Example
'Tidy data'
Format, coding and efficiency
'Wide' versus 'Long' data
Analysis efficiency
Coding and logical efficiency
Storage efficiency for larger datasets
Visual efficiency
Preferred cohort format (Example)
Counting and units
Establish counts of records and unique records
Unit of analysis
Merging/joining data
Inner join
Left join (also known as a left outer join)
Full join (also known as a full outer join)
Many-to-one and one-to-many joins
Sequencing events
Example
Code snippets
Counting rows and unique persons
Basic joins
Aggregating
Passwords and encryption
Secure transfer of data
How to set up passwords and encrypt files
What does 'password protection' and 'encryption' mean?
References
Further reading
Last updated: 22 April 2022
Home
Data Collections
Manuals Archive
Data Quality Statements
Reports
Aboriginal and Torres Strait Islander Health
Country of birth
Information Circulars
Information Sheets
Other reports
Perinatal Annual Reports
Statbites
Statistical Analysis Reports
Technical Reports
How to access data from SSB
Research requests
Summary / aggregated data
Queensland Health employees
Commonly requested data
Data Linkage
What collections can be linked?
Data Linkage Symposium
Data linkage training resources
Frequently asked questions
About us
Hospital Activity and Capacity Time Series
Contact SSB
