Corporate · onsite · online training worldwide
contact@DevOpsSchool.com· +91 99057 40781·
> Business Intelligence & Analytics · DevOpsSchool Trainer

Power BI Trainer

Private corporate batches, live online cohorts and 1-on-1 mentoring in Power Query, star-schema modelling, DAX, report design and governed publishing at enterprise scale — taught by a practitioner who runs it in production.

20 years across DevOps, SRE and Security · 10,000+ engineers trained · Trained teams at JPMorgan Chase, Verizon, Nokia and the World Bank

DeliveryOnline · Onsite · Hybrid
FormatsCorporate · 1-on-1 · Cohort
AgendaCustomisable
Batch size8–30 engineers
Engineers we've trained work at
JPMorgan ChaseBank of AmericaWells FargoVerizonNokiaWorld BankGE HealthcareVMwareOracleQualcommMercedes-BenzAirbusDatadogSplunkDeloitteInfosysWiproCapgemini
# who teaches it

Your Power BI trainer

Rajesh Kumar

Principal DevOps Engineer & Architect

Early-bird MLOpsAIOps practitionerData platform operations20 years in productionPrincipal / architect roles10,000+ engineers trainedM.Tech BITS Pilani25+ certifications

Rajesh teaches Power BI around the model rather than the visual: why a star schema outperforms a flattened table, what filter context actually is and how CALCULATE modifies it, and why the same measure returns different numbers in two visuals. Sessions cover the operational half most courses skip — storage modes and composite models, incremental refresh against a large fact table, row-level security that scopes one report to many audiences, gateway configuration, deployment pipelines and reading the Performance Analyzer to find the visual that is costing three seconds. Every concept is demonstrated against a live model rather than described on slides.

Twenty years across DevOps, SRE and Security, in principal and architect roles at PayPay, SoftwareAG, ServiceNow, JDA Software, Intuit, Adobe and others. He has trained engineers at JPMorgan Chase, Verizon, Nokia, the World Bank, VMware, Oracle, Mercedes-Benz and Airbus — more than 10,000 people personally. He teaches what he runs, not what he reads.

One practitioner, not a bench

You are booked with a named engineer, and that is who turns up. Marketplaces and larger providers rotate whoever is free, so the person who sold you the agenda is rarely the person teaching it.

The same trainer is available for the next engagement, which matters when a team builds on what it learned last time.

18,000+certified learners
500+corporate batches delivered
50+countries served
100+certification programmes
# faculty

Who delivers Power BI engagements

Your batch is assigned a named trainer before it starts, and that is who teaches it. See the full faculty.

How your Power BI trainer is chosen

Engagements are matched on the tool, not the calendar. For Power BI that means a trainer who has run it in production — Power Query, star-schema modelling, DAX, report design and governed publishing at enterprise scale — rather than whoever is free that week. You are told who is teaching before you commit, and that person is on the discovery call that shapes the agenda.

Where a batch is large enough to need a second trainer, the pairing is declared up front. The lead trainer stays accountable for the syllabus and the assessment either way.

Rajesh Kumar

Principal DevOps Engineer & Architect

India20 yrsLead trainer

Twenty years across DevOps, SRE and Security in principal and architect roles at PayPay, SoftwareAG, ServiceNow, JDA Software, Intuit, Adobe, IBM/Emptoris, Ness, MindTree and Accenture. He has trained more than 10,000 engineers personally, at organisations including JPMorgan Chase, Verizon, Nokia, the World Bank, VMware, Oracle, Mercedes-Benz and Airbus. He teaches what he runs, not what he reads.

Gaurav Aggarwal

IndiaInstructorCoach

Harsh Mehta

IndiaInstructorCoach

Kapil Gupta

IndiaInstructorCoach

Kunal Jain

IndiaInstructorCoach

Nikhil Gupta

IndiaInstructorCoach

Pranab Kumar

IndiaInstructorCoach

Rohit Ghatol

IndiaInstructorCoach

Amit Agarwal

IndiaInstructorCoach

Anil Kumar

IndiaInstructorCoach

Balachandran Anbalagan

IndiaInstructorCoach

Durga Prasad

IndiaInstructorCoach

# how to engage

