Analyst Skills Guide
The tools and languages that actually get you hired as a data, business, or product analyst — with clear definitions and the roles that demand each one.
SQL
The #1 requested analyst skill — querying and joining data.
Python
Automation, analysis, and data pipelines with pandas.
Tableau
Industry-standard dashboards and data visualization.
Power BI
Microsoft's BI suite — DAX, reports, and modeling.
Excel
Still essential: pivot tables, Power Query, and modeling.
R
Statistical analysis, hypothesis testing, and ggplot2.
Looker
Modern BI and semantic modeling with LookML.
dbt
Transform data in the warehouse with tested, versioned SQL.
