Housing

We have worked with several of the largest social housing providers and focus on two main areas:

1. Assisting in the design and delivery of reports and dashboards, especially ones delivered in Microsoft Power BI

2. Providing in depth training and support on how to use data intelligently and effectively

   1. Housing Analytics for Managers

   2. Analytics - Summaries and Tools

   3. Analytics - Trends and Models

   4. Reporting in Power BI

   5. Data Preparation and Modelling in Power BI

In our experience huge sums are spent on housing management systems which provide core operational tools. However, often this vast data store is not used to deliver the insights that they could to deliver business improvements. The focus of our support, whether building tools and providing training, is to help managers understand what they can ask of the data and to enable business intelligence analysts to run the necessary analysis and reports.

THIRD SECTOR

We have developed dashboards to help provide comparative performance data on community businesses for PowerToChange.

More recently we have been working with mycake to develop tools to help funders assess financial viability and risk of not-for-profit organisations.

We provide training in business intelligence tools, especially Microsoft Power BI.

Health

For many years we have worked with the health sector and have detailed knowledge of data sources and reporting challenges.

Our particular expertise is in building interactive dashboards in Microsoft Power BI. These might be focused on operational monitoring and reporting or they may be designed to provide insight on pathways.

We have worked with clinical commissioning groups and NHS providers and the Private Health Information Network to develop information strategies and data repositories to support decision making and analytical insight.

A particular focus is on activity and length of stay, using statistical tests to ensure that incorrect inferences are not drawn from data tables.

We also work with major pharmaceutical companies, for reporting and insight generation. Our background in the health sector makes it easy for us to understand issues for reporting and communication with the NHS.

Manufacturing

For several years we worked with Jaguar Land Rover (JLR) on a series of important analytical and process improvement projects. For example, we have:

• developed sales operations and sales planning dashboards;

• provided economic forecasts of markets demand

• analysed monthly sales patterns and provided forecasts of whether sales targets are likely to be achieved

Our skill has combined in depth regression modelling, interface design and process mapping.