Data Analysis

Note:  This product is included as part of the Analysis - 2 CD Set.

Product Description:
This 5 hour interactive multimedia training course is equivalent in scope to a two-day instructor led course. It will teach you the core skills needed for the analysis and design of any information (data) based business system.  Please note that this product is licensed to one user only and can be installed on any individual PC.

Course Overview:
This interactive multimedia training course is accredited by NCC Education Services. It will teach you how to apply the IT industry standard techniques of data modeling: from understanding the simple symbol notation used to drawing an accurate data model of an entire business area. This approach enables you to analyze, understand and then optimize the way that information is stored and retrieved within any business system. This course teaches candidates how to create data models that depict the current, or planned, business system and how to optimize the way that information is stored and processed. The course covers the entire method: from initial investigation to refinement of the diagrams you produce.

The course will run on any multimedia PC with a sound card and is presented using a combination of specially developed 3D graphics, animation and interactivity. This provides a stimulating one-on-one multimedia learning environment that is packed with interactive exercises, case studies and questions. It is made up of self-contained sections, each representing approximately 15 minutes of training, which means that it can either be used intensively or be fitted into a busy work schedule.

This course contains the following Sections:

Study Area 1 - Introduction
Introduction - Data analysis enables you to analyze, understand and then optimize the way that information is stored and retrieved within a business system. This course teaches candidates how to create data models that depict the current, or planned, business system and how to optimize the way that information is stored and processed.

Study Area 2 - Entities & Relationships
Entities - This section introduces, explains and illustrates what constitutes an entity and discusses in detail; types, occurrences, data groups and items.

Identifying Entities - Involves the candidate in identifying entities in a simple business scenario.

Entity Identification Guidelines - Introduces a set of accepted, practical standards and guidelines for entity identification.

Entity Keys - Explains the use of entity attributes as keys within the data model. Topics covered include: compound keys, primary keys, foreign keys and candidate keys.

Entity Descriptions - In this section candidates learn the basic principles of completing a formal entity description.

Relationships - The relationships section introduces the second critical component of a data model, the ‘relationship’ between entities. Topics include: occurrences, link phrase, cardinality and participation/optionally.

Identifying Relationships -This section teaches the basic skills required to identify and model entity relationships.

Relationship Statements - Explains how to identify the principal forms of notation used when defining relationship statements.

Study Area 3 - Modeling Complex Relationships
Resolving M:M Relationships - The practical techniques used to resolve many-to-many relationships are explained in this section, as are the reasons that these relationships are not permitted on formal data models.

Resolving 1:1 Relationships - One-to-one relationships are rare and are not permitted in formal data models. This section teaches users how to resolve apparent 1:1 relationships.

Amending the Diagrams - Once candidates have resolved the apparent M:M and 1:1 relationships, they will need the skills taught in this section to amend the final data model.

Multiple Relationships - Explains how to portray entities when they have multiple relationships.

Exclusive Relationships - This section explains the special nature of exclusive relationship groups and how to depict them in the data model.

Recursive Relationships - A recursive relationship is one in which an entity has a relationship with itself; this section explains how to identify and model recursive relationships.

Study Area 4 - Conducting the Analysis
Entity Cross Referencing - There is a choice between a rigorous, formal referencing technique and one based on ‘what usually happens’. This section concentrates on the formal, rigorous approach.

Informal Relationship Identification - In this section candidates learn a less formal approach, which takes into account probable relationships, as the model evolves.

Drawing the Preliminary Model - This section provides candidates with practice in drawing a simple preliminary data model.

Refining the Preliminary Model - Interactive exercises aimed at enhancing and refining a simple preliminary data model.

Study Area 5 - Advanced Exercises
Exercise 1 - This interactive exercise applies all of the concepts and techniques learned on the course to a straightforward business scenario. Full case study support is provided.

Exercise 2 - The second interactive exercise applies all of the concepts and techniques learned on the course to a more complex business scenario. It also introduces more advanced data modeling techniques, for example, ‘connection traps’. Full case study support is provided.

Want Additional Information?

to view screen shots of course.

to download our product brochure.

to learn more about how to order online.

to sign up to receive our electronic Newsletter.

Looking for Additional Savings?

This product forms part of the Analysis - 2 CD Set for just $59 US.

Order our Complete Training - 10 CD Set for just $249 US and get all 10 courses.

Method of Delivery

This product is not downloadable and must be shipped.  Please select the shipping option when completing your on-line transaction.

    We accept Visa and MasterCard