Data modelling is a step-by-step process of database design to store data. It is the conceptual representation, implemented by using Star or Snow-Flake schemas in any database technology such as Microsoft SQL Server, Oracle, MySQL, HP Vertica etc. It defines the structure of data to optimally manage large amount of structured/ non-structured data. It is classified in three basic models, primarily Conceptual Model, Logical Model & Physical Model.
Data modelling is the first step to create complex software/ BI solutions. It is the core concept for handling huge data or often called as Big Data. It helps you to manage data resources and integrate existing information system to develop data repository for all kind of reporting needs.
In asset management, there are two sets of data models with facts and dimensions related Building level data and Unit level data. The business requirement is to bridge the two fact tables to drill down from Building to Unit level information in analysis. The solution provided created a bridge table between Building and Unit fact tables by including the business keys in bridge table and connecting the two fact tables. With the help of data modelling, drill down and drill up from building to unit level was made possible.