How to Create a Conceptual Data Model

00:40 - advantages of a conceptual model
01:35 - the data domain
05:00 - start drawing

Useful for #businessanalyst #businessarchitect #dataarchitect or #datanalayst. Using a free dataset from @kaggle.

TOOLS USED IN THIS VIDEO:
(affiliate link - I will receive a small commission if you purchase a subscription - at no additional cost to you)

Yulia's mini-courses

Download BA templates and handouts:

#why_change #erd #datamodeling #conceptualmodel #datamodel

[abdo]

I think this is a logical data model. Conceptual, would be the same but without attributes. Not sure though, depends on how it is defined.

[rohitw]

Nicely explained. Thanks for the video.

[selsoft]

In the conceptual model, you don't state the fields, columns.

[RyTubeOne]

This presentation is completely wrong. It is NOT Conceptual Modelling, it is Logical Modelling. Conceptual Modelling is based on business concepts and its fundamental feature is to reveal the essence of how a business works. There is NO SIGNIFICATION here of the numerosity of entities.

The goal was to model any Ski Resort, a business that provides winter recreational opportunities.

To avoid unnecessary "discussion" below, here is a list of the logical elements of the above model that are not part of the Conceptual Model:

SkiResort : it is the object of the model, it is described by the model, so it is not a business entity per se. Instead, it should have been the LOCATION entity.

ResortStatistics : what "concept" is represented by "statistics"... ? None.

LiftTicket : ...and what about the rope of the elevator ... ? That is part of the ascent, isn't it ? :-) No, it's not an Entity in its own right, but at most it's just a tool or part of the TRANSPORTATION entity ( which is very much missing from the model ! ).

Here is the real model elements, the list of (business) entities, without their relationships ( this interface is not suitable to display them ) :

LOCATION ( ...Ski Resort... )
STATION (...Summit... )
RUN
TRANSPORTATION ( ...Lift...)
USAGE POLICY (...Statistics, etc. )
SERVICE (...Lift ticket, etc. ... )