Philip Egan, one of ReACT’s prolific consultants, gives an overview of his recent work.
“Hello readers, I’ve got a bit of a mixed bag for you this month.
The past few weeks have seen a combined workload largely relating to testing, reporting, and data analysis. I’ll take each one of these elements in turn if I may and explain a little further into the work that I have been carrying out.
Testing
With the ReACT 4 release just around the corner and primary development complete we have been shaking and breaking the application to its core. The internal testing started by designing and producing detailed test plans to make sure every element of the new application is tested under load, by users of varying security levels. With the test plan complete and scheduled tasks allocated to various members of the team it was time to start the testing. We have adopted a phased filtration approach, with the first failed tests being logged and fed back to the development team in one batch. Once we have a new release with the issues addressed, due by the end of today, we have a second tier testing plan to follow which will entail re-testing the reported issues and following the entire test plan once more to ensure that none of the resolutions cause knock-on effects elsewhere within the application. During this second phase of testing any issues will be logged and fed back and a similar pattern followed until every element of the application passes all tests under various environments to ensure that we have a sound and solid product ready for implementation from the launch made during our user groups in September.
Reporting
As my main skill base is related to SQL Server development my primary role within ReACT 4 aside from testing is the design and development of the new reporting suite which we are incorporating into the product. A large number of our support queries over the past two years and more have largely been caused by confusion over reporting figures and queries regarding why the numbers in one report don’t match up to the numbers in another report. We have also had a large number of requests from people who like a particular report but would prefer to have the option to filter by the date the case was completed rather than the date the case was received. To address these key issues we have reduced the reports available within ReACT to 4 primary reports available from the application menu.
These reports consist of –
- PIs
- Satisfaction
- HouseMark
- Diversity
Each report can be filtered by any or all of the following parameters, only the date range is mandatory –
- Start Date
- End Date
- Company
- Region
- Area
- Sub Area
- Secondary Sub Area
- Primary Officer
- Date filter type (Date Received / Date Completed / Survey sent for Satisfaction Report
If further detail is required to investigate the actions / incidents / cases / individuals which make up a reporting figure then that number can be clicked on to drill down to a detailed list showing the makeup of the figure or slice of the pie.
- Any individual’s name can be clicked on to see the profile and history of the cases the individual has been involved in.
- Any case reference can be clicked on to see the case file with the details regarding that particular case.
- We hope and believe that the new reporting suite will be well received by Performance Managers and envisage that these reports will be run on a monthly or quarterly basis with figures produced for your board of directors and published to make like comparisons quarter on quarter and year on year.
Data Analysis
Taking a step away from ReACT 4 for a little while, during the past month I have also been involved in a sideline project working with John Wickenden, Knowledge Manager at HouseMark, to produce a more detailed analysis section of the “ASB Benchmarking Analysis of Results 2010/2011” with particular reference to the makeup of early intervention actions.
Following the kind contribution of datasets from the organisations listed below I developed a set of queries to extract overview data of cases, incidents, and actions from the past reporting year. This data was collated and passed on to John to interrogate and pattern match to produce results which are now available in the report detailed above.
As I type the HouseMark ASB Benchmarking Conference is taking place down the road in Coventry so hopefully you will have access to the report now if not soon and find the detailed breakdown particularly useful.
The geek inside me particularly enjoyed this project and we hope to embark on a similar project next year and take it to another level with more in-depth analysis in other areas. Any requirements or feedback on this matter would be appreciated.
Thanks to the following organisations who helped us with this project –
- Acis Group Limited
- Adactus Housing Association Limited
- AmicusHorizon Group
- Christian Action Housing Association
- Community Gateway Association
- East End Community Homes
- Gateway Housing Association
- Gloucestershire Housing Association
- Green Vale Homes
- Havebury Housing Partnership
- Irwell Valley Housing Association
- Newlon Housing Trust
- NSHousing
- Pennine Housing 2000
- Poplar HARCA Limited
- Severn Vale Housing Society Limited
- Spitalfields Housing Association Limited
- The Community Housing Group
- Tower Hamlets Community Housing Limited
- Venture Housing Association Limited
- Westlea Housing Association Limited
- Wolverhampton Homes
Thanks for reading
Phil Egan