Case Study

Enterprise Report Rationalization​

Data Technology


U.S. Bank Cooperative


Data Quality & Lineage, Process Automation, Business Intelligence & Reporting

Project Overview

The Client’s senior leadership sought guidance on improving governance and report management practices across the enterprise. ​ RP built a survey intake form with industry standard metadata to identify reports across all business lines and several siloed reporting platforms; developed a comprehensive report catalog to provide transparency into report ownership, source, utilization, and purpose; and provided a set of recommendations and a roadmap, including establishing a Reporting Governance Framework to manage and establish a systematic report management practice. ​ The team then analyzed report usage statistics and conducted stakeholder interviews to develop a regular report archival process.


  • Reference Point deployed a team of data analysts to establish a comprehensive report catalog, capture associated metadata, and categorize reports based on key attributes. Key observations provided the foundation for the development of a Report Governance Framework including a Reporting Operating Model, RACI matrix, ownership model, and standards and procedures.

  • The team also developed a Modernization Roadmap that outlined a Report Retirement & Modernization Strategy to improve report management practices and identify opportunities for improvement.

  • The team successfully built and operationalized a report archival process which, analyzes report usage statistics monthly, taking into consideration exceptions, such as regulatory requirements, for reports that are required to be maintained for various timeframes

  • Additionally, the team built automation requirements, first utilizing a set of complex Excel Macros that enabled the data analysis, generation of excel files for distribution, and automatic saving on to a shared SharePoint site, with leverageable documentation for enhanced automation in the future. 


  • Reference Point’s expertise and extensive analysis identified approximately half of the bank’s reports as candidates for archiving based on inactive usage and duplication.

  • Establishment of a report ownership structure and associated RACI matrix promoted accountability, responsibility and improved the efficacy of the Client’s report management practices

  • Development of reporting standards and procedures ensured adoption of best practices for creating, managing, and utilizing reports and corresponding metadata across the bank.

  • The Report Modernization Roadmap showcased the value of continued maturation of the Client’s governance and report management practices to optimize reporting capabilities.

End-to-End Services, Working Together

We approach every engagement with our client in mind—creating solutions that are tailored to fit the task at hand. Our interrelated services offerings address a wide range of client needs. Whether a company is looking to solve a problem or capitalize on an opportunity, we can help them to achieve and exceed their goals—effectively and efficiently.

See Services See More Cases