Task Build a unified analytics system that collects data from multiple sources, visualizes key business metrics, and gives the team a tool for setting and tracking goals — without using expensive third-party BI platforms.
Problem The owners of an online training sales app were making decisions blind: payment data was stored in payment systems, app usage data was kept separately, and there was no single view. Off-the-shelf analytics platforms like PowerBI solved the visualization task, but created ongoing subscription costs and did not provide the flexibility needed for the product’s specifics. There was also no data backup.
Solution Development of a custom analytics platform using the FastAPI + React + PostgreSQL stack, deployed on the client’s existing servers. This ensured high performance, full control over the data, and zero costs for third-party software.
Implemented modules
Data collection and storage
- Regular automatic collection of data from payment systems has been configured: transactions, subscriptions, cancellations, refunds
- Behavioral data collection for app usage has been configured: user activity, workout views, progress, retention
- Scheduled backup of the entire database has been configured
Goal system
- A business goal-setting module has been developed with breakdowns by periods and directions
- Automatic real-time progress tracking for each goal
- Visual indicators of completion and deviations from the plan
Dashboards
- Role-based custom dashboards: owner, marketer, product manager
- All key metrics on one screen: revenue, active subscriptions, churn, LTV, engagement
- Metric dynamics and progress toward goals on one screen
Access system
- Individual access rights for each team member
- Each person sees only the data needed for their role
Bonus: AI analytics agent
- As an additional gift to the client, an AI agent was implemented with direct access to the database
- Answers business questions in free-form language: “What was the churn last month?”, “Which workouts are watched most often?”
- Automatically generates analytical insights and identifies anomalies without the need to build reports manually
What results did we achieve
- The team got a single view of the business for the first time — data from payment systems and the app is combined in one place
- Decision-making accelerated: all key metrics are available in real time without manual report exports
- The goal system made the team’s progress transparent and measurable
- Abandoning PowerBI and similar platforms made it possible to completely eliminate BI subscription costs
- Data is protected by backups and stored on the client’s own infrastructure
- The AI analytics agent gave the team the ability to gain insights from data in a conversational mode — without SQL queries or technical expertise