Origin World Labs
Reference Guide

Analytics Tools Guide

21 tools used in modern business analytics. For each one: what it does, how to access it, what it costs, and how to control it using AI agents without writing code from scratch.

Build Your Custom AI Data Analyst Course

Why this guide exists

The analytics tool landscape is fragmented. Business professionals encounter Excel in one meeting, SQL in another, and suddenly a data engineer is recommending dbt or Snowflake. This guide cuts through the noise with one clear page per tool: what it actually does, who uses it, what it costs, and what you can realistically accomplish with it.

Every page also answers the question that matters most for 2026: how do you control this tool using AI? The Build Your Custom AI Data Analyst course teaches you to answer that question for all 21 tools below.

Spreadsheet
Microsoft Excel
The world's most widely used spreadsheet. The starting point for almost every analytics career.
Google Sheets
Excel in the cloud. Real-time collaboration, built-in scripting, and free for anyone with a Google account.
Database
MySQL
The most popular open-source relational database. Where most analysts first learn to write SQL.
SQL Server
Microsoft's enterprise database platform. Runs inside thousands of large organizations.
Cloud Database
Google BigQuery
A cloud data warehouse that can query billions of rows in seconds without managing any servers.
Database GUI
phpMyAdmin
A browser-based interface for managing MySQL databases. No command line required.
Cloud Platform
Google Cloud
Google's full cloud infrastructure platform — storage, compute, databases, and AI tools in one place.
Data Transformation
Power Query
Excel's built-in data transformation engine. Cleans and reshapes data without writing formulas.
Programming Language
Python
The world's most popular programming language for data work. Flexible, readable, and AI-ready.
Python Library
pandas
The Python library that made data analysis practical. Manipulates tables of data with simple code.
Automation
Excel VBA
Excel's built-in programming language. Automates repetitive tasks and builds custom tools inside spreadsheets.
Google Apps Script
JavaScript for Google Workspace. Automates Sheets, Gmail, Docs, and Calendar with code.
Business Intelligence
Power BI
Microsoft's dashboard and reporting platform. Connects to almost any data source and builds interactive reports.
Looker Studio
Google's free dashboard tool. Connects to Google data sources and publishes shareable reports.
Development Environment
Jupyter Notebook
An interactive coding environment that mixes code, results, and explanations in one document.
Google Colab
Jupyter Notebooks hosted by Google. Free GPU access and no installation required.
Version Control
GitHub
Where code and data projects live. Tracks every change and makes work reproducible.
API Testing
Postman
The standard tool for testing and working with APIs. Makes external data sources accessible to analysts.
Web Scraping
Beautiful Soup
A Python library for extracting data from web pages. Turns HTML into usable structured data.
Graph Database
Neo4j
A database built around relationships, not tables. Reveals patterns that SQL queries miss entirely.
AI Assistant
Claude
Anthropic's AI. Writes code, explains data, builds analysts, and executes across the full analytics stack.

Learn to control all 21 tools using AI

The Build Your Custom AI Data Analyst course teaches business professionals to build AI agents that do the analytical work. No prior programming experience needed.

Register Now