Case Study
Salt River Project Power District: Simplified SAP Data Integration, Analytics and Reporting Solution.
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
“Given an eight month timeline, SRP partnered with Neudesic and formed a team to build and implement an enterprise data warehouse from start to finish. Upon discovery of a data integration issue mid-project, Neudesic supported us with a CountERPart for SAP data integration tool, which saved us weeks of effort. Neudesic’s leadership and technical contributions throughout the project were instrumental to our success.“— Lindsey Lee, Manager, Business Intelligence Services |