Case Study
Milaha Boosts its Analytics Capabilities Qatar’s Milaha rolls out IBM Cognos to harvest data from across its diverse businesses and turn it into powerful business intelligence reports
Executive Summary Customer Name Milaha Industry Travel & Transport Location Qatar Number of Employees 3000
Challenge Bring together data from across all different operations into a single business intelligence application that is easy to use for staff. Provide up-to-date analytics information. Provide Milaha an automated solution to extract their data, report on it, and budget. Solution Cognos TM1 solution to capture actual financial data that can easily be analysed for decision making, including current month data and nonfinancial metrics and data.
Challenge Milaha, formerly known as Qatar Navigation, has operations in diverse areas including maritime and logistics, trading, real estate and investments. The aim of the project was to bring together data from across all of these operations, into a single business intelligence application that is easy to use for staff, and provide up-to-date analytics information. Solution The Cognos TM1 solution captures actual financial data that can be easily analysed for decision making, including current month data coming from Milaha’s Oracle ERP System; along with non-financial metrics and data, pertaining to the company’s marine and logistics operations. In contrast to the financial data that resides in the Oracle ERP System, this data is taken from Milaha’s operational systems. Milaha selected GBM for the project, which included installation and development, along with training for users. IBM Cognos TM1 was deployed on an HP Proliant server at Milaha’s head office, and in total, the project took 17 weeks to deliver, including two weeks of developer and end user training. “The project’s primary aim was to provide Milaha an automated solution to extract the data from the operational systems, report on it, and preform budgeting and planning. They needed a sophisticated, yet easy to use, system to analyse their data. The multidimensional OLAP functionality of IBM Cognos TM1 fitted their requirements very well. With this solution, Milaha is now able to look at the information in a different manner and analyse it in any way they need. In addition, Milaha’s user base was looking for a tech-easy solution which the business could manage, instead of relying on their IT department, which was the case for their ERP system,” explained Soubhi Chebib, country general manager, GBM Qatar. “The implementation required creating the planning and forecasting model as per Milaha’s business processes, at the same time making it simple enough to be easily used enterprise-wide by each department,” Chebib added. “The biggest benefit to Milaha comes in the form of time savings. In the past, it was time consuming to run multiple reports, cut and paste in Excel, manipulate data, and so forth. Previous to the deployment of this project, it would take much longer for Milaha to complete the necessary processes; however, with the implementation of the project it can now pull out all necessary information from the multiple source applications within seconds. Milaha will now have the ability to access statistical data that wasn’t readily available before, from one system,” Chebib said.
1
Case Study
Results The BI application gave Milaha faster access to reports, as well as access to reports on data. Cognos, and its strong integration with Microsoft Excel, meant that the solution is able to easily provide reporting to users in different formats, so that they can get to the data that is most relevant to them. View results on different hierarchical levels, over various timelines, using multiple dimensions.
Another important objective of the project was to be able to utilise it for budgeting. Milaha already had an existing budgeting solution that allowed highly focused management of budgeting across the company’s different business units. The company also has a large general ledger, manpower in excess of 3,000 people and considerable annual capital expenditures. To accommodate this, GBM and Milaha invested considerable time in customizing Cognos TM1, with multiple testing phases, to ensure it provided the right capabilities to all business units. Sami Shtayyeh, vice president, financial planning and analysis at Milaha, commented: “We didn’t want to lose any functionality that we had with our previous budgeting solution. In addition, we also wanted to enhance the system and process. We wanted linkages from our manpower and capital expenditures budgets direct with the financial budget. As a company, we budget to the lowest level ie. individual, account number and capital requirement, hence capitalising on linkages was critical.” Results The business intelligence application now gives Milaha much faster access to reports, as well as access to reports on data that weren’t previously easily accessible. The flexibility of Cognos, and its strong integration with Microsoft Excel, also meant that the solution is able to easily provide reporting to users in different formats, so that they can get to the data that is most relevant to them. “Many finance professionals can’t work without Excel – having a strong interface with Excel makes it easy to view live data, and at the same time utilise all the other aspects of Excel for analysis. In the past, our reports had always been static, and to update or change them, we had to run new reports. That is no longer the case,” Shtayyeh adds. “We can quickly view results on different hierarchical levels, over various timelines, using multiple dimensions. This is the main benefit of a multi-dimensional OLAP tool. Milaha has multiple business units, each with several responsibility centres. Different managers want to view their results in different ways. Some prefer to look at detailed results by account number, by responsibility centre, through different time periods. Others prefer to view high level results at the business unit level. We can now accommodate both, very quickly. “In the end, the system is really about enabling us to make better decisions, more quickly. We have not achieved the end state, but implementing IBM Cognos TM1 has helped move us in the right direction,” Shtayyeh concluded.
2
Case Study
“We can quickly view results on different hierarchical levels, over various timelines, using multiple dimensions. “ Sami Shtayyeh Vice President, Financial Planning & Analysis, Milaha.
For more information To learn more about the solutions mentioned in this case study, please go to: www.gbm4ibm.com Products and Solutions List Cognos® TM1® 9.5.1 Cognos® TM1® Excel Interface Cognos® TM1® OLAP Engine IBM® Cognos® 8 Enterprise Planning TM1 Contributor IBM® Cognos® 8 Enterprise Planning TM1 Modeler IBM® Cognos® Enterprise Planning TM1 Explorer IBM® Cognos® Analytic Server IBM® Cognos® TM1® IBM® Cognos® 8 Enterprise Planning
© 2012 Gulf Business Machines. All rights reserved. GBM, the GBM logo are trademarks of Gulf Business Machines. IBM and the IBM logo are trademarks or registered trademarks of International Business Machines in the United States, other countries, or both.
3