Tranzit-Tech Professional Certificate

Data Analytics Professional Certificate

Build job ready data skills. Learn spreadsheets, SQL, R, and dashboards through hands on projects. No degree needed.

4.8 (85k+ reviews)
Beginner friendly 8 courses Flexible schedule

What you will learn

  • Clean, analyze, and visualize data with spreadsheets and SQL.
  • Use R for data analysis and reproducible workflows.
  • Build dashboards with Tableau or Looker Studio.
  • Apply data ethics and stakeholder communication.

Hands on projects

Sales dashboard

Design a KPI dashboard with filters and trends.

Survey analysis

Clean messy survey data and present insights.

Skills you will gain

Spreadsheets SQL R Data Visualization Dashboarding A/B testing

Program info

Level
Beginner
Learning pace
Flexible
Duration
3 to 6 months
Projects
8

Job outcomes

  • Entry data analyst, junior data analyst, reporting analyst.
  • Portfolio with real projects to show employers.
  • Interview practice and career resources.

Alumni stories

Switched from support to data within 4 months. The projects helped me stand out.

Amina, Zurich

Landed an analyst role after building a portfolio and practicing SQL daily.

Jon, Berlin

Where skills apply

  • Tech companies
  • Consulting
  • Healthcare
  • Finance

Median starting pay

$55k to $75k

Ranges vary by region and role.


Courses in the certificate

8 courses • self paced

Foundations of Data Analytics

Data types, lifecycle, and analysis process.

  • Define questions and metrics.
  • Structure data for analysis.
  • Meet the analytics toolkit.

Ask questions with data

Stakeholders, goals, and KPIs.

  • Define SMART questions.
  • Choose metrics and guardrails.

Prepare data with spreadsheets

Cleaning, joins, and lookups.

  • Data types and cleaning.
  • Lookups and pivot tables.

SQL for analysts

Select, join, group, and window functions.

  • Joins and aggregations.
  • CTEs and window functions.

R programming

Tidyverse and reproducible analysis.

  • dplyr and ggplot2.
  • R Markdown and projects.

Data visualization

Principles and dashboard design.

  • Chart choices and pitfalls.
  • Interactive dashboards.

Capstone project

End to end analysis with presentation.

  • Choose a dataset and problem.
  • Deliver insights and a deck.

Tools used

Sheets SQL R Tableau Looker Studio

What learners say

Priya

Clear path and strong projects. Helped me switch roles.

Mateo

The SQL course was practical. The capstone tied it all together.

Sara

I landed interviews after publishing my dashboards.