Project Description

Portfolio Analysis Model

The Challenge

Savills’ came to us knowing that there was more to be done to optimize the way they analyzed their properties. Although their problems were unique, they were certainly understandable, with the real estate industry requiring big data to be analyzed and actioned to a high level of accuracy.

Their daily tasks meant they needed to analyze and forecast the performance of individual and group properties depending on Savills’ tailored set of variables, such as area crime and employment rate. This was difficult to say the least, with the current approach resulting in reports having a higher risk of error and miscalculation. This also had a noticeable impact on workbook efficiency, which is made evident with the sheer volume of data.

All together, the main issues lied with the size, accuracy and the visual representation of the available data. Slow loading workbooks leading to poor communication and lack of synergy resulted in a lack of efficiency, as well as poor allocation of resources.

The Solution

When sitting down with Savills to understand the scale of the problem, we quickly identified plenty of opportunities for automation and increasing overall efficiency.

We first started by reviewing the scale of the challenge at hand, looking at how best to approach the project in order to meet all Savill’s requirements. This involved the use of our VBA experts tailoring certain processes down to the niche nature of Savill’s analysis process, which allowed a better understanding of which variables were necessary to best analyze the data at hand.

Down to the importance of the solution, we also saw the need for impressive data visualization that goes beyond norms, leading us to integrate Google maps, allowing users to pick and choose a certain location or property and view it for themselves, simply through the click of a button.

The sheer size of the existing setup was having an impact on the business, with workbook management becoming a mammoth daily task. We used Excel in a tailored way to only refresh once prompted, thus saving time and using up less processing power.

Our tailored reports took this further by allowing data sharing to also become a one-click job that eliminated the risk of errors, ensuring that any issues are picked up on and the relevant managers notified in a timely fashion.

On top of the essentials aspects of Savills’ new solution, we wanted to make the workbook easily navigable, which included a clean navigation bar that easily allowed users to pick and choose certain data, thus increasing efficiency and improving the overall user experience.

The Results

Our solution brought new life to Savills’ Property Performance Analysis, as they no longer have to spend phenomenal amounts of time on one portion of the process, just to find errors later down the line. Their workbooks now run efficiently, as what was previously a 64mb workbook is now slimmed down to 2mb, meaning time spent analyzing properties is well optimized, allowing for more in depth analysis and less time watching the loading screen.

Not only is time now optimised, but their tailored property analysis tool is now optimised for use on all levels, from analysis, to meetings and decision making. What was previously hefty, unorganised data is now easily visible and digestible through optimised methods of data visualisation such as graphs, making for easy analysis for their users of all skill levels.

Overall, the professionalism achieved through all of the tailored aspects of this workbook reinforced the true quality of the Savills brand, whilst ensuring their data is cared for using long term error-free pioneering Excel methods.

Bespoke are a hardworking team with excellent knowledge of modeling principles and have come up with creative solutions for enhancing our models. Due to their success I have introduced them to other teams within Savills which has led to further work as a result of their professionalism.
Nick Carlisle, Savills Housing Consultancy

Speak to our Manchester based team

Provide your details for a call with one of our Excel experts.

Are you ready to make Excel work harder for you?