For freshers and career-switchers, a portfolio is often the only proof that you can do the job. But most beginner portfolios look the same: the same Kaggle datasets, the same charts and no clear business question. This guide gives eight project ideas that stand out to Indian recruiters, and a simple template for presenting each one.

Data sources and tool details in this article were checked in October 2026.

What makes a portfolio project useful to a recruiter

A hiring manager skimming your project has a few minutes at most. They are looking for answers to four questions:

  1. Can you start from a business question rather than a dataset?
  2. Can you clean messy data and explain what you changed?
  3. Can you use the tools in the job description (usually SQL, Excel and Power BI or Tableau)?
  4. Can you turn findings into a clear recommendation?

A project that answers all four, even with simple charts, beats a flashy dashboard with no story.

Eight project ideas

#ProjectMain toolsData source ideas
1E-commerce sales and returns analysisSQL, Power BI or TableauPublic e-commerce sample datasets on Kaggle
2State-wise public data dashboard (for example agriculture, health or education indicators)Excel or Power Query, Power BI or TableauIndia’s Open Government Data Platform (data.gov.in)
3Banking and credit trendsExcel, PythonRBI’s Database on Indian Economy (DBIE)
4Customer churn analysis for a subscription businessSQL, Python (pandas)Telecom or subscription churn datasets on Kaggle
5Marketing funnel and campaign performanceSQL, ExcelPublic marketing or web analytics sample data
6Cohort retention for an appSQL with window functionsAny dataset with user IDs and dated events
7HR attrition dashboardPower BI or Tableau, DAX or calculated fieldsPublic HR attrition sample datasets
8Your own industryWhatever your target role usesAnonymised or public data from your current field

How to make each project stand out

1. Start with a question, not a dataset

Instead of “Analysis of e-commerce data”, write “Which product categories drive most returns, and what would reducing them by 10% be worth?” A specific question shows business thinking.

2. Use Indian context where you can

Projects rooted in Indian business are easier for Indian interviewers to relate to and discuss. Use rupee values, Indian states and cities, festival seasons and Indian business models such as cash on delivery, UPI payments or quick commerce.

3. Show your cleaning steps

List what you fixed: missing values, duplicates, inconsistent city names, wrong data types. This is real analyst work, and interviewers often ask about it.

4. Include at least one SQL-heavy project

Projects 1, 4 and 6 are ideal for showing joins, CTEs and window functions. Save your SQL in a GitHub repository with comments.

5. Include one dashboard

Projects 2 and 7 suit Power BI or Tableau. Tableau Public lets you publish dashboards online for free. For Power BI, share screenshots and a short video walkthrough, or publish to the web only if the data is public and not sensitive.

6. End with a recommendation

Close each project with two or three specific recommendations and the expected impact. This is the part that separates analysts from chart-makers.

7. Add a validation step

Show how you checked your numbers, for example by reconciling totals with the published source. As AI tools generate more analysis, employers increasingly value analysts who verify results.

A simple write-up template

Use the same structure for every project, on GitHub or a short blog post:

  • Business question in one sentence.
  • Data: source, size, time period and any limitations.
  • Approach: cleaning steps, tools and key queries or formulas.
  • Findings: three to five bullet points with numbers.
  • Recommendation: what you would do and why.
  • Links: dashboard, code and data source.

Where to host your portfolio

  • GitHub for SQL scripts, Python notebooks and a README for each project.
  • Tableau Public for Tableau dashboards.
  • LinkedIn featured section, with a short post for each project.
  • A one-page portfolio site if you are comfortable building one, but GitHub plus LinkedIn is enough for most roles.

How many projects do you need?

Three strong projects are better than ten weak ones. A good mix is:

  1. One SQL-focused project.
  2. One dashboard project in the BI tool your target employers use.
  3. One end-to-end project using Python or Excel, with a written recommendation.

If you are switching careers, make one of the three about your current industry. A former bank operations executive analysing loan processing times, or a former teacher analysing school performance data, tells a strong story.

Talking about your project in an interview

A portfolio only helps if you can discuss it confidently. Prepare a two-minute walkthrough for each project using this order: the question, the data, one interesting problem you hit while cleaning it, the main finding and your recommendation. Then expect follow-up questions such as:

  • “Why did you choose this chart type?”
  • “What would you do differently with more time or more data?”
  • “How do you know your numbers are right?”
  • “If a manager disagreed with your recommendation, how would you respond?”

Practising these answers aloud is as important as building the project itself.

Mistakes to avoid

  • Using only Titanic, Iris or Netflix datasets without a fresh angle.
  • Dashboards with ten charts and no clear message.
  • No README, so the recruiter cannot tell what you did.
  • Copying a tutorial project step by step and presenting it as your own.
  • Publishing confidential company data. Always anonymise or use public data.

Frequently asked questions

Do recruiters in India actually look at portfolios?

Not every recruiter will, but hiring managers and technical interviewers often do, especially for freshers and career-switchers. A portfolio also gives you concrete examples to discuss in interviews.

Can I use AI tools to build my portfolio projects?

Yes, as long as you understand and can explain every step. Interviewers will ask why you made each choice. Mention where you used AI and how you checked its output.

Should I put portfolio links on my resume?

Yes. Add a short “Projects” section with one line per project, the tools used, the key result and a link. Keep links short and make sure they open without login.

Official sources

One response to “8 Data Analyst Portfolio Projects That Get Interviews in India (2026 Guide)”

  1. […] Put them on GitHub or Google Drive, add screenshots, and link them in your LinkedIn Featured section. For more ideas, see our list of data analyst portfolio projects that get interviews. […]

Leave a Reply

Trending