image
image

Data Analysis & Modelling (DAM)

 Duration: 2 days   |  Cost: $1,485 inc GST  |  download brochure
This course is endorsed by the IIBA® and is compliant with Version 2 of the BABOK®

Endorsed by the IIBA
(Program ID: E018-006, CDU:14)

Data is the lifeblood of an organisation - from client information held in marketing and customer service applications to operational and competitive data in business intelligence systems and data warehouses. To get maximum benefit out of the ever increasing volumes of information, good data analysis and data modelling skills are essential.

In this course you'll learn top-down business and application data modelling and how to analyse and normalise data. You'll learn how to use entities, attributes, keys, relationships and how to build data models using entity relationship diagrams. The course provides practical training in the core skills needed to model data that reflects the needs of the business.


Is this the right course for you?

 The course is suitable for anyone involved with the analysis, specification or development of databases. This includes:
  • Business analysts
  • Systems analysts
  • Programmers and developers
  • Database administrators
  • Data architects
Course topics are applicable to all popular database products (Microsoft, Oracle, IBM, etc) and all types of systems (client/server, web, PC, mainframe).


Course objectives

 To provide practical training in analysis and modelling techniques so that organisational data and business logic can be translated into robust data models - efficiently and without duplication or redundancy.

Accurate data models allow optimum database design, leading to improved application performance and faster response times. It also provides a reference point for business users, developers, architects and database administrators.

The process of data modelling forces a detailed examination of core business data and business rules. This highlights inefficient processes and missing data which can be of value to the organisation.


Learning outcomes

 How this course can help you be a better data analyst - you'll learn how to:
  • develop a top-down business and application data model (Entity Relationship Model)
  • describe entities, attribute, keys and relationships
  • analyse and normalise data
  • build third normal form data models
  • build a composite data model
  • understand fourth and fifth normal forms

Customer testimonials

 "Excellent course giving all the essentially required tools for analysis and design"
Solutions Design Architect, NAB

"Helped me understand the benefits of good data analysis - good data analysis leads to a good structured solution"
Analyst Programmer, CSC

"Well presented, meaningful and well structured. Excellent real-life exercises"
Business Analyst, Wesptac

"A great help in refreshing the knowledge I gained at university - made it all make sense and fall into place"
Business Analyst, ATO

"Great to hear people talking about how relevant the course was to their work, and how they can immediately use what they have learnt"
Business Information Manager, BP


Course outline

 DAY 1

INTRODUCTION
  • Examples of data analysis
  • Application of data analysis during the project life cycle
  • Role of the analyst, designer and user during this activity
BASIC PRINCIPLES AND TERMINOLOGY
  • The business analysis approach
  • Cross checking & consolidation
  • Global, application & transaction model
  • Entities, attributes, relationships & normalisation
ENTITY RELATIONSHIPS
  • Relationship notation
  • Mapping
  • Simple & complex relationships
  • Naming relationships & models
  • Producing an application data model from the results of normalisation

DAY 2

DATA ANALYSIS AND NORMALISATION
  • Fact finding & identification of candidate data
  • Recording data in a data dictionary
  • Data dictionary notation
  • Normalisation
  • First, second & third relations
GLOBAL DATA MODEL
  • Analysis of business rules
  • Drawing a global data model
  • Annotating the data model & checking with user management
COMPOSITE DATA MODEL
  • Composite & compound keys
  • Key-only relations
  • Combining models to form one composite data model
FOURTH AND FIFTH NORMAL FORMS
  • Circumstances which may lead to data anomalies in key fields
  • Overview of transaction path analysis


All IRM courses are practical workshops, led by instructors with real-world business analysis experience. Each workshop is oriented around a fully worked case study with an emphasis on practical work, both individually and in teams. Each delegate takes away a comprehensive course manual - much more than a collection of slides, the manual is a valuable guide for future reference and contains numerous checklists and templates.

One thing we guarantee - these are "roll your sleeves up" courses with an emphasis on doing, participation, interaction and learning.

DAM is learn by doing... practical, hands-on, intensive... and fun!



how to book | back to top | download brochure image


 image
image