How to Model Business Data from Forms and User Views

Workshop: How to Model and Analyze Business System Data

Request an In-house Quote

Schedule Your Own Virtual Workshop

Check our Scheduled Business Analysis Training Classes

Print Course Description (pdf)

Overview

Data represents the atomic level of today’s information systems. Data is the building blocks upon which everything else depends. In a very real sense if you get the data right, the rest will follow. If you get the data wrong, the system may never recover. This workshop is designed to give you a time-proven set of techniques, methods, and tricks to help you acquire, understand, document, and model business data from both the forms, reports and screens that the business community uses.

Outline

  • Business Data and User Views
  • Simple Document for Invoicing System
  • Data Model from a Form
  • Identifying Entities
  • Normalization — a Bottom Up Approach
  • The Order Document for the Invoicing System
  • Normalized Order
  • Identifying Relationships from Normalization
  • Relationships for an Order
  • Normalize the Shipping Ticket
  • The Shipping Ticket
  • The Invoice
  • Normalization Helpful Hints
  • On Merging Data Models
  • Normalize an Invoice
  • Data Modeling — Two Approaches
  • Completing the Invoicing System Data Model
  • E/R (Entity-Relationship) Diagrams: A Summary


Objectives
  • Draw detailled data model (entity relationship) diagrams
  • Build a data model based on existing system documentation
  • Analyze user views, (screens, reports, etc.) to create a data model
  • Identify data entities based on their attributes
  • Define data attribute’s characteristics (metadata)
  • Determine the appropriate key attributes

 

Our vision of a virtual workshop is web-based training that is highly interactive. We absolutely avoid the death by page-turning and the passive learning approach that is highly prevalent in most web-based training.

3.5 hours

Target Audience

Business Analysts
Data Administrators
Data Analysts
Requirements Definition Specialists
System Analysts
Test Engineers
Anyone charged with managing, understanding and/or improving information use.