American Recovery Act Business Intelligence

329px-official_seal_of_the_american_recovery_and_reinvestment_act_of_2009svg

On February 17, 2009, President Obama signed into law the American Recovery and Reinvestment Act of 2009 (ARRA or the Recovery Act). It places great emphasis on accountability and transparency in the use of taxpayer dollars — anybody who receives funds must meet stringent legal requirements to publish timely and accurate accounting, allocation and results data for every dollar received:

Recipient Reports. Not later than 10 days after the end of each calendar quarter, each recipient that received recovery funds from a Federal agency shall submit a report to that agency that contains–

(1) the total amount of recovery funds received from that agency;
(2) the amount of recovery funds received that were expended or obligated to projects or activities; and
(3) a detailed list of all projects or activities for which recovery funds were expended or obligated, including

the name of the project or activity;

a description of the project or activity;

an evaluation of the completion status of the project or activity;

an estimate of the number of jobs created and the number of jobs retained by the project or activity; and

for infrastructure investments made by State and local …

329px-official_seal_of_the_american_recovery_and_reinvestment_act_of_2009svg

On February 17, 2009, President Obama signed into law the American Recovery and Reinvestment Act of 2009 (ARRA or the Recovery Act). It places great emphasis on accountability and transparency in the use of taxpayer dollars — anybody that receives funds must meet stringent legal requirements to publish timely and accurate accounting, allocation and results data for every dollar received:

Recipient Reports. Not later than 10 days after the end of each calendar quarter, each recipient that received recovery funds from a Federal agency shall submit a report to that agency that contains–

(1) the total amount of recovery funds received from that agency;
(2) the amount of recovery funds received that were expended or obligated to projects or activities; and
(3) a detailed list of all projects or activities for which recovery funds were expended or obligated, including

the name of the project or activity;

a description of the project or activity;

an evaluation of the completion status of the project or activity;

an estimate of the number of jobs created and the number of jobs retained by the project or activity; and

for infrastructure investments made by State and local governments, the purpose, total cost, and rationale of the agency for funding the infrastructure investment with funds made available under this Act, and name of the person to contact at the agency if there are concerns with the infrastructure investment.

(4) Detailed information on any subcontracts or subgrants awarded by the recipient to include the data elements required to comply with the Federal Funding Accountability and Transparency Act of 2006 (Public Law 109-282), allowing aggregate reporting on awards below $25,000 or to individuals, as prescribed by the Director of the Office of Management and Budget.

The US government has then promised to publish much of this information on the www.recovery.gov website:

“Recovery.gov is a website that allows you, the taxpayer, to see how the money from the American Recovery and Reinvestment Act is being distributed and managed. Within days after the signing of the legislation, Federal agencies started distributing funds. As the agencies report data to Recovery.gov, you will be able to see the states, Congressional districts, and even Federal contractors that receive Recovery fund. We’ll display that information visually, through maps, charts, and graphics.”

This means the US government is essentially mandating effective use of business intelligence for any organization that touches the US$787 billion in economic stimulus money, and major vendors such as SAP and IBM have quickly rolled out reporting packages to help organizations meet the new requirements.

SAP has published a white paper with more information about Maximizing the Value of Economic Stimulus Funds

And SAP has recently announced a Management and Reporting of American Recovery and Reinvestment (ARRA) funds package. It is designed to help organization answer questions such as:

How do I meet reporting requirements and deadlines?
How do I effectively monitor and account for spending of funds in mandated time frames?
How do I enable complete visibility into spend?
How do I measure and report outcomes and performance?
How do I mitigate risk and ensure compliance with federal requirements?

The package is based on the SAP BusinessObjects portfolio, including dashboards:

Here’s an interactive version (sorry, there’s a slight glitch: the videos at the top left do not work). Note the inclusion of “sentiment analysis” on the fourth tab:

Of course, dashboards are useless without the underlying data, and so the ARRA reporting solution includes information management to provide analytical support and models for reporting stimulus data:

The solution also includes options for strategy management to enable government policy management and tracking of stimulus spending against strategic policy outcomes, and mobile software to provide remote access to business intelligence data:

Choosing a flexible solution will be essential: Chris Kanaracus of IT World reports that the federal government may still fine-tune its reporting guidelines leading up to the first quarterly report deadline of Oct. 10.

And collecting the data from the recipients is just the start. The Recovery Act proposes a sophisticated “Accountability Framework” designed to monitor reporting compliance, operational efficiency, and when the strategic outcomes are actually being achieved (see diagram below).

As I’ve mentioned before on this blog, it’s pointless to talk about performance without risk, so it’s especially gratifying to see that the accountability framework emphasizes the importance of governance, risk, and compliance:

To promote effective management of Recovery Act funds and compliance with the objectives of the Act, the Department developed a Risk Management Plan that includes the following:

Identification of significant risks related to the achievement of Recovery Act goals and the primary drivers of such risks (at the Department level and program-specific level)

Quantification of the potential impact and likelihood of significant risks

Evaluation of existing control activities

Review of performance monitoring and reporting processes

Analysis of significant internal control gaps and areas for improvement

Mitigation of risks with the highest probability of occurrence and greatest impact if not mitigated

Tracking of progress against the risk identification, assessment, and mitigation framework.

I can’t sum things up better than Doug Henschen in his article on Tracking the Stimulus: BI Answers Call for Government Transparency:

“The Recovery Act sets forth audacious goals, including creating 3.5 million jobs, upgrading 75 percent of the nation’s worst bridges and highways, and weatherizing and modernizing 75 percent of federal buildings to be more energy efficient — all within two years. Add to that list the goal of attempting what may turn out to be the biggest experiment in e-government-style reporting and transparency every attempted. What’s more, it’s a BI-powered project, and within a few short years it may prove whether (or not) there is such a thing as intelligent government.”

Greater government transparency through business intelligence may turn out to be the most challenging – and world-transforming — BI applications ever.