https://prat.io/blog Musings on Data & Tech en-us hi@prat.io (Pratyay Modi) hi@prat.io (Pratyay Modi) Thu, 03 Aug 2023 00:00:00 GMT https://prat.io/blog/berlin-pankow-library-dashboard https://prat.io/blog/berlin-pankow-library-dashboard Data for the Pankow City Library extracted to Clickhouse & visualized in Metabase inspired by the Open Data Information Center (ODIS). Thu, 03 Aug 2023 00:00:00 GMT hi@prat.io (Pratyay Modi) metabaseberlinclickhouse https://prat.io/blog/google-sheets-custom-functions https://prat.io/blog/google-sheets-custom-functions Use Google Sheets custom functions to connect to your datawarehouse apis and enable Self-Service analytics. Fri, 21 Jul 2023 00:00:00 GMT hi@prat.io (Pratyay Modi) pythonjsgoogle-sheetsgcp https://prat.io/blog/snowflake https://prat.io/blog/snowflake Understanding the Snowflake query history feature to monitor the changes in a Table with sample Streamlit app. Sun, 12 Feb 2023 00:00:00 GMT hi@prat.io (Pratyay Modi) pythonsnowflakestreamlit https://prat.io/blog/cohort-analysis-tutorial https://prat.io/blog/cohort-analysis-tutorial A tutorial on preparing data for Cohort Analysis using only SQL with Postgres and then visualising it on Metabase & Tableau Wed, 12 Jun 2019 00:00:00 GMT hi@prat.io (Pratyay Modi) postgrescohortsmrrchurnretentionmetabasetableaucohort analysis