INTELLIGENCE
Archive
How to Use Julius AI for Data Analysis
Julius AI lets you upload a CSV or Excel file and ask questions about your data in plain English. It returns charts, statistical summaries, and written insights without requiring any code. This guide walks through account setup, data upload, effective prompting strategies, and how to export results, so you can go from raw spreadsheet to finished analysis in minutes.
How to Set Up Grist for AI Data Cleaning
Grist is a free, open-source spreadsheet platform with a built-in AI assistant that generates Python formulas from plain English prompts. To set it up for data cleaning, create a free account at getgrist.com, import your messy dataset, open the AI assistant from the Tools menu, and describe what you need fixed. The assistant handles duplicate detection, date standardization, format corrections, and category normalization without requiring any code.
How to Set Up Sourcetable for AI Data Analysis
Sourcetable is an AI-native spreadsheet platform that connects to over 900 data sources and lets users run analysis, build models, and generate reports using plain English. To set it up, create a free account, connect a database or upload a file, and use the AI assistant to query your data. The platform supports files up to 10GB and handles datasets exceeding one million rows without browser slowdown.
How to Use Excel Copilot Agent Mode
Excel Copilot Agent Mode lets you describe complex, multi-step spreadsheet tasks in plain English and have the AI execute them directly in your workbook. It plans a sequence of actions, builds formulas, charts, and PivotTables, then reviews its own output before finishing. Agent Mode is available on Excel for web, Windows, and Mac with a Microsoft 365 Copilot or AI credits subscription.
How to Set Up Flourish for Data Visualization
Flourish is a free, browser-based platform that turns spreadsheet data into interactive charts, maps, and stories without writing code. You pick a template from over 50 options, paste or upload your data, map columns to visual variables, customize colors and labels, then publish with an embed code or shareable link. The entire process takes under ten minutes for a basic chart, and your data never leaves your browser during editing.
How to Set Up Notion Dashboard Views
Notion dashboard views let you combine multiple database views, charts, boards, and calendars into a single control panel inside any Notion database. Released in March 2026 for Business and Enterprise plans, they replace the old method of stacking inline views on a page. You set them up by adding a new dashboard view to any database, then arranging up to 12 widgets with drag-and-drop layout controls and global filters that apply across all widgets at once.
How to Set Up Ask Zia in Zoho Analytics
Ask Zia is the built-in AI assistant in Zoho Analytics that lets you create reports, dashboards, and data pipelines using plain English prompts. It is included at no extra cost on Premium and Enterprise plans, supports synonym training so it understands your business terminology, and can forecast trends or flag anomalies automatically. This guide walks through the full setup from data import to your first AI-generated dashboard.
How to Analyze CSV Files with DuckDB
DuckDB is a free, serverless SQL database that lets you query CSV files directly from your terminal with zero setup beyond installing a single binary. You write standard SQL against your files as if they were database tables, making it one of the fastest ways for analysts to filter, aggregate, and join local data without loading it into Excel, Python, or a cloud warehouse.
How to Use the Google Sheets AI Function
The Google Sheets AI function, powered by Gemini, lets you run AI prompts directly inside spreadsheet cells using the =AI() formula. It works on all Google Workspace plans and handles tasks like text classification, sentiment analysis, summarization, and data extraction without add-ons or API keys. This guide walks through the syntax, practical formulas for common data tasks, and when to use external tools instead.