Skip to main content
← Back to home

Amealyze - building an analytics platform

Erik Ehnsiö1 min read

What started as Excel-based monthly reporting to track results over time became increasingly complex as the service grew. Spreadsheet compilations create more problems than they solve - difficult to track changes, ensure routines and data quality, extract data and analyze trends. The core issue was that we lacked a unified data source, which meant manual compilation whenever we needed insights.

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.
Editor dashboard
Editor dashboard in light mode
Editor dashboard in dark theme
Editor dashboard in dark mode
Client details
Client details in light mode
Client details in dark theme
Client details in dark mode
Reports
Reports in light mode
Reports in dark theme
Reports in dark mode

Improvements over time

Since launching in January 2024, the platform has continued to grow based on user feedback.

  • Architecture
    • Pages Router → App Router
    • Next.js 16
    • Drizzle ORM with automated migrations
  • Security
    • Server-side MSAL authentication
    • Server-side permission validation
  • Automation
    • CI/CD for dev/prod environments
    • Scheduled jobs via GitHub Actions
  • Features
    • Insights system with records and trends
    • Login analytics
    • Admin dashboard with system overview