← Back to home

Amealyze

•Erik Ehnsiö

Background

To make informed decisions for our application management service, leadership needed clear insights into client metrics, trends, and performance data over time. The existing Excel-based reporting system made this nearly impossible. Each month, teams manually compiled data into spreadsheets, making it difficult to analyze trends, compare periods, or identify patterns. There was no single source of truth, and historical analysis required digging through and collecting information from Excel.

The opportunity: Design and build a platform that enables teams to track client data continuously, to aid with trend spotting, client information exports, and monthly reports for leadership.

Solution

  • Built the platform from concept to production using Next.js 15, TypeScript, and PostgreSQL,
  • Designed key features: client management with filtering, search and expport functions,
  • Created patterns for data visualization, historical tracking, and SSO with role-based access through Azure AD authentication.
Monthly reporting dashboard in light mode
The main dashboard displays stacked bar charts showing client metrics month by month
Report page in dark mode
Dark mode to match preferences

Outcomes

  • Launched to production and adopted as the core analytics tool across the organization,
  • The platform is now a core part of the team's workflow: track → analyze → report → improve.