INTELLIGENCE
Guides
How to Use the =AI() Function in Google Sheets
Google Sheets now includes a built-in =AI() function powered by Gemini that lets users generate text, categorize data, extract information, and run sentiment analysis directly inside cells. The function accepts a natural language prompt and optional cell references, returning AI-generated output without leaving the spreadsheet. It is available in beta to Google Workspace Business, Enterprise, and AI Ultra subscribers as of March 2026.
How to Set Up Hex for AI Data Analysis
Hex is a collaborative data notebook that combines SQL, Python, and no-code tools with built-in AI agents for exploratory analysis. Setting it up requires connecting a data warehouse, endorsing trusted tables, adding descriptions, and configuring workspace context so the AI agent can generate accurate queries. The free Community plan supports unlimited public projects, and paid plans start at $36 per editor per month.
How to Set Up Sourcetable for AI Data Analysis
Sourcetable is an AI-native spreadsheet that connects to over 900 data sources and lets you query, clean, and visualize data using plain English. This guide walks through account setup, connecting your first data source, running AI-powered analysis, and building reusable workflows. A free tier and 7-day Pro trial are available with no credit card required.
How to Set Up Quadratic for Data Analysis
Quadratic is a free, open-source AI spreadsheet that lets you run Python, SQL, and JavaScript directly in cells alongside traditional formulas. With over 250,000 users and SOC 2 certification, it bridges the gap between spreadsheets and code-based analysis. This guide walks through account setup, data import, writing your first AI-assisted query, and building a chart, all in under 15 minutes.
How to Build a Business Dashboard with Notion Charts
Notion now supports native chart views and a dedicated dashboard layout, letting teams track business KPIs without leaving their workspace. You can create bar, line, donut, and number charts directly from any database, combine them into a filtered dashboard, and even ask the Notion Agent to build the whole thing from a text description. This guide walks through the full setup from database to live dashboard.
How to Set Up AI Automations in Airtable
Airtable now includes built-in AI automation actions that let you generate text, classify records, and extract structured data without writing code. This guide walks through setting up the "Generate with AI" action step by step, from choosing a trigger to configuring prompts that reference your table fields. Most teams can have a working AI automation running in under 15 minutes.
How to Use Julius AI for Business Data Analysis
Julius AI is a natural language data analysis platform that lets you upload CSV, Excel, or Google Sheets files and analyze them by asking questions in plain English. It generates charts, statistical summaries, and written insights without requiring SQL or Python. The free plan includes 15 messages per month; paid plans start at $20 per month for 250 messages. This guide covers setup, file upload, practical prompt strategies, and which plan fits different business use cases.
How to Set Up MindsDB Anton for Data Analysis
MindsDB Anton is an open-source autonomous BI agent that installs with a single terminal command and answers plain-language questions about your data. It connects to databases, CSVs, and APIs, then plans the analysis, writes and executes its own code, and returns tables, charts, and dashboards. Released April 2, 2026, Anton works on macOS and Linux and is free to use with an existing OpenAI or Anthropic API key.
How to Query CSV Files with SQL Using DuckDB
DuckDB is a free, in-process SQL database built for analytical workloads. It reads CSV, Parquet, and JSON files directly with no import step, no Python environment, and no server configuration. Install the CLI with a single command, open a terminal, and run SQL queries on any CSV file immediately. DuckDB version 1.5.1 is the current release. This guide covers installation on Mac, Linux, and Windows, plus the most common analysis queries business analysts and operators actually need.