Global Data Analytics Company Gains Real-Time Insights into Revenue and Expense Data
An S&P 500 global measurement and data analytics company with operations in more than 100 countries had little to no visibility into its Travel and Expense (T&E) analytics or spend related to vendors and internal customers. While this highly trusted company was known for providing proprietary data to clients around the world, its internal financial data was segmented and existed in silos, making it nearly impossible to access without intimate knowledge of each of its individual source applications. With no way to integrate the data, the company was unable to access detailed transactions and conduct root cause analysis which triggered mistrust in the data.
The company turned to Protiviti for an expense and revenue reporting solution that would provide the company with accurate and trusted data. Leveraging Amazon Web Services (AWS) cloud platform, Protiviti quickly developed a small-scale solution prototype that would give the company immediate access to expense data at the general ledger account level for any combination of divisions or departments. Once this proof-of-concept was validated as a success, the solution was then scaled to create a department-wide, real-time expense and revenue reporting system on the AWS platform leveraging SAP’s portfolio of tools including SAP® BusinessObjects™, SAP Data Services and SAP HANA®. This system provided actionable information and root-cause analysis on the fly.
With this new solution in place, the company had easy access to its financial data, from corporate credit card feed and booking systems to expense submissions and revenue, providing a comprehensive view of the T&E habits of its staff. The company could easily drill down into its data and determine its biggest policy offenders by simply identifying outliers. Several pre-built analysis reports were developed for answering common questions, with ad-hoc functionality that could answer new questions or investigate issues more thoroughly. The solution’s real-time design maximised available hardware and was driven completely from existing systems, providing vital security. With Protiviti’s support, the company now has complete visibility and access to its critical data and has already expanded the solution to Project Revenue Reporting, thanks to the easily scalable and flexible AWS architecture.