SQL

Related to Business

• MRR (Revenue Growth) Metrics
• MRR Rolling
• MAU (User Growth) Metrics
• MAU Rolling
• Quick Ratio Rolling Weekly
• Churn Ratio Rolling Weekly
• DAU/MAU Rolling (Stickness Metrics)
• L5+/30 Rolling (Sttickness Metrics)
• Apriori (frequent itemsets)
• RFM (customer segmentation)
• Referral Tree
• Moving Average
• Weighted Moving Average
• OLAP Query
• Hierarchy Pivot Table (ROLLUP)
• Pivot Table with sub and grand total (CUBE)
• Cohort
• Breakdown Cohort
• Cumulative Percent
• Truncated Mean

miscellaneous

• All subset of a set (power set)
• Permutation
• CAGR (predict goal)
• Maze Solver (BFS - shortest path)
• Double Negation (Relational Division)
• Seven Segment Clock