Visualisation and write up reports
We used PowerBi to visualise the clusters cross-sectionally and longitudinally.
Analysis of data and refinements
We analysed the data longitudinaly exporting the clusters information and the list of companies per cluster.
July Data Collection
6 regions were selected for the downloading. The download featured up to 10 pages per company, on a quarterly basis from 2000 to 2019.
Draft data collection software and refined algorithm
The scale of the data collection and storage required adopting alternative to the originally-envisaged approaches.
UK and Irish companies with Turnover > £1.5 million, Profits > £150,000, Shareholder Funds > £1.5 million. 232k companies in 22 regions.
Project plan reviewed and milestones agreed.