Real-time Financial Analytics Application Speeds Up Data Processing by 100X

About Client 

One of the leading audit and professional services firms that supports clients globally by providing a full range of consulting, risk management, legal, tax, and financial advisory services.

• Location: USA
• Cooperation period: 2008 - present
• Industry: Professional Services
• Employees: 100,000+

Business Challenge

While working on the development of predictive quality models, the client's data scientists faced the problem of poor quality of exported data (incomplete, insufficient, etc.) needed for training a model.

• With the amount of data constantly growing, our client needed to re-platform Finance databases from legacy SAP BW to support Next-Gen Project Analytics in the future
• Integrate Special and General Ledger data into the HANA analytics platform
• Enable near real-time data availability
• Allow access to data by utilizing established tool sets (SAP Analysis for Microsoft Office, Tableau)

Solution

• Implemented SAP HANA Advanced Financial Analytics Project that delivers existing core finance data to the SAP HANA platform from ECC using the Special and General Ledger to meet ad hoc reporting requirements.
• The system contains at least 3bln records and is used by at least 10,000 users daily.

Technologies & Tools

• SAP HANA
• SAP BODS
• SAP Analysis for Microsoft Office
• Tableau
• Angular

Business Value

• Increased data availability to allow more in-depth strategic trending and analytics
• Enabled deeper analytics by providing detailed date-level data
• Reduced manual efforts of business 100 times resources on manual reporting efforts
• Improved data processing by up to