Transcript Datawatch Visual Data Discovery - Financial Management Services

Impact
Datawatch
Visual Data
Discovery
Department of Defense
United States Army
Detail Financial Transaction Data
Visualization
Department of the Army
Federal Financial Management
Integrity, Transparency, & Accountability
U.S. Constitution
Financial Statements
Preamble: We the People of the United States,
in Order to form a more perfect Union, establish
Justice, insure domestic Tranquility, provide for
the common defense, promote the general
Welfare, and secure the Blessing of Liberty to
ourselves and our Posterity, do ordain and
establish this Constitution for the United States
of America.
Integrity
Article I, Section , Section 9, Clause 7: No
Money shall be drawn from the Treasury, but in
Consequence of Appropriations made by Law:
and a regular Statement and Account of the
Receipts and Expenditures of all public Money
shall be published from time to time.
Independent Oversight:
Government Accountability Office
Agency Inspector General
Congressional Budget Office
Accountability - To The Public
President
Congressional Representatives
Executive & Legislative Branch
Political & Career Employees
Transparency - To The Public
OMB: President’s Budget & Appendix
Treasury: Combined Statement & Annual Report
Congress: Bills, Reports, & Public Laws
GAO: Audit, Accountability, & Performance Reports
Agency: Financial, Audit, & Performance Reports
Datawatch Corporation
Visual Data Discovery
http://datawatch.com/products/datawatch-visual-data-discovery - http://datawatch.com/form-page
 Visually Design, Discover and Explore New Insights From Any Data
in Real-Time: With the new understanding of the value of Big Data and the accelerating
pace of business, organizations need more than ever the ability easily access and visually
explore any information source at any speed, especially real-time. Organizations need powerful
tools to empower them to leverage every shred of data available and then manage, secure, and
deliver that information to transform business processes, increase visibility to critical Big Data
sources, and improve business intelligence applications offering broader analytical capabilities.
 Securely Share and Analyze Visualizations Throughout Your
Organization: To fully exploit the power of optimized information, organizations must ensure
that every shred of information is easily available to users of all types. With Datawatch Server
(formerly Datawatch Enterprise Server and Panopticon Server), companies of all sizes can allow
every user to access and visualize in real-time this information through a web browser and
provide them the ability to analyze and understand this information more effectively
With the ability to manage, secure, and visualize this content, users of all levels can access the
information stored in structured, unstructured and semi-structured sources like static reports,
PDF files, and EDI streams – in real-time sources like CEP engines, tick or machine data, to
gain a complete understanding of the business. By using the models developed in Datawatch
Modeler, and managing and securing them in a high availability server, that works directly with
Datawatch’s high performance Datawatch Automator , you can make your big data solutions
available to every user ensuring that no matter where they are they Get the Whole Story!
Federal Financial Management
Financial Reporting Relationships
Financial Statements
Financial Reporting Process Flow
Army
Army
Legacy Accounting & Reporting Systems
Core Accounting System (GFEBS):
General Fund Enterprise Business System
House Armed Service Committee FINANCIAL
MANAGEMENT AND AUDITABILITY REFORM
Findings & Recommendations, January 24, 2012
Treasury
Combined Statement of Receipts, Outlays, and
Balances of the United States Government
Monthly Treasury Statement
Annual Financial Report
Daily Detail Transaction Process
• Legacy Financial Systems
• GEFEB Data Interface with Legacy System
Annual Budget MAX Reporting to OMB
Monthly Summary Reporting to Treasury
• Statement of Accountability
• Monthly Statement of Transactions
Treasury
• Monthly Treasury Statement
• Annual Combined Statement (Cash Basis)
• Annual Financial Report (Accrual Basis)
Office of Management & Budget
Office of Management & Budget
Presidents Budget
Budget Appendix
• President’s Budget Document
• Budget Appendix
• Budget Historical & Other Tables
Datawatch Corporation
Visual Data Discovery
Business Case 1 – IT Investment ITDASHBOARD
Office of Management & Budget
Visual Data Discovery
Business Case 1 – IT Investment Department Level
Office of Management & Budget
Visual Data Discovery
Business Case 1 – IT Investment Bureau/Service Level
Datawatch Corporation
Visual Data Discovery
Business Case 1 – IT Investment Department Level
Datawatch Corporation
Visual Data Discovery
Business Case 1 – IT Investment Bureau/Service Level
Datawatch Corporation
Visual Data Discovery
Business Case 1 – IT Investment IT Infrastructure
Datawatch Corporation
Visual Data Discovery
Business Case 1 – IT Investment Warfighter
Datawatch Corporation
Visual Data Discovery
Business Case 2 – Personnel Services
 DoD Army Military Personnel Services
