Enterprise Data Flow Architecture: Source to Consumption via Semantic Layer
Tier 4
BI Dashboards Reporting & self-service analytics
LLM-Powered AI Agents
Python Notebooks
Consumption Layer Access via Uniform APIs
semantic_api.get_order_history(user_id)
“Show me total sales by region for Product X”
Tier 3
Semantic API Gateway
Semantic Layer
Uniform REST/GraphQL APIs
Unified Business Context
User
Customer
Region
Order
Product
Inventory
Transaction
Tier 2
Physical Storage & Modeling Data Platform
ELT Ingestion
(Cloud) Database
Data Vault Model Hubs, Links, and Satellites
Star Schema Model Fact and dimension tables
Load first, transform in place
Single physical storage platform
Tier 1
Relational DBs
Flat Files
APIs
Fragmented Physical Data Sources
Operational systems of record
CSV · JSON · XML exports
REST · GraphQL endpoints
& Metrics on dbt Learn how to define your metrics once and query them consistently in every BI tool, every time. Semantic Models
Watch it now: https://scalefr.ee/semantic-models
Semantic Layer Guide © Scalefree International GmbH 2026
5
Powered by FlippingBook