Data & Business Intelligence
Data & Business Intelligence encompasses the strategies, technologies, and practices for analyzing and utilizing data to support business decisions.
- Knowledge domains
- /Thematic areas
- /Segments
- /Building blocks
Data Modeling & Semantics
This segment covers modeling data for analytics and reporting, including shared terminology and definitions. It includes semantic layers, fact and dimension models, metric and attribute definitions, and rules for consistency and reuse. The focus is on translating raw data into understandable, stable meaning structures, independent of specific visualizations or operational data quality enforcement.
Data Modeling Workshop
A workshop aimed at enhancing data modeling skills within an organization.
Dimensional Modeling
Dimensional Modeling is a data modeling technique commonly used in data warehousing and business intelligence.
Schema Evolution Strategy
A method for continuously adapting and improving database schemas with minimal disruptions.
Semantic Mapping
Semantic mapping is a method for organizing information through logical connections.
Canonical Data Model
A canonical data model describes a standardized data structure for the integration and exchange of information between different systems.
Columnar Databases
Columnar databases store data in columns instead of rows, leading to faster queries and more efficient analytics.
Logical Data Model
A logical data model describes the structure and relationships of data within a specific domain.
Physical Data Model
A physical data model defines the physical storage and structure of data in a database.
Schema Definition Languages (SDL)
Schema Definition Languages are essential tools for describing data schemas and assist in software development through validation.
Semantic Layer
The semantic layer enhances data accessibility.
DataGrip
DataGrip is a powerful SQL development environment for database administrators and developers.
Erwin Data Modeler
Erwin Data Modeler is a powerful data modeling tool that helps organizations visualize and manage their data architecture.
dbt
dbt is an open-source data modeling tool that transforms data warehouses.