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