Data Analytics for Social Housing -
Introductory Course · Two half-days · Microsoft Excel · No prior knowledge assumed
A practical, hands-on introduction to data analysis for housing professionals. Using real datasets from responsive repairs and rent arrears, participants learn to understand, summarise, and visualise data — and to communicate findings clearly to different audiences.
What's covered
Understanding your data: data types, data quality, and cleaning messy records in Excel
Summary measures: mean, median, mode, spread, and how to handle skewed data
PivotTables: building, grouping, filtering, and creating histograms
Data visualisation: choosing the right chart — bar, line, histogram, scatter, Pareto
Interpreting findings: turning data into insight and tailoring the message for your audience
Who it's for
Housing professionals in income, repairs, housing management, or performance roles who work with data day-to-day but have had little formal training. No analytical background is needed — just everyday familiarity with Excel.
Requirements
A laptop with Microsoft Excel (Microsoft 365 or Excel 2019 or later)
No prior knowledge of statistics or data analysis
Format
Two half day sessions of 3½ hours each, delivered online or in person. Theory is kept short — most of the time is spent on hands-on exercises with real housing data.