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 aggregate functions: COUNT, SUM, STRING_AGG, ARRAY_AGG and moreBigQuery SQL style and best practices: a short, tested standardData Modeling50Is the Medallion Architecture Worth Its Complexity? Count Decisions, Not Layers8 mistakes in data modeling and how to avoid themReporting31Automated reporting: a schedule is not a source of truthThe role of business data dashboards: Real-life examples for practical useGA429How to link your Google Ads and Google Analytics 4 accountsFacebook Ads vs GA4 conversions: why the numbers differ and how to read themAI in Analytics28Machine learning in marketing: the uses your data can actually supportAI hallucinating SQL: what it looks like and how to catch itData Integration28How to connect Criteo Ads to BigQuery with OWOX Data MartsHow to connect Google Ads to BigQuery with OWOX Data MartsData Analytics22How to choose a data warehouse: BigQuery, Snowflake, Redshift, Athena and Databricks comparedData lakehouse architecture: the layers, open table formats and how to build oneMarketing Analytics22How to align marketing, sales and analytics teams on the same metricsCustomer lifetime value: formula, calculation and analysisMarketing Strategy18Comprehensive guide to channel strategy in marketingMastering marketing efficiency ratio (MER) for improved campaign performanceSnowflake13Automate Snowflake reports in Google Sheets with OWOX Data MartsHow to load Facebook Ads data into Snowflake with OWOX Data MartsData Tracking87 free UTM builders for tracking your marketing campaignsGoogle Analytics and GDPR: how to stay compliant in EuropeDatabricks7How to connect Facebook Ads to Databricks, step by stepHow to connect Google Ads to Databricks, step by stepAnalytics Tools6Can you retire your BI tool now the data lives in the warehouse?How to Choose a BI Tool When Per-User Licensing is the ProblemData Quality6Common data quality issues and how to fix themWhat is data freshness? How to measure it and how fresh a decision needsMarketing 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 Analytics5Primary and foreign keys in SQL: what your warehouse enforcesUnderstanding key constraints in SQL for data integrityAmazon Athena4How to Connect AWS Athena to Google Sheets Without CSV ExportsAWS Redshift vs Athena: Key Differences ExplainedCase Studies0OWOX0Amazon Redshift0Topics0