INTELLIGENCE
Guides
How to Set Up Wren AI for Natural Language SQL
Wren AI is an open-source tool that connects to PostgreSQL, BigQuery, Snowflake, MySQL, and 8 other databases and lets you query them in plain English. Unlike tools that pass raw schema directly to an LLM, Wren AI uses a semantic layer where you define table relationships and column meanings once, producing consistent SQL across every question. Setup takes roughly 30 minutes: install via Docker, connect your database, define relationships, add column descriptions, then start asking questions.
How to Build Automated Data Workflows with n8n
n8n is an open-source workflow automation platform that connects databases, spreadsheets, and APIs through a visual node editor. You pull data from sources like Postgres or Google Sheets, apply transforms and aggregations, and push the results to Slack, email, or a dashboard on a schedule. Teams report eliminating 3 to 5 hours of weekly manual report assembly after building a single n8n workflow.
How to Get Started with Tableau Pulse
Tableau Pulse is Tableau Cloud's AI-powered metrics layer that surfaces personalized KPI insights in plain language, delivered via email and Slack digests without requiring anyone to open a dashboard. Setup takes three steps: enable Pulse at the site level, create a metric definition from a published data source, and configure which users follow which metrics. Teams can have their first metric live in under an hour.
How to Use Gemini in BigQuery (2026 Guide)
Gemini in BigQuery is Google's AI assistant that lets analysts ask questions about their data in plain English, without writing SQL. Enable it through the Google Cloud console, open BigQuery Studio, and type your question into the chat panel. Gemini translates your question into SQL, runs it, and returns results with an explanation. The Data Insights feature generates suggested questions automatically from any unfamiliar table in minutes.
How to Get Started with Sigma Computing
Sigma Computing is a cloud analytics platform that lets business users work with warehouse data through a familiar spreadsheet interface, with no SQL required. It connects directly to Snowflake, BigQuery, or Databricks and queries live data in real time - no CSV exports, no stale snapshots. A non-technical analyst can go from connecting a data source to publishing a live dashboard in under 30 minutes.
How to Get Started with Omni Analytics
Omni Analytics is a modern business intelligence platform that connects directly to your database or cloud warehouse and lets business users build analyses and dashboards without writing SQL. The setup takes under 30 minutes: connect a data source, explore data in a workbook using point-and-click or SQL, then publish a shareable dashboard. A natural language query layer added in 2025 lets users ask questions in plain English against their live, governed data model.
How to Set Up the Hex AI Agent (2026 Guide)
Hex is a collaborative analytics platform that combines SQL, Python, and AI agents in a single workspace. Getting useful results from the Hex Agent requires four setup steps before asking a question: a scoped data connection, endorsed tables, column descriptions, and a workspace context file. With those configured, the agent generates accurate SQL, surfaces charts from existing projects, and since the April 2026 update, builds a persistent user memory that improves responses over time.
How to Get Started with Dagster
Dagster is an open-source data orchestration platform that models pipelines as software-defined assets rather than task graphs. To get started, install it with pip, define assets as plain Python functions decorated with @asset, and run dagster dev to launch a local UI. Unlike Airflow, Dagster tracks the freshness of each data asset it produces, making lineage and staleness visible at a glance. A working pipeline with a daily schedule takes under 20 minutes to set up from scratch.
How to Set Up Snowflake Cortex Analyst
Snowflake Cortex Analyst lets analysts and business users ask plain-English questions about their warehouse data and get SQL-generated answers instantly. Setup requires a Snowflake account, a semantic model YAML file that maps your tables into business terms, and either a Streamlit interface or the Cortex REST API. This guide walks through each step from environment prep to running your first natural language query.