Data modeling is done to define relationship among the tables to represent the group of tables into Data model
The data has to model to prepare an in-depth report
The best way to prepare a report is to use tables with a defined relationship if you use a single table the interactives of the report may reduce data modeling is nothing but arranging the fact tables and dimension tables
Fact tables are defining the business process while the dimension tables answer the question like when, what, how, where, when.
The fact tables have a large number of attributes which is data while dimension tables are a small number of attribute
The fact tables have data in the form of numbers whereas the dimension tables have a string that defines place name etc.
Whereof dimension tables are answered by time table or Calendar table which defines dates, days, year in a certain interval of time required
When you are load data from the source make sure you remove unwanted columns out of tables
TO CREATE A DATA MODEL
Step 1: To determine the fact tables and the dimension tables in your database if you are just getting started then should begin with one fact table and two or more attributes
Step 2:Then define the relationship among them do not complicate at the start
for example, in the below image you can see a database diagram which as one fact table which is connect with different dimension table
Step 3: Then for making a report use the measures and create a basic report once done with the basic report you can start adding more dimension tables, fact tables, and complex measures
