Heatwave
for Cape Peninsula
Learn more
Skip to main content
Skip to main navigation
www.health.qld.gov.au
Contact us
Search
Menu
Queensland Government
Queensland Health
Search this website
Search
Menu
Close
Home
Public health & wellbeing
Public health & wellbeing
Public health and 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 practice
Clinical practice
Clinical guidelines and procedures
Service referrals
Informed consent
Databases and tools
Clinician engagement
Clinical innovation
Health system & governance
Health system & governance
Health system and governance
Health Infrastructure Queensland
Suppliers & procurement
Performance
Policies and standards
Legislation & bills
Strategic direction
Health system & services
Health licences
Health records and privacy
Contact us
Careers
Careers
Careers
Job search
How to apply
Allied health
Medical
Nursing and midwifery
Dental
Other careers
Students and graduates
Working for us
Research & reports
Research & reports
Research and reports
Research
Reports
Population health data and statistics
Newsroom
Newsroom
Newsroom
News
Features
Podcasts
Department of Health media releases
Health alerts and warnings
Minister for Health media statements
Media contacts
Queensland Health Events
Campaigns
Queensland Health's YouTube channel
Newsletter
Contact us
Home
Statistical Services Branch
Data Linkage Training Resources
Statistical Services Branch
Data Linkage Training Resources
Statistical Services Branch
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
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
Back to top