Datawatch Data Visualization Demonstration
 Federal Government Personnel Classification
Structure Metrics
 Treasury Combined Statement Personnel Data
distributed by State, County, Foreign Country, &
compared to OMB, Treasury & Agency Legacy
financial Systems
 Other Metric Comparison to the above County or
State distribution if data is available to the public
or that is available from Department and Agency
Core Accounting Systems::
 Employment
 Unemployment
 US Population by State
 Congressional District
 Natural & Man Made Disaster Spending
 Crime
 Federal Government Personnel Classification Structure Metrics
 Other data sources, e.g., http://www.usgovernmentspending.com/federal_budget_fy13
Datawatch Corporation
Visual Data Discovery
Business Case 2 – Personnel Services
Datawatch Corporation
Visual Data Discovery
Business Case 2 – Personnel Services
BACKGROUND Material
Related to Available Data to the
Public Used in the
Demonstration
Common Government-wide Accounting
Classification Structure
Core Financial Systems Requirements
Common Government-wide Accounting
Classification Structure
Core Financial Systems Requirements
Common Government-wide Accounting
Classification Structure
Common Government-wide Accounting
Classification Structure
PROGRAM
FUND CODE
AGENCY
Program
Project
TREASURY
ACCOUNT SYMBOL
Activity
Sub
Level
Prefix
Code
Allocation
Transfer
Agency
Identifier
FUND ATTRIBUTES
FEDERAL ACCOUNT SYMBOL TITLE
Activity
Code
Fund
Type
Code
Receipt
Account
Indicator
USSGL
Account
Code
Budget
Function
Code
Budget Sub
Function
Code
Object
Code
PAYEE NAME & ADDRESS
Payee
Beginning
Period of
Availability
Ending
Period of Availability Type Code
Availability
USSGL Account
COST
Cost
Center
Code
Agency
Identifier
Street 1
Street 2
City
Sub
Object
Code
ZIP
Country
Sub
Account
Code
ORGANIZATION
Reveue
Source
Code
Agency
Lodation
Code
Business Event
Type Code
BETC Listing
Reporting
Agency
Identifier
OTHER CLASSIFICATION CODES
State
Main
Account
Code
North American
Industrial Classification
System (NAICS)
[Standard Industrial
Classification System
(SIC)]
Catalog of
Federal
Domestic
Assistance
Programs
(CFDA)
Dun and
Bradstreet
(DUNS)
Business
Registration
Number
Reporting
Bureau
Identifier
TREASURY COMBINED
STATEMENT REPORTING
OUTLAYS
Department of the Treasury
Federal Accounts Symbols and Title FASTBOOK)
Office of Management & Budget
President’s Budget
of the United States Government
Office of Management & Budget
Budget Appendix
of the United States Government
Office of Management & Budget
Budget Appendix
Program & Financing Schedule
Office of Management & Budget
Budget Appendix
Program & Financing Schedule
Government Printing Office
National Defense Authorization Act
Fiscal Year 2012 - H.R. 112-1540
Government Printing Office
Department of Defense Appropriation Act
Fiscal Year 2012 - P.L. 112-74
Department of the Treasury
Combined Statement Of Receipt, Outlays, and
Balances of the United States Government
Department of the Treasury
Combined Statement Of Receipt, Outlays, and
Balances of the United States Government