Topic

Data Modeling

50 articles · 2 guides

Is the Medallion Architecture Worth Its Complexity? Count Decisions, Not LayersArticle · Data ModelingIs the Medallion Architecture Worth Its Complexity? Count Decisions, Not Layers8 mistakes in data modeling and how to avoid themArticle · Data Modeling8 mistakes in data modeling and how to avoid themWhat is data modeling? The full guideArticle · Data ModelingWhat is data modeling? The full guideWhat is Apache Ossie? The Open Standard for Semantic Models, ExplainedArticle · Data ModelingWhat is Apache Ossie? The Open Standard for Semantic Models, ExplainedOKF vs Apache Ossie: Which Format Should Describe Your Data Model?Article · Data ModelingOKF vs Apache Ossie: Which Format Should Describe Your Data Model?How to Read an Apache Ossie Model: From YAML File to DiagramArticle · Data ModelingHow to Read an Apache Ossie Model: From YAML File to DiagramClinic Network Data Model: Tables, Keys and One Definition per MetricArticle · Data ModelingClinic Network Data Model: Tables, Keys and One Definition per MetricSubscription E-Commerce Data Model: Tables, Keys and One Definition per MetricArticle · Data ModelingSubscription E-Commerce Data Model: Tables, Keys and One Definition per MetricMarketing Analytics Data Model: What to Ask Your Analyst forArticle · Data ModelingMarketing Analytics Data Model: What to Ask Your Analyst forThe FP&A Data Model: The Tables and Keys Behind Actuals, Budget and ForecastArticle · Data ModelingThe FP&A Data Model: The Tables and Keys Behind Actuals, Budget and ForecastDo You Need a Semantic Layer? Data Model vs Data Mart vs the LayerArticle · Data ModelingDo You Need a Semantic Layer? Data Model vs Data Mart vs the LayerBusiness reporting: the OWOX approach to Data MartsArticle · Data ModelingBusiness reporting: the OWOX approach to Data MartsConceptual data modeling explained: definition and four examplesArticle · Data ModelingConceptual data modeling explained: definition and four examplesTop 10 free database diagram design toolsArticle · Data ModelingTop 10 free database diagram design toolsWhy your GA4 export to BigQuery needs a data model, and how to build itArticle · Data ModelingWhy your GA4 export to BigQuery needs a data model, and how to build itLogical vs physical data models: the main differences explainedArticle · Data ModelingLogical vs physical data models: the main differences explainedHow to normalize ad spend across currencies in Google SheetsArticle · Data ModelingHow to normalize ad spend across currencies in Google SheetsObject-oriented data models: definition, example, pros and consArticle · Data ModelingObject-oriented data models: definition, example, pros and consWhat is a semantic data model?Article · Data ModelingWhat is a semantic data model?Snowflake schema in data modeling: definition, diagram and exampleArticle · Data ModelingSnowflake schema in data modeling: definition, diagram and exampleUnderstanding star schema: definition, diagram and a SQL exampleArticle · Data ModelingUnderstanding star schema: definition, diagram and a SQL exampleTypes of data models and data modeling techniques in DBMSArticle · Data ModelingTypes of data models and data modeling techniques in DBMSForex & CFD Broker Data Model: Free TemplateArticle · Data ModelingForex & CFD Broker Data Model: Free TemplateBest data modeling tools in 2026Article · Data ModelingBest data modeling tools in 2026Best free ERD tools in 2026Article · Data ModelingBest free ERD tools in 2026OKF vs dbt exposures vs LookML: How to describe a data modelArticle · Data ModelingOKF vs dbt exposures vs LookML: How to describe a data modelOWOX Model Canvas vs dbdiagram.io: ERD tools comparedArticle · Data ModelingOWOX Model Canvas vs dbdiagram.io: ERD tools comparedOWOX Model Canvas vs DrawSQL: ERD tools comparedArticle · Data ModelingOWOX Model Canvas vs DrawSQL: ERD tools comparedOWOX Model Canvas vs Lucidchart for ERDsArticle · Data ModelingOWOX Model Canvas vs Lucidchart for ERDsBitcoin data model: the public BigQuery dataset, visualizedArticle · Data ModelingBitcoin data model: the public BigQuery dataset, visualizedE-commerce data model: a free template to open and editArticle · Data ModelingE-commerce data model: a free template to open and editFintech data model: a free neobank & lending templateArticle · Data ModelingFintech data model: a free neobank & lending templateHealthcare Data Model: Free Analytics TemplateArticle · Data ModelingHealthcare Data Model: Free Analytics TemplateMarketing data model: a free lead-gen funnel templateArticle · Data ModelingMarketing data model: a free lead-gen funnel templateMarketplace data model: a free two-sided templateArticle · Data ModelingMarketplace data model: a free two-sided templateMobile game data model: a free analytics templateArticle · Data ModelingMobile game data model: a free analytics templateStack Overflow data model: the public BigQuery datasetArticle · Data ModelingStack Overflow data model: the public BigQuery datasetFree data model templates: open, edit, and export OKFArticle · Data ModelingFree data model templates: open, edit, and export OKFThe OKF ecosystem: Every open-source tool for Google's Open Knowledge FormatArticle · Data ModelingThe OKF ecosystem: Every open-source tool for Google's Open Knowledge FormatSaaS data model: a free subscription analytics templateArticle · Data ModelingSaaS data model: a free subscription analytics templateWhat is OKF (Open Knowledge Format)? Google's new data standard, explainedArticle · Data ModelingWhat is OKF (Open Knowledge Format)? Google's new data standard, explainedData Mart design: structuring flat tablesArticle · Data ModelingData Mart design: structuring flat tablesThe three types of fact tablesArticle · Data ModelingThe three types of fact tablesGoverned metrics without a full semantic layer: Mastering output schemasArticle · Data ModelingGoverned metrics without a full semantic layer: Mastering output schemasWhy every SaaS product team needs a data modelArticle · Data ModelingWhy every SaaS product team needs a data modelDimensional data modeling: concepts, techniques and best practicesArticle · Data ModelingDimensional data modeling: concepts, techniques and best practicesStar schema vs snowflake schema: 10 key differencesArticle · Data ModelingStar schema vs snowflake schema: 10 key differencesKey benefits of data modeling for business reportingArticle · Data ModelingKey benefits of data modeling for business reportingThe beginner's guide to data transformationArticle · Data ModelingThe beginner's guide to data transformationData aggregation techniques for effective data analysisArticle · Data ModelingData aggregation techniques for effective data analysis

Guides