PinnedWilliam Song·Jul 13, 2023The Beginning….. Hello World!After few years of work experience in Data Analytics, I want to log and share some techniques (mainly SQL) I encountered and learned from…
William Song·Nov 3, 2023How to Calculate Retention Rate 留存率分析Retention Rate is one of the major KPI metrics in many businesses. The concept isn’t too complicated, but it involves many details and is…
William Song·Aug 16, 2023BigQuery: Query Performance Optimization BQ數據抓取優化My apology, I forgot where I researched the methods to provide the reference link here. I believe there are many posts regarding the…
William Song·Jul 24, 2023BigQuery:Merge Tables 合併表格Reference 1 : https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax#merge_statement
William Song·Jul 14, 2023SQL: Find The Most Consecutive Days SQL計算最大連續天數Reference: https://stackoverflow.com/questions/54225868/longest-consecutive-days-count-for-bigquery
William Song·Jul 13, 2023SQL: Find Duplicates SQL找出重複數據https://www.sqlservertutorial.net/sql-server-basics/sql-server-find-duplicates/