💼 Portfolio Projects

Recruiters shortlist projects, not certificates. Build all three, publish them on GitHub, and be ready to explain the business insight behind every chart.

💹

Project 1 — Sales Analytics Dashboard

Beginner friendly

Excel

SQL

Power BI

A retail company's revenue is flat while costs rise. Leadership wants one dashboard that explains where revenue and profit actually come from, and which regions or products are dragging margin down.

Dataset

Superstore-style sales data (~10k rows): order_id, order_date, ship_date, region, state, category, sub_category, product, customer_id, sales, quantity, discount, profit.

What you analyse

Revenue

Profit & margin

Products

Customers

Regions

Monthly sales trend

🛒

Project 2 — E-Commerce Analytics

Intermediate

SQL

Python

Power BI

An online store spends heavily on acquisition but revenue is not growing. Find out who the valuable customers are, how many come back, and which segments deserve retention spend.

Dataset

Online retail transactions (~500k rows): invoice_no, stock_code, description, quantity, invoice_date, unit_price, customer_id, country.

What you analyse

Orders

Customers

Products

Revenue

Repeat customers

Customer segmentation (RFM)

👥

Project 3 — HR Analytics

Interview favourite

Python

SQL

Power BI

An IT services company loses too many employees in their first two years. HR wants to know who leaves, from where, and which factors are associated with attrition.

Dataset

IBM-style HR attrition data (~1,470 rows): age, department, job_role, monthly_income, years_at_company, total_working_years, overtime, job_satisfaction, work_life_balance, attrition.

What you analyse

Employee attrition

Salary

Departments

Job roles

Experience

Employee satisfaction