Tutorial Outline

Data Analysis

Foundational Knowledge

This tutorial is designed for business analysts who wish to gain a deeper understanding of data analysis and data modelling.

The Tutorial

This two-day tutorial provides an integrated approach to data analysis and process modelling which emphasises data analysis as being an essential component of a comprehensive business analysis approach. With a focus on the critical data requirements for added value realization and competitive edge demands, this workshop provides participants with the completed model for Business Requirements Specification.

The objective of this tutorial is to enable business analysts to use data models in planning requirements and benefits realisation. At the end of the workshop participants will be able to conduct consultations with clients and stakeholders to verify a data model and to identify business objectives and business rules. They will be able to construct an Entity Relationship diagram for a small system, and will be able to interpret a wide range of data modelling elements and constructions in a business context.

Topics covered include:

Day 1

Introduction
What is Data Modelling and why use it:
Data modelling in the project life-cycle
Resolving ambiguities in business names
Basic concepts defined:
- Object Types
- Relationships
- Keys
- Super-Types and Sub-Types
Notations and Conventions
Putting it together…drawing the Entity-Relationship Diagram
Case Study: Preparing an ERD
Interview with the client
Review Day 1

Day 2

Normalisation (to 5th normal form)
Interpretation of an ERD in the business context, including:
- Reference Tables
- Summaries
- Access Keys
- Clusters
- Characteristics
Resolution of Many-to-Many relationships
Role Types and alternative generalized presentations
Explicit consideration of the business in the data model
Recursive structures
The time dimension:
- Time-stamping
Reconstruction options
MIS considerations
Case Study: Reviewing an ERD
Validation of the model
Technical concerns
Presentation issues: addressing the differing interests across the business
The transition to physical design
Conclusion: Summary and Review

Documentation

Participants will receive a full set of the tutorial reference materials.

Book an In-house Tutorial or a place on a Public Tutorial

In-house Tutorial

Public Tutorial

thomsett INTERNATIONAL would be pleased to help you with your enquiry regarding the presentation and / or tailoring of this tutorial for your organisation.

For further enquiries please contact us.

This tutorial is currently not scheduled for public presentation.

To review those workshops and tutorials that are scheduled publicly see our Public Workshop Schedule.




			copyright: thomsett INTERNATIONAL 2006 \| contact