Skip to main content

Data Analyst Skills: SQL, Excel, BI and What Comes Next

By Bhavishya SinglaUpdated Nov 20267 min read

In short

Data analysts turn raw data into answers a business can act on. The must-have skills are SQL, Excel or Google Sheets, one BI tool (Power BI, Tableau or Looker Studio), basic statistics, data cleaning, and the ability to explain findings to non-technical people. Python helps and is often expected from mid level. Employers test with SQL rounds, Excel tasks, take-home case studies and "walk me through a dashboard you built". In the AI era, analysts use AI to draft queries and clean data faster, but their value is in asking the right question, checking the numbers and telling the story. Show skills with portfolio projects on real, messy data.

On this page
  1. Who this guide is for: data analysts at each level
  2. Must-have data analyst skills and how employers test them
  3. Tools data analysts are expected to know
  4. Soft skills that decide analyst offers
  5. AI skills for data analysts
  6. How to show analyst skills on LinkedIn and your resume
  7. A 30/60/90-day plan to build analyst skills
  8. Common data analyst job-search mistakes
  9. Questions people ask

Who this guide is for: data analysts at each level

This guide is for freshers from any degree (commerce, engineering, economics, science), people moving from operations, finance, marketing or MIS roles into analytics, and working analysts aiming for senior or analytics engineering roles.

LevelTypical titlesWhat you are trusted with
Fresher / 0 to 2 yearsData Analyst, Junior Analyst, MIS Analyst, Business Analyst (data)Pulling data, building and maintaining reports and dashboards, answering defined questions.
Mid / 3 to 6 yearsSenior Data Analyst, Product Analyst, Marketing AnalystOwning the metrics for a business area, designing analyses, running and reading experiments, advising managers.
Senior / 7+ yearsLead Analyst, Analytics Manager, Analytics EngineerMetric definitions across the company, data models, the analytics roadmap and a team.

"Business analyst" means different things: in some companies it is a data role, in others (especially IT services) it is about gathering requirements and writing specs. Read the job description, not the title.

Must-have data analyst skills and how employers test them

SkillWhat good looks likeHow employers test it
SQLJoins, GROUP BY, subqueries, CTEs and window functions (ROW_NUMBER, LAG, running totals); you check row counts and avoid double counting.Live SQL rounds or online tests on a sample schema; very common.
Excel / Google SheetsPivot tables, XLOOKUP/VLOOKUP, INDEX-MATCH, IF and SUMIFS, data validation, clean charts; Power Query for repeated cleaning.Timed Excel tasks, especially in finance, operations and MIS roles.
BI and dashboardsA dashboard that answers specific questions, with the right chart for each, filters that make sense and definitions written down."Walk me through a dashboard you built and who used it."
Statistics basicsAverages versus medians, distributions, sampling, correlation versus causation, confidence intervals and how A/B tests work.Conceptual questions and case discussions.
Data cleaningHandling missing values, duplicates, inconsistent formats and outliers, and documenting what you changed.Take-home tasks with deliberately messy data.
Business sense and storytellingYou turn a vague ask into a clear question, find the answer and present it as "what happened, why, and what to do".Case studies: "Sales fell 8% last month; how would you investigate?"
Python (often from mid level)pandas for cleaning and analysis, matplotlib or seaborn for charts, notebooks that others can rerun.Take-homes or coding tests in data-heavy companies.

Try it on your profile

The free LinkedIn Profile Keyword Analyzer applies this in a minute.

Open the tool

Tools data analysts are expected to know

  • Databases and warehouses: PostgreSQL or MySQL to learn on; in companies, cloud warehouses such as BigQuery, Snowflake, Redshift or Databricks.
  • Spreadsheets: Excel (including Power Query and Power Pivot) and Google Sheets.
  • BI tools: Power BI (common in Indian enterprises and GCCs), Tableau, Looker or Looker Studio, Metabase.
  • Programming: Python with pandas and Jupyter notebooks; R in some research and healthcare settings.
  • Data modelling (mid and senior): dbt, star schemas, and the idea of a semantic layer.
  • Product and marketing analytics: Google Analytics 4, Mixpanel or Amplitude if you work near product or marketing.
  • AI tools: AI features inside Excel, Google Sheets and BI tools, and chat assistants for SQL and Python.

Microsoft offers the PL-300 Power BI Data Analyst certification, and Google has a well-known data analytics certificate on Coursera. They can help with early filters, but a portfolio project is still what most interviewers ask about.

Soft skills that decide analyst offers

  • Asking "what decision will this inform?" before starting any analysis.
  • Explaining numbers simply to managers who do not want the method, only the answer and how sure you are.
  • Saying "the data cannot answer that" when it cannot, and suggesting what would.
  • Attention to detail: one wrong filter can send a business the wrong way.
  • Managing requests: prioritising when five teams want reports by Friday.

