AI for data analysts
Use machine learning and AI assistants on your own data, and know when the answer does not match the numbers.
Begin with machine learning basics, move to working with data in Python and Fabric, and finish with building and checking models.
Foundations
What you need to know before you build.
- Infrato courseAI for Data Analysts56 min
Start here: using an assistant for SQL and analysis, and checking every number before you share it.
- Infrato courseUse AI Safely at Work: Privacy and Data55 min
Sort the data you handle into never, ask first and fine before you paste any of it.
- Google · CourseMachine Learning Crash CoursePrice not listed
Google’s course on machine learning basics.
- Microsoft · CourseMachine Learning for BeginnersbeginnerFree
A lesson-by-lesson machine learning course using Python.
Build
Make the thing.
- Microsoft Azure · CourseIntroduction to machine learning with Python and Azure NotebooksbeginnerFree131 min
Machine learning with Python in notebooks.
- Infrato courseCheck the Output: Evaluate What AI Gives You55 min
Build a small repeatable test for an AI result you rely on, awkward cases included.
- Microsoft Azure · CoursePrepare AI-ready analytics data in Microsoft FabricintermediateFree233 min
Preparing analytics data in Microsoft Fabric.
Extend
Check it, harden it, go further.
- Microsoft Azure · CourseCreate machine learning modelsintermediateFree379 min
Building machine learning models.
- Microsoft Azure · CourseImplement a data science and machine learning solution for AI in Microsoft FabricbeginnerFree329 min
A data science and machine learning solution in Microsoft Fabric.
- Stanford University · CourseCS229: Machine LearningPrice not listed
Stanford’s machine learning course, for the underlying methods.
Tools to try
Products from each vendor’s own site, listed by name and link only. We have not tested them, they are not endorsements, and we are not affiliated with the vendors. Prices and features change, so check the vendor’s page.
Google
Google ColabNotebooks in the browser.
Microsoft
Copilot in FabricMicrosoft’s overview of Copilot in Fabric.
Google
Gemini in BigQueryGoogle’s overview of Gemini in BigQuery.
Microsoft
Copilot for Power BIMicrosoft’s overview of Copilot for Power BI.
There are more by what you use them for: AI tools worth learning.
Agents and MCP servers for this role
An MCP server runs code with your accounts and can act in them. Read what each one can reach, and which credentials it asks for, before you connect it. These are picked from our directories by hand, not ranked, and are not endorsements.
MCP servers
- postgres-mcp
Read and write access to Postgres, with performance analysis.
Reaches: postgres. No credentials listed.
- mcp-server-mysql
Read-only access to MySQL.
Reaches: mysql. No credentials listed.
- mcp-google-sheets
Google Drive and Google Sheets from an assistant.
Reaches: google, googledrive, googlesheets. Asks for: GOOGLE_APPLICATION_CREDENTIALS.
- excel-mcp-server
Excel file manipulation.
Reaches: excel. Asks for: EXCEL_MCP_AUTH_TOKEN.
- dbt-mcp
A server for working with dbt.
Reach not listed. No credentials listed.
- tableau-mcp
Tableau’s own MCP server.
Reach not listed. No credentials listed.
- mcp-clickhouse
Connects ClickHouse to an assistant.
Reaches: clickhouse, fastmcp. Asks for: CLICKHOUSE_CLIENT_CERT_KEY, CLICKHOUSE_MCP_AUTH_TOKEN, CLICKHOUSE_PASSWORD, CLIENT_CONFIG_OVERRIDES_KEY, FASTMCP_SERVER_AUTH_AZURE_CLIENT_SECRET.
Agent skills
- google-analytics-data-api-basics
Set up Google Analytics reporting access.
- research
Investigates a question using high-trust primary sources.
Your project
Answer a question from a messy dataset
Take a dataset you are allowed to share. Ask an AI assistant for an analysis plan, run the analysis yourself, then list every place where the claims made by the assistant did not match the data.
The order and the notes are Infrato's own picks. The resources are made by their providers, open at their own sites, and can change; prices, levels and durations are the provider's. Infrato is not affiliated with the providers listed.