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.


