Business Challenges

• Inefficient Process – Significantmanual effort required to produce consolidated reporting across all lines of business, including key operational drivers
• Siloed Reporting and Analytics – Lacked a central repository for customer mapping and global consolidated customer reporting across all LOBs
• Difficulty “Drilling Down” – Lacked ability for FP&A to drill from account level data to invoice vendor and customer detail quickly and easily

Solution

• Centralized Reporting Solution – Created dashboards for C-suite executives and line of business leads using Oracle Analytics Cloud (OAC)
• Standardized Input – Leveraged Application Express (APEX) to allow users to easily upload files through a web interface
• Drill Down Capabilities – Dashboards provide drillable features to allow insight from summary to transaction level detail
• Data Load Automation – Simplified data loading and transformation process from multiple source systems

Impact

• Improved Insights – Improved visibility into customer and vendor invoicing details across all lines of business enables strategic decision making
• Established a Technology Foundation – Created an enabling technology and framework for extending and expanding organization’s analytic and reporting footprint over time
• Reduced Monthly Manual Efforts – Minimal effort now required to load data and update dashboards, allowing users to focus on analysis and strategic decision making