Data Analyst Portfolio Projects for Freshers: 7 Ideas That Get You Shortlisted

Short answer: a fresher’s data analyst portfolio needs three to five projects that each answer a real business question using messy data, covering Excel, SQL, a BI tool (Power BI or Tableau) and ideally Python. Each project should end with recommendations, not just charts. Good starting projects are a sales dashboard, a churn analysis, an SQL funnel and cohort analysis, and a data story built on Indian public data.

Recruiters see hundreds of resumes listing the same tools. Projects are where you prove you can use them. The best portfolios show three things: you can clean data, you can find insights, and you can explain what the business should do next.

What makes a portfolio project stand out?

• A clear business question, written at the top: “Which regions lose money?” beats “Sales analysis”.
• Messy, realistic data, with your cleaning steps documented.
• The right tool for each step: SQL to query, Excel or Python to clean, Power BI or Tableau to present.
• Insights and recommendations in plain language, with the numbers behind them.
• Easy to review: a short summary, screenshots and links, so a recruiter can understand it in two minutes.

7 data analyst project ideas for freshers

1. Sales performance dashboard

Tools: Excel or Power BI
Business question: Which products, regions and months drive revenue and profit, and where are we losing money?
Data: A public retail or superstore sales dataset, such as those on Kaggle
What to show: KPIs, trends, drill-downs by region and category, and three written recommendations

2. Customer churn analysis

Tools: SQL + Power BI or Tableau
Business question: Which customers are likely to leave, and why?
Data: A telecom or subscription churn dataset
What to show: Churn rate by segment, tenure and plan; drivers of churn; a retention suggestion

3. E-commerce funnel and cohort analysis

Tools: SQL
Business question: Where do users drop off between visit and purchase, and do customers acquired in different months behave differently?
Data: An e-commerce events or orders dataset
What to show: Funnel conversion by step, monthly cohort retention table built with window functions

4. HR attrition and workforce dashboard

Tools: Power BI or Tableau
Business question: Which teams and roles have the highest attrition, and what factors relate to it?
Data: A public HR analytics dataset
What to show: Attrition by department, tenure and satisfaction; filters for managers

5. Public data story with Indian data

Tools: Excel or Python + Tableau
Business question: What does public data show about a topic you care about, such as rainfall, crop production, air quality or state-level indicators?
Data: The Open Government Data Platform India (data.gov.in)
What to show: Clean, well-labelled charts, a clear narrative and honest notes on data limitations

6. Data cleaning and EDA notebook

Tools: Python (Pandas)
Business question: Can you turn a messy dataset into a reliable one and find the first insights?
Data: Any raw dataset with missing values and inconsistent formats
What to show: A documented cleaning process, before-and-after checks and an exploratory summary

7. Marketing campaign performance

Tools: Excel + SQL or Power BI
Business question: Which channels and campaigns give the best return on spend?
Data: A digital marketing or ad campaign dataset
What to show: Cost per acquisition, ROI by channel and a budget reallocation recommendation

Which tools does each project prove?

Pick projects that together cover all four columns. Three well-documented projects beat seven half-finished ones.

How to present your portfolio

1. GitHub: one repository per project with a README covering the question, data source, tools, steps, key insights and screenshots. Include your SQL files and notebooks.
2. Dashboards: publish Tableau work to Tableau Public, and share Power BI work through screenshots, a short screen recording or a PDF export, because Power BI’s public “Publish to web” option needs a work account and is often disabled by administrators.
3. A one-page portfolio site or LinkedIn featured section linking to everything.
4. Your resume: list each project with the question, tools and one quantified finding.

Never upload confidential data from an employer or internship. Use public datasets or create your own sample data.

How to talk about projects in interviews

Use a simple structure: the question, the data and its problems, what you did, what you found, and what you would recommend. Be ready for follow-ups such as “How did you handle missing values?”, “Why this chart?” and “What would you do with more time?”. Practise the SQL behind your projects using our SQL interview questions for data analysts.

Where projects fit in your learning path

Start projects early, not at the end. Build the sales dashboard while learning Excel and Power BI, the funnel project while learning SQL, and the cleaning notebook while learning Python. Our data analyst roadmap shows the full order, and data cleaning techniques and building professional Power BI dashboards help with specific steps.

Build projects with TryCatch Classes

TryCatch Classes’ Data Analytics Training covers Advanced Excel, SQL, Power BI, Tableau, Alteryx, Python and AI tools, with projects throughout the course and resume and interview preparation. You can also start with a single tool: Power BI, Tableau or SQL. Learn at our Borivali West classroom or live online, with a 100% placement guarantee.

Frequently asked questions

How many projects should a fresher data analyst have?

Three to five strong projects are enough. Make sure together they show Excel, SQL, a BI tool and ideally Python, and that each ends with clear recommendations.

Are Kaggle datasets good enough for a portfolio?

Yes, if you choose realistic datasets, do your own cleaning and analysis, and frame a business question. Avoid copying popular notebooks; recruiters recognise them.

Should I use Power BI or Tableau for portfolio dashboards?

Either works. Tableau Public makes sharing easy. Power BI is widely used in Indian companies. Many learners build one dashboard in each.

Do I need Python for a data analyst portfolio?

Not for every role, but one Python project, such as a cleaning and exploratory analysis notebook, strengthens your profile and opens more opportunities.

Cover image: photo by dlxmedia.hu on Unsplash.