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
