Data Analyst Portfolio Projects in Excel
Four end-to-end projects for one company (e-commerce sales, HR attrition, marketing campaigns, customer support): clean, analyse, chart and state the insight, with every cell checked.
The first lesson is free — no account needed.
About this course
Four data analyst portfolio projects in Excel, worked end to end on one outdoor retailer's data, for aspiring analysts who want practice that looks like the job. In the e-commerce project you clean a raw order export, compute net revenue, average order value and the return rate, then chart the monthly trend and name the top product. In the HR project you turn messy Yes/No answers into a leaver flag, compare attrition by department and find the strongest driver among overtime, satisfaction and tenure. In the marketing project you repair a spend column exported as text and rank 16 campaigns and five channels by ROAS and CPA. In the customer support project you turn timestamps into resolution hours, check every ticket against its SLA, report the backlog and read a histogram of resolution times. Each project ends with one insight stated with its number. The first lab is free.
Lessons
- Project 1 · E-commerce Sales: Clean the Orders and Compute the KPIsFree
- Project 1 · E-commerce Sales: Monthly Trend, Top Product and the Insight Pro
- Project 2 · HR Attrition: Clean the Leaver Flags and Compare Departments Pro
- Project 2 · HR Attrition: Find the Drivers and Chart Them Pro
- Project 3 · Marketing Campaigns: Fix the Spend Column, ROAS and CPA Pro
- Project 3 · Marketing Campaigns: Channel Summary, Best Channel and the Chart Pro
- Project 4 · Customer Support: Resolution Time, SLA and Backlog Pro
- Project 4 · Customer Support: Resolution-Time Histogram and the Insight Pro