|
Data Analysis & Modelling (DAM)
Duration: 2 days | Cost: P.O.A. | download brochure
This course is currently not on our public training schedule. To enquire about running the training on your company premises (inhouse), please contact us.
Data analysis, data modelling and normalisation are key components of software development and are essential knowledge for software developers. This course introduces the delegate to the concepts and best practice. All Computer Aided Software Engineering (CASE) tools are built around these ideas and Object Oriented (OO) development also relies heavily on data analysis concepts. This knowledge is as basic to software development as Pythagoras is to mathematics.
All software developers need to be able to model data and to produce file structures that reflect the needs of the business - for today and tomorrow. Whether you are using a procedural language or a 4GL; a native file access method or a data base manager; whether systems are written internally or by 3rd party developers, the use of data analysis will greatly assist your ability to support future information processing needs. This 2-day Data Analysis & Modelling workshop covers it all.
Who will benefit?
Systems developers - business analysts, systems analysts, analyst-programmers and designers involved in the analysis, specification and development of computer-based systems.
Course objectives
Delegates will have a good understanding of data modelling and will be able to develop data storage designs to suit their environment.
Learning outcomes
On completion of the Data Analysis & Modelling workshop, delegates will be able to:
- develop a top-down business and application data model (Entity Relationship Model)
- describe entities, attributes, keys and relationships
- analyse and normalise data
- build third normal form data models
- understand fourth and fifth normal forms
- build a composite data models
Learning techniques
Techniques used on the Data Analysis & Modelling workshop include:
- lectures supported by visual aids
- class examples
- syndicate case study work
- small group sessions
- presentation of syndicate findings
- comprehensive delegate manual
Customer testimonials
Excellent course giving all the essentially required tools for analysis & design
Solution Design Architect, NAB
Very useful course... can be applied to actual job
Analyst Programmer, AXA
A great help in refreshing the knowledge I had gained at university. It made it all make sense and fall into place
Australian Tax Office
Well presented, meaningful and well structured. Excellent real life exercises
Westpac
Very useful for all types of IT people
Attorney General's Department
Extremely thorough
Department of Employment & Workplace Relations
Directly useful to my work
Systems Engineer, AirServices Australia
Good, clear details
Business Analyst, Origin Energy
Course outline
DAY 1
INTRODUCTION
Examples of data analysis; the application of data analysis during the project life cycle; the roles of analyst, designer and user during this activity.
BASIC PRINCIPLES & TERMINOLOGY
The business analysis approach; cross checking and consolidation; global, application and transaction models; entities, attributes, relationships and normalisation.
ENTITY RELATIONSHIPS
Relationship notation; exercise in mapping; simple and complex relationships; naming relationships and reasons for doing so; drawing an application data model from the results of normalisation.
DAY 2
DATA ANALYSIS & NORMALISATION
Fact finding and the identification of candidate data; recording data in the data dictionary; data dictionary notation; normalisation; examples of first, second, third, fourth and fifth normal form relations; normalisation exercise.
GLOBAL DATA MODEL
Analysis of business rules and an exercise to draw a global data model; annotating the data model and checking with user management.
THE COMPOSITE DATA MODEL
Composite and compound keys; key-only relations, combining the models to form one composite data model.
FOURTH & FIFTH NORMAL FORMS
Circumstances which may lead to data anomalies within key fields. Overview of transaction path analysis.
There are delegate and group exercises throughout the course so that theory is always backed up with examples and practical exercises.
back to top
|
|
|
|