CertClue
Courses · Data
BI Analyst / Power BI Developer

Business Intelligence / Power BI Developer

Build the thing other people use without you in the room: a star schema model, relationships that filter the right way, a small library of correct DAX measures, and a multi page dashboard that answers a decision instead of decorating a wall.
5.5 hrs taught · 5 to 9 hrs applied 7 modules 29 lessons 5 portfolio artifacts Completion certificate Updated August 2026
Created by the CertClue team
What you'll build

Real portfolio pieces built during the course, not a certificate for its own sake. Each one is work you can show.

  • Stakeholder requirements noteOne page that turns a vague dashboard request into named decisions: who opens it, what they do differently because of it, the agreed definition of every metric, and what you deliberately did not build.
  • Data model diagramA star schema drawn out: every table with its grain, every relationship with its cardinality and filter direction, and a written reason for each direction you chose.
  • DAX measures libraryTwelve to twenty measures with a comment on each saying what it returns, what filter context it assumes, and where it would give the wrong answer if used somewhere else.
  • Multi page dashboard specPage by page: the one question each page answers, the visuals on it, the filters a user can change, and the reason a requested chart was left out.
  • Refresh and ownership runbookWhat refreshes, when, from which source, who owns that source, what breaks it, and the exact steps for the next person when a refresh fails at seven in the morning.

What you'll learn

Fundamentals, kept short
The role decoded
A day in the role
The recurring calendar
Live simulation · a week at Thornbury Supply
Artifacts · the proof you leave with
Handoff · interviews, tests, and the route on

Course content · 7 modules, 29 lessons

Sign up to unlock every lesson - the titles below show exactly what is inside.

The ideas that separate a BI developer from someone who can drag fields onto a canvas: what you are really building, the star schema, relationships, columns against measures, filter context, why a date table is not optional, and the security model that decides which rows each person sees.

What a BI developer actually builds
The star schema, and why one flat table hurts
Relationships: cardinality, direction, and the ones that bite
Calculated column or measure, and how to tell
Filter context, the concept that separates the two jobs
The date table, and why time comparisons need one
Row level security, and the thing it cannot do

Requirements

  • No prior experience in this field is required to start.
  • A computer with a reliable internet connection.
  • Comfortable using a web browser - no software to install.

Description

Every CertClue course follows the same seven-part shape: fundamentals, the role translated out of job-posting language, a real working day, the job's recurring rhythms, a multi-day simulation, the portfolio you build along the way, and a handoff into your next move. Here is what that looks like for bi analyst / power bi developer.

Who this course is for

Anyone aiming to become a bi analyst / power bi developer, including career changers with no background in it yet. This is the entry rung of a realistic ladder:

entry
BI Analyst

Builds dashboards and reports from defined data sources, and answers ad hoc questions from the business.

Dashboard buildingDAX basicsAd hoc reporting
mid
Power BI Developer

Owns the data model and semantic layer for a domain, and builds dashboards other analysts build on top of.

Data modelingDAXSemantic layer design
senior
BI / Analytics Lead

Sets reporting standards across the org, governs the data model, and translates leadership questions into metrics.

GovernanceMetric designStakeholder alignment

Where it leads

This course prepares you for the Microsoft PL-300 role or credential path. Named for preparation only - no partnership or endorsement is implied.

Reviews

No reviews yet. Reviews come from learners who have taken the course, so this stays empty until someone leaves one.

Sign in to leave a review.

Students also explore