Improve by Analysis and Modelling

Computer Storage Allocation at HSBC

Bringing together different silos of data in your organisation is frequently a great source of insight. It gives you the ability to see how processes fit into the bigger picture of your organisation and how these function together. The data could already be available to you or be created with minimal effort to provide a greater benefit.

The Challenge

HSBC wanted a view of how their data storage was utilized over the world. The source of the data came from a list of all their storage hardware and storage array logs. The view had to capture the country and regional summaries but also be able to drill down to an individual storage array level. All reporting had to be packaged in a way to allow storage executives to make strategic decisions on global storage.

The Solution

Storage array logs generate a lot of data. When considered at a global level, it would normally break Excels one million line limit. As there was MS Office already installed on the development computer, the best fit solution was using MS Excel and MS Access.

Loading Data

The array operational logs would be saved to a location on the network and a VBA script would be run to import the data into an Access database. The old data would be summarized and archived for reporting and trend analysis. The new data would then be aggregated to make reporting queries more efficient and take less time to load.


A host of reports were presented as dashboards on Excel. These reports connected to the summary tables on the access database and were refreshed when the reporting file was opened.

The Result

The streamlined solution enabled all the dashboards to be generated just by opening and refreshing a file. The global views as well as the ability to drill down to region, country, data center and individual array let management see patterns in how data was allocated. Due to the overall investment of the bank, any insight into this area proved to be a massive benefit as optimisation provided significant cost saving.

The Applications Involved

During initial investigation we select the best applications that will fix your requirement and build our solutions on top of this.

The Services Involved

Come to us for our unique approach to data solutions taylor made for your unique needs. We have years of experience delivering useful solutions doing only a few things that we are really good at.

Our services allow you to hand over the techincal aspects of data management and analysis over to us to help you focus on the business

Statistical Modelling

A statistical model takes the guesswork out of thinking there are patterns in your data. Using a statistical model, you can mathematically prove if there are relationships between elements of a dataset and if so you can assign a number to the degree of the relationship. When you model real world data, relationships are a grey area. There are exceptions to rules due to the complexity of real world interactions. Intellisolve sets up statistical models the same way as financial models, focusing on the business need first and building the model around that.

We would like to hear from you.

Give us a call on 020 333 20457

Would you like a callback?

Leave your details and we will call you back.