Dimensional Data Modeling - Semantic Layer

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

3 - Example

4 - Data Modeling Issue

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

5 - Documentation / Reference


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap