Business Intelligence And Analytics — professional stack.
For each requirement below, pick the option that fits your build — recommended first, then free and cheaper alternatives — or skip what your project doesn't need. Tap the info icon next to any requirement to see why it matters.
BI Platform / Dashboarding Tool
A piece of your stack you may or may not need, depending on scope. Pick the option that fits — or skip it if your project doesn’t require this capability yet.Pricing & free-tier limitsSuperset OSS: Free self-hosted, unlimited users/dashboards, infra $20-50/mo VM. Metabase OSS: Free self-hosted MIT, unlimited. Metabase Cloud Starter $29/mo (up to 10 users), Pro $500/mo (10 users incl., $20/user extra). Tableau Cloud Viewer $15/user/mo, Explorer $42/user/mo, Creator $75/user/mo, 14-day free trial. Power BI Pro $14/user/mo, Premium $20/user/mo. Looker $35k/yr platform fee + $60/user/mo. Overage: $5-20/user/mo extra, compute separate.
Data Warehouse Connector / Query Engine
A piece of your stack you may or may not need, depending on scope. Pick the option that fits — or skip it if your project doesn’t require this capability yet.Pricing & free-tier limitsDuckDB OSS: Free unlimited queries local. MotherDuck: Free 10GB storage + 10GB queried/mo, then $20/mo for 100GB storage + $20 per 100GB queried. BigQuery: Free 1TB queries/mo + 10GB storage, then $6.25/TB scanned on-demand or $0.04/slot-hour flat (~$1k/mo for 25 slots). Snowflake: Free trial $400 credit, then Standard $2-3/credit (XS = 1 credit/hr ~$2/hr), storage $40/TB/mo. Redshift Serverless $0.36/RPU-hr. Overage: Auto-suspend saves compute.
Semantic Layer / Metrics Store
A piece of your stack you may or may not need, depending on scope. Pick the option that fits — or skip it if your project doesn’t require this capability yet.Pricing & free-tier limitsdbt Core OSS: Free self-hosted unlimited models. Cube.js OSS: Free self-hosted unlimited. Cube Cloud: Free 1 deployment, 1M queries/mo, 2 concurrency, then Developer $99/mo for 10M queries, storage 10GB incl. dbt Cloud Developer free 1 seat, Team $100/seat/mo (min 8 seats ~$800/mo). Looker LookML included in $35k/yr platform fee. Overage: Cube $0.10 per 1k queries, dbt Cloud $100/seat/mo extra.
Caching for BI Queries
Stores frequent results in fast memory so you serve less from the database. Big lever for speed and cost.Pricing & free-tier limitsRedis OSS self-hosted free, infra $10/mo VM. Upstash: Free 10k commands/day, 256MB max, then $0.20 per 100k commands, Pay-as-you-go $10/mo min. Dragonfly Cloud free 2GB. Redis Cloud free 30MB, Essentials from $5/mo 100MB, $12/mo 1GB, Pro $100/mo 5GB. ElastiCache t4g.micro $11/mo, t4g.small $22/mo. Overage: Upstash $0.4/GB egress, Redis Cloud $0.15/GB, storage $0.20/GB/mo.
Dashboard Hosting / Embedded Frontend
Where your code actually runs and serves requests. Picking the right host affects speed, scaling, and how much ops work you do.Pricing & free-tier limitsVercel Hobby: Free 100GB bandwidth, 6000 execution hrs, then Pro $20/user/mo + $40 per 100GB bandwidth over. Cloudflare Pages free unlimited bandwidth, 500 builds/mo. Netlify free 100GB bandwidth. Tableau Server $35/user/mo min 10 users ($4.2k/yr + infra). ECS Fargate for Metabase $15-50/mo per service. Overage: Vercel $0.40/GB bandwidth, $0.60 per 1k function invocations over.
Object Storage for Report Exports (PDF/CSV)
Where you keep files users upload or you serve — images, videos, documents — and how fast they reach visitors around the world.Pricing & free-tier limitsR2: Free 10GB storage + 10M Class A + 10M Class B ops, egress free. Paid $0.015/GB/mo storage, $4.50/M Class A ops after free. S3: Free 5GB 12 months then $0.023/GB/mo storage, $0.09/GB egress, $0.005/1k PUT. B2: Free 10GB then $0.006/GB storage, $0.01/GB egress. GCS: Free 5GB then $0.02/GB/mo + $0.12/GB egress. Overage: R2 no egress fees, S3 cheapest for long-term with lifecycle.
Auth for BI (SSO, RBAC, Row-Level)
How users sign up, log in, and are authorized. Getting roles and access control right early prevents painful rewrites.Pricing & free-tier limitsAuth0 free 25k MAU, 3 enterprise connections, then Essentials $35/mo for 500 MAU, Professional $240/mo for 1k MAU + $0.08/MAU over. Clerk free 10k MAU, Pro $25/mo + $0.02/MAU over 10k. Supabase Auth free 50k MAU included. Okta SSO $2/user/mo min $1500/yr. Overage: Auth0 $0.07-0.20 per extra MAU, Clerk $0.02/MAU.
Email for Report Delivery
Where you keep files users upload or you serve — images, videos, documents — and how fast they reach visitors around the world.Pricing & free-tier limitsResend: Free 3k emails/mo + 1 domain, Pro $20/mo 50k emails then $0.90/1k over. SES: Free 3k/mo sandbox or 62k if from EC2 (first year), then $0.10/1k emails + $0.12/GB attachments. SendGrid free 100/day, Essentials $19.95/mo 50k. Postmark free 100/mo then $15/mo 10k. Overage: Resend $1/1k over, SES $0.10/1k linear.
Background Jobs for Scheduled Reports
Runs slow work (emails, exports, payouts) in the background so users don’t wait. Keeps your app snappy.Pricing & free-tier limitsGitHub Actions free 2000 min/mo private, then $0.008/min Linux. QStash free 500 messages/day, then $10/mo for 10k msgs, $1 per 10k over. Trigger.dev free 2k runs/mo, Pro $29/mo 10k runs + $0.003/run over. Inngest free 50k step runs/mo, Pro $20/mo 250k steps then $0.0001/step. Temporal Cloud free 10k actions/mo then $0.18/1k actions. Overage: linear per run.
Data Ingestion / ETL for BI
A piece of your stack you may or may not need, depending on scope. Pick the option that fits — or skip it if your project doesn’t require this capability yet.Pricing & free-tier limitsAirbyte OSS free self-hosted unlimited connectors, infra $20-100/mo VM. dlt free OSS. Airbyte Cloud free 500 credits/mo (~5M rows), then $2.50/credit $10 min. Fivetran free 14-day trial, Starter from $500/mo for 500k MAR (monthly active rows), Standard $1-2 per credit ~$0.40/MAR over. Overage: $2.50/credit, Fivetran $0.30-0.60 per extra 1k MAR.
Monitoring for Dashboard Performance & Query Observability
Tells you when things break and why. You cannot fix what you cannot see — this is how you keep downtime short.Pricing & free-tier limitsGrafana Cloud free 10k series metrics, 50GB logs, 50GB traces, 14d retention, 3 users. Pro $29/mo per 15k metrics + 8 users $8/1k metrics over. UptimeRobot free 50 monitors 5min interval. Better Stack free 10 monitors then $24/mo. Datadog APM $31/host/mo, logs $0.10/GB ingested, metrics $0.05/custom metric. New Relic free 100GB/mo then $0.30/GB. Overage: Grafana $8/1000 series, Datadog $0.15/GB logs over.
API Gateway for BI APIs
Controls and protects your APIs — quotas, abuse prevention, and firewalls. Important once you have real traffic or many clients.Pricing & free-tier limitsCloudflare Workers free 100k req/day, then $5/mo for 10M requests incl. + $0.30/M over. Kong OSS free self-hosted. Zuplo free 5k req/day then $25/mo 250k/mo + $0.0002/req over. AWS API Gateway free 1M calls/mo 12mo then $1.00/M HTTP API + $0.09/GB egress, REST $3.50/M. Apigee pay-as-you-go $0.50/1k calls min $500/mo. Overage: AWS $1-3.50/M requests.
Secrets Management for BI Credentials
A piece of your stack you may or may not need, depending on scope. Pick the option that fits — or skip it if your project doesn’t require this capability yet.Pricing & free-tier limitsInfisical OSS free self-hosted unlimited secrets. Doppler free 5 users, 100 secrets. Doppler Developer $12/user/mo unlimited. AWS Secrets Manager 30-day free trial then $0.40/secret/mo + $0.05/10k API calls. HashiCorp Vault Cloud free 25 secrets then Standard cluster $0.30/hr (~$216/mo) + $0.50/secret. Overage: Doppler $0.50 per extra secret pack, AWS $0.05/10k calls.
CI/CD for BI Definitions (dbt, Dashboard as Code)
Automates testing and deploying your code. Saves enormous time and prevents “works on my machine” releases.Pricing & free-tier limitsGitHub Actions free 2000 min/mo private (unlimited public) + 500MB artifacts, then $0.008/min Linux, Team $4/user/mo. GitLab free 400 compute min/mo then Premium $19/user/mo. CircleCI free 6k credits/wk then $15/mo 30k credits. dbt Cloud CI included in Team $100/seat/mo. Overage: $0.008-0.016/min runner, storage $0.25/GB/mo over artifact free.
Version Control & Data Catalog for BI
Where your source code lives and is collaborated on. Non-negotiable for any team or serious project.Pricing & free-tier limitsGitHub Free unlimited repos 500MB packages, Team $4/user/mo. OpenMetadata OSS free self-hosted. DataHub OSS free self-hosted. Atlan Starter $20k/yr 10 users ($167/user/mo), Growth $50k/yr 25 users. Alation $150k+/yr enterprise. Catalog infra self-host ~$50-200/mo VM. Overage: Atlan $150/user/mo extra, GitHub storage $0.25/GB.
Reverse ETL / Activation to SaaS
A piece of your stack you may or may not need, depending on scope. Pick the option that fits — or skip it if your project doesn’t require this capability yet.Pricing & free-tier limitsHightouch free 1 destination, 3 syncs, 500 events/mo, then Starter $350/mo 1M events + $0.02 per 1k over. Census free 10 syncs 10k records/mo then Starter $300/mo 100k records. RudderStack free 500k events then Cloud Pro $400/mo 1M events + $80/M over. Overage: $0.05-0.10 per 1k records synced.
SQL Query History & Auditing (Warehouse)
Persistent storage for your app’s data — users, products, orders. The single most important architectural decision for most projects.Pricing & free-tier limitsSnowflake/BigQuery native history free included with compute. Select Star free 5 users 1 data source, Team $450/mo 10 users $45/user extra. Metabase audit OSS limited, Pro $500/mo advanced. Datadog DB monitoring $0.15/hr per DB host (~$105/mo) + logs $0.10/GB. Overage: Select Star $45/user/mo, Datadog $0.10/GB logs over.
Data Warehouse Compute Scaling
Where your code actually runs and serves requests. Picking the right host affects speed, scaling, and how much ops work you do.Pricing & free-tier limitsBigQuery free 1TB queries + 10GB storage then $6.25/TB on-demand or $0.04/slot-hour flat ($1k/mo 25 slots). Snowflake auto-suspend free $400 credit trial then Standard $2/credit (XS 1 credit/hr ~$2/hr) 60s min. Redshift Serverless free $300 credit 90d then $0.36/RPU-hr. ClickHouse Cloud $0.38/compute-hr min $50/mo. Overage: Autoscale up to 2x baseline cost.
Backup & Restore for BI Metadata
Copies of your data so a bug, hack, or outage doesn’t become permanent loss. Cheap insurance every serious project needs.Pricing & free-tier limitsSelf-script free OSS + $5/mo VM + R2 $0.015/GB/mo storage. Litestream OSS free + storage $5/mo. AWS Backup first evaluation free then $0.05/GB/mo backup storage + $0.15/GB restore. Crunchy Bridge daily backup free 7d retention then $0.09/GB/mo extended 30d. Overage: AWS $0.05/GB/mo over, restore $0.03/GB.
Row-Level Security & Column-Level Security Enforcement
A piece of your stack you may or may not need, depending on scope. Pick the option that fits — or skip it if your project doesn’t require this capability yet.Pricing & free-tier limitsSuperset OSS free RLS unlimited self-hosted. Metabase OSS limited, Pro $500/mo 10 users incl. sandbox/RLS, Enterprise $1k/mo, extra user $20-30/mo. Power BI Premium $20/user/mo includes RLS. Immuta free dev then Starter $25k/yr platform. Overage: Metabase $20/user/mo sandboxed, Immuta $2k per extra data source.
Audit Logs WORM for Report Access (Immutable Logging)
Controls who can do what inside your admin tooling. Limits blast radius if an account is compromised.Pricing & free-tier limitsS3 Object Lock free feature, storage $0.023/GB/mo + $0.005/1k writes retention free. R2 WORM config free + storage $0.015/GB. CloudTrail free 1 trail + 1 copy, Lake $2.50/GB ingested 7yr retention $0.023/GB-mo storage. Datadog Audit $0.40/1M events ingested + storage $0.10/GB. Overage: CloudTrail Lake $0.75/GB scanned over, S3 $0.005/1k writes.
Data Lineage & Observability for BI Pipelines
Tells you when things break and why. You cannot fix what you cannot see — this is how you keep downtime short.Pricing & free-tier limitsOpenLineage + Marquez free self-hosted unlimited. Elementary OSS free dbt observability. Monte Carlo free 14-day trial then Growth $30k/yr for 50 tables monitoring $0.50/table extra, Enterprise $100k/yr. Datafold free 3 seats then $800/mo 10 seats. Atlan lineage incl. in $20k/yr starter. Overage: Monte Carlo $1k per 100 extra tables, infra $50/mo VM self-host.
Cost Monitoring / Query Cost Attribution for BI
Tells you when things break and why. You cannot fix what you cannot see — this is how you keep downtime short.Pricing & free-tier limitsCost Explorer/Billing native free. Infracost free 2k runs/mo. Vantage free $1k credits then $500/mo starter up to $100k spend. CloudZero free trial then Starter $800/mo up to $50k cloud spend then 1% of spend over. Finout $500/mo starter. Datadog Cost $0.10/hr cluster. Overage: CloudZero 0.8-1% of cloud spend over threshold, Vantage 0.5% over $100k.
Embedded Analytics SDK / White-Label Hosting
Where your code actually runs and serves requests. Picking the right host affects speed, scaling, and how much ops work you do.Pricing & free-tier limitsSuperset embedded free unlimited self-hosted. Metabase Pro SDK $500/mo 10 users. Looker Embedded $35k/yr base + $500/mo per embedded domain + $5/viewer/mo over 100 viewers. Power BI Embedded Gen2 A1 $1.008/hr (~$735/mo) up to A6 $16.13/hr (~$11.7k/mo). Sigma Embedded $3k/mo min 50 internal users + usage. Overage: Power BI $1-20/hr per scale-up, Looker $5/viewer over.
Real-time Streaming Ingestion for BI (Kafka -> Warehouse)
Delivers and processes audio/video to users. Bandwidth-heavy, so plan the cost.Pricing & free-tier limitsUpstash Kafka free 10k msgs/day 1 topic then pay-as-you-go $0.20/M msgs + $0.20/GB storage $0.20/GB egress. Confluent free $400 credit 90d then Basic $0.10/GB ingress + $1.50/hr cluster baseline ~$100/mo. Kinesis free 1 shard 12mo then $0.015/shard/hr (~$11/mo) + $0.014/1M PUT. Redpanda free tier 2 vCPU then Pro $0.60/hr ~$430/mo. Overage: $0.10-0.20 per M msgs over, storage $0.10/GB/mo.
OLAP Cube Store / Pre-aggregation Engine
A piece of your stack you may or may not need, depending on scope. Pick the option that fits — or skip it if your project doesn’t require this capability yet.Pricing & free-tier limitsCube Store OSS free self-hosted unlimited. DuckDB free. Cube Cloud free 1M queries then Developer $99/mo includes managed Cube Store 10GB storage. Snowflake Dynamic Tables cost as warehouse $2-3/credit extra lag. Materialize free dev $0.20/credit-hr ~$50/mo then Scale $800/mo. ClickHouse Cloud free tier then $0.38/compute hr. Overage: Cube Cloud $0.10/1k queries over, storage $0.25/GB over, Materialize $0.30/credit-hr.
Compliance & SOC2 for BI Platform
Keeps you secure and compliant with regulations. Required for enterprise customers and handling sensitive data.Pricing & free-tier limitsOpen-source compliance template free. Vanta Starter $4k/yr 1 framework 10 employees, Growth $12k/yr 3 frameworks 50 employees then $150/employee/yr extra. Drata Starter $6k/yr 1 framework, Growth $15k/yr 3 frameworks. Secureframe Starter $5k/yr. Thoropass $10k/yr includes audit. Overage: $100-200/extra employee/yr, pentest $5k/yr extra, auditor $10-20k/yr.
DLP & PII Masking for Reports
A piece of your stack you may or may not need, depending on scope. Pick the option that fits — or skip it if your project doesn’t require this capability yet.Pricing & free-tier limitsNightfall free 100 findings/mo 1 integration then Starter $100/mo 1k findings + $0.10/finding over. Piiano Vault free dev 1k tokens then Team $499/mo 50k tokens. Skyflow free dev then $650/mo vault base + $0.10/API call. Immuta $25k/yr platform starter. Overage: Nightfall $0.10 per extra finding, Skyflow $0.10 per vault API over.
Multi-region Dashboard CDN & Edge Caching
Where you keep files users upload or you serve — images, videos, documents — and how fast they reach visitors around the world.Pricing & free-tier limitsCloudflare CDN free unlimited bandwidth, Pro $20/mo adds WAF managed rules, Business $200/mo. CloudFront free 1TB/mo 12mo then $0.085/GB first 10TB + $0.0075/10k HTTPS reqs. Fastly free $50 credit then Starter $50/mo min + $0.12/GB egress + $0.01/10k reqs. Akamai $0.08/GB min $500/mo. Overage: CloudFront $0.02/GB after 10TB, Fastly $0.08-0.28/GB after min.
Load Testing & Performance Benchmarking for Dashboards
A piece of your stack you may or may not need, depending on scope. Pick the option that fits — or skip it if your project doesn’t require this capability yet.Pricing & free-tier limitsk6 OSS free unlimited self-hosted. k6 Cloud free 500 VUh/mo 1 project then Pro $79/mo 5k VUh + $0.05/VUh over. Locust OSS free. BlazeMeter free 10 tests then Basic $99/mo 1k VUh. Datadog Synthetics $5/1k tests. Gatling Cloud free trial then Pro $65/mo. Overage: k6 Pro $0.03/VUh over, ~500 tests per VUh pack.
How this professional business intelligence and analytics checklist works.
Each requirement below is something a professional business intelligence and analytics build typically needs. Pick one of the four researched options — recommended, free, cheaper or paid — add your own with "Other", or skip the requirement if your project doesn't need it. Nothing is mandatory; the plan on the right tracks what you've decided so nothing gets forgotten.
Your picks are saved in this browser automatically, so you can come back anytime. Options are researched per build level and refreshed as vendors change their plans — always verify details on the provider's page before committing.