Data Analyst Portfolio Projects That Get Interviews
What hiring managers look for in a data analyst portfolio, how to choose three strong projects, and how to present each one around a business problem.
Short answer: Lead with the answer, not the method. Say what happened, why it matters and what you recommend, in that order, in the words your audience uses. Put the detail in an appendix. A good analysis that nobody acts on has not done its job.
You spent two days on the analysis. You present it in five minutes. The first slide is the data source, the second is the methodology, and by the third slide the sales director is checking their phone. Sound familiar? I have been the person presenting that deck.
Data storytelling sounds fluffy, but it is the practical skill of getting a decision out of your findings. Databricks’ overview of data storytelling describes it as the structured combination of data, visuals and narrative. Here is how I make it work in practice.
Frameworks come in many names. A Statsig piece on communicating with non-technical teams and others describe similar shapes: a beginning that sets the context, a middle with the insight and a close that calls for action. A simple three-step version is sometimes called “so what?”: what happened, why it matters, and what should happen next.
I use this skeleton:
Then the appendix holds the method, the queries and the extra charts. The validation checklist belongs in your prep, not in your slides.
The same finding needs different stories for different people.
| Audience | What they want | How to tell it |
|---|---|---|
| Executive | The decision and the money at stake | One slide, one number, one ask |
| Manager | What to do differently | Three findings and the actions that follow |
| Peer analyst | How you got there | Method, assumptions, a look at the query |
| Customer-facing team | What to say to customers | Plain language and examples |
Adjust depth, vocabulary and focus for each. The same message lands better when the audience can act on it with confidence.
Say the range in plain language: “We think the effect is between 3% and 9%, and our best guess is 6%.” Then say what would change your mind. Being straightforward about limits builds trust. People remember the analyst who said “I’m not sure yet, and here is how we will find out”.
My opinion: the analyst who can explain a modest finding clearly beats the one with a brilliant finding nobody understood. If your audience is a peer who wants to see the SQL, skip the story and show the query.
A dashboard is a story that people have to read without you in the room, which is a harder job. I cover that in building a KPI dashboard people actually open.
Sources: Databricks: What is Data Storytelling?, Statsig: From data to decisions, how to communicate findings to non-technical teams. The audience table, slide habits and example headlines are my own and illustrative.
Part of: Analyst Craft & Authority
Free tools for this topic: RICE / ICE Prioritizer