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
- State the business question you're answering
- Describe the data source (real or simulated)
- Show the SQL or Excel logic
- Present the dashboard or output
- 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
- State the business question you're answering
- Describe the data source (real or simulated)
- Show the SQL or Excel logic
- Present the dashboard or output
- 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
- State the business question you're answering
- Describe the data source (real or simulated)
- Show the SQL or Excel logic
- Present the dashboard or output
- 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
- State the business question you're answering
- Describe the data source (real or simulated)
- Show the SQL or Excel logic
- Present the dashboard or output
- 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
- State the business question you're answering
- Describe the data source (real or simulated)
- Show the SQL or Excel logic
- Present the dashboard or output
- 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
- State the business question you're answering
- Describe the data source (real or simulated)
- Show the SQL or Excel logic
- Present the dashboard or output
- 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
- State the business question you're answering
- Describe the data source (real or simulated)
- Show the SQL or Excel logic
- Present the dashboard or output
- 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
- State the business question you're answering
- Describe the data source (real or simulated)
- Show the SQL or Excel logic
- Present the dashboard or output
- 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
- State the business question you're answering
- Describe the data source (real or simulated)
- Show the SQL or Excel logic
- Present the dashboard or output
- 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
- State the business question you're answering
- Describe the data source (real or simulated)
- Show the SQL or Excel logic
- Present the dashboard or output
- 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
- State the business question you're answering
- Describe the data source (real or simulated)
- Show the SQL or Excel logic
- Present the dashboard or output
- 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.