Four ways to work with this trainer

Private corporate batch

Teams of 8–30

Custom agenda, your timezone, onsite or online, NDA-friendly.

Request a quote

1-on-1 mentoring

Individual engineers

A private instructor and a curriculum built around your goal.

₹99,999

Live & Interactive cohort

Individuals who want peers

Scheduled batch, max 8 to 10 hours of live instruction.

₹34,999

Self-paced video

Self-starters

Full LMS access — 20+ courses and 50+ tools included.

₹833/mo
# private batches

Private Power BI training for your team

A private batch starts with a discovery call. We look at the stack you actually run — the CI system, the cloud, the constraints — and map the agenda onto it, so examples use your topology rather than a generic one.

Delivery is onsite at your premises, live online, or hybrid, scheduled around your release calendar rather than ours. Batches run 8 to 30 engineers.

Every attendee leaves with recordings, slides, lab repositories and a completion certificate. You receive an attendance and assessment report. Invoicing supports PO and GST.

Talk to us about a private Power BI batch

What you provide vs what we bring

  • You: the room or the call, and the engineers
  • Us: trainer, agenda, labs, assessment, certificates
  • Labs: we guide your team through provisioning their own free-tier cloud environment — the skill goes with them
# the technology

What is Power BI?

Power BI is Microsoft's business intelligence platform. It has three parts that people often blur together: Power BI Desktop, where you connect to data, shape it, model it and design reports; the Power BI service, where semantic models and reports are published, refreshed, secured and shared; and the mobile and embedded surfaces where the results are consumed. Underneath all of them sits a tabular analytical engine — the same VertiPaq columnar store used by Analysis Services — which is why a well-modelled Power BI file can scan tens of millions of rows in under a second and a badly modelled one cannot.

Three languages do the work. M, the Power Query language, handles connection, shaping, merging and cleansing at refresh time. DAX handles calculation at query time — measures, filter context, time intelligence and everything that makes a number respond correctly when a user clicks a slicer. The report canvas handles interaction: visual interactions, bookmarks, drillthrough and tooltips. Most Power BI problems that look like DAX problems are actually modelling problems, and most that look like performance problems are storage-mode or cardinality problems.

The platform side matters just as much in an organisation. Workspaces and apps decide who sees what, on-premises data gateways connect to data that is not in the cloud, incremental refresh keeps large models refreshing in minutes rather than hours, row-level security scopes a single report to many audiences, and deployment pipelines move content from development to test to production without rebuilding it. Getting these right is the difference between a few useful reports and a BI capability the business trusts.

Why this skill matters now

Reporting has moved from a central BI team producing fixed outputs to analysts and domain teams building their own models. That is faster, and it fails in a predictable way: dozens of near-identical files, contradictory numbers for the same metric, refreshes that time out, and no clear owner. Organisations are now investing in the discipline — shared semantic models, governed workspaces, defined metric definitions — rather than more dashboards.

At the same time the technical bar has risen. Composite models and DirectQuery, incremental refresh, calculation groups, the XMLA endpoint and integration with lakehouse storage mean Power BI is no longer only a desktop tool. Handling a model that will not fit in memory, or a refresh window that has run out of room, requires genuinely different skills from building a first report.

The demand is for people who can do both halves: design a star schema and write DAX that returns the right number under every filter combination, and then publish, secure, refresh and govern the result so that the business can rely on it. Report-building alone is now table stakes.

Power BI training
# outcomes

What your team can do afterwards

Connect to and shape data with Power Query, and read and edit the underlying M rather than only using the ribbon
Design a star schema with correct relationships, cardinality and filter direction, and explain why it beats a flattened table
Write DAX measures that behave correctly under every filter combination, using CALCULATE and filter context deliberately
Build time intelligence — year to date, prior period, rolling averages — on a proper date table
Choose between Import, DirectQuery, Dual and composite models based on data volume, freshness and cost
Design reports that answer a question rather than display everything, with controlled visual interactions, drillthrough and bookmarks
Publish and govern content with workspaces, apps, deployment pipelines and row-level security
Configure gateways, scheduled refresh and incremental refresh so large models refresh reliably inside the window
Diagnose slow reports with Performance Analyzer and DAX Studio and fix the actual cause
# curriculum

