Skip to main content

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.

  1. 1. Sales dashboard in Excel

    Pivot tables, charts and slicers on a sales dataset.

  2. 2. SQL analysis of an e-commerce database

    Revenue, retention and top products with joins and window functions.

  3. 3. Customer churn analysis in Python

    Clean data with Pandas and find churn drivers.

  4. 4. Power BI executive dashboard

    Multi-page report with DAX KPIs.

  5. 5. A/B test case study

    Design and analyse an experiment with significance testing.

Skills these projects use