Projects for Data Analyticss
Data Analytics projects are portfolio analyses that show the full workflow on realistic data: a sales performance study with SQL and Power BI, a customer segmentation in Python, and a marketing funnel dashboard with a short insights memo. Each shows a question, method, result and recommendation, which is what reviewers look for.
Stage: Capstone and Career · Part of the Data Analytics roadmap · Last reviewed 19 November 2026
What to learn in Projects
- Frame each project around a business question and the decision it informs
- Clean and join messy tables in SQL while documenting every assumption
- Segment customers with RFM scores or k-means and describe each group
- Build a funnel dashboard showing conversion and drop-off at each step
- Write a one-page memo that leads with findings and recommended actions
Projects interview questions
What is RFM segmentation and what data does it need?
RFM scores customers by recency of last purchase, frequency of purchases and monetary value. It needs transaction-level data with customer ID, date and amount. Each score is binned, often into quintiles, and combined to label groups such as champions or at-risk customers.
What should an insights memo for a funnel dashboard contain?
The headline finding, such as the step with the largest drop-off, supporting numbers, likely reasons backed by data, caveats about data quality, and two or three recommended actions, each with an expected impact and a way to measure it.
Where Projects fits in the Data Analytics roadmap
Projects belongs to the Capstone and Career stage (intermediate level), which takes about 7 hours. Show real analyses.
Other units in this stage
Back to the full Data Analytics roadmap