# Analytical Ants

> Build the intelligence your operation owns.

Analytical Ants is an AI systems engineering consultancy for operations-forward companies. We build client-owned operational software and governed AI capabilities, then transfer the controls, documentation, and operating knowledge to the client team.

## Pages

- [Home](https://analyticalants.com/): A guided ownership journey from operational pressure through durable systems, governed AI, proof, scope, controlled delivery, and client handoff.
- [Field Notes](https://analyticalants.com/breakdown): An engineering archive of Case Studies and Insights about operating systems, governed AI, data, and implementation practice.
- [Services](https://analyticalants.com/products): Five offerings, in order: Build a Nest, Deploy Ants, Build a Colony, Fractional AI Systems Architect, and Colony Operations.
- [Services — Build a Nest](https://analyticalants.com/products/build-the-nest): A client-owned operational-system build with a scope mapper.
- [Services — Deploy Ants](https://analyticalants.com/products/deploy-the-ants): A governed AI capability with bounded context, routes, approvals, and evidence.
- [Services — Build a Colony](https://analyticalants.com/products/build-the-colony): Combined delivery of the durable system and governed intelligence layer.
- [Services — Fractional AI Systems Architect](https://analyticalants.com/products/fractional-ai-systems-architect): A monthly senior leadership engagement for roadmap, architecture, governance, vendor decisions, and team enablement.
- [Services — Colony Operations](https://analyticalants.com/products/colony-operations): Monthly scoped support for health, evaluations, controlled improvement, training, and recovery readiness.
- [About Us](https://analyticalants.com/about-us): The company’s stewardship, proof, ownership, capability-transfer, and founder perspective.
- [Contact](https://analyticalants.com/contact): An operational intake for the desired outcome, active trigger, participation and ownership, source of truth, and constraint.
- [Privacy Policy](https://analyticalants.com/privacy-policy): How visitor and contact-form information is collected, used, and protected.
- [Terms of Service](https://analyticalants.com/terms-of-service): Website terms and the boundary between published information and a written engagement agreement.

## Blog

- [How to Configure Claude Code Across Projects and Machines](https://analyticalants.com/blog/260508-claude-code-config-management) (2026-05-08): A reproducible, project-aware Claude Code configuration structure that keeps sensitive prompting logic out of public code.
- [Building a Virtual Business Card System With No Subscription](https://analyticalants.com/blog/260507-virtual-business-card) (2026-05-07): How Analytical Ants built a QR and vCard-based business card system without a monthly subscription.
- [How to Identify B2B Website Visitors Without a Form Fill](https://analyticalants.com/blog/260504-b2b-visitor-identification-rb2b) (2026-05-04): The business case and Next.js implementation for identifying B2B visitors who do not submit a form.
- [How We Built an Operational Intake Form](https://analyticalants.com/blog/260501-contact-cta-system) (2026-05-01): How a structured Next.js intake captures the outcome, trigger, ownership, and operating context needed to begin useful systems discovery.
- [Built for the Mill Floor: Digitizing Quality Control in Forest Products](https://analyticalants.com/blog/260425-forest-products-quality-platform-case-study) (2026-04-25): How a forest-products manufacturer digitized quality-control work with Power Apps and Power BI.
- [When the Numbers Don't Tie: Rebuilding a BI Platform for an Eyecare Network](https://analyticalants.com/blog/260424-eyecare-bi-platform-case-study) (2026-04-24): How an eyecare network rebuilt a BI platform with production reports and a Microsoft Fabric lakehouse.
- [Filter and Row Context in DAX: A Moving Annual Total Example](https://analyticalants.com/blog/250720-filter-and-row-context-dax-example) (2025-07-21): A worked DAX example explaining filter context, row context, and a rolling annual total.
- [Time Series Decomposition in Power BI with Python](https://analyticalants.com/blog/250108-time-series-decomposition-and-autocorrelation-function-in-power-bi-with-python) (2025-01-08): A build guide for dynamic time-series decomposition and autocorrelation using Python visuals in Power BI.
- [VBA Code to Find References Across Excel Worksheets](https://analyticalants.com/blog/240610-how-to-use-vba-code-to-find-references-in-multi-worksheet-excel-workbook) (2024-06-10): Four VBA macros for locating table, sheet, column, and text references before changing an Excel workbook.
- [Automate Power BI PDF Exports with Python and the REST API](https://analyticalants.com/blog/240521-python-dynamic-power-bi-pdfs-with-rest-api) (2024-05-21): A Python approach for filtering and emailing Power BI PDF exports without per-user licenses.

## Contact

- Email: info@analyticalants.com
- LinkedIn: https://www.linkedin.com/in/wmrodriguez/
- GitHub: https://github.com/Analytical-Solutions

---
Generated by Claude Code · /wizard-site-docs · 2026-07-23