The Challenge

In order to gain a complete view of its financial actuals, SRP needed to combine financial data stored in SAP with data from a number of isolated work management systems–each of which utilized a unique data structure. The company determined that creating the required reports and analytics in SAP BI would be too costly and could not be done in time to meet financial reporting deadlines and regulatory requirements.

The Solution

Neudesic used its CountERPart for SAP integration solution, ETL framework, and extensive utility industry knowledge to combine SRP’s SAP data with other critical information from its Oracle and IBM systems into a Microsoft enterprise data warehouse. Neudesic’s BI team then leveraged SRP’s existing Microsoft BI tools to quickly and cost effectively create dashboards and reports hosted in SharePoint. Neudesic’s solution also provides SRP’s business users with self-service analytics through Microsoft Excel PivotTables/PivotCharts and Power Pivot.

The Benefit

  • Leverages SRP’s existing investment in Microsoft BI tools, reducing the cost to re-create reports and analytics in SAP BI by 66%
  • Enabled SRP to meet regulatory requirements and launch its solution ahead of financial reporting deadlines
  • Allows SRP to use familiar Microsoft BI tools, eliminating any specialized training
  • Helps SRP reduce the cost of managing an enterprise data warehouse