INTELLIGENCE
Archive
How to Query CSV Files with SQL Using DuckDB
DuckDB is a free, in-process SQL database built for analytical workloads. It reads CSV, Parquet, and JSON files directly with no import step, no Python environment, and no server configuration. Install the CLI with a single command, open a terminal, and run SQL queries on any CSV file immediately. DuckDB version 1.5.1 is the current release. This guide covers installation on Mac, Linux, and Windows, plus the most common analysis queries business analysts and operators actually need.
How to Set Up PandasAI for Data Analysis
PandasAI is a Python library that lets you query, visualize, and clean data using plain English instead of code. Version 2 supports more than 100 LLM providers through LiteLLM, including OpenAI, Anthropic, and Google Gemini, and works with CSV files, Excel sheets, SQL databases, and cloud data warehouses. This guide walks through installation, LLM configuration, and running your first real queries on a dataset in under 15 minutes.
How to Set Up Looker Studio for Business Reporting
Looker Studio is a free dashboarding tool from Google that connects to more than 1,050 data sources including Google Sheets, BigQuery, and Salesforce. To set it up for business reporting, sign in with a Google account, connect a data source, build a report with charts and filters, and share via link. No SQL or coding knowledge is required, and most teams are running their first dashboard within two hours.
How to Set Up a Microsoft Fabric Data Agent
Microsoft Fabric Data Agents let business users ask plain English questions against enterprise data -- including Power BI semantic models, lakehouses, and warehouses -- and receive answers without writing SQL or DAX. The feature requires F2 or higher Fabric capacity, six tenant settings enabled by an admin, and at least one structured data source already in OneLake. Setup takes under an hour end to end. As of early 2026, the core feature is available in Fabric workspaces, with Copilot Studio integration in preview.
How to Use Python in Excel
Python in Excel is a Microsoft 365 feature that runs Python code directly in spreadsheet cells using a cloud-based Anaconda environment. No local Python installation is required. It gives Excel users access to pandas, matplotlib, NumPy, and scikit-learn through the =PY() formula. The feature is available on Excel for Windows, Mac, and the web for active Microsoft 365 subscribers. All execution happens in Microsoft's cloud, so results are returned to the worksheet without any setup beyond opening Excel.
How to Use Gemini AI in Google Sheets
Google's native =AI() function in Sheets, powered by Gemini, lets you run text analysis, classification, and summarization directly in spreadsheet cells using plain English prompts. It ships with paid Google Workspace plans at Business Standard tier and above, plus Google One AI Premium. The function handles up to 200 cells per batch, outputs plain text, and requires one-time admin enablement on workspace accounts. It does not auto-update and cannot nest inside other formulas without a workaround.
How to Analyze Business Data with Claude AI
Claude can analyze business data from a CSV or Excel file without any coding. Upload a file to Claude.ai, describe what you want to know, and Claude reads the actual rows and calculates results using its built-in analysis tool. This guide covers the exact workflow, prompt templates that produce reliable output, and the single instruction that prevents Claude from returning estimated numbers instead of real ones.
How to Set Up Metabase for Business Analytics
Metabase is a free, open-source business intelligence tool that lets non-technical teams query databases and build dashboards without writing SQL. It installs in under 30 minutes via Docker, a JAR file, or Metabase Cloud. Once connected to a database, teams can build charts, share dashboards, and filter data with a point-and-click interface. Version 0.59 supports over 20 databases including PostgreSQL, MySQL, BigQuery, Snowflake, and Redshift.
How to Use Julius AI for Data Analysis
Julius AI is a no-code data analysis tool that lets you upload a CSV, Excel, or Google Sheets file and ask questions in plain English to get charts, statistics, and written insights instantly. It supports exploratory data analysis, correlation tests, regression, and ANOVA without writing a single line of code. Most analyses complete in under 30 seconds, making it practical for operations managers, analysts, and founders who need answers from data without waiting on a data team.