# Rittman Analytics Blog - Articles, Tutorials, Case Studies URL: https://rittmananalytics.com/blog Description: Expert articles on data strategy, modern data platforms, analytics delivery, and embedded analytics from Rittman Analytics. --- Latest thoughts on data analytics, customer insights, and industry trends [See client results ›](https://rittmananalytics.com/case-studies) 45 minutes · no obligation · you'll speak with a founder, not sales Group by: Sort by: ![New!](https://rittmananalytics.com/lovable-uploads/be1c118f-63e9-492e-bb23-cbe97fe702bf.png) ![Migrating Tableau, Metabase and Data Studio Reports to Looker using AI, Wire & Rittman Analytics](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2026%2F10%2F1b-bl4zdtAyHn0ArbdDr7A.png) ### Migrating Tableau, Metabase and Data Studio Reports to Looker using AI, Wire & Rittman Analytics One of the most-common requests we get from clients is to help them move from legacy BI tools such as Metabase, Tableau or Power BI to a modern data analytics… markrittman·Oct 11, 2026 ![New!](https://rittmananalytics.com/lovable-uploads/be1c118f-63e9-492e-bb23-cbe97fe702bf.png) ![What’s New in Wire 4.x : Multi-Agent Development, dbt Charts, Agents Schema & More](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2026%2F10%2F1ll3tZHaKFmujJAuTWqlxRQ.png) ### [What’s New in Wire 4.x : Multi-Agent Development, dbt Charts, Agents Schema & More](https://rittmananalytics.com/blog/2026/10/11/whats-new-in-wire-4-x-multi-agent-development-dbt-charts-agents-schema-more) We just released the 4.1.0 version of Wire, the plugin for Claude Code and Gemini CLI that brings our delivery blueprints, skills and best-practices to the AI-powered agentic coding tools… markrittman·Oct 11, 2026 ![Agentic Data Platform Migration using Wire, Claude Code and Rittman Analytics](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2026%2F07%2FData-Pipeline-Diagram-selection-1-1.png%3Ffit%3D3840%252C1640%26ssl%3D1) ### [Agentic Data Platform Migration using Wire, Claude Code and Rittman Analytics](https://rittmananalytics.com/blog/2026/07/19/agentic-data-platform-migrations-using-wire-claude-code-and-rittman-analytics) Migrating an entire analytics platform including the data warehouse, data source extractions, semantic layer, BI reports, orchestration and reverse ETL syncs from one stack to another used to be the… markrittman·Jul 19, 2026 ![Making Agentic Analytics More Accurate using Anthropic’s Agentic Data Stack and the Wire Framework](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2026%2F07%2F360ff-0mllmr2anbsdy3fh2.png) ### [Making Agentic Analytics More Accurate using Anthropic’s Agentic Data Stack and the Wire Framework](https://rittmananalytics.com/blog/2026/06/11/making-agentic-analytics-more-accurate-using-anthropics-agentic-data-stack-and-the-wire-framework) Anthropic published a blog article last week, “How Anthropic enables self-service data analytics with Claude”, describing an approach to one of the hardest problems in enterprise AI: how do you… markrittman·Jun 11, 2026 ![Google Next 2026: What’s New for Looker, BigQuery, Data Platforms and Agentic Analytics](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2026%2F07%2F3358f-1vzv4jkdgans1-jnm34yfnq.jpeg) ### [Google Next 2026: What’s New for Looker, BigQuery, Data Platforms and Agentic Analytics](https://rittmananalytics.com/blog/2026/04/26/google-next-2026-whats-new-for-looker-bigquery-data-platforms-and-agentic-analytics) Lydia, Olivier Dupuis and I were representing Rittman Analytics at Google Next 2026 in Las Vegas this last week, and it certainly was an event at Google-scale. In a masterpiece… markrittman·Apr 26, 2026 ![Introducing the Wire Framework: The “Secret Sauce” Behind Our AI-Augmented Analytics Project…](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2026%2F07%2F80274-1hdwqcjqntkn-ou-tbe3kwg.png) ### [Introducing the Wire Framework: The “Secret Sauce” Behind Our AI-Augmented Analytics Project…](https://rittmananalytics.com/blog/2026/02/25/introducing-the-wire-framework-the-secret-sauce-behind-our-ai-augmented-analytics-project) If you’ve tried asking Claude or ChatGPT to generate a dbt model or a fact table definition for you, it’s impressive how fast it can produce syntactically-correct code. But building… markrittman·Feb 25, 2026 ![So, Just How Relevant is Multi-Touch Attribution to Marketers in 2026?](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2026%2F07%2Ff030a-1tfrmp8woifje_y8pmms6gg.png) ### [So, Just How Relevant is Multi-Touch Attribution to Marketers in 2026?](https://rittmananalytics.com/blog/2026/01/28/so-just-how-relevant-is-multi-touch-attribution-to-marketers-in-2026) If you’re running marketing for a B2C business, it’s somewhat of an understatement to say you’ve probably noticed that attribution has become significantly harder over the past few years. Between… markrittman·Jan 28, 2026 ![One Person Many Roles: Designing a Unified Person Dimension in Google BigQuery](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2026%2F01%2F0.03577433557574594.png%3Ffit%3D1236%252C1044%26ssl%3D1) ### [One Person Many Roles: Designing a Unified Person Dimension in Google BigQuery](https://rittmananalytics.com/blog/2026/01/26/one-person-many-roles-designing-a-unified-person-dimension-in-google-bigquery) When building our internal data warehouse, we quickly noticed that people and companies sit at the centre of most business processes and that the same person or company often plays… markrittman·Jan 26, 2026 ![Why We’ve Tried to Replace Data Analytics Developers Every Decade Since 1974](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2026%2F01%2F0.2706437466233763.webp%3Ffit%3D1360%252C768%26ssl%3D1) ### [Why We’ve Tried to Replace Data Analytics Developers Every Decade Since 1974](https://rittmananalytics.com/blog/2026/01/19/why-weve-tried-to-replace-data-analytics-developers-every-decade-since-1974) (This article was inspired by Stephan Schwab’s excellent piece “Why We’ve Tried to Replace Developers Every Decade Since 1969” which traces the recurring dream of eliminating software developers from COBOL… markrittman·Jan 19, 2026 ![How Rittman Analytics uses AI-Augmented Project Delivery to Provide Value to Users, Faster](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2026%2F01%2F0.11539852215881174.webp%3Ffit%3D1400%252C545%26ssl%3D1) ### [How Rittman Analytics uses AI-Augmented Project Delivery to Provide Value to Users, Faster](https://rittmananalytics.com/blog/2026/01/19/how-rittman-analytics-uses-ai-augmented-project-delivery-to-provide-value-to-users-faster) Our latest case study features Barton Peveril College in Eastleigh, UK and the AI-augmented delivery approach we used to ship their Looker and Google Cloud MVP platform in December 2025. Over the past year we’ve quietly… markrittman·Jan 19, 2026 ![Rittman Analytics 2025 Wrapped : A Year of Platforms, People and High-Performing Data Teams](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2026%2F01%2F0.3619284028022317.webp%3Ffit%3D1400%252C488%26ssl%3D1) ### [Rittman Analytics 2025 Wrapped : A Year of Platforms, People and High-Performing Data Teams](https://rittmananalytics.com/blog/2026/01/19/rittman-analytics-2025-wrapped-a-year-of-platforms-people-and-high-performing-data-teams) Spotify has Wrapped. Everyone else has year end lists. Here’s our take on 2025 at Rittman Analytics. The topics we kept coming back to 1. The semantic layer as the… markrittman·Jan 19, 2026 ![You Probably Don’t Need an RFP](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2026%2F01%2F0.9555669754665426.webp%3Ffit%3D1400%252C764%26ssl%3D1) ### [You Probably Don’t Need an RFP](https://rittmananalytics.com/blog/2026/01/19/you-probably-dont-need-an-rfp) Many organisations still use large, prescriptive RFPs to select partners for data platform and analytics projects. These documents often define architecture, scope, timelines and deliverables in detail before any discovery… markrittman·Jan 19, 2026 ![Claude Meets Looker: Building Smarter, Connected Analytics with Google’s MCP Toolbox](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2025%2F12%2F0.8426204116330105.webp%3Ffit%3D1400%252C654%26ssl%3D1) ### [Claude Meets Looker: Building Smarter, Connected Analytics with Google’s MCP Toolbox](https://rittmananalytics.com/blog/2025/12/08/claude-meets-looker-building-smarter-connected-analytics-with-googles-mcp-toolbox) As well as Looker’s new built-in Conversational Analytics feature, you can now connect Looker to AI assistants such as Claude from Anthropic along with agentic developer tools such as Windsurf and Claude… markrittman·Dec 8, 2025 ![From Prompts to Skills: Automating Financial and KPI Analysis in Looker with Claude Skills and MCP Toolbox](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2025%2F12%2F0.17482841878719146.webp%3Ffit%3D1400%252C892%26ssl%3D1) ### [From Prompts to Skills: Automating Financial and KPI Analysis in Looker with Claude Skills and MCP Toolbox](https://rittmananalytics.com/blog/2025/12/08/from-prompts-to-skills-automating-financial-and-kpi-analysis-in-looker-with-claude-skills-and-mcp-toolbox) A couple of weeks ago we shared an article about the new Looker MCP Toolbox and how AI assistants like Claude.ai can now use it to query data from your Looker semantic… markrittman·Dec 8, 2025 ![“Fivetran In Talks to Buy Dbt Labs”, reports The Information](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2026%2F07%2F1d4e2-1wljnxv_pnyfah3bqzxwkhw.png) ### [“Fivetran In Talks to Buy Dbt Labs”, reports The Information](https://rittmananalytics.com/blog/2025/09/28/fivetran-in-talks-to-buy-dbt-labs-reports-the-information) A story in The Information published on Saturday 27th September 2025 reports that “Data Startup Fivetran In Talks to Buy Dbt Labs in Multibillion Dollar Deal”. The article is behind… markrittman·Sep 28, 2025 ![Google Integrates Spectacles into Looker for Continuous Integration & Regression Testing](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2025%2F09%2F0.21588027490316408.png%3Ffit%3D1400%252C708%26ssl%3D1) ### [Google Integrates Spectacles into Looker for Continuous Integration & Regression Testing](https://rittmananalytics.com/blog/2025/09/08/google-integrates-spectacles-into-looker-for-continuous-integration-regression-testing) When you’re developing LookML views and models in Looker, it’s possible that changes you’ve made could end-up breaking downstream looks and dashboards that rely on that LookML content; you might… markrittman·Sep 8, 2025 ![How Rittman Analytics Does Financial Analytics using Looker, Fivetran and Google BigQuery](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2025%2F09%2F0.1669793402786709.png%3Ffit%3D5116%252C3680%26ssl%3D1) ### [How Rittman Analytics Does Financial Analytics using Looker, Fivetran and Google BigQuery](https://rittmananalytics.com/blog/2025/09/07/how-rittman-analytics-does-financial-analytics-using-looker-fivetran-and-google-bigquery) As you’d expect from a data analytics consultancy that runs its business on Google Cloud, Google BigQuery and Looker, we use these services to provide the financial reports and dashboards… markrittman·Sep 7, 2025 ![Opinionated, AI-Enabled & Modern: The Story Behind Rittman Analytics’ New Website](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2025%2F08%2F0.8472241509609719.png%3Ffit%3D3840%252C2785%26ssl%3D1) ### [Opinionated, AI-Enabled & Modern: The Story Behind Rittman Analytics’ New Website](https://rittmananalytics.com/blog/2025/08/29/opinionated-ai-enabled-modern-the-story-behind-rittman-analytics-new-website) Over the past few years, we’ve built and modernised data platforms for dozens of digitally native businesses. The patterns are consistent: ambitious data goals, strong technical leadership and newly formed… markrittman·Aug 29, 2025 ![Adventures in Aggregate Awareness (and Level-Specific Measures) with Looker](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2025%2F08%2F0.01426986606877012.png%3Ffit%3D2048%252C676%26ssl%3D1) ### [Adventures in Aggregate Awareness (and Level-Specific Measures) with Looker](https://rittmananalytics.com/blog/2025/08/25/adventures-in-aggregate-awareness-and-level-specific-measures-with-looker) Looker aggregate awareness is a performance optimisation feature that automatically directs users’ queries to use pre-aggregated summary tables instead of detail-level transaction tables, significantly improving the performance of reports and… markrittman·Aug 25, 2025 ![When Your Talented Data Team is Stuck in Second-Gear](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2025%2F07%2F1753885226192-9hs0g.webp%3Ffit%3D1400%252C676%26ssl%3D1) ### [When Your Talented Data Team is Stuck in Second-Gear](https://rittmananalytics.com/blog/2025/07/30/when-your-talented-data-team-is-stuck-in-second-gear) You did everything right. You recognised the limits of spreadsheets, secured the budget, and invested in a talented data team. You’ve adopted the modern data stack with dbt, a cloud… markrittman·Jul 30, 2025 ![IQR-Based Website Event Anomaly Detection using Looker and Google BigQuery — Rittman Analytics](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2025%2F07%2F1753874062120-ri2bhh.webp%3Ffit%3D1536%252C1024%26ssl%3D1) ### [IQR-Based Website Event Anomaly Detection using Looker and Google BigQuery — Rittman Analytics](https://rittmananalytics.com/blog/2025/07/28/iqr-based-website-event-anomaly-detection-using-looker-and-google-bigquery-rittman-analytics) Website event tracking bugs can become costly quickly. A deployment of a new website version that triggers events multiple times can increase your hosting charges or worse, lead to overage… markrittman·Jul 28, 2025 ![Integrating Looker and LangChain with langchain-looker-agent](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2025%2F06%2F110e5-a63820d4-6b37-4fb3-924f-52508023e9b4_1000x897.png%3Fssl%3D1) ### [Integrating Looker and LangChain with langchain-looker-agent](https://rittmananalytics.com/blog/2025/06/02/integrating-looker-and-langchain-with-langchain-looker-agent) We’ve just released a prototype of a new Langchain tool that enables LangChain applications and agentic workflows to connect to Looker, via its Open SQL Interface. In the past when… markrittman·Jun 2, 2025 ![London Looker Meetup – May 8th 2025 – Registration Open & Call for Speakers!](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2025%2F06%2Ff85d3-9e0bf430-312b-4669-84c0-3fa0a88936a4_1340x752.png%3Fssl%3D1) ### [London Looker Meetup – May 8th 2025 – Registration Open & Call for Speakers!](https://rittmananalytics.com/blog/2025/03/31/london-looker-meetup-may-8th-2025) The first London Looker Meetup will be on Thursday, May 8th at the Google London — Pancras Square office from 17:30–20:30 and registration is now open! Back in 2019 Jonathan… markrittman·Mar 31, 2025 ![Drill to Detail Podcast Transcripts & Gen AI Insights Now Available, Powered by OpenAI Whisper API & BigQuery Colab Notebooks](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2025%2F06%2Fe604e-07ae4298-00be-4b00-9377-eab236288bd0_1000x1053.png%3Fssl%3D1) ### [Drill to Detail Podcast Transcripts & Gen AI Insights Now Available, Powered by OpenAI Whisper API & BigQuery Colab Notebooks](https://rittmananalytics.com/blog/2025/02/14/drill-to-detail-whisper-api-colab-notebooks) We’ve been asked many times in the past for episode transcripts for the Drill to Detail Podcast, and I’m therefore pleased to launch our new Drill to Detail Podcast website… markrittman·Feb 14, 2025 ![How Rittman Analytics Automates Project RAG Status Reporting using Vertex AI, DocumentAI, BigQuery & Looker](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2025%2F06%2F033e1-2b6b5931-448f-4565-97bb-a6fe006c0a00_1000x664.png%3Fssl%3D1) ### [How Rittman Analytics Automates Project RAG Status Reporting using Vertex AI, DocumentAI, BigQuery & Looker](https://rittmananalytics.com/blog/2025/01/29/genai-looker-rag-status) A common way to report on the progress of a project is through RAG (Red, Amber Green) status indicators for the project, at the overall level and by cost, schedule,… markrittman·Jan 29, 2025 ![Deploying Maxwell’s Demon: QA Automation In Droughty](https://rittmananalytics.com/api/public/og-image?src=https%3A%2F%2Fi0.wp.com%2Fdtdtemp8.wpcomstaging.com%2Fwp-content%2Fuploads%2F2025%2F01%2Fscreenshot2025-01-20at10.54.33.webp%3Ffit%3D1000%252C363%26ssl%3D1) ### [Deploying Maxwell’s Demon: QA Automation In Droughty](https://rittmananalytics.com/blog/2025/01/20/deploying-maxwells-demon-qa-automation-in-droughty-2)