12 Data Analyst Portfolio Projects That Can Get You Hired in 2026

A recruiter opens your resume and sees Excel, SQL, Python, Power BI, and Tableau listed under skills. That is useful, but it does not prove that you can solve a real business problem.

Now imagine the recruiter opens your portfolio and finds a project showing why customers are leaving a subscription business, which customers are most likely to leave next, and how the company could improve retention.

That is the difference between knowing a tool and demonstrating job-ready analytical ability.

A strong data analyst portfolio is not a collection of colourful dashboards. It is evidence that you can take an unclear business problem, work with imperfect data, find meaningful patterns, and communicate a practical recommendation.

This guide covers the best data analyst portfolio projects for 2026, the tools you should use, how to present each project, expected salaries, career opportunities, and common mistakes that weaken otherwise good portfolios.

Why Data Analyst Portfolio Projects Matter in 2026

Entry-level data analytics has become more competitive. Many applicants now complete the same online courses, use the same public datasets, and mention the same technical skills.

Employers therefore need a better way to separate candidates who have only followed tutorials from those who can work independently. Your portfolio provides that evidence.

A well-developed project can demonstrate:

• Business problem-solving
• Data cleaning and validation
• SQL querying
• Exploratory data analysis
• Dashboard development
• Statistical thinking
• Data storytelling
• Commercial awareness
• Written communication
• Attention to detail

Current hiring trends also show that employers value a combination of core analytical skills and broader capabilities such as AI literacy, data modelling, governance, and communication. One analysis of more than 1,300 data analyst job postings found SQL in around half of the listings, Python in 33%, Excel in 41%, and stakeholder communication in nearly 60%.

The message is clear: your portfolio should show more than technical execution. It should show how your work supports decisions.

What Makes a Data Analytics Project Job-Ready?

The weakest point in most student portfolios is not the dataset or dashboard. It is the absence of a clear business objective.

A project becomes job-ready when it answers five questions:

1. What business problem are you solving?

Avoid vague objectives such as analysing sales data or creating an HR dashboard.

Use a specific problem statement:

The company’s revenue increased, but profit margins declined. The objective is to identify the products, regions, and discounting practices responsible for the decline.

This gives your analysis direction.

2. Who will use the analysis?

Identify the decision-maker. It could be a sales manager, HR director, marketing head, operations manager, product manager, or finance team.

Your choice of metrics and recommendations should reflect that audience.

3. How did you prepare the data?

Real analysts spend significant time checking data quality. Explain how you handled:

• Missing values
• Incorrect data types
• Duplicate records
• Outliers
• Inconsistent categories
• Invalid dates
• Unmatched records
• Currency and unit differences

A clean dashboard built from unreliable data is still unreliable.

4. What did you discover?

Do not simply describe what appears on the chart.

Instead of writing, Sales were highest in the West region, explain why the finding matters:

The West generated the highest sales but produced a lower profit margin because heavy discounts were concentrated in low-margin furniture products.

5. What action should the company take?

Every major insight should connect to a decision.

Your recommendations might involve changing pricing, targeting a customer segment, adjusting inventory, redesigning a campaign, improving employee scheduling, or investigating an operational issue.

12 Data Analyst Portfolio Projects That Can Get You Hired

You do not need all 12 projects. A focused portfolio containing three or four complete, original projects is usually stronger than ten unfinished dashboards.

Choose projects that demonstrate different analytical abilities and match the roles you plan to target.

1. Sales Performance and Revenue Leakage Analysis

A sales analysis project is common, but it can still be impressive when it goes beyond monthly revenue charts.

Business problem

Management wants to understand why sales growth is not producing a similar increase in profit.

Questions to investigate

• Which products generate revenue but destroy profit?
• How do discounts affect margins?
• Which regions consistently miss targets?
• Are high-performing sales representatives dependent on one customer?
• Which product combinations are commonly purchased together?
• Where is revenue being lost through returns or cancellations?

Recommended tools

Use SQL for data extraction, Excel or Python for validation, and Power BI or Tableau for the final dashboard.

Important metrics

Include:

• Total revenue
• Gross profit
• Profit margin
• Average order value
• Discount percentage
• Return rate
• Revenue growth
• Target achievement
• Customer contribution
• Product profitability

What makes the project stand out

Add a revenue leakage page identifying losses caused by returns, discounting, cancelled orders, and low-margin products.

Your final recommendation could explain which discounts should be limited, which products need repricing, and which regions require closer performance monitoring.

2. Customer Churn and Retention Analysis

Customer churn is one of the strongest portfolio projects because it connects analytics directly to revenue protection.

