By /

Client Background and Business Context

The customer is one of Canada’s premier corporations, providing customers with innovative, sustainable solutions in the sectors fundamental to global growth and prosperity: housing, real estate, energy, water, transportation, and agriculture.

The customer was looking for a single shared data analytics model across all Oracle and third-party applications. As a result, they decided to collaborate with Trinamix for the implementation of Oracle Fusion Analytics Warehouse integrated with the Oracle ERP Cloud modules: Financial Analytics: AP/AR/GL and Oracle Spend and Procurement Cloud. This implementation helped them achieve out-of-the-box procurement KPIs and spend analytics KPIs.

Client Industry

  • Energy and utilities

Oracle Modules Implemented

  • Oracle fusion analytics warehouse (FAW)

Geography

  • Canada

Key Solution Highlights

Supply Chain:

  • Classified and categorized customer spending data into a 3-level hierarchy with 13 categories, 150 sub-categories, and 800 items
  • Segmented spending into “Addressable” and “Non-Addressable “
  • Built a vendor hierarchy while ensuring data accuracy
  • Provisioned ML model for spend analytics and used the results to provide meaningful insights into spend data in FAW.
  • Created additional KPIs to identify immediate data quality opportunities
  • Enabled 125+ out-of-the-box SCM KPIs
  • Leveraged machine learning to drive alerts and discover relationships between metrics

Finance:

  • Enabled all ERP hierarchy data related to cost centers, departments, and more
  • Modified key KPIs/Dashboards/Reports with a focus on high-quality data
  • Enabled 175+ out-of-the-box Finance KPIs
  • Delivered 5 decks with drill-down details and more focused on high-quality data
  • Provided 25+ Pre-Built Dashboards/Reports, allowing easy creation of custom analysis (Profitability & Loss, Receivables, Payables, Procurement, and Balance Sheet) using the pre-built data model
  • Provided the ability to drill directly from KPIs into underlying details

Key Benefits

Quick access to critical Financial and Supply Chain KPIs and metrics compared to targets Faster time-to-value with everything pre-built and oracle managed

Better insight into profitability drivers and analyzing historical trends, providing leaders a greater understanding of all project costs – including inception-to-date and year-to-date comparisons across any project

Enhanced integration with non-cloud data sources provided an opportunity for enterprise-level analytics