The Benefits of Data Modeling in Data Warehousing
If one can harness the vast quantities of data that are available in organizations, one can derive huge business benefits. It can accurately analyze past results, supply this information to BI systems to find correlations in data, and present information in a user-friendly way to business users. To achieve these goals, it must model the data warehouse very carefully. The source systems are often varied and might lack accuracy. The destination systems often have different requirements and, equally, each business user might have different demands. It should spend a substantial amount of time modeling the data warehouse system. Data warehouses are an expensive and time-consuming undertaking, but, when designed correctly, they can give enormous business benefits.