The Royal Bank of Scotland (RBS), based in Edinburgh in the UK, has implemented Microsoft SQL Server 2012 Parallel Data Warehouse in order to handle multiple terabytes of data and an unprecedented level of query complexity more efficiently.
To help customers develop better business strategies, the bank needed more insight into the bigger macroeconomic picture and the behaviour of its clients. In 2013 the bank created the Customer Solutions Group (CSG), which was tasked with providing insight to RBS executives and customer engagement teams. CSG subsequently has access to data from approximately 1.5 million business customers and sees more than £7 billion per day and £1.5 trillion (US$2.4 trillion) annual transactions.
In November 2013, CSG began a proof of concept with HP AppSystem for SQL Server 2012 Parallel Data Warehouse. Two weeks later, the team had replicated approximately half of its existing analytics environment on the two-node appliance, including tables, processes, and complex algorithms.
With SQL Server 2012 PDW, RBS can gain deeper insight into the UK economy and help customers of all sizes to harness the power of big data. Furthermore, CSG has gained significantly faster performance through the use of SQL Server 2012 PDW.
“With SQL Server 2012 PDW, we have a better understanding of our customers’ needs and wants,” says RBS’ chief analytics officer, Alan Grogan. “We can model, test, and execute solutions that help customers manage business risk, as well as improve our own offerings ranging from online services to branch transactions. It’s providing the next level of intelligent discussion with our customers. Using this SQL Server 2012 PDW infrastructure, we’ll be able to move customer relationships into customer partnerships.”
CSG also plans to consolidate data from daily account transactions and connect the solution with business software such as Microsoft Dynamics CRM.
Share this story