AI skills for data analysts

What is changing

  • Drafting queries and formulas is fast. AI assistants write SQL, Excel formulas, DAX and pandas code from a description. Copilot in Excel and Power BI, and Gemini in Google Sheets, do some analysis inside the tool.
  • Self-serve analytics grows. Managers can ask some questions of the data in plain language, so routine report-pulling shrinks.
  • The risk moves to correctness. AI-written SQL often runs but answers a slightly different question (wrong join, wrong date filter, duplicates). Someone has to catch that.

AI skills worth building

  • Prompting for analysis: give the assistant the table schema and definitions, ask for the query, then check row counts and a few rows by hand.
  • Automating cleaning: use AI to write Python or Power Query steps for a messy export you get every week, then save it as a reusable process.
  • Summarising text data: grouping open-ended survey answers or reviews into themes, then reading samples to confirm.
  • Defining metrics clearly so AI tools and self-serve users get consistent answers.

What stays human

Choosing the right question, knowing the business context that explains a number (a holiday, a pricing change, a broken tracker), judging whether a result is believable, and persuading people to act on it. Never paste confidential company or customer data into tools your employer has not approved.

How to show analyst skills on LinkedIn and your resume

All examples below are made up for this guide.

Headline examples

  • Fresher: "Data Analyst | SQL, Excel, Power BI | Portfolio: retail sales and churn analysis"
  • Switching from operations: "Operations Analyst | SQL and Power BI | Turning warehouse data into faster delivery decisions"
  • Mid: "Product Analyst | SQL, Python, A/B Testing | Subscription and retention analytics"

Write your own with the free headline generator, and check which analyst keywords you are missing with the keyword analyzer.

About section (made-up example)

I'm a data analyst who helps sales and operations teams answer questions with data. I work mostly in SQL and Power BI, with Python for cleaning messy exports. My favourite projects end with a decision someone actually made: which stores to restock first, which customers to call before they cancel. I use AI assistants to draft queries faster and check every result against the source. Open to analyst roles in retail, e-commerce or fintech.

Experience bullets (made-up examples)

  • Built a Power BI dashboard for 40 store managers on daily stock-outs; managers used it in weekly reviews and stock-outs on top items fell over the next two months.
  • Replaced a manual weekly Excel report (about 4 hours) with a scheduled SQL query and Power Query flow (about 20 minutes to check).
  • Analysed churn by signup cohort and found most cancellations came in the first 14 days; the onboarding change that followed was tested and kept.

Portfolio

Two or three projects on real public data (government open data portals, Kaggle datasets, your own scraped or collected data) with a clear question, the SQL or notebook, a dashboard and a one-paragraph conclusion. Put them in LinkedIn Featured and on GitHub or a public BI link.

A 30/60/90-day plan to build analyst skills

Days 1 to 30: SQL and spreadsheets

  • Learn SQL from zero to window functions with a free interactive tutorial (SQLBolt is a well-known one), then practise daily on a sample database.
  • Do the Excel basics properly: pivot tables, lookups, SUMIFS, charts and Power Query. Microsoft Learn has free material.

Days 31 to 60: a BI tool and statistics

  • Pick Power BI or Tableau (both have free versions for learning) and rebuild one real report from your work or a public dataset.
  • Learn basic statistics: free courses on Khan Academy cover distributions, sampling and hypothesis tests.
  • Start Python with pandas through Kaggle Learn's free micro-courses.

Days 61 to 90: portfolio and applications

  • Finish two portfolio projects end to end, each with a business question and a recommendation.
  • Practise SQL interview questions out loud and prepare to walk through each project in five minutes.
  • Update your LinkedIn and resume, and tailor each application to the tools named in the job ad.

Common data analyst job-search mistakes

  • Only clean Kaggle datasets in your portfolio. Show you can handle messy data too.
  • Dashboards without a question. Twenty charts nobody asked for.
  • Listing tools you used once (Hadoop, Spark, R, SAS) without depth in SQL.
  • No business result in your bullets, only "created reports".
  • Trusting AI-written queries without checking totals.
  • Skipping communication practice. Many analyst interviews are decided on how clearly you explain.

To see which analyst skills recruiters search for are missing from your profile, check your LinkedIn profile free. LinkedInRank also shows open analyst roles that fit your profile, from employers' own career pages. Next steps: data scientist and ML engineer skills, or the general skills for the AI era.

Questions people ask

SQL, Excel or Google Sheets, one BI tool such as Power BI or Tableau, basic statistics, data cleaning and clear communication of findings. Python is increasingly expected from mid level.

Written by Bhavishya Singla

Founder of LinkedInRank. Writes about how recruiters search LinkedIn and what makes a profile show up.

Google Search

Add LinkedInRank as a preferred source on Google

See our new LinkedIn guides first in Google results.

Keep reading

All guides