BI Developer

Program

BI Developer

Model data and build dashboards people trust

Learn to build the semantic models, DAX measures, and dashboards that power business intelligence.

8

Weeks

50

Chapters

4

Practice formats

1

Portfolio artifact

8 weeks — one module per week (8 modules, 50 chapters), each week ending with a live class every Saturday, plus a module exam before the next module opens.

Curriculum

50 chapters across 8 modules — each with guided notes, a live example, a quiz, an exercise, a challenge, and class practice.

Module 2 · EXCEL FOR DATA ANALYTICS & BUSINESS INTELLIGENCE

  1. 8Module PlanningWhat Module 2 covers, how long it takes, and why Excel is still the BI developer's everyday tool.Learn →
  2. 9Learning OutcomesThe skills you should be able to demonstrate by the end of Module 2, and how they map to BI developer tasks.Learn →
  3. 10Excel Fundamentals for Data AnalyticsWorkbooks, sheets, cells and ranges; data types; tidy data layout; and the cell references every formula depends on.Learn →
  4. 11Excel Formulas & Basic FunctionsOperators and order of operations, SUM/AVERAGE/COUNT/MIN/MAX, ROUND, percentages and growth — the arithmetic behind every KPI.Learn →
  5. 12Logical Functions — IF, AND & ORComparisons, IF for categories and flags, AND/OR for combined rules, nested IF and IFERROR — the logic behind conditional columns and DAX IF.Learn →
  6. 13Conditional Calculations — SUMIF, SUMIFS, COUNTIF & COUNTIFSTotals, counts and averages for a subset of rows — single and multiple conditions, comparison criteria, criteria in cells, and the link to DAX CALCULATE.Learn →
  7. 14Data Cleaning & Preparation in ExcelSpot and fix the usual data quality problems: spaces, capitals, duplicates, blanks, codes hidden in text, and mismatched keys — then look values up with XLOOKUP.Learn →
  8. 15Excel Tables & Data OrganizationConvert ranges into Excel Tables, use structured references, sort, filter and validate input — the clean, growing source that Power BI loves to import.Learn →
  9. 16PivotTables & Business AnalysisBuild PivotTables from a table, choose rows, columns, values and filters, show percentages and growth, and read results like a business analyst.Learn →
  10. 17Excel Charts & Data VisualizationChoose the right chart for the question, build clean bar, line, combo and KPI visuals, and remove clutter so the message is obvious.Learn →
  11. 18Excel Business KPI DashboardDesign and build a one-page KPI dashboard: choose KPIs, calculate them with formulas, compare against targets, add charts and slicers, and present the story.Learn →

Module 3 · SQL FOR BUSINESS INTELLIGENCE

  1. 19Relational Databases & SQL for BIModule 3 plan and outcomes; tables, rows, keys and relationships; how a BI developer uses SQL; and your first SELECT queries.Learn →
  2. 20Filtering & Sorting Business DataWHERE with comparison and logical operators, IN, BETWEEN, LIKE, NULL handling, ORDER BY and LIMIT — the questions behind every report filter.Learn →
  3. 21Aggregations with GROUP BY & HAVINGCOUNT, SUM, AVG, MIN and MAX; grouping by one or more columns; filtering groups with HAVING; and computing revenue-style measures in SQL.Learn →
  4. 22Joining Tables for ReportingINNER and LEFT joins, joining a fact table to several dimensions, finding unmatched rows, and avoiding duplicated totals.Learn →
  5. 23Reporting Queries — CASE, CTEs & ViewsBuild reusable, readable report queries: CASE for categories, CTEs for step-by-step logic, views as clean sources for Power BI, and Import vs. DirectQuery.Learn →

Module 4 · POWER QUERY & DATA PREPARATION

  1. 24Power BI Desktop & Getting DataModule 4 plan; a tour of Power BI Desktop; connecting to Excel, CSV and databases; and how Power Query records every transformation as an applied step.Learn →
  2. 25Cleaning Data in Power QueryTrim and Clean, fix capitalisation, replace values, fill down, remove duplicates and errors, and use column profiling to find quality problems.Learn →
  3. 26Shaping Columns & RowsSplit and merge columns, extract text, add conditional and custom columns, filter and sort rows — turning codes and raw fields into report-friendly attributes.Learn →
  4. 27Combining Queries — Append, Merge & Group ByStack tables with Append, join them with Merge (and its join kinds), summarise with Group By, and organise queries with references and staging.Learn →
  5. 28M Language, Parameters & Best PracticesRead the M behind your steps, use parameters for sources, fix type errors safely, keep query folding, and follow naming and performance best practices.Learn →

Module 5 · DATA MODELING IN POWER BI

  1. 29Star Schema — Facts & DimensionsModule 5 plan; why models matter; fact and dimension tables; grain; star vs. snowflake vs. one flat table — and how relationships replace lookups.Learn →
  2. 30Relationships, Cardinality & Filter DirectionOne-to-many relationships, cardinality, single vs. both filter direction, active and inactive relationships, and checking keys before you connect tables.Learn →
  3. 31The Date TableWhy every model needs a dedicated date table, which columns it holds, how to create and mark it, and how to sort month names correctly.Learn →
  4. 32Calculated Columns vs. MeasuresWhere DAX calculations live, how they are stored and evaluated, row context vs. filter context in practice, and how to choose correctly.Learn →
  5. 33Model Best Practices & PerformanceNaming, hiding, formatting and organising the model; reducing size with the right columns and types; and finding slow visuals with Performance Analyzer.Learn →

