# Presentation: 670973

## Report User Training : How to Mine Value

- DEAR Input – MBT Updates and ongoing maintenance
- Diagrams
- System Architecture
- Department Loads
- Initial Inventory
- DEAR Output – Reporting capabilities
- DEAR Model Reporting
- Reference Model Reporting
- Validation Reporting
- Analysis Reporting
- Mining Tools

## How is data updated in DEAR?

- Power User makes updates – delegate of IAWG Bureau Lead
- Using Diagramming tools for business and data modeling
- Using System Wizard tool for
- System Architecture updates
- Inventory updates
- Reference Model Relationships to Systems
- Department Batch Loads
- Investment - Ex 53 Line items (no dollar figures) and Ex 300 FEA data
- Security – C&A attributes
- Approved Reference Model updates
- Other complex data load support for bureaus
- Future: Blueprint Wizard tool for MBT updates

## Recall What DEAR Is

- A repository of integrated enterprise architecture data.
- An enterprise data mining and modeling tool that emphasizes data integration and reuse of enterprise objects.
- A reporting tool that greatly expands access to integrated enterprise architecture data.

- This presentation focuses on the repository & data mining aspects of DEAR!

## DOI Enterprise Architecture Repository (DEAR) Conceptual Meta-model

- Not in
- DEAR

## System Architecture

- Interface
- Capability

- System
- Interface
- Capability

- System-
- Component
- Instance

- System-
- Component
- Instance

- Sub-
- System

- Sub-
- System

- C&A
- Phase

- C&A
- Phase

- Enclave

- Enclave

**System Architecture**

- Key Concepts:
- Describes Systems and their building blocks
- Relates closely to investment architecture
- Hierarchically links:
- Systems
- Sub-systems
- System components (reusable)
- Has C&A information to classify systems by whether they are certified and accredited (C&A status)
- Includes security & privacy data
- Flags Enclaves & Trust systems
- Key Domain Links:
- Uses links to other domains to describe sub-systems & system components in terms of:
- Services they perform (how they fit the SRM)
- Technology they use (TRM)
- Data they use (DRM)
- What business they support (BRM)
- Where deployed

- System-
- Component
- Interface

- C&A
- Phase

- Security
- Data Set

- Privacy
- Data Set

- Sub-
- System

- DOI Tracked
- System

- System

- Enclave

- System
- Interface
- Capability

- System-
- Component

- System-
- Component
- Instance

- Security/Privacy

- Inventory

**System Architecture Detail**

**Notes:**
Investment life-cycle cost (overall estimated investment required)
Investment life-cycle stage (Initial Concept, Planning, Full Acquisition, Steady-State, Mixed Life-Cycle)

## Report Examples - DEAR Model Reporting

- _[http://www.doi.gov/ocio/architecture/metamodel](http://www.doi.gov/ocio/architecture/metamodel)_
- Used for reviewing:
- What information is in DEAR
- Over 50 views are provided
- Navigate Interactive Diagrams
- Diagrams hyperlinked to Entity detail with Attribute detail

## Report Examples - Reference Model Reporting

- http://www.doi.gov/ocio/architecture/fea.htm
- Used for reviewing:
- Tabular view of reference models
- Linked views of reference models
- Interactive view of reference models
- http://www.doi.gov/ocio/architecture/documents/core/refmodel/default.htm
- Review “Line of Sight” between PRM to BRM to DRM or from SRM to TRM
- Interact with Reference Model diagrams hyperlinked to definitions

## Report Examples - Validation Reporting

- http://dear.nbc.gov/reports
- Select your organization or business blueprint area
- 90+ reports run nightly against your “BEAR”
- Portfolio-based validation – what is complete, gaps, etc.
- Used for Validating Phase System Arch. Information to :
- Inventory Section – Phase 1
- Technical Section – Phase 2
- Business Section – Phase 3
- Data Section – Phase 4
- Investment Section – Dept. Load
- Security Section – Dept Load
- Audit Section – BEAR Update Tracking
- Phase Guidance at: http://www.doi.gov/ocio/architecture/step1.htm

## Report Examples - Analysis Reporting

- http://dear.nbc.gov/reports
- In same sections, reports marked analysis show Reference Model reports to portfolios (or enterprise for DEAR) for redundancy analysis
- For specific System Analysis or Interactive Analysis, use:
- http://dear.nbc.gov/reports/DEAR/WIP/PANEL/default.htm
- Home page describes Who uses and why?
- CPIC, Security, Architects, Blueprint Teams, Procurement, etc.
- Examples of MBT products for Recreation also included on home page

## Report Examples - Mining Tools

- All reports are based on XML output
- Open in Word
- For sharing and tracking changes while offline edits are made with multiple editors
- Open in Excel
- For filtering – Data Menu, Autofilter – Filter on specific attributes to perform ad-hoc queries against canned views
- For Sorting – Data Menu, Sort – Sort to change views by different attribute ascending and descending order
- For charting – Inset Menu, Chart... - Use the Chart wizard after selecting data to view trends visually
- For Pivot Tables (aka Matrix views) – Data Menu, Pivot Tables – Use for building Matrix Views (and Pivot/Matrix Charts) (i.e. Reference Model to systems
- Communicate – Save report, Email report, or Send Comments to DEAR Reporting Administrators

## Document Abstract

| Doc Status | Rev. Date | Author/Editor | Description of edit | Filename/lineage |
| --- | --- | --- | --- | --- |
| Initial | 02.13.2004 | M. Tricomi | Presented to Jim B | doi_cpic_training_02132004.ppt |
| Draft | 02.16.2004
 | J. Barrett | Added sections to 3 and 5 | doi_cpic_training_02182004_jb.ppt |
| Final | 02.17.2004 | M. Tricomi | QA/final | doi_cpic_training_02182004_final.ppt |
| Revision 1 | 04.05.2004 | K. Tallentire | Minor formatting changes | 4doi_cpic_training_04052004_r1.ppt |

| Key Words:
Application Technology Architecture | CPIC Training | FEAF Area:
Subject Function Code: | 
1230 | Contract #:  NBD020221
Task Number: 4 |
| --- | --- | --- | --- | --- |
| Used for Training CPIC members – Bureau and DOI |  |  |  |  |

**Revision History**