ChatGPT User Analytics Dashboard

Interactive Streamlit dashboard for executive and management reporting on ChatGPT user analytics.

What it includes

• Executive KPI cards: users, active users, active rate, messages, credits, messages/user, tool messages, project messages, projects created, credits/message.
• Sorted bar and horizontal bar charts only. No pie charts.
• Leadership views by Department, Location, Category, model usage, tool usage, and top users.
• CSV upload feature to refresh the dashboard with latest exported data.
• Filter controls for Department, Location, Category, and user status.

Local run

pip install -r requirements.txt
streamlit run app.py

Deploy with URL using Streamlit Community Cloud

1. Create a GitHub repository and upload these files: app.py, requirements.txt, and optionally sample_data.csv.
2. Go to Streamlit Community Cloud and create a new app from the repository.
3. Set main file path as app.py.
4. Deploy. Streamlit will provide a shareable URL.
5. Open the URL and upload the newest CSV from the left sidebar whenever data needs to refresh.

Deploy with URL using Hugging Face Spaces

1. Create a new Hugging Face Space.
2. Choose Streamlit as the SDK.
3. Upload app.py, requirements.txt, and optionally sample_data.csv.
4. The Space URL becomes the shareable dashboard link.

Data refresh

Use the left sidebar upload control to upload a new CSV. The dashboard recalculates every metric and visualization immediately for that browser session.