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:
Coronavirus (COVID-19)
Site header
Contact us
|
Help
Site navigation
Public health & wellbeing
Disaster management
Cancer screening
Subsidies and support
Health topics
Information for specific groups
Industry and environmental health
Schools and early childhood
Notifiable incidents and conditions
Scientific services, analysis and advice
Forensic, biomedical and pathology services
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
Strategic direction
Health system
Health licences
Health records and privacy
Contact us
Employment
COVID-19 EOI
Job search
Work for us
Rural and remote
Overseas applications
Clinical placements
Training and professional development
Employment conditions
Research & reports
Research projects
Research ethics and governance
Intellectual property
Research funding
Research and data requests
Reports
Data
Population health data and statistics
News & events
News archive
Media contacts
Department of Health media releases
Minister for Health media statements
Campaigns
Events
Health Blog
Newsletter
Podcast
Health Heroes
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...
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
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: 25 September 2019
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