INTELLIGENCE
Guides
How to Set Up Looker Studio for Business Reporting
Looker Studio is a free Google tool that converts spreadsheets and databases into shareable, interactive dashboards without writing code. Connect a Google Sheet, drag on chart types, and share a live link that updates automatically. Setup takes under 30 minutes for a first working report. The platform queries your data live on every load, so stakeholders always see current numbers without a manual refresh step.
How to Clean Messy Data with OpenRefine
OpenRefine is a free, open-source desktop application that lets analysts clean and standardize messy datasets without writing code. You download and install it on your computer, import a spreadsheet or CSV, then use its faceting, clustering, and transformation tools to fix inconsistencies, remove duplicates, and standardize values. Data never leaves your machine. Setup takes about five minutes, and most cleaning tasks are completed through menus and point-and-click operations.
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.