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
How Small Model Evaluation Prompts Can Mislead and How to Fix Them
A Reddit post explains that small model evaluation prompts often produce misleading results due to triggering the wrong cognitive pathways in transformers, specifically identifying three distinct modes: factual recall, application/instruction following, and emotional/empathic inference.
OpenClaw Memory Plugin Analysis: Lossless Claw + LanceDB Recommended
A developer tested OpenClaw memory plugins and found that the default setup causes token bloat, while Lossless Claw paired with LanceDB provides optimal performance for maintaining agent context without high costs.
Building Claude Skills to Automate Cognitive Processes
Claude Code includes a built-in skill-creator that lets you build AI-powered skills by describing processes in natural language instead of writing code. The source describes creating a startup validation skill that reduced a 2-day manual process to 15 minutes.
Practical Glossary for AI Agent Terminology (Harness, Scaffold, Agent, etc.)
A glossary from Hugging Face blog explaining common AI agent terms like Harness, Scaffold, and Agent with simple definitions and real examples.