Meta Pixel Saltar al contenido
Advanced level

Power BI advanced course for companies

A Power BI advanced course for the team that already maintains the company-wide dashboards and needs them to scale: models that answer in seconds with millions of rows, DAX measures that do not break as they grow, row-level security by branch or area, scheduled refreshes that do not fail and a tidy Power BI service with workspaces, apps and data lineage.

Power BI advanced course

What is the Power BI advanced course?

It is the third level of the path: 16 hours for the people who manage or build the organization's critical dashboards. It goes deep into advanced DAX (iterators, virtual tables, ranking and segmentation patterns, calculation groups), performance (DAX Studio, model analysis, unnecessary columns, storage mode), static and dynamic row-level security, dataflows and incremental refresh, and service governance: workspaces, apps, gateways, lineage and certified datasets. It assumes the intermediate level or equivalent experience.

How long is the course and how is it delivered?

The exact duration is in the first card. It runs on-site at your company, live virtual for teams in several locations or self-paced on the platform; every participant who meets attendance and assessment receives a DC-3 certificate with the STPS, and Geedle Bot answers questions afterwards with the exact minute of the recording.

Duration

16 hours

Formats

Live virtual · On-site · Self-paced

Certificate

DC-3 · STPS

AI agent

Geedle Bot answers questions 24/7 with the exact minute of the recording

Investment

Proposal with three scope options and a closed price in under 24 business hours

What your team will be able to do

Learning objectives observable on the job.

  • Write advanced DAX and calculation groups

    Iterators, virtual tables, RANKX, TOPN, dynamic segmentation patterns and calculation groups to reuse time and formatting logic.

  • Optimize model performance

    Measure with Performance Analyzer and DAX Studio, reduce cardinality, choose storage mode and rewrite slow measures.

  • Implement row-level security

    Static and dynamic roles with USERPRINCIPALNAME, permission tables and security testing before publishing.

  • Govern the Power BI service

    Workspaces, apps, gateways, dataflows, incremental refresh, lineage and certified datasets.

Syllabus

What does the course syllabus include?

Six modules in order, each with a deliverable you apply in your operation the following week. Exercises use real files and cases from your organization, each module's assessment is recorded on the platform and serves as evidence for the DC-3 certificate.

  1. Advanced DAX

    Iterators (SUMX, AVERAGEX), virtual tables, RANKX and TOPN, dynamic segmentation, "new and returning" patterns and debugging with variables.

    Advanced measure catalog
  2. Calculation groups and formatting

    Calculation groups for time intelligence and unit conversion, dynamic format strings and field parameters.

    Time calculation group
  3. Model performance

    Performance Analyzer, DAX Studio and VertiPaq, columns and types that bloat the model, aggregations and storage mode.

    Optimized model with before/after metrics
  4. Row-level security

    Static and dynamic roles, USERPRINCIPALNAME, permission tables by branch or area, RLS in the service and testing as another user.

    Dashboard with dynamic RLS
  5. Dataflows and incremental refresh

    Reusable dataflows, gateways, scheduled and incremental refresh, RangeStart and RangeEnd parameters.

    Dataset with incremental refresh
  6. Service governance

    Workspaces, apps, permissions, lineage, certified datasets, measure-catalog documentation and a deployment plan.

    Published, documented app
01

Who is the advanced level for?

Senior analysts, business-intelligence leads, IT and data teams that publish dashboards for management, several branches or several agencies, and university teams that consolidate institutional indicators. It is the course for whoever gets asked "why does this dashboard take a minute to open?" or "how do I make each manager see only their region?". Requires fluency with the star-schema model, CALCULATE and time intelligence.

02

What changes in the company after the advanced level?

Dashboards that open in seconds, with row-level security that shows each person only what belongs to them, scheduled incremental refresh and a Power BI service with workspaces per area, published apps for management and certified datasets that other reports reuse. The team stops rebuilding the same model in every report and documents its measure catalog and data lineage: that is what an audit or a staff change needs to find.

Want this course at your company?

Request the proposal for the power bi advanced course: three scope options with a closed price in under 24 business hours.

For companies, universities and government

01

For companies

Sales, operations, finance and HR dashboards that refresh on their own and that management opens every Monday without asking for a new Excel. We work with your real data and leave the model documented. See how we apply it in courses for manufacturing and industry.

02

For universities

Institutional indicators (enrollment, dropout, graduation, teacher evaluation) consolidated from the student system and surveys into one model with security by faculty. We chain it with the courses for university administrative staff.

03

For government

Dashboards for program indicators, citizen service and budget execution, with row-level security by agency and training records ready for the comptroller. It is part of the courses for government and the public sector.

Case studies

Projects we have already delivered

Real projects told with facts, not promises.

Corporate university

A gamified corporate university for a sushi restaurant chain in Mexico and the US

Train crews spread across restaurants in several Mexican states and the United States with the same standard — and give every employee a clear view of how to grow inside the company.

Read the full case
  • One team from start to finish. Pedagogy, design, development and consulting — nothing critical subcontracted.
  • Fixed price, no surprises. A proposal with three scopes and a closed price for each. You choose the size of the step.
  • We listen before we quote. A free, no-strings assessment: you keep a useful report even if we don’t work together.
Participant asking Geedle Bot on a laptop at night; the agent replies with minute 42:15 of the course recording
Artificial intelligence

An AI agent supports every participant during and after the course

Geedle Bot is trained on the syllabus, materials and recordings of your course. Participants ask in plain language and get an exact answer, not a generic one.

  • Knows every detail of the course: dates, syllabus, deliverables and certificate criteria
  • Solves problems in real time, at any hour, from Moodle, WhatsApp, Teams or Slack
  • Delivers the exact minute and second of the recording where the instructor explained the topic
  • Reinforces what was covered with summaries and review questions, and escalates to the instructor when needed
  • Shows HR which topics raise the most questions so the course can be adjusted

Which format suits each course?

All of them issue a DC-3 certificate and leave records on the platform; what changes is how people practice and how the calendar is organized.

Live virtualOn-site at your companySelf-paced on the platform
Ideal forTeams across several sites or remoteHands-on practice, team dynamics and brigadesRotating shifts and large workforces
InteractionLive instructor, breakout rooms and real casesInstructor in the room, role-plays and practice with equipmentMicrolessons, challenges and automatic assessments
Typical duration2-to-4-hour sessions on different days4-to-8-hour days2 to 4 weeks at your own pace
RecordsAttendance, participation and assessment on the platformRoster, assessment and photo evidenceProgress, grades and time on the platform
Questions between sessionsGeedle Bot 24/7Geedle Bot 24/7Geedle Bot 24/7
CertificateDC-3 with the STPSDC-3 with the STPSDC-3 with the STPS
FAQ

Frequently asked questions about the power bi advanced course

Get a quote for this course for your team

Tell us how many people, in which city and in which format. We reply the same day, free and with no commitment.

★

Enter the VIP Zone

Geedle clients only. No passwords: we send a code to your email.

or

Not a client yet? Request your free diagnosis · Privacy notice