Housing Analytics Using Excel

The focus of this course is to provide a sound overview of basic analytical methods. This is a perfect introduction or refresher course to explore 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.  

Two half-day sessions will cover: types of data and analysis, effective graphs, descriptive statistics, identifying outliers using control charts, relationships between measures, using pivot tables and PowerPivot. 

Who is this course for? The course is aimed at those working at all levels of reporting and analysis, whether commissioning reports, managing business intelligence teams (or equivalent), or simply carrying out analysis. There is a significant element of participation via sharing experience and challenges and would therefore suit those developing analytical strategy as well as those carrying out in-depth analysis. 

Entry requirements: The course requires an intermediate skill level in Excel, such as that covered in the intermediate syllabus of the Introduction to Excel. A good understanding of housing measures, such as those in the Sector Scorecard would also be beneficial, but not essential. 

2021 dates

MONDAY 17 AND TUESDAY 18 MAY - BOOK YOUR PLACE

MONDAY 20 AND TUESDAY 21 SEPTEMBER - BOOK YOUR PLACE

Price

£375+VAT each (HouseMark members)

£450+VAT  each (Non-members)

Access the full 2021 Data Training prospectus here. 

Subscribe to our newsletters

Subscribe below to get regular updates from Housemark

Latest Tweets

Latest tweet

hasRole=False

leadValue=False

showPopup=False

totalGroups=0

loginStatusModel.IsLoggedIn=False

  1. id: 12584
  2. name: Housing Analytics Using Excel
  3. item type: Content
  4. template alias: FullWidthSlim
  5. created data: 02/02/2021 14:53:14
  6. Document Type Alias: Page
  7. Path: -1,1101,1099,12584
  8. Last Render: 20/04/2021 12:26:23