The SaaS Metrics Dashboard is a comprehensive tool for analyzing key metrics of a SaaS business. It includes visualization of Monthly Recurring Revenue (MRR), churn rate, customer growth, revenue by plan, and regional revenue distribution. The dashboard also provides a 5-point analysis and generates detailed PDF reports.
- Key Metrics Display: Monthly Recurring Revenue (MRR), Customer Lifetime Value (CLTV), Active Customers, Total Revenue, Average Revenue Per User (ARPU), Churn Rate, and Average Subscription Length.
- Graphs: Line charts for MRR, churn rate, customer growth, revenue forecast, and bar charts for revenue by plan and region.
- Regional Map: Geographical representation of revenue by region.
- Custom Data Input: Upload your own CSV data file to visualize metrics.
- PDF Report Generation: Downloadable PDF report with key metrics, graphs, and analysis.
-
Clone the repository:
git clone https://github.com/yourusername/saas-metrics-dashboard.git cd saas-metrics-dashboard
-
Create a virtual environment and activate it:
python -m venv venv source venv/bin/activate # On Windows, use `venv\Scripts\activate`
-
Install the required dependencies:
pip install -r requirements.txt
-
Run the Streamlit app:
streamlit run saas_dashboard.py
-
Upload your CSV file via the sidebar. Ensure the file has the following columns:
- Customer ID
- Start Date
- End Date
- Amount
- Status
- Plan
- Region
Example:
Customer ID,Start Date,End Date,Amount,Status,Plan,Region 1,2022-01-01,2022-12-31,100,active,Standard,North America 2,2022-02-15,2022-08-15,200,canceled,Premium,Europe
-
Use the sidebar to filter the data by date range.
-
View key metrics and graphs in the main dashboard.
-
Download the PDF report from the button at the bottom of the dashboard.