Housing Analytics Courses
We offer a range of data skills training courses. These packages are designed to help social housing providers to improve their understanding of data analytics, including exploratory analysis, data presentation, relationships between metrics and predictive analytics. Most of the examples are framed in a social housing context, making them relevant and accessible to those in the sector.
HOUSING ANALYTICS (2 Mornings)
Basic analytical methods are the focus for this course which aims to provide an introduction or refresher course to statistical and analytical methods. It covers the broad topics of exploratory data analysis, all with the aim of helping participants to really ‘know their data’ in such a way that they can build meaningful reports with relevant insight and storytelling for a variety of audiences. The course material includes an extensive slide pack as well as exercise files produced from typical housing data.
CONTENT
Types of data and analysis
Effective graphs
Descriptive statistics
Identifying outliers using control charts
Relationships between measures
Using pivot tables and PowerPivot
TARGET AUDIENCE
The course is aimed at staff working at all levels of reporting and analysis, whether commissioning reports, managing business intelligence teams (or equivalent), or just carrying out analysis. There is a significant element of participation via sharing experience and challenges and so would suit those developing analytical strategy as well as those carrying out in depth analysis.
PREREQUISITE
The course requires an intermediate skill level in Excel. A good understanding of housing measures, such as those in the Sector scorecard would also be beneficial but is not essential.
ADVANCED hOUSING ANALYTICS USING EXCEL AND R (2 Mornings)
This course is for those wanting to go beyond reporting and develop predictive models and more advanced insight. We will study regression models (paying particular attention to the methods deployed in the Regulator’s Unit Cost Analysis), forecasting and significance testing. The course will be delivered primarily in Excel but with some parts covered in R Studio. R studio will be introduced as it has more extensive and robust regression and forecasting capabilities.
CONTENT
Significance testing
Regression analysis
Forecasting
TARGET AUDIENCE
The course is aimed at advanced data analysts with experience of delivering robust reports but who want to develop the tools to investigate further and build predictive models.
PREREQUISITE
The course requires a good understanding of Excel and basic data analysis. Knowledge of R is not essential but would be helpful. A good understanding of housing measures, such as those in the Sector scorecard would also be beneficial but is not essential.
“It was good to have group discussions, more so the larger groups than the discussions in pairs, as there was more debate and more points of view. Simon was very insightful and charismatic - his passion for the analysis made it very interesting to be a part of. Zoom worked really well and offered all of the facilities that you would expect from attending the training in person.”
“It was very informative and has shown me new ways to look at and analyse my data.”
“Very good trainer, in depth training and full definitions/examples given”