Business problem

A telecom, banking, software, or subscription company is losing customers and wants to identify the major causes.

Questions to investigate

• Which customer groups have the highest churn rate?
• Does contract type influence churn?
• Are new customers leaving faster than established customers?
• Does poor service usage predict churn?
• How much revenue is at risk?
• Which customers should receive retention offers?

Recommended tools

Use SQL for customer segmentation, Python for exploratory analysis, and Power BI or Tableau for presenting churn patterns.

You can also build a simple logistic regression or classification model, but predictive modelling should support the business analysis rather than replace it.

Important metrics

Track:

• Overall churn rate
• Churn by customer segment
• Customer tenure
• Monthly recurring revenue
• Revenue at risk
• Customer lifetime value
• Support complaints
• Contract type
• Payment behaviour

What makes the project stand out

Create a risk-based customer list using high, medium, and low churn probability.

Then recommend different retention actions. High-value customers might receive personal outreach, while price-sensitive customers could receive a revised plan or temporary discount.

3. HR Attrition and Workforce Analytics Dashboard

An HR analytics project demonstrates that you can work with employee data, interpret human behaviour, and communicate sensitive findings responsibly.

Business problem

An organisation is experiencing high employee attrition and wants to understand which workplace factors are associated with resignations.

Questions to investigate

• Which departments have the highest attrition?
• Does overtime increase resignation risk?
• How do salary, age, tenure, and job level affect attrition?
• Are employees leaving because of limited promotion opportunities?
• Does training influence retention?
• Is attrition concentrated under particular managers or job roles?

Recommended tools

Power BI is suitable for interactive workforce reporting. Use Excel, SQL, or Python for data cleaning and statistical analysis.

Important metrics

Include:

• Employee headcount
• Attrition rate
• Average tenure
• Overtime rate
• Promotion history
• Training participation
• Salary band
• Job satisfaction
• Work-life balance
• Attrition cost estimate

What makes the project stand out

Do not claim that one factor caused attrition simply because the numbers are correlated.

Explain the distinction between association and causation. Suggest further investigation through exit interviews, employee surveys, or controlled policy changes.

This demonstrates analytical maturity.

4. E-Commerce Customer Funnel Analysis

This project is ideal for students interested in product analytics, digital marketing, online retail, or consumer behaviour.

Business problem

An e-commerce business receives significant website traffic, but too few visitors complete a purchase.

Questions to investigate

• At which stage do users leave the funnel?
• Which devices have the lowest conversion rate?
• Do customers abandon their carts after seeing delivery charges?
• Which traffic sources generate paying customers?
• How long does conversion normally take?
• Do returning visitors convert better than new visitors?

Funnel stages

A typical funnel may include:

1. Product page viewed
2. Product added to cart
3. Checkout started
4. Payment attempted
5. Order completed

Recommended tools

Use SQL for event-level analysis, Python for behavioural exploration, and Power BI or Tableau for funnel visualisation.

What makes the project stand out

Segment the funnel by device, location, acquisition source, product category, and customer type.

A useful recommendation may show that mobile customers leave during payment, suggesting the business should test a shorter mobile checkout process.

5. Marketing Campaign ROI Analysis

Many beginner projects focus on impressions and clicks. Hiring managers are more interested in whether marketing activity generated profitable customers.

Business problem

A company runs campaigns across search, social media, email, and display advertising but does not know which channels deserve more budget.

Questions to investigate

• Which channels generate the most conversions?
• Which campaigns deliver the highest return?
• Are cheap leads becoming paying customers?
• Which customer segments respond best?
• Does campaign performance change by location or season?
• Which campaigns should be paused?

Important metrics

Calculate:

• Click-through rate
• Conversion rate
• Cost per lead
• Customer acquisition cost
• Revenue per campaign
• Return on advertising spend
• Customer lifetime value
• Email open rate
• Repeat purchase rate

Recommended tools

Excel can be used for a beginner-level version. SQL and Power BI can handle larger campaign datasets, while Python is useful for attribution, segmentation, and experimentation.

What makes the project stand out

Compare acquisition cost with customer lifetime value.

A campaign producing many inexpensive leads may still be a poor investment when those leads generate little revenue or leave quickly.

6. Financial Performance and Budget Variance Dashboard

This project is valuable for finance analyst, financial planning, management reporting, and business intelligence positions.

Business problem

Management wants to compare actual performance with budgets and identify the reasons behind major variances.

Questions to investigate

