Data modelling creates the structure your data will be stored and exist. It defines how things are labelled and organized, which determines how your data can be utilized and what information or insight it will convey. When you build a database system of any kind, the complexity is driven by the number of tables and columns. As a result, the cost of developing and sustaining it rises. A data model helps you reduce unnecessary columns by constructing an optimal data structure with the fewest tables and columns and thus helps reduce system complexity and reduce cost.
Your data can be unreliable, inconsistent, and complicated when you work with numerous types of systems, databases, applications, and NoSQL data, which may result in incorrect insights or conclusions, errors or wrong or poor decision making. Most often, you will come across the need for data modeling when you have data that needs to be stored in RDBMS or NoSql like stores. Both Relational and NoSql stores specify a format in which data can be stored in them. Relational follows a tabular format where data is stored in Row-Column format, each row representing one data record and each column in the row representing a specific attribute of data. NoSql stores may store data as Key-Value pairs, Column Family format, or documents.