Improve by Analysis and Modelling

Financial Data Analysis at HSBC

A well organized financial model shines a spotlight on the elements of the enterprise that guarantee success and the relationship between the components of the model. Users should be able to see how making a change in one of the components affects the others. At intellisolve, we have a standard methodology of creating models that focuses on business goals first. We then use our expertise in Excel to make these items stand out so that the finance can see what they need to focus on.

The Challenge

Create a financial model that shows the state of global enterprise data storage. The model should give the ability to slice data by different dimensions such as line of business and type of hardware. The model should also summarize the current global view of storage and predict the future storage requirement based growth. The model should be able to run different scenarios to highlight what would happen in these alternate realities.

The Solution

This was a two fold solution, first building a consolidated operational data model based on the HSBC global estate. The financial side of the operational was presented separately. The model included a parameters section where all the variables were presented in one place along with the summary of the entire model. Here users could easily see the impact a change in one variable had in the rest of the model. This made it easy for users to consider alternative scenarios for enterprise storage in the short to long term.

The Result

Using Intellisolve's business centric methodology for creating financial models meant the end product was created using a framework that was guaranteed to deliver a useful solution. The final model clearly showed the relationships between the various components and gave executives overall visibility of the interactions between components. The final product highlighted the areas where significant costs could be saved.

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.