How shwarnasrivastava23/saas-retention-analysis works
This repository is a product-analytics analysis and reporting project. Its workflow simulates signup and event data, loads the CSVs into SQLite, analyzes activation, retention, and acquisition-channel patterns, then presents findings and recommendations in a browser dashboard. The README documents the SQL and dashboard capabilities; their implementation details are not sampled, so those links are grounded in the README rather than inspected source.
Main entry points: product_analytics.db Analytics database · analysis.py Analysis charts · summary.json Summary statistics · load_db.py Database loader
Components 14
Data preparation
- Data simulator
generate_data.py - Signup records
users.csv - Event log
events.csv - Database loader
load_db.py - Analytics database
product_analytics.db
Analytics
- SQL analysis queries
analysis.sql - Activation funnel
analysis.py - Retention analysis
analysis.py - Channel comparison
analysis.py - Cohort analysis
analysis.py - Summary statistics
summary.json
Reporting
- Analysis charts
analysis.py - Browser dashboard
dashboard.html
Other components
- Leadership / analyst
Connections 20
- Data simulator → Signup records: generates
generate_data.py - Data simulator → Event log: generates
generate_data.py - Database loader → Signup records: reads
load_db.py - Database loader → Event log: reads
load_db.py - Database loader → Analytics database: loads tables
load_db.py - SQL analysis queries → Analytics database: queries
README.md - Activation funnel → Analytics database: queries
analysis.py - Retention analysis → Analytics database: queries
analysis.py - Channel comparison → Analytics database: queries
analysis.py - Cohort analysis → Analytics database: queries
analysis.py - Activation funnel → Summary statistics: exports metrics
analysis.py - Retention analysis → Summary statistics: exports curves
analysis.py - Channel comparison → Summary statistics: exports rates
analysis.py - Activation funnel → Analysis charts: renders
analysis.py - Retention analysis → Analysis charts: renders
analysis.py - Channel comparison → Analysis charts: renders
analysis.py - Cohort analysis → Analysis charts: renders
analysis.py - Browser dashboard → Summary statistics: displays
README.md - Browser dashboard → Analysis charts: includes visuals
README.md - Leadership / analyst → Browser dashboard: views report
README.md