Data Analyst project ideas for beginners to advanced
Build these 5 projects to turn the data analyst roadmap into proof of work you can show recruiters. Start at the top and move down as you gain confidence.
Beginner
1. Sales dashboard in Excel
Pivot tables, charts and slicers on a sales dataset.
Beginner
2. SQL analysis of an e-commerce database
Revenue, retention and top products with joins and window functions.
Intermediate
3. Customer churn analysis in Python
Clean data with Pandas and find churn drivers.
Intermediate
4. Power BI executive dashboard
Multi-page report with DAX KPIs.
Advanced
5. A/B test case study
Design and analyse an experiment with significance testing.