Home / Roadmaps / Data Analytics
Data Analytics
Turn raw spreadsheets and databases into decisions people trust.
Data analytics is the most accessible on-ramp into the data field. You learn to clean data, query it, and communicate findings — without needing heavy maths or a CS degree up front. It pairs well with almost any background, from finance to marketing.
The route
Spreadsheet & data literacy 2–4 weeks
Get fluent in spreadsheets and the vocabulary of data before touching code.
- Excel / Google Sheets
- Pivot tables
- Descriptive statistics
- Clean vs dirty data
SQL for analysis 4–6 weeks
SQL is the single most valuable analytics skill. Learn to query, join, and aggregate confidently.
- SELECT / WHERE / GROUP BY
- JOINs
- Window functions
- CTEs
BI & visualization 4–6 weeks
Build dashboards that answer a question at a glance. Power BI or Tableau — pick one and go deep.
- Power BI / Tableau
- DAX or LOD basics
- Dashboard design
- Storytelling with data
Real projects & portfolio 4–8 weeks
Three end-to-end projects on real datasets beat any certificate. Publish them.
- End-to-end analysis
- Stakeholder framing
- Portfolio / GitHub
- Light Python (optional)
Who it's for
- Career switchers who like spreadsheets and logic
- Marketers, finance, and ops people who want to use data
- Anyone testing the waters before data science
Career outcomes
- Junior Data Analyst
- BI Analyst
- Reporting / Insights Analyst
Prefer guided learning?
If self-paced study keeps stalling, a mentored cohort can get you to job-ready faster. DTI runs structured programs in Albania across software, data, and security.
Explore DTI →