Topics

Topics

22 topics

Google Sheets Tips82Joined Data Marts in Google Sheets: one report from several tables, no VLOOKUP chainsWhy your scheduled refresh keeps wiping Google Sheets formulas (and how to fix it)Google BigQuery73BigQuery MCP for Claude: connect it, see every query, check every numberSnowflake vs BigQuery: A Detailed ComparisonData Modeling46Clinic network data model: tables, keys and one definition per metricSubscription e-commerce data model: tables, keys and one definition per metricReporting31Board pack numbers you can defend: what the audit covers and what it doesn'tWhy sales, marketing and finance report different pipeline numbersData Analytics29How to choose a data warehouse: BigQuery, Snowflake, Redshift, Athena and Databricks comparedData lakehouse architecture: the layers, open table formats and how to build oneData Integration29How to assess the impact of offline ads on online salesHow to connect Facebook Ads to BigQuery with OWOX Data MartsGA429GDPR compliance with Google Analytics 4 consent modeGoogle Analytics alternatives: the main options comparedMarketing Analytics29How to align marketing, sales and analytics teams on the same metricsCustomer lifetime value: formula, calculation and analysisAI in Analytics28AI hallucinating SQL: what it looks like and how to catch itTrace an AI answer to its SQL: from number to source tableMarketing Strategy1825 marketing metrics and KPIs to track, with formulasHow to calculate marketing ROI, and defend the numberSnowflake13Automate Snowflake reports in Google Sheets with OWOX Data MartsHow to load Facebook Ads data into Snowflake with OWOX Data MartsData Tracking8Google Analytics and GDPR: how to stay compliant in Europe7 free UTM builders for tracking your marketing campaignsData Quality7Common data quality issues and how to fix themWhat is data freshness? How to measure it and how fresh a decision needsDatabricks7How to connect Facebook Ads to Databricks, step by stepHow to connect Google Ads to Databricks, step by stepAnalytics Tools5Data analysis tools in 2026: 19 tools by the job they doOWOX Data Marts vs Connected Sheets: which one fits your reportingMarketing Attribution5How to build a marketing attribution model in BigQueryData-driven attribution: how Google's model works in GA4, Google Ads and Search Ads 360SQL for Analytics5Mastering Primary and Foreign Keys in SQL for Data IntegrityUnderstanding Key Constraints in SQL for Data IntegrityAmazon Athena1AWS Athena 101: serverless SQL on S3 explainedCase Studies0OWOX0Amazon Redshift0Topics0