Business Intelligence Platform icon

Business Intelligence Platform

analytics

Transform your data into actionable insights with this complete business intelligence platform. Build interactive dashboards, run ad-hoc SQL queries, create custom visualizations, and share reports across your organization. Unlike expensive BI SaaS tools that charge per-seat and limit data access, this platform gives you unlimited users and direct database connections. Built on proven open-source technologies including Metabase for the BI interface, ClickHouse for fast analytics queries, and dbt for data transformation.

Cost: $400-800/monthTime: 15-25 minutesbeginner

Features

  • Interactive dashboards with drag-and-drop builder
  • Ad-hoc SQL query editor with auto-completion
  • Custom visualization library (charts, maps, tables)
  • Scheduled reports and email delivery
  • Role-based access control for data governance
  • Direct database connections (PostgreSQL, MySQL, Snowflake, etc.)
  • Data transformation pipelines with dbt
  • Embedded analytics for your applications

Requirements

  • AWS account with administrator access
  • Existing databases to connect (or we'll create sample data)
  • Custom domain for BI dashboard (optional)
  • Email SMTP for scheduled reports (optional)

Technology Stack

MetabaseClickHousePostgreSQLdbtRedisnginx
Back to all recipes