Published onAugust 3, 2023Data for the Pankow City LibrarymetabaseberlinclickhouseData for the Pankow City Library extracted to Clickhouse & visualized in Metabase inspired by the Open Data Information Center (ODIS).Read more →
Published onJuly 21, 2023Google Sheets custom functionspythonjsgoogle-sheetsgcpUse Google Sheets custom functions to connect to your datawarehouse apis and enable Self-Service analytics.Read more →
Published onFebruary 12, 2023Snowflake query history with StreamlitpythonsnowflakestreamlitUnderstanding the Snowflake query history feature to monitor the changes in a Table with sample Streamlit app.Read more →
Published onJune 12, 2019SaaS Cohorts data prep with Postgrespostgrescohortsmrrchurnretentionmetabasetableaucohort-analysisA tutorial on preparing data for Cohort Analysis using only SQL with Postgres and then visualising it on Metabase & TableauRead more →