Project Builder

Browse 30 ready-made project templates or generate a focused, realistic brief tailored to you.

Generator usage: 0/1 free project ideas.

10 project ideas per pathway

Filter by your target pathway, then save the ones you'll build.

Project structure for every Data Analyst project
  1. State the business question you're answering
  2. Describe the data source (real or simulated)
  3. Show the SQL or Excel logic
  4. Present the dashboard or output
  5. Write 2–3 sentences of insight or recommendation
Data Analyst · Idea #1
Sales KPI Dashboard
What to build
SQL + Power BI/Tableau dashboard tracking revenue, orders, and trends.
Why it's hiring-relevant
Shows end-to-end BI workflow.
Recommended tools
SQL, Excel, Power BI or Tableau
Output type
Interactive BI dashboard + GitHub README
Project structure
  1. State the business question you're answering
  2. Describe the data source (real or simulated)
  3. Show the SQL or Excel logic
  4. Present the dashboard or output
  5. Write 2–3 sentences of insight or recommendation
Data Analyst · Idea #2
Customer Churn Report
What to build
Cohort analysis and churn rate over time with insight narrative.
Why it's hiring-relevant
Common business problem; tests SQL and storytelling.
Recommended tools
SQL, Excel, Power BI or Tableau
Output type
Dashboard + written insight memo
Project structure
  1. State the business question you're answering
  2. Describe the data source (real or simulated)
  3. Show the SQL or Excel logic
  4. Present the dashboard or output
  5. Write 2–3 sentences of insight or recommendation
Data Analyst · Idea #3
Fake SaaS KPI Monitor
What to build
Monthly dashboard for MRR, churn, and activation.
Why it's hiring-relevant
Mirrors real product analytics work.
Recommended tools
SQL, Excel, Power BI or Tableau
Output type
Multi-page dashboard
Project structure
  1. State the business question you're answering
  2. Describe the data source (real or simulated)
  3. Show the SQL or Excel logic
  4. Present the dashboard or output
  5. Write 2–3 sentences of insight or recommendation
Data Analyst · Idea #4
Cohort Retention Analysis
What to build
Week-by-week retention table and visualisation.
Why it's hiring-relevant
Appears frequently in analyst interviews.
Recommended tools
SQL, Excel, Power BI
Output type
Retention heatmap + commentary
Project structure
  1. State the business question you're answering
  2. Describe the data source (real or simulated)
  3. Show the SQL or Excel logic
  4. Present the dashboard or output
  5. Write 2–3 sentences of insight or recommendation
Data Analyst · Idea #5
Revenue Segmentation
What to build
Breakdown by region, channel, and product category.
Why it's hiring-relevant
Tests SQL aggregation and BI layout skills.
Recommended tools
SQL, Excel, Power BI or Tableau
Output type
Segmented dashboard
Project structure
  1. State the business question you're answering
  2. Describe the data source (real or simulated)
  3. Show the SQL or Excel logic
  4. Present the dashboard or output
  5. Write 2–3 sentences of insight or recommendation
Data Analyst · Idea #6
Operations Tracker
What to build
Throughput, error rate, and SLA monitoring dashboard.
Why it's hiring-relevant
Useful for ops/logistics roles.
Recommended tools
SQL, Excel, Power BI or Tableau
Output type
Ops dashboard with KPI tiles
Project structure
  1. State the business question you're answering
  2. Describe the data source (real or simulated)
  3. Show the SQL or Excel logic
  4. Present the dashboard or output
  5. Write 2–3 sentences of insight or recommendation
Data Analyst · Idea #7
Website Traffic Funnel
What to build
Session-to-conversion analysis with drop-off commentary.
Why it's hiring-relevant
Web analytics staple; good for e-commerce roles.
Recommended tools
SQL, GA-style data, Power BI
Output type
Funnel dashboard + insight memo
Project structure
  1. State the business question you're answering
  2. Describe the data source (real or simulated)
  3. Show the SQL or Excel logic
  4. Present the dashboard or output
  5. Write 2–3 sentences of insight or recommendation
Data Analyst · Idea #8
Survey Results Pack
What to build
Clean visualisation + written recommendation memo.
Why it's hiring-relevant
Tests communication alongside technical work.
Recommended tools
Excel, Power BI
Output type
PDF/slide deck + dashboard
Project structure
  1. State the business question you're answering
  2. Describe the data source (real or simulated)
  3. Show the SQL or Excel logic
  4. Present the dashboard or output
  5. Write 2–3 sentences of insight or recommendation
Data Analyst · Idea #9
Inventory & Stockout Monitor
What to build
SKU-level stock dashboard with low-inventory alerts.
Why it's hiring-relevant
Useful for retail and supply chain roles.
Recommended tools
SQL, Excel, Power BI or Tableau
Output type
Dashboard with alert table
Project structure
  1. State the business question you're answering
  2. Describe the data source (real or simulated)
  3. Show the SQL or Excel logic
  4. Present the dashboard or output
  5. Write 2–3 sentences of insight or recommendation
Data Analyst · Idea #10
Monthly Executive Report
What to build
Insight-led narrative report with supporting visuals.
Why it's hiring-relevant
Shows stakeholder communication skills.
Recommended tools
Excel, Power BI, PowerPoint
Output type
Executive-ready report
Project structure
  1. State the business question you're answering
  2. Describe the data source (real or simulated)
  3. Show the SQL or Excel logic
  4. Present the dashboard or output
  5. Write 2–3 sentences of insight or recommendation

Generate a custom brief

Want a focused project for your industry and country? Use the generator below.