Build a Local AI Data Analyst for the Stock Market
Create an AI data analyst for stock and financial data using Claude Code, Bruin CLI and BigQuery - all running locally on your machine.
What
Goal - Create an AI data analyst for stock and financial data using Claude Code, Bruin CLI and BigQuery.
Audience - Data professionals, hobbyists, and financial analysts who want to build a local AI analyst.
Prerequisites
- BigQuery project and dataset with data already loaded
- gcloud CLI installed
- Bruin CLI installed
- Claude Code installed
- Bruin MCP added to Claude Code (setup video)
More guides
Capstone: add returns to the pipeline
Extend the project, prove the result, and assess the finished pipeline.
Describe the model in its asset definition
Keep the metric definition, owners, limits, and checked examples next to the SQL.
Load and profile the source data
Load local commerce data and check its shape before modeling it.