Module 6 · DAX — DATA ANALYSIS EXPRESSIONS

  1. 34DAX Fundamentals & Your First MeasuresModule 6 plan; DAX syntax; SUM, COUNTROWS, DISTINCTCOUNT, DIVIDE; building a measures table and reusable base measures.Learn →
  2. 35Filter Context & Row ContextHow one measure returns different numbers in every visual cell, how row context works in columns and iterators, and how to read a matrix like the engine does.Learn →
  3. 36CALCULATE & Filter ModifiersCALCULATE as the most important DAX function; adding, replacing and removing filters with ALL, REMOVEFILTERS and ALLEXCEPT; and percent-of-total patterns.Learn →
  4. 37Iterators — SUMX, AVERAGEX, RELATED & RANKXRow-by-row calculations inside measures, RELATED for values from dimensions, averages per entity with AVERAGEX, and ranking with RANKX.Learn →
  5. 38Time IntelligenceYear-to-date, previous period, month-over-month growth, same period last year and rolling totals — built on a marked date table.Learn →
  6. 39Variables, SWITCH & Reusable DAX PatternsReadable DAX with VAR/RETURN, SWITCH(TRUE()) for status logic, handling BLANK, dynamic titles, and testing measures in DAX query view.Learn →

Module 7 · REPORTS, VISUALIZATION & STORYTELLING

  1. 40Choosing the Right VisualModule 7 plan; matching visuals to questions; cards, bar, line, matrix, map and scatter; and the visuals that usually mislead.Learn →
  2. 41Building Report PagesPage layout and grids, building an executive overview, slicers and the filter pane, formatting visuals, and a consistent theme.Learn →
  3. 42Interactivity — Drill-down, Drill-through, Tooltips & BookmarksCross-filtering and edit interactions, hierarchies and drill-down, drill-through detail pages, report-page tooltips, bookmarks, buttons and field parameters.Learn →
  4. 43Report Design & AccessibilityVisual hierarchy, colour with meaning, decluttering, mobile layouts, and Power BI accessibility features: alt text, tab order, contrast, and screen readers.Learn →
  5. 44Data Storytelling & DashboardsTurning analysis into a recommendation: the story arc, report vs. dashboard, annotations, presenting to stakeholders, and gathering feedback.Learn →

Module 8 · POWER BI SERVICE, SECURITY & CAREER

  1. 45Publishing — Workspaces, Apps & SharingModule 8 plan; publishing from Desktop to the Power BI Service; workspaces and roles; apps and audiences; sharing options and licensing basics.Learn →
  2. 46Data Refresh & GatewaysScheduled and on-demand refresh, credentials, on-premises data gateways, incremental refresh, refresh failures, and monitoring.Learn →
  3. 47Row-Level SecurityStatic and dynamic row-level security with roles and DAX filters, USERPRINCIPALNAME and mapping tables, testing with View as, and object-level security basics.Learn →
  4. 48Governance, Deployment & PerformanceDevelopment, test and production environments; deployment pipelines; endorsement and certified models; sensitivity labels; documentation; and capacity-friendly performance.Learn →
  5. 49PL-300 Exam PreparationThe Microsoft Power BI Data Analyst (PL-300) exam: skills measured, question styles, a 4-week study plan, and practice strategies.Learn →
  6. 50Capstone Project & BI Career LaunchThe end-to-end capstone brief, portfolio presentation, CV and LinkedIn for BI roles, common interview questions, and a technical interview task.Learn →
Start learning →

Delivery

Blended — self-paced lessons plus weekly live sessions

Portfolio outcome

A live Power BI dashboard built on a real business dataset, ready to show in interviews.

Certificate

Certificate of completion, verifiable online with its credential code.

By the end of this program, you'll be job-ready to…

  • Model relationships between tables the way production BI teams do
  • Write DAX measures that hold up under real business questions
  • Design and publish a dashboard a stakeholder would actually use

Salary expectations

Estimated U.S. national average annual salary by experience level.

$65,000

Entry-level

$95,000

Mid-level

$130,000

Senior-level

Estimated figures for planning purposes — actual pay varies by location, employer, and experience.

Tools you'll master

Power BIDAXPower QuerySQLExcel

Practical training, every chapter

  • A live "try it yourself" example in every chapter you can run immediately
  • A hands-on exercise per chapter, with hints and a reveal-able answer
  • An open-ended challenge per chapter, graded against real success criteria
  • Class practice prompts for pairs or cohorts, not just solo homework

Why take this program

Interview- and job-ready

Built to the same bar Aicloud actually hires against — not a generic syllabus.

Tier 1 company partners

Program partnerships with leading employers are in progress — see Affiliation for status.

Job connection access

Graduates get access to Aicloud's own hiring pipeline and employer referral network.

Professional networking

Cohort discussion boards and live sessions connect you with peers and mentors, not just content.

A real portfolio

You leave with a concrete, explainable artifact — proof of knowledge, not just a certificate.

Register Explore Packages