Tag: Data Modeling
Distributing Facts and Dimensions: Governance, Access & Ownership
Building facts and dimensions is only part of the challenge. This article explores how certified data should be distributed across the organization through controlled access paths, ownership models, governance processes, and support structures.
Flat Tables vs. Snowflake Semantic Models: The Ultimate BI Data Debate
Structuring data for BI is a key decision that impacts performance, scalability, and data consistency. This article compares flat tables and semantic models, highlighting the strengths and trade-offs of each. Learn how a hybrid approach can offer the best of both worlds—combining consistency, flexibility, and efficient analytics across tools and teams.
More tags:
- AI Agents
- AI Governance
- AI Strategy
- Access Management
- Analytics
- BI
- Business Intelligence
- CI/CD
- Cloud Cost Management
- Data Architecture
- Data Engineering
- Data Governance
- Data Infrastructure
- Data Integration
- Data Management
- Data Mesh
- Data Modeling
- Data Platform
- Data Platform Optimization
- Data Strategy
- Data Warehouse
- Dev vs Prod
- Enterprise AI
- Entra ID
- Flat Tables
- Kubernetes
- Metrics
- Modern Data Stack
- Modularity
- Python
- Query Performance
- RBAC
- RFC Protocol
- SAP
- Security Architecture
- Semantic Models
- Software Architecture
- analytics workflow
- connectivity
- data ingestion
- data mart
- data marts
- data orchestration
- data pipelines
- data platform architecture
- data reliability
- data workflows
- dataops
- dbt
- dlt
- elt
- elt process
- github actions
- google cloud platform
- governance
- networking
- orchestration
- pipeline recovery
- pipelines
- prefect
- prefect worker
- productized data platform
- roles
- supply chains
- sustainability
- terraform
- workflow orchestration