Career path · Data analyst

Analytics Pathway: SQL to analytics engineering

Six courses from your first SQL query to the transformation layer an analytics team runs on: SQL, Python for analysis, Power BI reporting, dimensional modeling, dbt pipelines, and data engineering foundations. Three of the six include a hosted lab on a real virtual machine.

Starting level
No experience needed
Content time
82 h 55 min
lesson time, from the published courses
Suggested pace
About 13 weeks
planning estimate, at your own pace
Weekly commitment
5–8 hours
suggested study time
Courses
6
Lessons
60
Labs
3
on real virtual machines
Certificate
On completion
Ultiblob-issued, verifiable by serial
Sign in to enrollEmployee sign-in$199.00 · Introductory pricing. Review the current price before checkout.
Three learners at a lab table with laptops and a server on a cart.

Before you start

Is this path for you?

Analytics work is mostly the part nobody shows you: getting the data into a shape that can be trusted. This path starts with SQL and Python against real data, adds reporting in Power BI, and then spends its second half on the modeling and pipeline work that makes a report reproducible — dimensional design, dbt, and the warehouse underneath. 60 lessons, about 83 hours of lesson content, with graded checks throughout.

Who it is for

  • Career changers starting with no analytics background
  • Spreadsheet-heavy analysts moving to SQL and a modeling layer
  • Report builders who want to own the pipeline, not only the dashboard
  • Developers moving toward analytics engineering

What you should know

  • Comfortable using a computer and a web browser
  • No prior SQL, Python or BI experience is assumed

What you will need

  • A computer with a current web browser
  • A stable internet connection
  • Lab machines are hosted by Ultiblob; the Power BI course has no hosted lab, and Power BI Desktop is a free Windows download you install yourself if you want to follow along

Curriculum

6 stages, in the order the work happens

Stage 1

SQL

  1. SQL

Stage 2

Python analysis

  1. Python analysis

Stage 3

Power BI

  1. Power BI

Stage 4

Dimensional modeling

  1. Dimensional modeling

Stage 5

dbt and pipelines

  1. dbt and pipelines

Stage 6

Analytics / data engineering

  1. Analytics / data engineering

Hands-on

Labs on this path

Each of these courses provisions virtual machines for you on the Ultiblob cluster and opens a console in your browser. The topology below is the published blueprint — roles and operating systems only.

Price and enrollment

$199.00

Introductory pricing. Review the current price before checkout.

  • labs included
  • certificate on completion

Before you decide

What we will not promise

  • A job, a salary, or an employer introduction. We teach and we let you practise; we do not place people.
  • Accreditation. An Ultiblob certificate records what you completed here. It is not an industry certification.
  • Statistics we have not measured. You will not find completion rates, placement rates or student counts on this site until they exist and are audited.

We would rather lose you here than mislead you.

$199.00

introductory price