Start with a question
Define the decision, the metric and the data you need before building a chart.
- Spreadsheets
- Data types
- Metrics
- Data quality
Your checkpoint
Write a precise question and define how you will measure it.
All roadmapsData Analytics + GenAI
Data Analytics + GenAI
Roadmap.
Build towards an analytics portfolio with clean data, working dashboards and business recommendations you can defend.
Query and clean the data
Use SQL to join records and Python to prepare them. Check duplicates, missing values and row counts.
- SQL
- Joins & grouping
- Python & pandas
- Validation
Your checkpoint
Produce a clean dataset with a repeatable preparation process.
Explore and compare
Find patterns, compare groups and check whether an apparent change has another explanation.
- Summary statistics
- Distributions
- Segmentation
- Visualisation
Your checkpoint
Explain a change using comparable metrics and clearly stated limitations.
Build a dashboard
Choose charts that answer the question. Make filters, dates and metric definitions easy to understand.
- Power BI
- Dashboard layout
- Filters
- Data storytelling
Your checkpoint
Build a dashboard another person can use without you explaining every click.
Use AI and verify the result
Use AI to draft queries or summarise findings, then check the output against the source data.
- AI-assisted SQL
- Python assistance
- Verification
- Privacy
Your checkpoint
Find and correct a mistake in an AI-generated analysis before sharing it.
Present your recommendation
Show the question, evidence and recommendation. Make your analysis easy to inspect and reproduce.
- Project presentation
- Documentation
- Portfolio
- Peer review
Your checkpoint
Present an analysis with a dashboard, clean data and a short written recommendation.
Learn with guidance
Build your portfolio
with NYC.
Follow this path with live classes, project work and mentor feedback in Data Analytics + GenAI. Build the portfolio and the understanding to explain it.