8 modules. Live demos in a real lab, not slides.

01Architecture and the analytics workflowLive & Interactive5 hrs · 2 assignments · 1 capstone

The whole pipeline before any button is pressed. Where Desktop, the service, gateways and capacity sit; what a semantic model actually is; and the VertiPaq columnar engine that explains most performance behaviour later in the course. Then the workflow itself — connect, shape, model, calculate, visualise, publish, govern — and the failure that happens when a step is skipped.

Topics: Power BI Desktop, service, mobile and Report Server · Semantic models, reports and dashboards — what each one is · The VertiPaq columnar engine and compression · Licensing tiers and capacity in plain terms · The end-to-end analytics workflow · Where Power BI fits alongside Excel, a warehouse and a lakehouse · Common anti-patterns and how they start

  • Assignments: (1) Map an existing spreadsheet-based report onto the Power BI workflow; (2) Document where the data for one real business question actually lives
  • Capstone: Produce an architecture note for a specific reporting need, naming the storage mode and refresh strategy
02Power Query and M — connect, shape, combineLive & Interactive5 hrs · 2 assignments · 1 capstone

Getting data in and getting it clean. Connectors and connection settings, the query editor and what each transformation actually generates in M, and the transformations that matter most: unpivot, merge, append, group by, split and type handling. Then query folding — the single most important performance concept in Power Query — parameters, and dataflows for reuse across models.

Topics: Connectors, credentials and privacy levels · The query editor and applied steps · Reading and editing M in the advanced editor · Filtering, splitting, replacing and type conversion · Unpivot, merge and append · Group by and aggregation at source · Query folding and why breaking it wrecks refresh time · Parameters and reusable functions · Dataflows for shared, reusable transformations · Error handling and profiling data quality

  • Assignments: (1) Clean a deliberately messy source with unpivot, merge and type handling; (2) Take a query that has broken folding, find the step responsible, and restore it
  • Capstone: Build a parameterised query set that loads a clean fact and dimension structure
03Data modelling — star schemas and relationshipsLive & Interactive5 hrs · 2 assignments · 1 capstone

The module that determines whether everything after it works. Facts and dimensions, why a star schema beats both a single flat table and a normalised snowflake, relationship cardinality and cross-filter direction, and the specific problems — ambiguous paths, bidirectional filtering, many-to-many — that produce wrong numbers. Plus a proper date table, hierarchies and model hygiene.

Topics: Facts, dimensions and grain · Star schema versus flat table versus snowflake · Relationship cardinality: one-to-many, one-to-one, many-to-many · Cross-filter direction and the cost of bidirectional relationships · Active and inactive relationships and USERELATIONSHIP · Role-playing dimensions · Building and marking a date table · Hierarchies and display folders · Hiding columns, formatting and model documentation · Cardinality, column data types and model size

  • Assignments: (1) Convert a wide flat table into a star schema and compare model size; (2) Diagnose a report returning wrong totals caused by a bidirectional relationship
  • Capstone: Deliver a documented star-schema model with a marked date table and no ambiguous paths
04DAX foundations — filter context and CALCULATELive & Interactive5 hrs · 2 assignments · 1 capstone

DAX properly, starting from the concept that explains everything else. Calculated columns versus measures and when each is correct; row context and filter context; how a visual creates filter context; and CALCULATE as the only function that modifies it. Then variables for readability and performance, and iterator functions.

Topics: Calculated columns vs measures vs calculated tables · Row context and filter context · How a visual generates filter context · CALCULATE and filter modification · FILTER, ALL, ALLEXCEPT and REMOVEFILTERS · Iterators: SUMX, AVERAGEX and friends · VAR and RETURN for readable, faster measures · RELATED and RELATEDTABLE · DIVIDE and safe division · Common DAX mistakes and how to spot them

  • Assignments: (1) Write a percentage-of-total measure that behaves correctly at every hierarchy level; (2) Debug a measure that returns the right number in one visual and the wrong one in another
  • Capstone: Build a measure library for a business domain with documented definitions
05DAX in depth — time intelligence and calculation groupsLive & Interactive5 hrs · 2 assignments · 1 capstone

