AMNA AHMED
DATA
MODELLING
101
*
Data modelling is the process of
creating a blueprint for a database.
It is a critical skill for data analysts
because it allows them to understand
the structure of data and how it can be
used to answer business questions.
Learning data modelling will help you
understand the data, create efficient
queries for analysis, and communicate
with stakeholders.
AMNA AHMED
1
The first step in data modelling is
understanding
the business goals
the available data
the questions that need to be
answered.
If the data model does not align with the
business goals or the business
questions, then it will not be useful.
AMNA AHMED
2
Then you need identify the entities and
attributes in the data model.
Entities are the basic building blocks of
data models. They represent real-world
objects or concepts that are stored in a
database.
Attributes are the properties of entities.
They describe the characteristics of
entities.
AMNA AHMED
3
Now define the relationships between
the entities.
This includes identifying one-to-one,
one-to-many, and many-to-many
relationships.
It is important to consider the
following:
The business rules of the system
The data that needs to be stored
The queries that will be run
AMNA AHMED
4
Next, choose the right data model.
The type of data model that you choose
will depend on the business needs and
the data that is available.
There are different types of data
models, such as entity-relationship (ER)
models, dimensional models, star
schema, and snowflake schema models.
AMNA AHMED
5
After creating the data model, you need
to document it.
Note the entities, attributes,
relationships, and assumptions.
There are many ways to document a
data model:
Data modelling diagrams (e.g. ERD)
Data dictionary
Documentation text
AMNA AHMED
6
Once you have documented the data
model, you need to test it.
Here's a good way to start:
Data validation: ensure data types are
correct and that the data is consistent.
Entity relationship diagram (ERD)
validation: make sure that the entities
and relationships are correct.
Integration testing: test the data model
with other parts of the system.
AMNA AHMED
7
The data model is a living document
that needs to be maintained.
This includes keeping the data model
up-to-date as the business needs
change and the data changes.
This includes adding new entities,
attributes, and relationships. It also
includes making changes to existing
entities, attributes, and relationships.
AMNA AHMED
*
The tool you use for data modelling can
matter, but it depends on your specific
needs and requirements.
Some factors to consider when
choosing a data modelling tool include:
The type of data modelling you need
to do
The features you need
Your comfort level
Learning Data Modelling in SQL is a
great way to begin.
AMNA AHMED
*
You can buy a course on Data Modelling
if you like, but I personally think there
are enough online resources available
to teach you data modelling for free.
Application of impressive data
modelling techniques in your projects is
much more important for employers
than to see that you have a certificate in
data modelling.
AMNA AHMED
*
Once you have created a data model, it
is important to get feedback from
others. This will help you to identify any
potential problems with your model and
to improve it.
And keep practicing. The more you
practice data modelling, the better you
will become at it. So, don't be afraid to
start working on projects and
experiment with different techniques.
AMNA AHMED
If you love all
things data, follow
me and let's keep
learning together
AMNA AHMED
