Analytics portal
Analytics portal is a custom web application development project from the Pixel2Tech web apps practice. We were brought in because the business was running on a set of linked spreadsheets that broke every time two people edited at once. This page walks through the problem we were handed, how we approached it, and what changed as a result.
- Brand
- Analytics Portal
- Practice
- Custom Platforms
- Service
- Web Apps
- Year
- 2025
What we designed for Analytics Portal
- Product design
- Frontend build
- Backend & auth
- Deployment
The challenge
When the project started, the business was running on a set of linked spreadsheets that broke every time two people edited at once.
Our approach
We shipped a working core in weeks and expanded from real usage rather than a speculative feature list.
The outcome
The team stopped maintaining parallel spreadsheets, which removed a whole class of data errors.
- Manual hours saved / month
- 60+
- Systems consolidated
- 3 → 1
- Time to first release
- 8 weeks
How we delivered this web apps project
- Step 01
Workflow modelling
We documented how the team actually works today — roles, states, exceptions and the informal workarounds — because software that ignores the real process gets abandoned.
- Step 02
Data model and access rules
The schema was designed with row-level security so permissions live in the database rather than scattered through application code, which keeps access rules verifiable.
- Step 03
Iterative build
A working core shipped in weeks and expanded from real usage, so scope was driven by what the team needed next rather than a speculative feature list.
- Step 04
Deployment and support
The platform was deployed with monitoring, backups and error reporting, plus documentation and training so the team owns the system rather than depending on us.
Technologies and tools used
The stack below was chosen for this engagement because it matched the scale of the work, the team that would maintain it afterwards, and the performance the brief required.
- React
- TypeScript
- Node.js
- Supabase
- PostgreSQL
- Row-level security
- REST & GraphQL APIs
- Tailwind CSS
Why this project matters
A custom platform that models the real workflow scales with headcount. Spreadsheets and generic tools tend to break at exactly the point where growth makes them most expensive to replace.
If you are weighing up similar work, our services overview explains how we scope engagements, and about Pixel2Tech introduces the team who would run it.
Frequently asked questions
- When does a custom web app make more sense than off-the-shelf software?
- When the standard tool covers most of the workflow but the remaining part is manual, when you are paying per seat for features you never use, or when the process is a genuine competitive advantage worth building around.
- How is data security handled?
- Access rules are enforced at the database level with row-level security and role-based permissions, sensitive credentials live in server-side environment variables, and every deployment includes backups and audit history.
- Do we own the code?
- Yes. You own the codebase, the data and the infrastructure accounts. We hand over repositories and documentation, and you are free to continue with any development team.
Related services and articles
More Custom Platforms work
Have a project like this in mind?
Tell us about your goals — we'll come back with a clear plan and a fair timeline.