The calculations businesses actually ask for. Year to date, prior year, rolling periods and period-over-period comparison, built on a proper date table rather than improvised. Then ranking, running totals and semi-additive measures such as opening and closing balances. Finally calculation groups, which stop a model from needing forty near-identical measures.

Topics: Time intelligence functions and their date-table requirement · YTD, QTD, MTD and prior-period comparison · Rolling and moving averages · Custom and fiscal calendars · Ranking with RANKX and TOPN · Running totals and cumulative measures · Semi-additive measures: opening and closing balances · Calculation groups and calculation items · Dynamic format strings · Measure organisation and naming conventions

  • Assignments: (1) Build a full time-intelligence set against a fiscal calendar; (2) Replace a set of repeated measures with a calculation group
  • Capstone: Deliver a calculation layer covering current, prior and cumulative views with one measure set
06Report design and interactionLive & Interactive5 hrs · 2 assignments · 1 capstone

Reports that answer a question instead of displaying everything. Choosing the right visual for the comparison being made, layout and visual hierarchy, and colour and accessibility. Then the interaction model: slicers and sync, edit interactions, drillthrough, tooltips, bookmarks and buttons, conditional formatting, and designing for mobile.

Topics: Choosing a visual for the question being asked · Layout, grouping and visual hierarchy · Colour, contrast and accessibility · Slicers, sync slicers and filter panes · Edit interactions and controlling cross-filtering · Drillthrough and report page tooltips · Bookmarks, selection pane and buttons · Conditional formatting and dynamic titles · Small multiples and custom visuals · Mobile layout · Paginated reports and when to use them instead

  • Assignments: (1) Redesign a cluttered dashboard around a single decision it should support; (2) Add drillthrough and a report-page tooltip that answer the obvious follow-up questions
  • Capstone: Deliver a report that a named business role could use unaided to make a specific decision
07Publishing, sharing and governanceLive & Interactive5 hrs · 2 assignments · 1 capstone

Getting content out of Desktop and under control. Workspaces and roles, apps for distribution, and the difference between sharing a report and publishing an app. Then governance: row-level security so one report serves many audiences, sensitivity labels, endorsement, the shared semantic model pattern, and deployment pipelines that move content through environments properly.

Topics: Workspaces, roles and access · Publishing apps and audiences · Row-level security: static and dynamic roles · Testing RLS with view-as · Object-level security · Sensitivity labels and data protection · Certified and promoted semantic models · The shared semantic model and thin report pattern · Deployment pipelines: development, test, production · Usage metrics and adoption tracking · Source control and Git integration for workspaces

  • Assignments: (1) Implement dynamic row-level security and prove it with view-as for three users; (2) Move a report through a deployment pipeline with parameterised data sources
  • Capstone: Design a governance model covering workspaces, endorsement, security and promotion
08Refresh, performance and enterprise scaleLive & Interactive5 hrs · 2 assignments · 1 capstone

Making it work when the data is large and the refresh window is short. Storage modes and composite models, aggregation tables, incremental refresh with partitions, and the on-premises data gateway. Then performance work with a method rather than guesswork: Performance Analyzer to find the slow visual, DAX Studio to see the query, and the model changes that actually help.

Topics: Import, DirectQuery, Dual and composite models · Aggregation tables and automatic aggregations · Incremental refresh, partitions and the refresh window · On-premises data gateway: install, clustering and troubleshooting · Scheduled refresh, failures and alerting · The XMLA endpoint and external tools · Tabular Editor for model development at scale · Performance Analyzer: finding the slow visual · DAX Studio: reading the query plan and server timings · Reducing model size: cardinality, columns and data types · Lakehouse and Direct Lake connectivity · Capacity monitoring and cost

  • Assignments: (1) Configure incremental refresh on a large fact table and verify the partitions; (2) Take a report with a five-second page load and halve it with evidence
  • Capstone: Deliver an enterprise-scale model: composite storage, incremental refresh, gateway, RLS and a documented performance baseline

Need this mapped to your stack?

We rebuild the agenda around the tools you actually run.

Request a custom agenda
# hands-on

Labs and capstones your engineers actually build

LAB · POWER QUERY

Clean a messy source and keep folding

