FAQ : Why we need BI Semantic Model?

The Semantic Model helps us in various ways. The major benefits of Semantic model are as follows : -


Single Source of Truth : By providing a BI Semantic layer with user friendly definition, Relation , business logic and data access methods,  all those who consume the data will have consistent and correct data.

Readability :  Often the object names may not be user friendly because of various reasons like Product limitation, legacy database as data source or the technical terminology in the physical data model.  In BI Semantic model we can provide more meaningful object names. We can also define the relations even if it is not available in the data warehouse and there by provide more readability.

Layer of Abstraction : BI Semantic Model provides a layer of abstraction since the users access the BI Semantic Layer not the raw data(data warehouse)

Self Service/Personal BI  :  Once the Semantic Layer is defined and published, the data consumer can function independently without support from IT.  This provides a capability of Self-service BI and Personal BI.