Dimensional Data Modeling - Semantic Layer

About

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, …)

Example

Data Modeling Issue

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

Documentation / Reference


Powered by ComboStrap