Weekday and weekend classes available

Book a free 20-minute session with a mentor

No payment on this website: confirm your schedule and payment options with our team

Career Development

What to put in a data analyst portfolio, and what to leave out

Vivek Kumar, Co-Founder & Chief Learning Officer3 min read
Build a portfolio people can read

A portfolio is how you show a hiring manager what you can do before they meet you. It does not need many projects. It needs a few that are clear, honest and easy to follow.

Choose three to five projects

Three to five well-explained projects are better than ten notebooks nobody can follow. Between them, cover the tools that appear in the job adverts you are targeting, usually SQL, one BI tool (Power BI or Tableau), and Excel or Python.

Start each project from a business question, not from a tool. "Which regions are behind target, and why?" is a project. "My Power BI dashboard" is not.

What each project should show

  • A summary at the top: the question, what you found, and what you would recommend, in three or four lines.
  • The data: where it came from, how many rows, and what the important columns mean.
  • The cleaning: duplicates, missing values and odd values, and the decision you made about each.
  • The analysis: the main SQL queries or notebook, commented so a reviewer can follow them.
  • The result: two or three charts or a dashboard screenshot, each with a one-line takeaway.
  • The recommendation and its limits: what to do, what you expect to change, and what the data cannot tell you.

If you used AI anywhere, say where and how you checked it. A short verification log shows judgement, which is exactly what employers worry about.

Organise GitHub so it can be read in two minutes

  • A profile README: who you are, the roles you want, and links to your best three projects.
  • One repository per project with a clear name, such as sales-performance-analysis.
  • A README in every repository, written for someone who will spend two minutes on it.
  • Simple folders: data/, sql/, notebooks/, dashboard/, report/.
  • A screenshot or PDF of every dashboard, because reviewers may not have Power BI or Tableau installed.
  • No passwords, keys or personal data anywhere in the repository.

What to leave out

  • Tutorial projects copied step by step, unless you changed the question and say what you changed.
  • Charts without a takeaway.
  • Claims you cannot explain in an interview.

Present it

Pin your best repositories, add one or two projects to your CV with a one-line result each, and feature your best project on LinkedIn. Then practise a two-minute spoken walk-through of each project: the problem, your approach, the result and what you learned.

A strong portfolio helps you show what you can do. It does not guarantee interviews or a job, but it makes every application easier to judge in your favour.

More from Insights

Artificial Intelligence

How to check SQL an AI assistant writes for you

AI-written SQL often runs and is still wrong. A worked example of a double-counting join, and a five-step routine to check any AI-written query.

Vivek Kumar3 min read

Newsletter

Stay Ahead in Data and AI

Get new learning resources, practical guides, project ideas, and AI insights delivered to your inbox.

  • New free PDFs and Insights articles
  • We confirm by email before adding you
  • Unsubscribe in one click, any time
  • Learn data
  • Use AI
  • Build real projects
  • Build your portfolio
  • Develop professional skills
  • Get guided support
  • Apply it at work

Find your program.

A few short questions and a personalized report. Or talk to a mentor for free.

Talk to a mentorFind my program

Your cookie choices

Choose which optional cookies we may use. Essential storage is always on because the site needs it.

EssentialAlways on

Your theme and currency, this choice, and spam protection on forms.

Analytics

Google Analytics, to count visits and see which pages and links help people. Also lets us note which link brought you here and send it with a request you make.

Advertising

Meta (Facebook, Instagram) and Google Ads, to measure whether our ads lead to enquiries.

Cookie policy ยท Privacy policy ยท