Shape a deliberately awkward source with unpivot, merge and type handling, then find and fix the step that broke query folding and measure the refresh difference.

power querymquery folding
LAB · MODELLING

Flat table to star schema

Convert a wide flat table into facts and dimensions with a marked date table, then compare model size, refresh time and measure behaviour before and after.

star schemarelationshipsdate table
LAB · DAX

Filter context under the microscope

Build percentage-of-total, prior-period and rolling measures, then debug a measure that returns different numbers in two visuals and explain exactly why.

daxcalculatefilter context
LAB · DESIGN

Redesign a dashboard around one decision

Take a cluttered report, identify the decision it should support, and rebuild it with controlled interactions, drillthrough and tooltips.

report designdrillthroughbookmarks
LAB · GOVERNANCE

Row-level security and deployment pipelines

Implement dynamic RLS, verify it with view-as for three different users, then promote the content from development to production through a pipeline.

rlsworkspacesdeployment pipelines
CAPSTONE · SCALE

Large model, short refresh window

Configure incremental refresh and a gateway against a large fact table, tune the model with aggregations, and cut a slow report page in half with Performance Analyzer evidence.

incremental refreshgatewayperformance
# ecosystem

The tools Power BI sits next to

Power Query
DAX
Excel
SQL Server
Azure Synapse
Microsoft Fabric
Azure Data Factory
Tabular Editor
DAX Studio
SharePoint
Dataverse
Power Automate

Who this is for

  • Data analysts building reports who want to move beyond drag-and-drop
  • Finance, operations and commercial analysts who own recurring reporting
  • BI developers modernising from a legacy reporting platform
  • Data engineers who build the warehouse and now need to model for consumption
  • Team leads responsible for report governance, security and refresh reliability
  • Excel power users taking on organisation-wide reporting responsibility

Pre-requisites

  • Comfortable with spreadsheets — formulas, pivot tables, lookups
  • Basic SQL: SELECT, WHERE, JOIN and GROUP BY
  • Understanding of your own business data — what a customer, order or transaction means
  • A machine that can run Power BI Desktop
  • A Power BI account with a workspace you can publish to, for the service modules
# pricing

Straightforward pricing

Every plan includes 1 year of full LMS access — not just this course, the entire DevOpsSchool LMS: 20+ courses, 50+ tools, videos, quizzes, assignments and projects.

Self-paced video

₹833/mo

Billed yearly at ₹9,996

Enroll now

1-on-1 mentorship

₹99,999

Full program, private instructor

Enroll 1-on-1

Corporate / private batch

8–30 engineers · custom agenda · onsite or online · PO and GST invoicing

Get a custom quote

Refunds. If we cancel or postpone a cohort, you get a full refund within 15 days. There is no money-back guarantee otherwise.

Terms. Course material remains licensed to the attendee. Read the terms.

Your data. We don't share it with third parties. Privacy policy.

Every attendee gets a verifiable certificate

  • Issued per attendee on completion
  • Verifiable at devopsschool.com/certificates
  • Hard copy available on request
  • Corporate batches receive an attendance and assessment report
DevOpsSchool

Power BI Training

Certificate of completion

# feedback

What engineers say

4.4 / 5 from 26 reviews on Trustpilot.

★★★★★
I took Terraform training with the tutor named Mithilesh. I requested to tailor the course curriculum for my needs. He did an excellent job of showing me how to write the Terraform script per the instructions provided.
jason smith · Trustpilot
★★★★★
My experience with the AIOps training was positive. The course covered important topics in a structured way, and Rajesh Kumar explained the concepts patiently. I found the practical aspects particularly helpful because they made the technical content easier to understand.
AARTI KUMARI · Trustpilot
★★★★★
I was looking to improve my understanding of AIOps, and this training helped me achieve that goal. Rajesh Kumar explained the subject in a structured and practical manner. The sessions on different AIOps concepts were informative.
Sonali Tiwari · Trustpilot
★★★★★
I recently did a SRE Session with Rajesh Kumar from DevOps School and the session was great. Right from 1st day till day 15, we had a very interactive session. Rajesh clarified our doubts and the tool demos were excellent without any hiccups. He simplified the concepts while sticking to the content with a fine balance between theory and practice. Am convinced he is one of the best trainers for SRE & DevOps concepts.
chandrasekaran j · Trustpilot
★★★★★
The Rundeck developer session was excellent and highly engaging. I appreciated how well the session was structured, with the theoretical concepts explained clearly and in simple terms. What stood out most to me was the demo — it was both informative and enjoyable. I especially liked how Rajesh walked us through not only the happy path but also the sad path, showcasing common issues and sharing practical troubleshooting tips.
Raimy Roy · Trustpilot
★★★★★
Rajesh's experience and knowledge are exceptional and we learnt invaluable practical knowledge which we can apply in our production environment. Incredibly friendly and gave us a fantastic insight both in-depth and at a high level of the Rundeck product.
Fire Titan · Trustpilot
# comparison

