GetAhead - Getting YOU Ahead in YOUR career!

GetAhead in DATA analysis

COURSE DESCRIPTION

This training course will teach you the core skills needed for the analysis and design of the key processes that constitute any any information (data) based business system.

Data Analysis

You will learn how to:

Apply the recognized industry standard analysis technique of data modeling.
Analyze any information-based system and produce a clear pictorial representation of it.
Identify opportunities and problem areas within an existing data environment.
Model and assess the impact of any proposed changes to information flows.
Optimize the storage and processing of information within a database.

Study Area 1 - 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 - Introduces, explains and illustrates what constitutes an entity and discusses in detail; types, occurrences, data groups and items.
Identification Guidelines - Introduces a set of accepted, practical standards for entity identification.
Entity Keys - Explains: compound keys, primary keys, foreign keys and candidate keys.
Entity Descriptions - Candidates learn the basic principles of completing a formal entity description.
Relationships – Introduces the second element of a data model, the relationship between entities. It explains: occurrences, link phrase, cardinality and participation/optionality.
Identifying Relationships - Teaches the basic skills required to identify and model entity relationships and how to define accurate relationship statements.

Study Area 3 - Modelling Complex Relationships

Resolving M:M Relationships - The practical techniques used to resolve many-to-many relationships are explained.
Resolving 1:1 Relationships - Teaches users how to identify and resolve one-to-one relationships.
Multiple Relationships - Explains how to portray entities when they have multiple relationships.
Exclusive Relationships - Explains the special nature of exclusive relationship groups and how to depict them in the data model.
Recursive Relationships - Explains how to identify and model recursive relationships.

Study Area 4 – Building the Data Model

Entity Cross Referencing – Explains the formal approach of entity cross-referencing.
Informal Relationship Identification - Candidates learn a less formal approach, which takes into account probable relationships, as the model evolves.
Drawing the Preliminary Model - Provides candidates with practice in drawing a preliminary data model.
Refining the Preliminary Model - Interactive exercises aimed at enhancing and refining a simple preliminary data model.

Study Area 5 - Advanced Exercises

1 - interactive exercise applies all of the concepts and techniques learned on the course to a straightforward business scenario. Full case study support is provided.
2 - The second interactive exercise introduces more advanced data modelling techniques, including ‘connection traps’. This exercise uses a more complex business environment, supported by a detailed case study.

Back to Top