Which statement best describes the purpose of data modelling in a BI context?

• A. It models the relationships between data elements
• B. It creates dashboards for decision makers
• C. It configures hardware for ETL
• D. It involves analysis of business data

Answer: (C)

Defining and organizing data so reporting and analysis work smoothly is the essence of data modelling in BI. It focuses on how data elements relate to one another, establishing structures such as facts and dimensions and the links between them. This creates a consistent, efficient data foundation that supports accurate querying, drill-downs, and coherent dashboards. Dashboards are the outputs built on top of the data model; configuring hardware for ETL is a separate technical task; analysing business data is what you do with the data after it’s modelled. A solid data model reduces redundancy, ensures data integrity, and makes BI insights reliable.