# Presentation: 676636

## AART Reporting Suite A Reporting Suite to Transform A-123 Data into Valuable Business Intelligence

**DOE A-123 PMT Introduces:**

## Reporting Suite Topics

**Part I – Reporting Suite Overview**
**Introduction to Reporting Suite**
**Leveraging A-123 Data**
**Capabilities Summary**
**Part II – Reporting Suite in Action**
**Reporting Suite Components**
**Reporting Suite Examples**

## AART Reporting Suite

## Data Collected through A-123 Implementation

**Types of Data collected during the A-123 Implementation Process include: **
- Entity Areas and
- 	Sub-Categories
- Processes and
- 	Sub-Processes
- Inherent Risks
- Controls
- Inefficiencies
- Remediation
- 	Activities
- Testing

**AARTS**

**Reporting Suite**

**A-123 Data**

**Data Display**

## Leveraging A-123 Data to Support Business Objectives

**Data gathered through the A-123 process provides decision-making information in the areas of:**
- Reliability of Financial Reporting
- Effective Controls
- Eliminating Fraud, Waste, and Abuse
- Clean Audit Opinions
- Compliance
- Integration with other Internal Control Reviews
- Business Process Improvements

## AART Reporting Suite Capabilities

**Reporting Suite capabilities include:**
- Data Consolidation
- Standard Report Generation
- Custom Report Development

## Takeaways

**AART Reporting Suite:**
- Facilitates management decision making
- Allows you to leverage A-123 data to meet business goals outside of the A-123 implementation scope
- Supports meeting A-123 objectives
**To find out more, watch Part II of this video and contact your local A-123 Lead**

## AART Reporting Suite Components

**The major components of the Reporting Suite are:**

**User Developed Reports**

**Standard Reports**

**Data Consolidation Tool**

## Data Consolidation Tool

**The data consolidation tool****:**
- Consolidates Assess and Test data from selected AARTs
- Translates the data into a standard MS Excel database reporting structure
- Provides refresh capability, data field dictionary, and named ranges to support report generation

**AARTS**

**Data **
**Consolidation**

## Standard Reports to Meet Your Needs

**Developed to meet the most commonly identified reporting needs**

## Standard Reports to Meet Your Needs

**Developed to meet the most commonly identified reporting needs**

## Standard Reports

**Benefits**
- No special knowledge required
- Includes common types of analyses to minimize redundant report development
- Provides consistent metrics for ease of data comparison
**Release Strategy**
- Released Incrementally as Packages
- Reports for each package selected to
- 	meet a range of common information
- 	needs

## Standard Report Examples

**Progress Reports by Phase**
- Represent the degree of completion for each A-123 phase

## Standard Report Examples

**A-123 Completion Assessment**
- Represents current completion status

## Standard Report Examples

**Control Environment Health Statistics**
- Summarize key metrics regarding risks and controls

## User Developed Reports

**Enable you to create reports to meet your specific information needs**

## User Developed Reports Example

**Scenario:**
**	**A Field Office has received significant audit findings in the Payables Management area at a site and needs to review the controls in place for the process at that site

## Takeaways

**AART Reporting Suite:**
- Provides out-of-the box standard reports
- Facilitates creation of reports to meet your specific business intelligence needs
- Allows you to leverage A-123 investment for business intelligence

## DOE A-123 PMT Contact Information

**Helpdesk Phone:  **(301) 903-3937
**Helpdesk Email:  **A-123Helpdesk@hq.doe.gov
**Website:  **www.cfo.doe.gov/cf1-2/doeA123/index.htm

## Slide 20