• Which departments are overspending?
• Which revenue categories are below budget?
• Are variances temporary or recurring?
• How has profitability changed?
• Is cash flow keeping pace with reported profit?
• Which costs are increasing faster than revenue?

Important metrics

Include:

• Actual revenue
• Budgeted revenue
• Revenue variance
• Operating expenses
• EBITDA
• Net profit
• Gross margin
• Budget utilisation
• Cash flow
• Year-over-year growth

Recommended tools

Use Excel for financial modelling, SQL for transaction-level data, and Power BI for monthly management reporting.

What makes the project stand out

Add written variance explanations rather than showing only red and green indicators.

For example:

Logistics expenses exceeded budget by 14% because fuel costs increased and order volume shifted towards distant delivery locations.

7. Inventory and Supply Chain Optimisation

Inventory projects help demonstrate forecasting, operational thinking, and the ability to balance competing business objectives.

Business problem

A retailer faces stockouts in popular products while slow-moving inventory occupies warehouse space.

Questions to investigate

• Which products frequently go out of stock?
• Which items have not sold recently?
• How reliable are suppliers?
• Which warehouses carry excess stock?
• How much working capital is tied up in inventory?
• Which products should be reordered first?

Important metrics

Use:

• Inventory turnover
• Days inventory outstanding
• Stockout frequency
• Reorder point
• Supplier lead time
• Order fulfilment rate
• Carrying cost
• Dead stock value
• Demand forecast
• On-time delivery rate

Recommended tools

SQL is useful for combining orders, products, warehouses, and supplier tables. Python can support forecasting, while Power BI can create inventory monitoring dashboards.

What makes the project stand out

Build an ABC classification:

• A products: High-value items requiring close monitoring
• B products: Moderate-value products
• C products: Lower-value products requiring simpler controls

You can then propose different reorder policies for each group.

8. Product Analytics and A/B Testing Project

An A/B testing project is especially useful for product analyst, growth analyst, and digital analytics roles.

Business problem

A digital product team wants to know whether a redesigned page, pricing message, or onboarding process improves user behaviour.

Questions to investigate

• Did the test group perform better than the control group?
• Is the difference statistically significant?
• Did the change affect all users equally?
• Did improvement in one metric damage another?
• Was the experiment large enough?
• Should the new version be launched?

Recommended tools

Use SQL to prepare experiment data and Python to calculate confidence intervals, significance tests, and segment-level performance.

What makes the project stand out

Avoid announcing that Version B is better simply because its conversion rate is slightly higher.

Explain sample size, statistical significance, practical significance, confidence level, and possible experiment limitations.

This is a strong way to demonstrate statistical reasoning.

9. Banking Loan and Credit Risk Analysis

This project can help candidates target banking, financial services, fintech, risk, and credit analytics roles.

Business problem

A lender wants to improve loan approval decisions while controlling default risk.

Questions to investigate

• Which borrower characteristics are associated with default?
• How does income affect repayment?
• Are certain loan purposes riskier?
• Does previous credit history predict default?
• Which approved loans require closer monitoring?
• How can risk be reduced without rejecting too many reliable applicants?

Important metrics

Include:

• Default rate
• Approval rate
• Debt-to-income ratio
• Loan-to-income ratio
• Average loan amount
• Delinquency rate
• Credit grade
• Expected loss
• Recovery rate
• Portfolio risk concentration

What makes the project stand out

Discuss fairness and responsible analysis.

Variables such as gender, ethnicity, religion, or location can create ethical and regulatory concerns. Explain how bias should be tested before using a model in a real lending process.

10. Healthcare Operations Analysis

Healthcare data projects demonstrate the ability to work with operational complexity and socially meaningful outcomes.

Business problem

A hospital wants to reduce patient waiting times, improve resource utilisation, and understand repeat admissions.

Questions to investigate

• Which departments have the longest waiting times?
• When is patient demand highest?
• Which conditions lead to repeat admissions?
• Are beds and staff being used efficiently?
• Which appointment types have high cancellation rates?
• Can scheduling be improved?

Important metrics

Track:

• Average waiting time
• Patient volume
• Bed occupancy
• Readmission rate
• Appointment cancellation rate
• Treatment duration
• Patient satisfaction
• Staff utilisation
• Emergency admission rate

What makes the project stand out

Protect patient privacy. Use anonymised or synthetic data and avoid including information that could identify an individual.

Include a data ethics section explaining privacy, access control, and the risks of making decisions from incomplete medical data.

11. Customer Segmentation Using RFM Analysis

RFM analysis is a practical way to demonstrate customer segmentation without building an unnecessarily complex machine learning model.

RFM stands for:

