Dimensional Data Modeling - Semantic Layer


A semantic layer is a semantic data model that shows to the business user:

It will create/model a logical star schema by:

Once the semantic layer has been build, the business user will see a logical star schema that it can query (business query). This query is called a semantic query.

The semantic layer will translate:

It's a key components of business intelligence / data analysis application because it provides a translation of the underlying database structures into business user oriented terms (such as revenue by year, …)


Data Modeling Issue

While modeling the semantic layer, the developer can fall in different issues. See Semantic Layer Modeling - Issues (SQL Trap)

Documentation / Reference

Task Runner