Blog

OWOX Blog

1080 pieces, newest first

What Is Apache Ossie? The Open Standard for Semantic Models, ExplainedArticle · Data ModelingWhat Is Apache Ossie? The Open Standard for Semantic Models, ExplainedBad data visualization examples, and how to redraw each oneArticle · ReportingBad data visualization examples, and how to redraw each oneFacebook Ads vs GA4 conversions: why the numbers differ and how to read themArticle · GA4Facebook Ads vs GA4 conversions: why the numbers differ and how to read themFacebook Ads report templates: what each one answersArticle · ReportingFacebook Ads report templates: what each one answersGA4 Measurement Protocol: send an event and debug itArticle · GA4GA4 Measurement Protocol: send an event and debug itMarketing reports: how to build one that changes a decisionArticle · ReportingMarketing reports: how to build one that changes a decisionOKF vs Apache Ossie: Which Format Should Describe Your Data Model?Article · Data ModelingOKF vs Apache Ossie: Which Format Should Describe Your Data Model?Primary and foreign keys in SQL: what your warehouse enforcesArticle · SQL for AnalyticsPrimary and foreign keys in SQL: what your warehouse enforcesHow to Read an Apache Ossie Model: From YAML File to DiagramArticle · Data ModelingHow to Read an Apache Ossie Model: From YAML File to DiagramBigQuery aggregate functions: COUNT, SUM, STRING_AGG, ARRAY_AGG and moreArticle · Google BigQueryBigQuery aggregate functions: COUNT, SUM, STRING_AGG, ARRAY_AGG and moreBigQuery SQL style and best practices: a short, tested standardArticle · Google BigQueryBigQuery SQL style and best practices: a short, tested standardBigQuery IF, CASE, IFNULL, NULLIF and COALESCE, with tested examplesArticle · Google BigQueryBigQuery IF, CASE, IFNULL, NULLIF and COALESCE, with tested examplesBigQuery CREATE TABLE and DROP TABLE: syntax and examplesArticle · Google BigQueryBigQuery CREATE TABLE and DROP TABLE: syntax and examplesHow to create a view in BigQuery: CREATE VIEW, cost and limitsArticle · Google BigQueryHow to create a view in BigQuery: CREATE VIEW, cost and limitsBigQuery CTE: WITH clauses and recursive CTEs, with tested examplesArticle · Google BigQueryBigQuery CTE: WITH clauses and recursive CTEs, with tested examplesBigQuery DML: INSERT, UPDATE, DELETE and MERGE with tested examplesArticle · Google BigQueryBigQuery DML: INSERT, UPDATE, DELETE and MERGE with tested examplesBigQuery IAM roles: which one to grant, and how to share a datasetArticle · Google BigQueryBigQuery IAM roles: which one to grant, and how to share a datasetBigQuery JSON functions: the JSON type, JSON_SET, JSON_REMOVE and moreArticle · Google BigQueryBigQuery JSON functions: the JSON type, JSON_SET, JSON_REMOVE and moreBigQuery JSON arrays and objects: JSON_QUERY_ARRAY, UNNEST and JSON_OBJECTArticle · Google BigQueryBigQuery JSON arrays and objects: JSON_QUERY_ARRAY, UNNEST and JSON_OBJECTBigQuery materialized views: when they help, limits and refreshArticle · Google BigQueryBigQuery materialized views: when they help, limits and refreshBigQuery math functions: ROUND, SAFE_DIVIDE, MOD, POW and moreArticle · Google BigQueryBigQuery math functions: ROUND, SAFE_DIVIDE, MOD, POW and moreBigQuery navigation functions: LAG, LEAD, LAST_VALUE and PERCENTILE_CONTArticle · Google BigQueryBigQuery navigation functions: LAG, LEAD, LAST_VALUE and PERCENTILE_CONTBigQuery updates for analysts: what changed in 2025 and 2026Article · Google BigQueryBigQuery updates for analysts: what changed in 2025 and 2026BigQuery ROW_NUMBER, RANK, DENSE_RANK and NTILE, with tested examplesArticle · Google BigQueryBigQuery ROW_NUMBER, RANK, DENSE_RANK and NTILE, with tested examples

…