What Is a Data Model?

A data model defines the relationships between data points and is useful in software development, data migration, and system integration. It can also be used to design new systems and software. In business intelligence, data models can help database architects and data analysts gain insight into company data and its attributes and set parameters for data grouping, sorting, storage, and formatting.

The purpose of a data model is to help communicate the computer system’s requirements, interactions with the data, and potential outcomes. Building a data model specific to the needs of each individual organisation helps reduce errors, encourage consistency, save time, improve database performance, and develop communication between teams.

Types of data models

You can classify data models into three main categories based on the data’s abstraction levels (from lowest to highest abstraction):

1. Physical: A physical data model provides a specific blueprint of how the database will store data, helping technicians accurately create the design.

2. Logical: A logical data model omits technical specifications but includes essential details, such as data attributes, relationships, constraints, and subtypes. You can apply it to multiple databases or systems, meaning you could replicate the model for various products.

3. Conceptual: A conceptual data model offers a big-picture view of the system’s content and structure. It can also be a starting point for designing logical and physical models.

Data modelling and data analytics

Data modelling helps you as an analyst visualise data and set parameters to gain insights that enable making strategic business decisions. It also helps incorporate formulas, currencies, and data hierarchy for easier manipulation. Data models transform raw data into actionable insights.

Related terms

• Data integrity

• Data analytics

• Structured data

• Unstructured data

• Business intelligence

Learn more about data analytics.

A data model organises data and its relationships to help businesses understand and analyse information. Three main data model types include conceptual (big picture), logical (specific details), and physical (database storage blueprint). Data models are crucial for data analytics as they transform raw data into insights for strategic decision-making.

If you're ready to learn more about data models to start a career in data analytics, consider completing the Google Data Analytics Professional Certificate. This eight-course series is appropriate for beginners who want to learn skills like data analysis, data visualisation, data ethics, and data collection.