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.
The course is suitable for anyone involved with the analysis, specification or development of databases. This includes:
Course topics are applicable to all popular database products (Microsoft, Oracle, IBM, etc) and all types of systems (client/server, web, PC, mainframe).
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.
How this course can help you be a better data analyst - you'll learn how to:
“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
Basic Principles & Terminology
Data Analysis & Normalisation
Global Data Model
Composite Data Model
Fourth & Fifth Normal Forms