IRM Training Pty Ltd - Business Analysis Training
Select a course description to viewSelect a city to view schedules and online bookingsCourse ReviewsAbout usContact usSelect a resource to viewBack to home page


DATA ANALYSIS & MODELLING (DAM) - 2 day workshop

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.

download brochure


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.



    Data Analysis & Modelling Course fees & booking

    Data Analysis & Modelling is currently running as an inhouse course only.

    To discuss your inhouse course requirements and pricing, call 03 9533 2300 or email training@irm.com.au

    Australian Government Endorsed Supplier    		 Australian Computer Society



    back to top