INTELLIGENCE
Guides
How to Analyze Large CSV Files with DuckDB
DuckDB is a free, open-source analytical database that lets you query CSV files directly with SQL, no server or setup required. Install it with a single command, point it at any CSV (even files with hundreds of millions of rows), and run aggregations, filters, and joins in seconds on a standard laptop. This guide walks through installation, first queries, performance tuning, and exporting results.
How to Set Up Tableau Pulse for AI Metric Digests
Tableau Pulse is Tableau Cloud's AI-driven metrics layer that delivers personalized insights to users through email and Slack digests, without requiring them to open a dashboard. Setting it up involves enabling the feature in site settings, creating metric definitions from a published data source, configuring time dimensions and insight types, and connecting delivery channels. Once live, users follow specific metrics and receive automatic trend alerts and anomaly summaries.
How to Use NotebookLM Data Tables for Business
Google NotebookLM's Data Tables feature turns unstructured documents into structured, queryable tables using Gemini AI. You upload sources like PDFs, meeting notes, or reports, then prompt NotebookLM to extract specific fields into rows and columns. The output exports directly to Google Sheets for further analysis. Over 400 million Workspace users now have access to this feature, making it one of the fastest paths from raw documents to organized business data without writing code.
How to Use Excel Agent Mode for Automated Reports
Excel Agent Mode lets Microsoft 365 Copilot users automate multi-step reporting tasks directly inside a spreadsheet. You describe the outcome you want in plain English, and Copilot builds a plan, executes each step in your workbook, and validates the result. It works on Windows, Mac, and the web for any M365 Copilot, Personal, Family, or Premium subscriber. This guide walks through setup, effective prompts, and practical reporting workflows.
How to Set Up ThoughtSpot Spotter for AI Analytics
ThoughtSpot Spotter is ThoughtSpot's natural language analytics engine that lets business users query live data warehouse tables by typing plain English questions. You connect a cloud data source like Snowflake or BigQuery, build a semantic model, enable Spotter on that model, and start asking questions. The free trial includes sample data and supports up to five users for 30 days, with the Essentials plan starting at $25 per user per month after that.
How to Set Up Apache Superset with Docker
Apache Superset is a free, open-source business intelligence platform that supports over 40 visualization types and connects to virtually any SQL database. The fastest way to run it locally is with Docker Compose, which bundles Superset, a metadata database, a cache layer, and a sample PostgreSQL dataset in a single command. This guide walks through the full setup from Docker install to publishing your first interactive dashboard.
How to Set Up Snowflake Intelligence
Snowflake Intelligence is a conversational analytics agent that lets business users query structured and unstructured data in plain English without writing SQL. Setting it up requires an active Snowflake account, a semantic model defined in YAML that maps your business terms to database columns, and the ACCOUNTADMIN role to create the Intelligence object. Once configured, any team member can ask questions and get answers drawn directly from your warehouse.
How to Set Up Metabase for Self-Hosted Analytics
Metabase is a free, open-source business intelligence tool that lets teams query databases, build dashboards, and share reports without writing SQL. You can self-host it with a single Docker command or a Java JAR file. This guide walks through installation, connecting your first database, building your first dashboard, and the configuration steps most setup guides skip.
How to Use Looker Studio with Gemini AI
Looker Studio is a free Google dashboard builder. Its Gemini AI layer, unlocked through Looker Studio Pro, adds three practical features: Conversational Analytics for querying data in plain English, a Formula Assistant that writes calculated fields from a description, and a Slides export that turns dashboards into commented presentation decks. This guide covers the setup, how each feature works in practice, and the current limitations.