CL-226 Cloud & Platform

Enterprise BI with Power BI & Tableau

Deliver business intelligence people trust and can navigate, taught across Power BI and Tableau without favouring either vendor. Learners build a star-schema semantic model, write measures in DAX and level-of-detail expressions, enforce row-level security against an entitlement table, and tune a slow dashboard until refresh and render times are defensible. The exit artefact is a governed, published dashboard that answers one stated question.

B3Practitioner

6modules

43skill atoms

1role journey

Curriculum

What this course covers.

6 modules, 43 named skill atoms. Expand any module to see them.

1Semantic Models and Star Schemas7 skill atoms

fact and dimension separationsurrogate keys and conformed dimensionssingle-direction relationships and whysnowflaked dimensions flattened for BIrole-playing date dimensionsmany-to-many bridges and their costa model built for questions not for the source

2DAX and Calculated Measures7 skill atoms

measures against calculated columnsrow context and filter contextCALCULATE as the context transitiontime intelligence for YTD, prior year and moving averagevariables replacing repeated evaluationSUMX and AVERAGEX iterator costTableau FIXED, INCLUDE and EXCLUDE compared

3Dashboards That Answer a Question7 skill atoms

one question per view stated in the titlechart type matched to the comparisonfilters against drill-through against tooltipsreference lines and targets over bare numberscolour used for meaning not decorationmobile and print layoutsunopened dashboards diagnosed and retired

4Connectivity and Refresh7 skill atoms

import, DirectQuery and composite modelsTableau extracts against live connectionsincremental refresh policies and partitionsgateway configuration for on-premises sourcesrefresh windows set against source loadquery folding preserved through Power Queryrefresh failure alerting and retry

5Row-Level Security and Governance7 skill atoms

RLS roles with DAX filter rulesTableau user filters and entitlement tablesdynamic security from a user mapping tabletesting security by viewing as another userobject-level security for sensitive columnssecurity enforced in the model not the visualperiodic review of who can see what

6Publishing, Workspaces and Performance8 skill atoms

workspaces and projects structured by lifecycle stagedeployment pipelines from dev to test to productioncertified and promoted semantic modelsPerformance Analyzer and workbook optimiser outputcutting visual count and column cardinalityshared semantic models against report sprawlDirect Lake on OneLakeusage metrics driving retirement decisions

Where it fits

CL-226 in a role journey.

This course appears in 1 of our 45 role journeys. Here is what a learner takes immediately before and after it in each.

Data / BI Analyst

Practitioner stage

AI-111→CL-226→CL-225

Roles this course serves

Data / BI Analyst

The capability ladder

This course is authored to band B3.

Every course we run is written to one rung of the CASI ladder, so a plan can be assembled to take a team from where they are to where they need to be.

What do B1–B6 mean?The CASI Capability Ladder — click to expand

Every course targets a band on the CASI Capability Ladder — our six-band proficiency scale, anchored to open standards (O*NET, ESCO, NICE, NIST AI RMF, Bloom's). A band tells you how deep a course goes, and what evidence proves it.

What the learner can doTypical evidence

AwareUnderstands concepts and vocabulary; uses tools with guidance

Knowledge checks

FoundationPerforms standard tasks correctly in familiar contexts

Guided labs, autograded exercises

PractitionerDelivers complete pieces of work independently

Scenario labs, proctored hands-on exams

ProfessionalHandles production-grade complexity, trade-offs and failure modes

Break-fix drills, design defenses

AdvancedEngineers systems end-to-end under constraints; leads others

Rubric-scored capstones, vivas

ExpertSets direction; recognised authority across teams

Portfolio + panel evaluation

A note on B6. Courses in this catalog target B1–B5. B6 is not taught — it is recognised, through a portfolio and a panel, once someone is setting direction for others. Every journey here is built to land a learner at B5.

Other Cloud courses at this level.

CL-107

Run CL-226 for your team.

This course runs at several lengths depending on how deep you need to go and how much of it your people already have. Tell us who is being trained and we will scope it.

Add it to a training plan Talk to our team Check your team’s level free

Enterprise BI with Power BI & Tableau

What this course covers.

CL-226 in a role journey.

Data / BI Analyst

Roles this course serves

This course is authored to band B3.

Other Cloud courses at this level.

PostgreSQL for Cloud Engineers

Serverless Engineering on AWS (Lambda · DynamoDB)

Snowflake Core Engineering

Analytics Engineering with dbt

Workflow Orchestration with Airflow

Kubernetes Administration

Run CL-226 for your team.