--- title: "Democratizing Data: The AI Tools Making BI Accessible to Everyone · Appnovation" url: "https://www.appnovation.com/insights/democratizing-data-ai-tools-making-bi-accessible-everyone" description: "Ben Suan, our Manager of Data & Analytics, dives into the transformative role of AI in business intelligence in his latest blog, exploring how tools like…" --- Article # Democratizing Data: The AI Tools Making BI Accessible to Everyone Ben Suan, our Manager of Data & Analytics, dives into the transformative role of AI in business intelligence in his latest blog, exploring how tools like Looker and BigQuery are making data more accessible and actionable for everyone. [![](https://cdn.sanity.io/images/ey850001/production/d9fb896de2663aa254c2111bc8b6397955dece65-68x68.jpg?w=68&auto=format) Benjamin Suan Manager, Data & Analytics](/people/benjamin-suan.md) Jun 04, 2025 5 min read ![Democratizing Data: The AI Tools Making BI Accessible to Everyone](https://cdn.sanity.io/images/ey850001/production/fb2e1a904ddde5dea2ac1c2f7fd45f8e6445e0f7-1728x680.jpg?w=1400&auto=format) Ben Suan, our Manager of Data & Analytics, dives into the transformative role of AI in business intelligence in his latest blog, exploring how tools like Looker and BigQuery are making data more accessible and actionable for everyone. You can also find this on [LinkedIn here (opens in new window)](https://www.linkedin.com/feed/update/urn:li:activity:7338271676767326208). Exhausted hearing about AI? For the past few years, I’ve felt overwhelmed by the constant stream of AI headlines—first it was generative AI, then large language models (LLMs), retrieval-augmented generation (RAG), and now the buzz is all about model context protocol (MCP) and agentic AI. What’s next? Adding to this is the rapid evolution of cloud tools, which at times can feel like trying to keep your footing during an earthquake. But despite the noise, AI’s ubiquity means it’s showing up in more meaningful, applied ways across industries. Until recently, though, nothing in the AI landscape really stood out to me. That changed this year with the introduction of **Gemini in Looker** and a host of **AI enhancements in BigQuery.** Having specialized in Google Cloud Platform (GCP) for the past five years, I finally felt the promise of AI becoming real—especially in the space I care most about: **Business Intelligence (BI) and data warehousing.** One of the persistent challenges in BI is helping businesses make sense of their data. Raw data, by itself, isn’t very useful—mainly because the way it's ingested is rarely optimized for reporting. This is why data modeling is so critical: it shapes data into something analysis-ready. So the big question now is: **how is AI influencing this space?** #### **BigQuery: AI Gets Practical** BigQuery has seen a significant AI upgrade recently. A great example is the new Insights tab available on tables and views. This feature automatically surfaces key data patterns and generates suggested questions, each accompanied by a pre-written SQL query to kick off your analysis. These AI-generated queries aren’t always perfect—you may need to tweak them to join additional tables or apply specific filters—but they offer a strong head start, especially for analysts who regularly write complex SQL. But this is just scratching the surface. **Meet BigQuery Data Canvas** **BigQuery Data Canvas** is a new, **visual and interactive workspace for data exploration**. It replaces the traditional linear workflow with a **Directed Acyclic Graph (DAG)** approach, which allows you to: * Branch off at any step to explore alternative perspectives * Revisit earlier stages in your analysis * Compare multiple outcomes simultaneously This structure makes data exploration more flexible, iterative, and intuitive—especially when paired with Gemini’s AI capabilities. While it’s a shift from the traditional method of managing SQL queries in multiple tabs, I look forward to adapting and learning how it can streamline the process. #### **Looker: Conversational BI Comes to Life** On the Looker side, the integration of Gemini agents is a true game changer. Many business users just want to ask a question and get an answer—without having to run a report or build a dashboard. That’s now possible. **Conversational Analytics (Public Preview)** With **Conversational Analytics**, users can interact with their data using natural language. Just type in a question, and the Gemini agent generates a SQL query behind the scenes, then returns insights and next-step suggestions. You can even ask follow-up questions to drill deeper. This works well because Gemini leverages Looker’s Explore layer, which is built on the LookML semantic model. This semantic layer is crucial—it provides a governed, business-friendly interpretation of raw data. It's the map Gemini follows to understand and contextualize the data it’s working with. AI-Powered Development in Looker Not a fan of writing LookML from scratch? Gemini can now assist with LookML code generation, saving time on model development. And for those unfamiliar with dashboard creation, the new Visualization Assistant allows users to build charts and reports simply by using prompts. Together, these features lower the barrier to BI for non-technical users while speeding up workflows for technical teams. #### **Wrapping Up: AI + BI = Better Together** AI can’t work miracles unless your BI foundation is solid. That includes data modeling, quality, and semantic layers. As the old adage goes: Garbage In = Garbage Out—a truth I heard echoed by many data professionals at Google Cloud Next. But we’re seeing a new narrative emerge: not just BI enabling AI, but also AI enhancing BI. For example, BigQuery now includes tools like data profiling, lineage tracking, and quality checks that boost data engineers’ productivity. AI is even helping unify unstructured and structured data into more coherent models. #### **So, what does this all mean?** AI is bringing us closer to the long-held BI dream: **democratizing data access for all users.** It’s speeding up time-to-insight and reducing dependence on analysts for simpler queries. That’s a win—because it frees analysts to focus on higher-order questions where human creativity and domain expertise still reign. For my clients, this evolution translates to immediate, tangible benefits. With tools like Gemini in Looker and BigQuery’s AI upgrades, even non-technical teams can unlock insights from their data with minimal friction. This empowers clients to make faster, smarter decisions without waiting on analysts or complex reporting pipelines. By streamlining workflows and reducing bottlenecks, these tools enable organizations to become more data-driven—driving better outcomes and giving them a competitive edge in their industries. For clients who want to move past off-the-shelf BI into proprietary, defensible AI assets, the next step is [AI Product Development](/ai-product-development.md). Looking ahead, AI-infused BI tools will only get stronger—potentially amplifying human capability by 10x. We may finally get over the hump of "understanding our own data" with ease. And beyond that? Keep an eye on **quantum computing**—it’s poised to push these transformations even further. *As a first-ever recipient of the Google Public Sector Partner Expertise Badges in Data and Analytics and a preferred Google AI partner, At Appnovation we are committed to using cutting-edge technologies to empower organizations with actionable insights and drive meaningful progress—helping them navigate complex challenges and unlock new opportunities.* [![](https://cdn.sanity.io/images/ey850001/production/d9fb896de2663aa254c2111bc8b6397955dece65-68x68.jpg?w=68&auto=format) Benjamin Suan Manager, Data & Analytics · Appnovation](/people/benjamin-suan.md) ## Keep reading [![What Happens When AI Moves Faster Than Governance?](https://cdn.sanity.io/images/ey850001/production/e28e79e7849636542050b7cf71805e0b1266acac-1728x680.jpg?w=640&auto=format)](/insights/what-happens-when-ai-moves-faster-governance.md) Article · 4 min AI Jul 02, 2025 ### [What Happens When AI Moves Faster Than Governance?](/insights/what-happens-when-ai-moves-faster-governance.md) AI tools are everywhere—but governance is lagging behind. Learn how to balance innovation, agility, and control in the age of decentralized AI. [Iain MacNeil](/people/iain-macneil.md) Article [![AI Summit](https://cdn.sanity.io/images/ey850001/production/efad1693029e1747b2503957ed38c816253a6310-1200x627.png?w=640&auto=format)](/insights/highlights-ai-summit-navigating-future-intelligence.md) Article · 4 min AI Jun 18, 2025 ### [Highlights from the AI Summit: Navigating the Future of Intelligence](/insights/highlights-ai-summit-navigating-future-intelligence.md) Clare Fisher, Associate Director of Client Services at Appnovation, shares her reflections from the recent AI Summit in her debut LinkedIn blog. From the rise of AI agents to ethical adoption and the evolving human role, Clare offers sharp insights into how AI is reshaping industries—from banking to healthcare. [Appnovation](/people/appnovation.md) Article [![The Veeva-Salesforce Change: What It Means for Your CRM in Life Sciences](https://cdn.sanity.io/images/ey850001/production/86707f19a4d0aba52c5fb478fc9477bfbb40e7a9-1400x600.jpg?w=640&auto=format)](/insights/veeva-salesforce-change-what-it-means-your-crm-life-sciences.md) Article · 7 min Jun 30, 2025 ### [The Veeva-Salesforce Change: What It Means for Your CRM in Life Sciences](/insights/veeva-salesforce-change-what-it-means-your-crm-life-sciences.md) This post looks at the key questions life science businesses raise about the Salesforce Life Sciences Cloud and Veeva split. [Appnovation](/people/appnovation.md) Article ## Get the thinking, *before everyone else.* One considered email a month. New essays, field notes from live engagements, and the occasional strong opinion. No noise.