A Power BI intermediate course for people who already publish dashboards and hit the same walls: measures that return odd numbers when filtered, models that get slow and reports that cannot compare periods. In 16 hours your team masters CALCULATE, time intelligence, the star-schema model and Power Query queries that combine several sources, and redesigns a real dashboard from your operation.
It is the second level of the path: a 16-hour program focused on what separates a pretty dashboard from a reliable one. It covers the star-schema model with a calendar table, correct relationships and cardinality; DAX with CALCULATE, filter and row contexts, time intelligence (running totals, year over year, moving average); Power Query with merges, parameters and multi-source queries; and multi-page dashboards with bookmarks, tooltips and navigation. It follows the Power BI basic course and prepares for the advanced level.
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.
16 hours
Live virtual · On-site · Self-paced
DC-3 · STPS
Geedle Bot answers questions 24/7 with the exact minute of the recording
Proposal with three scope options and a closed price in under 24 business hours
Three independent levels, each with its DC-3; hire one or chain them as a learning path.
Learning objectives observable on the job.
Separate facts and dimensions, build the calendar table, set cardinality and filter direction, and spot relationships that break numbers.
Filter and row context, CALCULATE with filters, ALL and ALLSELECTED, variables and measures that survive any slicer.
Year, month and quarter to date, previous-period comparison, moving average and growth measures.
Power Query with merges and parameters; bookmarks, buttons, tooltips and navigation for management.
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.
Facts and dimensions, keys, cardinality, inactive relationships and USERELATIONSHIP; calendar table with a fiscal hierarchy.
Documented star-schema modelMerge and append queries, parameters, simple custom functions, reference queries and conditional load.
Queries from 2+ sourcesFilter context versus row context, CALCULATE, FILTER, ALL, ALLSELECTED, KEEPFILTERS and variables.
Context-aware measure catalogTOTALYTD, DATEADD, SAMEPERIODLASTYEAR, moving average, percentage variation and handling incomplete periods.
Period-comparison measuresParameter tables, dynamic selection measures, introductory calculation groups and conditional formatting with measures.
Dashboard with dynamic selectionBookmarks, buttons and navigation, page tooltips, executive layout and publishing through workspaces.
Published 4-page reportAnalysts and coordinators in finance, sales, operations, HR, quality or planning who already build dashboards and need measures that survive any filter, compare periods and compute the same way in every report. Also for data teams at universities and in government that consolidate information from several systems (ERP, CRM, Excel, surveys) into a common model. Requires the basic level or equivalent experience publishing dashboards.
A multi-page dashboard on a star-schema model that combines at least two sources, with a documented catalog of DAX measures (year-to-date sales, variation versus last year, moving average, share) that every other report reuses. Reports stop showing different numbers depending on who builds them, refresh in minutes, and the team understands why a measure returns what it returns. It is ready for row-level security, performance and data governance, which make up the advanced level.
Request the proposal for the power bi intermediate course: three scope options with a closed price in under 24 business hours.
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.
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.
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.
Real projects told with facts, not promises.
Move graduate and undergraduate subjects, plus English and Spanish language courses, to a virtual format with academic quality and a consistent look.
Read the full caseTrain 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
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.
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 virtual | On-site at your company | Self-paced on the platform | |
|---|---|---|---|
| Ideal for | Teams across several sites or remote | Hands-on practice, team dynamics and brigades | Rotating shifts and large workforces |
| Interaction | Live instructor, breakout rooms and real cases | Instructor in the room, role-plays and practice with equipment | Microlessons, challenges and automatic assessments |
| Typical duration | 2-to-4-hour sessions on different days | 4-to-8-hour days | 2 to 4 weeks at your own pace |
| Records | Attendance, participation and assessment on the platform | Roster, assessment and photo evidence | Progress, grades and time on the platform |
| Questions between sessions | Geedle Bot 24/7 | Geedle Bot 24/7 | Geedle Bot 24/7 |
| Certificate | DC-3 with the STPS | DC-3 with the STPS | DC-3 with the STPS |
Short reads to decide better before you hire.
Other data, office tools and digital security courses and the full category.
Tell us how many people, in which city and in which format. We reply the same day, free and with no commitment.