Why a named practitioner beats a marketplace listing

What mattersYouTube + blogsGeneric online courseFreelance marketplaceDevOpsSchool
Named practitionerNoRarelyVaries per bookingYes — same trainer each time
Production experienceUnknownUnknownUnverified20 years, named employers
Custom agendaNoNoSometimesBuilt from your stack
Onsite deliveryNoNoSometimesYes
Lab environmentNoneSandbox that expiresVariesYour own cloud — skill goes with you
AssessmentNoneQuizRarelyAssignments + capstone per module
Per-attendee certificatesNoSometimesRarelyYes
Corporate invoicingNoLimitedVariesPO and GST
Post-training supportNoneForum, time-limitedNoneLifetime forum access
# questions

Frequently asked

Can the agenda be customised for our stack?
Yes — that is the normal case for a private batch. We start with a discovery call, look at your data sources, warehouse, licensing tier and existing reports, and rebuild the module list around them. Examples then use your data shapes rather than a generic sample database.
Do you deliver onsite?
Yes. Private batches run onsite at your premises, live online, or hybrid. You provide the room and the engineers; we bring the trainer, agenda, labs, assessment and certificates.
What lab environment do we need?
Attendees need Power BI Desktop on their own machine and access to a workspace they can publish to. For the service and governance modules a trial or existing licence is enough. We walk everyone through setup on day one.
Do we need to know SQL or DAX before starting?
Basic SQL helps but is not essential. No DAX is assumed — the course builds it from filter context upward, which is the part that most self-taught users never get straight.
Can you use our own data instead of sample data?
Yes, and it makes the training substantially more useful. For private batches we prefer a sanitised extract of your real data so the model and measures attendees build are ones they can take back.
Does the course cover Microsoft Fabric?
It covers where Fabric fits — lakehouse storage, Direct Lake connectivity and how semantic models sit on top of it — at the level a Power BI practitioner needs. A full Fabric engineering course is a separate engagement.
Is this suitable for report consumers as well as builders?
The full course is aimed at builders. For consumers and business stakeholders we run a shorter one-day session on reading, filtering, subscribing to and correctly interpreting published reports, which can run alongside the main batch.
How long does a private Power BI batch take?
Typically three to five days. Power Query, modelling, DAX and report design fit in three; adding governance, row-level security, incremental refresh and performance tuning takes it to five.
What size are batches?
Private corporate batches run 8 to 30 engineers. Public Live & Interactive cohorts are capped at 10 so everyone gets time with the trainer.
Do attendees get a certificate?
Yes — every attendee receives a completion certificate, verifiable at devopsschool.com/certificates. Corporate batches also receive an attendance and assessment report.
What happens if someone misses a session?
Sessions are recorded and available in the LMS, and attendees keep LMS access for a year. For public cohorts, a missed session can be picked up in a later batch.
What is your refund position?
If we cancel or postpone a cohort, you receive a full refund within 15 days. There is no general money-back guarantee, and GST and gateway fees are not refunded.

Still deciding?

Tell us the team, the stack and the timeline. You'll get a straight answer, not a sales sequence.

Talk to an advisor
# ready when you are

Book a Power BI trainer — or ask a question first.

  • No spam, no drip sequence
  • Syllabus in 60 seconds
  • A human reply within one business day

Prefer to call or email?

More ways to reach us on the contact page.

Talk to an advisorRequest a quote