Data Analysis & Modelling Course Logo

DATA ANALYSIS & MODELLING

Data Analysis & Modelling course endorsed by IIBA Program ID: E018-006 | PD Hours/CDU:14

Duration: 2 days | Instructor-Led | Course Fee: $1,480 + GST


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.

IRM Training (est. 1989) is the longest serving Endorsed Education Provider (EEP™) to the IIBA® in Australia.

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 & 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 & 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 & Fifth Normal Forms

  • Circumstances which may lead to data anomalies in key fields
  • Overview of transaction path analysis
What is the Training Like?

This is a hands-on short course where most modules start with a trainer running a presentation interactively, followed by discussions and case-study-based exercises.

For most exercises you will break out into small groups of 3-4 people, creating the opportunity to exchange ideas with other keen learners.

Running in small groups, there is plenty of opportunity for questions and discussions. For questions that are not directly related to the course topics, the trainer(s) may schedule a time during one of the breaks to answer them, to ensure your questions are answered while keeping the course on track.

In line with the working-from-home trend, you can now also attend this course remotely. The course will still be practical, hands-on, interactive and delivered live by a senior instructor with 15 – 25+ years’ experience with the skills to make the intensive short course interesting and enjoyable.

Find out more about practical training delivered remotely (live).

Who Are the Trainers?
Eligibility requirements to become an IRM Training trainer:

  • A minimum of 15 years’ business analysis experience in Australia.
  • The ability to demonstrate in-depth knowledge in the real-world application of the course topics.
  • Driven by the passion to help develop others.
  • Excellent communication, presentation and people skills.
  • A good sense of humour! You can absorb and retain more knowledge when the training is fun!

IRM Training trainers have worked in / with a diverse range of industries and government departments. Some also came from academic background as lecturers at Australian leading universities, on top of their 15+ years’ hands-on experience.

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).

Related courses:

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
Related Courses

Related courses to Data Analysis & Modelling:

Or see all our Data Analytics courses. 

What Past Attendees Said

“Excellent insight into using data analysis to understand the business” – Process Analyst, Geoscience Australia

“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, Westpac

“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

Read more testimonials

COURSE DATES & BOOKINGS

LocationDate 
Anywhere - Remote Delivery3 - 4 March 2022
Group Booking - Remote DeliveryFlexible Dates & Hours
Your Office - In PersonFlexible Dates & Hours
AdelaideSelect one of the options above
BrisbaneSelect one of the options above
CanberraSelect one of the options above
MelbourneSelect one of the options above
PerthSelect one of the options above
SydneySelect one of the options above

Course hours during daylight saving time (3 October 2021 – 3 April 2022):

  • AEDT: 9:00am – 5:00pm (ACT, NSW, TAS, VIC)
  • ACDT: 8:30am – 4:30pm (SA)
  • AEST: 8:00am – 4:00pm (QLD)
  • ACST: 7:30am – 3:30pm (NT)
  • AWST: 6:00am – 2:00pm (WA)

Course hours during standard time: 9:00am5:00pm AEST.

For other locations or time zones, Convert to your time zone.

Need more information?
Contact Us
Not ready to book yet?
Remind Me

We train professionals from these Australian organisations and more:

IRM Clients