Skip to content
Automation Squad

Role

AI for BI Analysts

Robert MacKelfresh

By Robert MacKelfresh

Founder, Automation Squad

Produce financial and market intelligence by querying data repositories and generating periodic reports. Devise methods for identifying data patterns and trends in available information sources.

Business Intelligence Analysts · O*NET 15-2051.01 · Job Zone 4 · sourced from the U.S. Department of Labor occupation database

Automation coverage

20 of 40tools on this list have an AI solution available today

Counted by matching the tools this occupation is documented as using against a corpus of 226,452 AI products, MCP servers, skills and connectors. Where a tool has no match, we say so rather than inventing one.

AI you can use for this job

164 matched to the tools business intelligence analysts use. Showing 24.

  • GitHub

    MCP server

    GitHub is the perfect place to share code and work collaboratively on private and open source software.

    GitHub

  • Google Ads

    MCP server

    Google Ads (formerly Google AdWords) is an online advertising platform developed by Google, where advertisers pay to display brief advertisements, service offerings, product listings, video content, and generate mobile application installs within the Google ad network to web user

    Google Ads

  • PostgreSQL

    MCP server

    PostgreSQL is a powerful, open-source database engine with a uniquely advanced query optimizer and dozens of built in features, making it an easy choice for production databases.

    PostgreSQL

  • Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Airtable MCP or direct API to find, update, create, and organize records and tables through natural language.

    Make (make.com)

  • Airtable

    MCP server

    Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

    Airtable

  • Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with GitHub MCP or direct API to manage repositories, review pull requests, track issues, and automate code workflows through natural language.

    Make (make.com)

  • Snowflake

    MCP server

    Snowflake allows corporate users to store and analyze data using cloud-based hardware and software.

    Snowflake

  • Equip your AI agents with Snowflake MCP or direct API to run SQL queries, schedule analytics jobs, monitor data quality, create secure shares, and manage warehouse resources through natural language.

    Make (make.com)

  • Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Google Docs MCP or direct API to create, edit, search, summarize, and share documents through natural language.

    Make (make.com)

  • Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Google Slides MCP or direct API to create new presentations, update slides, extract content, and collaborate on decks through natural language.

    Make (make.com)

  • Microsoft Outlook is a web-based suite of webmail, contacts, tasks, and calendaring services.

    Microsoft Outlook

  • Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Microsoft Power Bi MCP or direct API to list workspaces, inspect reports, refresh datasets, and summarize dashboard insights through natural language.

    Make (make.com)

  • MySQL

    MCP server

    MySQL is a premier database used in millions of production environments around the world. Easily plug your MySQL database into any web service.

    MySQL

  • Salesforce

    MCP server

    Salesforce is a leading enterprise customer relationship manager (CRM) application.

    Salesforce

  • Tableau is a business intelligence and analytics platform that enables users to connect to databases, create data visualizations, and share insights. The platform offers deployment options including cloud-based, self-hosted, and desktop environments with drag-and-drop functionali

    Make (make.com)

  • Tableau

    MCP server
  • Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Youtube MCP or direct API to upload videos, fetch channel analytics, manage playlists, and moderate comments through natural language.

    Make (make.com)

  • Make (make.com)

  • Make (make.com)

  • Make (make.com)

  • Make (make.com)

  • Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Elasticsearch MCP or direct API to search documents, manage indices, run analytics, and update records through natural language.

    Make (make.com)

  • Securely connect your AI agents and chatbots (Claude, ChatGPT, Cursor, etc) with Facebook MCP or direct API to post updates, fetch messages, manage comments, and gather page analytics through natural language.

    Make (make.com)

The tools this job actually uses

203 documented for this occupation. Showing 40, hot technologies first. A filled dot means an AI solution exists for it.

  • Adobe Acrobathot
  • AJAXhot
  • Alteryx softwarehot
  • Amazon DynamoDBhot
  • Amazon Elastic Compute Cloud EC2hot
  • Amazon Redshifthot
  • Amazon Web Services AWS softwarehot
  • Apache Cassandrahot
  • Apache Hadoophot
  • Apache Hivehot
  • Apache Kafkahot
  • Apache Sparkhot
  • Apache Tomcathot
  • Atlassian Confluencehot
  • Atlassian JIRAhot
  • Bashhot
  • Chot
  • Chot
  • Chot
  • Djangohot
  • Eclipse IDEhot
  • Elasticsearchhot
  • Epic Systemshot
  • ESRI ArcGIS softwarehot
  • Extensible markup language XMLhot
  • Facebookhot
  • Githot
  • GitHubhot
  • Gohot
  • Google Analyticshot
  • Google Docshot
  • Google Looker Analyticshot
  • Hibernate ORMhot
  • Hypertext markup language HTMLhot
  • IBM DB2hot
  • IBM SPSS Statisticshot
  • Informatica softwarehot
  • JavaScripthot
  • JavaScript Object Notation JSONhot
  • jQueryhot

What this job involves

17 documented tasks, most important first. Showing 17.

  1. Generate standard or custom reports summarizing business, financial, or economic data for review by executives, managers, clients, and other stakeholders.
  2. Maintain or update business intelligence tools, databases, dashboards, systems, or methods.
  3. Manage timely flow of business intelligence information to users.
  4. Provide technical support for existing reports, dashboards, or other tools.
  5. Identify and analyze industry or geographic trends with business strategy implications.
  6. Document specifications for business intelligence or information technology reports, dashboards, or other outputs.
  7. Create business intelligence tools or systems, including design of related databases, spreadsheets, or outputs.
  8. Collect business intelligence data from available industry reports, public information, field reports, or purchased sources.
  9. Disseminate information regarding tools, reports, or metadata enhancements.
  10. Conduct or coordinate tests to ensure that intelligence is consistent with defined needs.
  11. Synthesize current business intelligence or trend data to support recommendations for action.
  12. Analyze competitive market strategies through analysis of related product, market, or share trends.
  13. Identify or monitor current and potential customers, using business intelligence tools.
  14. Communicate with customers, competitors, suppliers, professional organizations, or others to stay abreast of industry or business trends.
  15. Maintain library of model documents, templates, or other reusable knowledge assets.
  16. Create or review technical design documentation to ensure the accurate development of reporting solutions.
  17. Analyze technology trends to identify markets for future product development or to improve sales of existing products.