INTELLIGENCE
Archive

How to Get Started with Deepnote for Data Analysis
Deepnote is a cloud-based collaborative data notebook that combines SQL, Python, and no-code blocks in a single workspace. It supports real-time co-editing, connects directly to databases and warehouses like Snowflake and BigQuery, and recently went open source under the Apache 2.0 license. This guide walks through account setup, project creation, data connections, and sharing results with a team.

How to Set Up Quadratic for Spreadsheet Analysis
Quadratic is a free, browser-based AI spreadsheet that lets you write Python, SQL, and JavaScript alongside traditional formulas. To get started, create an account at app.quadratichq.com, import a CSV or Excel file, and use the built-in AI assistant or code cells to clean, transform, and visualize your data. No installation or configuration is required.

How to Get Started with Zerve for Data Analysis
Zerve is an agentic data workspace that combines AI-powered notebooks, data discovery, and one-click deployment in a single browser-based environment. To get started, create a free account, open a canvas, connect your data source or upload a file, and prompt the built-in AI agent to run your analysis. Zerve supports Python, R, and SQL in the same project and handles parallelization and scheduling without additional infrastructure.

How to Analyze CSV Data with Claude AI
Claude AI can analyze CSV files directly in the browser. Upload a file through the paperclip icon, ask questions in plain English, and Claude writes and runs JavaScript code behind the scenes to clean, filter, summarize, and chart your data. It handles files up to 30 MB and works best with datasets under 50,000 rows, making it practical for most business reporting tasks without any coding or tool setup required.

How to Use Rows AI for Spreadsheet Analysis
Rows AI is a browser-based spreadsheet platform with a built-in AI analyst that lets you clean, analyze, and visualize data using plain English prompts. You can upload a CSV or connect live data from tools like Google Ads or HubSpot, then ask questions directly in the spreadsheet to get summary tables, charts, and statistical breakdowns without writing formulas or code.

How to Use Perplexity Deep Research for Market Analysis
Perplexity Deep Research is a Pro feature that runs multi-step web research autonomously and delivers a structured, cited report in under five minutes. To use it for market analysis, open Perplexity, select Deep Research mode, enter a focused market question, and let the system synthesize findings from dozens of sources. The output includes a narrative summary with inline citations that you can export, share with stakeholders, or feed into further analysis tools.

How to Set Up Metabase for Self-Service Analytics
Metabase is a free, open source business intelligence tool that lets non-technical teams query databases, build dashboards, and share reports without writing SQL. You can deploy it with a single Docker command, connect it to PostgreSQL or any of 20-plus supported databases, and have your first interactive dashboard running in under an hour. This guide walks through every step from installation to team sharing.

How to Use Julius AI for Data Analysis
Julius AI lets you upload a spreadsheet or CSV, ask questions in plain English, and get charts, statistical summaries, and cleaned datasets without writing code. This tutorial walks through account setup, data preparation, prompt strategies that produce reliable outputs, and the key limitations you should know before relying on Julius for business decisions.

How to Use the AI Function in Google Sheets
Google Sheets now includes a built-in =AI() function powered by Gemini that lets you run AI prompts directly inside spreadsheet cells. You can use it to categorize text, analyze sentiment, extract data from unstructured content, and generate summaries without leaving your spreadsheet. The function accepts a text prompt and an optional cell range as inputs and works on Google Workspace Business, Enterprise, and Education Plus plans as well as the Google AI Pro add-on.