--- title: Smart Query description: "# Revolutionizing Data Analytics with Smart Query: Natural Language Dashboards In today’s data-driven business landscape, speed and simplicity in data analysis can define an organization's competitive edge. Yet, navigating complex dashboards, writing SQL queries, or drilling down through endless filters…" url: "https://dashboardbuilder.net/smart-query" updated: "2026-10-19" category: Building dashboards --- # Smart Query # Revolutionizing Data Analytics with Smart Query: Natural Language Dashboards In today’s data-driven business landscape, speed and simplicity in data analysis can define an organization's competitive edge. Yet, navigating complex dashboards, writing SQL queries, or drilling down through endless filters often makes data exploration overwhelming for non-technical users. Recognizing this gap, Dashboard Builder introduces a game-changing feature: **Smart Query**. By harnessing the power of **Artificial Intelligence (AI)** and **Natural Language Processing (NLP)**—through cutting-edge models like **ChatGPT**, **DeepSeek**, and **Gemini**. Smart Query allows users to interact with their data using simple, everyday language - bringing the concept of natural language dashboards into reality.. Whether you're asking to "see last year’s data" or "analyze top-performing regions," the system intelligently interprets the intent, restructures it into actionable queries, and dynamically regenerates visual graphs on the fly. This innovation bridges the gap between human conversation and machine-level data analysis—empowering every team member to make informed decisions without writing a single line of code. ![Smart Query ](/images/banner_for_smart_query_dashbaord_builder.webp) Smart Query interprets natural language like “Show me last year’s data” and dynamically visualizes it into actionable dashboards ## Introduction In the ever-evolving world of data analytics, simplicity and intelligence are becoming the new standards. Dashboard Builder is leading this transformation with its latest feature—**Smart Query**—a breakthrough that enables users to analyze data using **Natural Language Processing (NLP)**. No more struggling with complex SQL syntax or navigating multiple filters; just type what you need in plain English, and the system takes care of the rest. ## > Smart Query enables a natural language dashboard experience, allowing users to ask questions and instantly generate visual analytics. ## What is Smart Query? **Smart Query** is a cutting-edge feature in Dashboard Builder that empowers users to interact with their data naturally. Instead of traditional filter-based dashboards or manual SQL scripts, users can now ask questions like: > "I want to see data from last year." > "Show me top-performing sales regions." > "What were the monthly expenses in Q2?" This makes Smart Query a perfect example of natural language dashboards, where users move away from rigid filters and interact conversationally with data. ## How It Works: AI at the Core Smart Query is powered by advanced **AI language models**, including **ChatGPT, DeepSeek, and Gemini**, which are integrated into the Dashboard Builder platform. Here's how it works: 1. **Natural Language Query:** The user types a question or command in natural language. 2. **NLP Interpretation:** The input is processed by NLP agents, which translate it into a structured command. 3. **Query Conversion (MML & SQL):** The system converts the interpreted query into an internal markup (MML) and then into a SQL query. 4. **Graph Generation:** Based on the SQL output, the dashboard regenerates visualizations—bar charts, pie charts, KPIs, tables—reflecting the exact data requested. This entire process takes place in seconds, offering **real-time, intelligent data interaction**. ## Why Smart Query Matters - **No Technical Skills Required:** Users don’t need to know SQL or data schemas—just ask a question. - **Faster Decision-Making:** Instant results help teams make data-driven decisions quickly. - **Seamless Integration:** Smart Query works smoothly with existing data sources and visual layouts. - **AI-Powered Accuracy:** Leverages ChatGPT, DeepSeek, and Gemini to understand context, intent, and complex queries. ## Use Cases of Smart Query in Business Intelligence - **Marketing Teams:** Analyze campaign ROI by simply asking, "Show me ROI by campaign." - **Sales Managers:** View performance with queries like "Top 5 sales reps this quarter." - **Finance Departments:** Check expenditures with "Display expenses by category for Q1." - **Executives:** Get high-level KPIs like "What’s the YoY growth?" ## Future of Smart Analytics The integration of **Natural Language Processing in dashboards** - often referred to as **natural language dashboards** - marks a major shift in how businesses interact with data. It democratizes analytics—making it accessible to everyone, regardless of technical expertise. Smart Query is not just a feature; it’s a **new way of thinking about business intelligence**. With Smart Query, Dashboard Builder is redefining the future of interactive data analytics. By combining the power of **NLP, AI, and real-time visualization**, organizations can unlock faster insights and empower every team member to explore data freely and intelligently. Whether you're a data analyst, business executive, or a startup founder, **Smart Query transforms your data experience from complex to conversational**. ## How to Use the Smart Query Feature in Dashboard Builder (v7.4+) **APPLIES TO:**    On-premises    Online   Desktop The **Smart Query** feature in Dashboard Builder enables users to interact with data using **natural language**. This AI-powered functionality leverages APIs from **Gemini**, **ChatGPT**, or **DeepSeek** to generate dynamic graphs based on plain-language queries such as *“Show me sales from last year.”* ![Sample Smart Query input ](/images/smart_query_step_main.jpg) #### Requirements The Dashboard Builder can be installed any platforms like Windows, Linux, Mac and Ubuntu or any other platforms support Apache. - Dashboard Builder 7.4 or higher version - PHP Version 7.2 or later - Apache 2 or later - Windows 7 or later /Linux 3 or later - Firefox 52, Chrome 57, IE 8 #### Installation - Download from [https://dashboardbuilder.net/download-free-dashboard](/download-free-dashboard) - Place the files in a directory on the web server. e.g. …/www/dashboar/dbuilder/ This guide walks you through how to enable Smart Query using the **Gemini API** and how to embed it into your charts. ## Step 1: Log In to Dashboard Builder 1. Open your Dashboard Builder application (v7.4 or above). 2. Log in using your valid credentials. ![Login to the Dashboard Builder](/images/login.png) ## Step 2: Get Your Gemini API Key 1. Go to: [https://aistudio.google.com/app/apikey](https://aistudio.google.com/app/apikey) 2. Sign in with your Google account. 3. Click **"Create API Key"** (or copy an existing one if available). 4. Safely copy the API key to your clipboard. ![Smart Query Step 2: Get your Gemini Key ](/images/chatgpt_dashboard_step2.png) ## Step 3: Enable AI Integration in Dashboard Builder 1. Inside Dashboard Builder, go to the **Settings** menu. 2. Navigate to **AI Integration**. 3. Enable the toggle: **Enable AI Integration**. 4. Among the AI providers listed (**ChatGPT**, **Gemini**, **DeepSeek**), click the **Gemini** button. 5. Paste your Gemini API key into the field provided. 6. Click **Save Changes**. ![Smart Query Step 3: Enable AI Integration ](/images/deepseek_dashboard_settings-step3.png) ## Step 4: Create or Edit a Chart 1. Connect to your database as you normally would. 2. Navigate to your dashboard and click **Edit**. 3. Double-click the **chart header bar** to open the **Chart Settings** screen. 4. Create your chart using the standard options (e.g., select dataset, chart type, grouping, etc.). ## Step 5: Enable Smart Query on the Chart 1. In the **Chart Settings** screen, locate the **Properties** section. 2. Find the **Smart Query** option. 3. Set it to **Yes**. 4. Click **Save** to apply changes. ![Enable Smart Query ](/images/smart_query_enabled.png) ## Step 6: Use Smart Query Once enabled, a **Smart Query input box** will appear on the top of your chart bar. 1. Enter a natural language query, such as: - “Show me sales data for 2023.” - “What were the top 5 products last quarter?” 2. Click the **Submit** button. 3. A new chart will be dynamically generated based on your query. ![Use Smart Query](/images/smart_query_use.png) ![Use Smart Query Usage](/images/smart_query_usage.png) ## Step 7: Refresh or Revert Your Query - To regenerate a chart, click the **Refresh** button. - To go back to the original view, click the **Back** button. ![Use Smart Revert](/images/smart_queiry_revert.png) ## Notes - This feature requires a stable internet connection for API communication. - Smart Query is only available in **Dashboard Builder v7.4 and above**. - You can switch between AI providers anytime by updating the settings. ## Meet the Expert Behind Smart Query ### George Lewis – Director of AI & Business Intelligence Strategy, Dashboard Builder Smart Query is designed by George Lewis (Director of AI & Business Intelligence Strategy at the Dashboard Builder), with 10+ years in BI and data visualization. He’s led enterprise dashboard rollouts in healthcare and finance. With over a decade of experience in artificial intelligence and data science, George Lewis has been the driving force behind the innovation of Smart Query. As **the Director of AI & Business Intelligence Strategy at Dashboard Builder**, George has dedicated his career to making data more intelligent, accessible, and actionable. His work blends cutting-edge machine learning, **natural language processing (NLP),** and **advanced data engineering** to create a seamless analytics experience for users across the globe. Under his leadership, Smart Query evolved into a tool that empowers users to ask complex data questions in natural language—and receive instant, visual answers. George’s mission is clear: to democratize business intelligence by removing technical barriers and enabling smarter decision-making for everyone—from executives to analysts. His vision continues to shape Dashboard Builder into a globally trusted platform used by businesses to uncover insights effortlessly. > "I take pride in leading innovations that make business intelligence more accessible, intelligent, and impactful.” — [George Lewis](https://www.linkedin.com/in/george-lewis-6376a81bb/) ## Case Study: Accelerating BI with Smart Query At Diginix Technologies, AI & Data Scientist Jason Carter was spending hours each week writing complex SQL queries to extract insights for strategic reporting. With the adoption of Smart Query, his team transitioned to a natural language interface that lets them generate interactive dashboards instantly—simply by typing questions in plain English. The result? A 60% reduction in reporting time, improved decision-making speed, and increased data accessibility across non-technical departments. Smart Query not only streamlined their analytics workflow but also empowered broader teams to engage with data independently. ### How We Built Smart Query – From Real User Needs ![Jason Carter](/images/user_square.png) ★★★★★ "As an AI & Data Scientist at Diginix Technologies, I rely on Smart Query to simplify complex data exploration. It lets me generate meaningful visual insights instantly—without writing a single line of code. It’s truly changed how we handle business intelligence." Jason Carter AI & Data Scientist, Diginix Technologies ## Frequently Asked Questions How does Smart Query work with natural language? Smart Query uses NLP (Natural Language Processing) to convert your questions into database queries. You simply type a question in plain English, and Smart Query instantly generates charts or tables based on your data. Do I need coding knowledge to use Smart Query? Not at all. Smart Query is designed for non-technical users. If you can ask a question in English, you can use Smart Query to explore your data—no SQL or programming required. Can Smart Query connect to my existing databases? Yes. Smart Query can be integrated with various databases such as MySQL, PostgreSQL, SQL Server, and others. Simply configure your data source and start querying instantly. Is Smart Query secure for enterprise use? Absolutely. Smart Query is built with enterprise-grade security, supports role-based access, and complies with standard data protection policies. All queries are securely executed within your environment. What types of visualizations can Smart Query generate? Smart Query supports a wide range of visualizations including bar charts, line graphs, pie charts, tables, gauges, and more—based on your query and dataset structure. ## Conclusion The **Smart Query** feature in Dashboard Builder represents a transformative shift in how users interact with data. By integrating advanced AI technologies like **Gemini**, **ChatGPT**, and **DeepSeek**, the platform empowers users to go beyond traditional filters and technical query languages. Now, anyone—regardless of their technical background - can simply type a question in natural language and instantly receive relevant, visual insights through natural language dashboards. This functionality not only streamlines decision-making but also democratizes access to data across your organization. From setup to execution, enabling Smart Query is a straightforward process that brings powerful AI-driven analytics to your fingertips. Whether you're a business analyst, executive, or data enthusiast, this feature enhances productivity, promotes agility, and ensures more intuitive access to critical information. If you're using version 7.4 or higher of Dashboard Builder, it's time to turn on Smart Query and experience the future of interactive dashboards. [AI Dashboard Generator](/ai-dashboard-generator) ## As Featured In Smart Query was recently featured on Medium: [![Medium logo](https://cdn-icons-png.flaticon.com/512/5968/5968885.png) **Medium:** I Typed “Show Me Sales by Region” and My Dashboard Did the Rest](https://medium.com/@salesdashboardbuilder/i-typed-show-me-sales-by-region-and-my-dashboard-did-the-rest-9e294d177110) --- '; }, false) ## Need a hand? Tell us what you’re stuck on and we’ll help you finish the setup. [Contact support](https://dashboardbuilder.net/support)