Building a Full BI System with Claude Code and Metabase for Under $50/month
A developer on r/ClaudeAI shared a detailed walkthrough of building a complete business intelligence system using Claude Code (Opus 4.7) instead of hiring BI consultants. After receiving quotes of $15,000 for analytics dashboards, they built the entire system themselves in 3 days for ~$30/month on Google Cloud Platform.
Architecture & Setup
- Connect Claude Code via CLI to GCP — used the Claude CLI tool to interact with Google Cloud services directly.
- Data sources integrated: Stripe, Google Analytics 4, YouTube API (free tier), Google Sheets, Rewardful, and others — all pulled via APIs.
- Data warehouse: Built tables in BigQuery as the single source of truth (SSOT).
- Dashboarding: Installed Metabase (open-source, self-hosted) for the frontend.
Key Design Decisions
The developer spent hours discussing the architecture with Claude. The critical insight: define revenue as the single source of truth (SSOT). All other data layers are built around this core. This constraint keeps Claude focused when validating dashboard data, preventing scope drift.
To maintain coherence as the project grows, they deployed Kartpathi's Wiki LLM for Obsidian Graph on the project's GitHub repo — a "brain system" that tracks context and helps Claude stay aligned with prior decisions. The author plans to open-source this format soon.
Cost Breakdown
- Claude Pro subscription: ~$20/month (what they used).
- Google Cloud Platform (BigQuery + compute): ~$30/month.
- Total: well under $50/month. No per-seat licensing or BI expert fees.
Practical Tips
- Use Google Cloud CLI with Claude Code for direct API access.
- Start with one SSOT (revenue) and layer other metrics around it.
- Self-host Metabase to avoid per-user costs of tools like Looker or Tableau.
- Document the architecture in an Obsidian graph to keep Claude consistent on large projects.
📖 Read the full source: r/ClaudeAI
👀 See Also
OpenClaw v2.0 update requires manual checks before installation
OpenClaw's latest update includes 12 breaking changes, a new plugin system, and 30+ security patches. The update will silently break setups if users run npm update without first checking environment variables, state directories, and browser automation configurations.
Components of a Coding Agent: How Tools, Memory, and Context Extend LLMs
Sebastian Raschka breaks down the six building blocks of coding agents like Claude Code and Codex CLI, explaining how agent harnesses combine models with tools, memory, and repository context to make LLMs more effective for software work.
Qwen3.x models fail silently in OpenClaw due to streaming output format mismatch
Qwen3.x models in streaming mode output to the 'reasoning' field instead of 'content', causing OpenClaw to silently fall through to fallback models. A proxy that translates API formats and injects 'think: false' fixes the issue, enabling full tool-call evaluation.
Guide: Deploying OpenClaw with llama.cpp on GEEKOM IT15 Mini PC
A technical walkthrough details switching OpenClaw from Ollama to llama.cpp to run a local Qwen3-8B model with Intel Arc GPU acceleration, covering configuration changes, manual server management, and troubleshooting common pitfalls.