Course

Fundamentals of Data Modeling

Structure your data clearly in a good model
Many years ago, data modeling was introduced as a technique to optimize database design. Today the techniques that were developed back then can be used efficiently in many projects. In data modeling, we try to develop a representation of the things that matter most to the business.
Write your awesome label here.
Manu De Backer
teacher ‘Fundamentals of Data Modeling’

Hours

Videos

Questions and answers

What will you learn?

As an analyst, “clarity” is one of the things in life you appreciate most – however, as you may know in your projects, it is hardest to achieve. Project teams spend hours and hours discussing concepts that are not clearly defined, and these discussions are often time-consuming – and devastating for getting to the true questions that must be tackled.

Many years ago, data modeling was introduced as a technique to optimize database design. Today the techniques that were developed back then can be used efficiently in many projects. In data modeling, we try to develop a representation of the things that matter most to the business. These things are stored and tracked by the business and should be clearly defined.
That’s what data modeling is all about.

One of the best techniques to do this is building an entity-relationship diagram. And that’s exactly the model that we’ll introduce in this course.

Reveal the complexity of data

Compared to some other techniques in business analysis, data modeling is straightforward. To build even the most complex and large data models, we only need three basic elements: entity types, attribute types and relationships.

But this simplicity hides the true power of the entity relationships diagram. The complexity lies not within the elements but in how those elements are used in practice.

Learn data modeling concepts using a running example

  • What’s the use of a data model?
  • What are the different levels of data models (conceptual, logical, physical)
  • What are entity types, and how should we show them in the data model?
  • What data do we want to store about entity types, and how can we show them in the data model?
  • What are derived attribute types, composite attribute types and multi-value attribute types?
  • What are relationships, and how should you define them?
  • What about cardinality and optionality?
  • How do you handle various special relationships?

Extensive material

With high-quality videos, challenging tests, tons of data modeling examples and practical downloads, you will learn all there is to data modeling.

Related Downloads

Measurement Pattern

Information Model Poster

Meet the instructor
Write your awesome label here.

Manu De Backer

Professor - Trainer - Expert BA - Process Enthusiast - Smart Process Automation - Academic Director - Product Enthusiast
His focus on business processes is relentless, and as a consultant, he has helped many organizations in optimizing their process-oriented way of working. Driven by a love for great products and customer experiences, he helps organizations thrive in a complex business environment.

Professional development

International Institute of Business Analysis (IIBA®)

Continuing Development Units and PD Hours: 4
Complete all the course content to earn your Continuing Development Units (CDUs) or PD Hours. The Master channel is an approved IIBA® Endorsed Education Provider for ECBA®, CCBA® and CBAP®. Learn more about our cooperation here.

The Master Channel - Mastery Level Certificate

Complete all the content of a course and earn a score of 80% or higher on the exam to earn your Mastery Level Certificate.