• Recency: How recently a customer purchased
• Frequency: How often the customer purchases
• Monetary value: How much the customer spends

Business problem

A retail business wants to personalise marketing instead of sending the same promotion to every customer.

Possible segments

You can classify customers as:

• Champions
• Loyal customers
• Potential loyalists
• New customers
• At-risk customers
• Lost customers
• High spenders
• Frequent low-value buyers

Recommended tools

Use SQL to calculate customer-level RFM scores, Python for optional clustering, and Power BI for segment visualisation.

What makes the project stand out

Create a practical marketing strategy for each segment.

For example, at-risk high-value customers may need personalised reactivation campaigns, while new customers may need onboarding communication rather than aggressive discounts.

12. End-to-End Automated Reporting Project

This is one of the strongest projects for candidates who want to show that they understand the complete analytics workflow.

Business problem

A reporting team manually combines several Excel or CSV files every week, leading to delays and mistakes.

Project workflow

Your project could:

1. Import raw files automatically
2. Validate column names and data types
3. Remove duplicates
4. Transform the data
5. Load it into a database
6. Run SQL calculations
7. Refresh a dashboard
8. Generate a quality-control report

Recommended tools

Use Python, SQL, Power Query, Power BI, GitHub, and a simple cloud or local database.

What makes the project stand out

Measure the operational benefit.

For example:

The automated workflow reduced the reporting process from 90 minutes to 12 minutes and introduced validation checks for missing dates, duplicate orders, and negative revenue.

Even when the figures are based on a simulated business case, explain the assumptions clearly.

Which Projects Should a Beginner Choose?

A balanced beginner portfolio could contain:

These projects cover business reporting, SQL, Python, dashboarding, communication, and automation without forcing you to build advanced machine learning systems.

Generic Project vs Job-Ready Project

Essential Skills Your Portfolio Should Demonstrate

Technical skills

Excel

Show that you can use:

• XLOOKUP or INDEX-MATCH
• SUMIFS and COUNTIFS
• PivotTables
• Conditional formatting
• Power Query
• Data validation
• Date and text functions
• Dynamic arrays
• Charts and dashboards

SQL

Your projects should include:

• SELECT statements
• Filtering and sorting
• JOIN operations
• GROUP BY
• CASE statements
• Common table expressions
• Subqueries
• Window functions
• Date calculations
• Data quality checks

Power BI or Tableau

Demonstrate:

• Data modelling
• Relationships
• Calculated measures
• Time intelligence
• Drill-through analysis
• Tooltips
• Filters and slicers
• Dashboard navigation
• KPI design
• Data storytelling

Python

For analyst roles, prioritise:

• Pandas
• NumPy
• Matplotlib
• Data cleaning
• Exploratory data analysis
• Statistical testing
• Automation
• Basic predictive modelling

Do not add machine learning merely to make the project look advanced.

Business and communication skills

Technical work alone will not make your portfolio convincing.

Show that you can:

• Define business requirements
• Select relevant KPIs
• Identify assumptions
• Explain trade-offs
• Write an executive summary
• Prioritise recommendations
• Present findings to non-technical audiences
• Distinguish evidence from opinion
• Communicate analytical limitations

How to Structure Every Portfolio Project

Use the following structure for each case study.

Project title

Use a result-oriented title.

Weak title:

Sales Dashboard

Stronger title:

Retail Profitability Analysis: Identifying ₹18 Lakh in Potential Revenue Leakage

Business background

Explain the company, industry, and business situation in a short paragraph.

Objective

State what management needs to understand or decide.

Dataset

Mention:

• Data source
• Number of rows
• Number of columns
• Time period
• Important tables
• Data limitations

Data preparation

Explain the cleaning and transformation process.

Analysis

Show the questions investigated, calculations performed, and analytical methods used.

Key insights

Highlight three to five findings that affect the business.

Recommendations

Provide specific, prioritised actions.

Limitations

Explain what the data cannot prove and what additional information would improve the analysis.

Tools

List the software and technical methods used.

Files

Provide access to:

• Dashboard
• SQL scripts
• Python notebook
• Cleaned dataset
• Data dictionary
• Presentation
• README file

Data Analyst Salary in India

Data analyst salaries vary considerably by experience, city, company, technical depth, industry, and the level of responsibility involved.

Indeed reported an average base salary of approximately ₹6.59 lakh per year in India, based on 965 salary reports and updated on July 4, 2026.

A practical market range is:

Candidates with strong SQL, data modelling, domain expertise, stakeholder management, automation, cloud exposure, and portfolio evidence can often compete for higher-paying opportunities.