New cloud data platform improves business intelligence


Capitalrise_hero illustration_large
The client

About CapitalRise

CapitalRise is a UK-based property investment and lending firm. It was launched in 2016 and controls a premium property portfolio worth more than £500 million. CapitalRise was set up with a clear mission: To disrupt the old way of investing in property and give investors easy and direct access to prime property-backed investments with attractive potential returns.


Key Outcomes

We worked in partnership with the team at CapitalRise to deliver immediate business impact and helped them on their journey to data maturity.

  • Speed Reduced time to create business intelligence reports from 2 hours to 2 minutes
  • Control CapitalRise retained control over valuable data
  • Accuracy Automation reduced typos and errors affecting report reliability
The Challenge

Making data meaningful

CapitalRise was experiencing problems creating reliable business intelligence reports.

Staff were spending hours generating relevant insights by collecting data from multiple separate sources and then manually merging them.

The company was storing its transactional, customer, and property data on Amazon Relational Database Service (Amazon RDS) - a scalable, cloud relational database - and Amazon Simple Storage Service (Amazon S3), but was experiencing problems trying to access that data in a meaningful way.



A cloud-based modern data solution

We worked with CapitalRise to build a data warehousing platform using Amazon Web Services (AWS).

Creating a single source of reliable, clear information and reducing the time taken to generate reports and discern clear insights from hours to minutes.

The Delivery

Migrating data to AWS

The project was completed in two sprints. In the first sprint, our specialists worked with CapitalRise to clarify the business objectives and data strategy, with the project then being implemented in the second sprint.

Data control

CapitalRise investigated several BI tools and visualisation options but after consulting with us, decided to build on its existing AWS infrastructure. We advised CapitalRise to maintain control of its data by building its own data asset, using tools available on AWS. That would mean CapitalRise could manipulate and transform its data into a visual format while retaining ownership and full control.

Data integration

We used AWS Glue for simple, scalable, and serverless data integration and AWS QuickSight - a cloud-native, serverless BI service - to clean and prepare the data respectively. The use of QuickSight meant that CapitalRise could also create interactive and shareable visualisations.

Creating a landing zone

CapitalRise was using Amazon RDS to store all of its transactional data and Amazon S3 as a simple file store. In the second sprint, we created a landing zone for the data in Amazon S3 and used AWS Glue to clean and prepare the data into a format that could be read by analysis and visualisation tools.

Data transformation

Once the data had been properly formatted, we used AWS QuickSight to pull it in for analysis and visualisation. This allowed us to build the required charts and dashboards, adding interactive elements so that the CapitalRise team can drill down into components on the main dashboard to see further details.

The Result

Greater insights, quicker

Improved decision making and data ownership

Within a limited timescale we worked closely with the team at CapitalRise to enable them to self-manage their data platform. They can now quickly and simply visualise data and derive invaluable insights.

Owning their own data

Upon completion of the project, CapitalRise were left with the ability to self-manage the data platform. This allows them to continue on their journey to data maturity and maintain ownership of their data.

Delivery at pace

We considered different use cases before producing the initial design. We did this by working closely with the team at CapitalRise to determine what data they needed to see visualised on their dashboards and then used that to prioritise our build focus, ensuring that we could complete the implementation within the limited timescale set out by CapitalRise.

Business insights delivered in minutes

Generating business insights is no longer a slow and manual process. The CapitalRise team are now able to quickly extract valuable insights from multiple sources that help them make better decisions, faster. They can generate accurate, reliable, and attractive BI reports in a matter of minutes.

Case studies

See our impact elsewhere

More successful digital transformation projects...

Want to learn more about the work we do with clients? Take a look below.

Talk to us.

Get in touch to discuss your digital ambitions.

Contact us