Report User Training : How to Mine Value

1
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

2
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 CA attributes
• Approved Reference Model updates
• Other complex data load support for bureaus
• Future Blueprint Wizard tool for MBT updates

3
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!
4
DOI Enterprise Architecture Repository (DEAR)
Conceptual Meta-model
Not in DEAR
5
System Architecture

• Key Concepts
• Describes Systems and their building blocks
• Relates closely to investment architecture
• Hierarchically links
• Systems
• Sub-systems
• System components (reusable)
• Has CA information to classify systems by
  whether they are certified and accredited (CA
  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

Security/Privacy
CA Phase
Security Data Set
Privacy Data Set
CA Phase
CA Phase
Inventory
Enclave
Enclave
Enclave
System
DOI Tracked System
System Architecture Detail
Sub- System
System- Component
Sub- System
Sub- System
System- Component Interface
System Interface Capability
System- Component Instance
System Interface Capability
System- Component Instance
System Interface Capability
System- Component Instance
6
Report Examples - DEAR Model Reporting

• 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

7
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/cor
  e/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

8
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/archite
  cture/step1.htm

9
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

10
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

11
Document Abstract
Revision History