Data and analytics · Free · ₹0
Power BI for Manufacturing: OEE and Production Dashboards
The no-code way out of the weekly Excel production report. Twelve modules take an engineer from opening Power BI Desktop for the first time to a shift-wise OEE dashboard: Power Query on downtime and production exports, a star schema a plant model can live in, the DAX behind availability, performance and quality, a downtime Pareto that ranks by lost minutes, reject rate by machine and shift, plan against actual, and the refresh, publishing and handover that keep it running after you.
Inside the course
From the lessons
What Power BI does on an engineer's desk
Chandoo
The same workflow, taught a second way
Learn Skills Daily
DAX: writing the measures
Chandoo
Report layout, tooltips and interaction
Chandoo
Downtime Pareto and reject analysis
Learn Skills Daily
Plan against actual: targets and variance
Chandoo
Lesson frames belong to the creators named in the Credits below and are shown from YouTube.
What you will learn
Load plant data from Excel, CSV and SQL with Power Query and write cleaning steps that rerun on next month's file; split a flat production sheet into a fact table and its dimensions and set the relationships correctly; write measures with SUM, DISTINCTCOUNT, DIVIDE and CALCULATE; calculate availability, performance, quality and OEE in DAX and defend the definitions you used; build a downtime Pareto, a reject-rate view and a machine-utilisation page; lay the report out so a plant head can read it on a phone; and set up refresh, publishing and a handover note so the dashboard survives your transfer.
- Clean a downtime or production export in Power Query with steps that rerun on next month's file
- Split a flat shift sheet into a star schema and set cardinality and filter direction correctly
- Write production measures in DAX with SUM, DISTINCTCOUNT, DIVIDE and CALCULATE
- Calculate availability, performance, quality and OEE, and say which loss each one hides
- Build a downtime Pareto ranked by lost minutes and a reject rate sliced by machine, shift and part
- Publish, schedule a refresh and write the handover note so the dashboard outlives you
Course content
13 modules · 19 lessons · 8h 24m
In order, at whatever pace suits you. Each module ends with a practice task that builds on the last, and a short quiz.
- 01What Power BI does on an engineer's desk2 lessons24m
- 02Your first report, start to finish1 lesson38m
- 03The same workflow, taught a second way1 lesson36m
- 04Power Query and the star schema3 lessons50m
- 05DAX: writing the measures1 lesson54m
- 06Choosing visuals a plant head can read2 lessons38m
- 07Report layout, tooltips and interaction2 lessons32m
- 08OEE: availability, performance and quality2 lessons42m
- 09Downtime Pareto and reject analysis1 lesson24m
- 10A full build watched end to end2 lessons1h 9m
- 11Plan against actual: targets and variance1 lesson55m
- 12Refresh, publish and hand over1 lesson43m
- 13Final assessment0 lessons0m
Requirements
- Who it is for
- Beginner. Comfort with Excel helps, no coding needed. Power BI Desktop is free but runs on Windows only.
- Software
- Power BI Desktop, a free download from Microsoft, Windows only. Excel for the sample files. Every module can be completed on Desktop alone, without a Power BI service licence.
- Hardware
- A Windows PC or laptop. Nothing on the plant side.
Power BI for Manufacturing: OEE and Production Dashboards at a glance
Power BI for Manufacturing: OEE and Production Dashboards is a free, self-paced online data and analytics course from EDWartens India with 13 modules, 8h 24m of video lessons, written notes, practice tasks and assessments, and an optional verifiable certificate.
- Price
- ₹0, free for good. No trial, no card. Comparable classroom training of this length costs about ₹4,999.
- Format
- 13 self-paced modules, 8h 24m of video, written notes, a quiz per module and a final assessment.
- Level
- Beginner. Beginner. Comfort with Excel helps, no coding needed. Power BI Desktop is free but runs on Windows only.
- Brand
- Vendor-neutral
- Software
- Power BI Desktop, a free download from Microsoft, Windows only. Excel for the sample files. Every module can be completed on Desktop alone, without a Power BI service licence.
- Hardware
- A Windows PC or laptop. Nothing on the plant side.
- Certificate
- Optional EDWartens Certificate of Completion, verifiable by code. Not a vendor credential.
- Video lessons by
- Chandoo, Learn Skills Daily (independent creators, credited below)
- Language
- English
A shareable EDWartens certificate
Finish every module and pass the final assessment, and the optional EDWartens certificate is yours. It carries a unique verification code on a public page anyone can check, so it stands up when a recruiter looks it up. See it below.
- Add it to your LinkedIn profile in one click
- Link it from a CV or portfolio, the URL is permanent
- Publicly verifiable by code, not a PDF anyone can edit
- Issued by EDWartens India, the training centre itself
The course itself stays free whether or not you ever buy one.
Stuck? Ask a practising engineer
A free course usually means a comment section and hope. This one does not. Every module has an Ask-your-trainer panel that reaches the same engineers who teach our paid programme: people who commission panels for a living, not moderators.
- Questions answered in the context of the module you are on
- The same engineers who teach the AEP programme
- Career tools, CV help and public job listings included
- Your progress and notes stay in your account for good
Pairs well with
PLC programming · FreeSiemens TIA PortalFrom zero electrical knowledge to a working, simulated S7-1200 program, for nothing.
PLC programming · FreeSiemens S7-1200 with TIA Portal: The Tutorial SeriesEvery S7-1200 instruction, one short video at a time: bits, edges, timers, counters, comparators, maths, MOVE, conversion, analog scaling, jumps and shift registers.
HMI · FreeSiemens TIA Portal HMI: KTP and Comfort Panels with WinCCEvery screen a plant operator touches, built in TIA Portal: tags, buttons, symbols, numeric input, bar graphs, navigation and templates, trends, alarms, recipes, faceplates, pop-ups, users and languages.
Process control · FreeSiemens TIA Portal PID Compact and Analog ProcessingClosed-loop control the way it is done on an S7-1200 or S7-1500: analog in, NORM_X and SCALE_X, PID_Compact configured, tuned and wired to an HMI, analog or PWM out, proved on a free tank simulation.Learner reviews
No reviews yet
Reviews here are written only by learners who have finished every module of Power BI for Manufacturing: OEE and Production Dashboards, and they are published exactly as written. Finish the course and yours will be the first.
Common questions
Is the course really free?
Yes. All twelve modules, the practice tasks, the notes and the assessments cost ₹0. You create an account so your progress is saved and the quizzes can be marked. The certificate is the only paid item, and only if you want one.
What certificate do I get?
An EDWartens Certificate of Completion, issued when you have finished every module and passed the final at 70 percent, with a verification code anyone can check. It is not a Microsoft credential and is never described as one.
Who made the video lessons?
Chandoo and Learn Skills Daily, on their own YouTube channels, credited at the foot of the course page. EDWartens did not make the videos and neither creator is affiliated with EDWartens. What EDWartens wrote is the study plan, the notes, the OEE material, the practice tasks and the assessments.
Do I need to buy Power BI?
No. Power BI Desktop is a free download from Microsoft and every module can be completed on it. Note that Desktop runs on Windows only, so a Mac needs Windows in a virtual machine. Publishing and sharing through the Power BI service needs a licence, which your employer usually already holds inside its Microsoft 365 tenant.
Is this the same as the Microsoft PL-300 certification?
No. PL-300 is Microsoft's paid exam and this course is neither that exam nor a substitute for it. It is preparation and practice: it covers Power Query, modelling, DAX and report design on manufacturing data, which is the same ground, but the certificate you receive is an EDWartens Certificate of Completion.
Do I need to know Python or SQL first?
No. This is the no-code route. If you can build a pivot table in Excel you have enough. The SQL and Python courses in the track sit beside this one, not before it.
What if my plant has no OEE data yet?
That is the normal starting point. The practice tasks are written for one machine and one shift on paper, so you can work through the whole course with a downtime register and a production log. The course also covers what to do when the reason codes are free text, which is the usual problem.
Who is it for?
Automation, maintenance, quality and production engineers who currently report in Excel, and anyone who has been asked to put the daily production numbers on a screen. The engineer who builds the OEE dashboard tends to become the one who presents it in the morning meeting.
What you walk away with
Your certificate for Power BI for Manufacturing: OEE and Production Dashboards
Finish the course, pass the final, and this is the document with your name on it.
Verifiable by anyone
A unique certificate number and a public verification page. A recruiter checks it in ten seconds.
Adds to LinkedIn in one click
Issuer, credential ID and URL prefilled, with 5 matching skills to pin to your profile.
QR code on the certificate
Scans straight to the verification page, so a printed copy proves itself.
Names what you can do
Lists the topics covered, from power query: loading and cleaning shift, downtime and production exports to downtime pareto, reject-rate analysis, report layout, refresh and publishing.
A permanent link
Put it on a CV, a portfolio or an application. The URL never changes.
Earned, not attended
Issued only after every module and a final assessment at 70%, with three attempts. That is why it stands up.
Learning is free. The certificate is optional.
Add it now and pay only when you have finished the course, or come back for it later. One-off, ₹459, GST included, with a receipt.
Issued by EDWartens India (Wartens Automation Private Limited) as a Certificate of Completion for this self-paced course. It is not a vendor certification, a university award or a CPD-accredited activity, and it does not certify competence on live equipment. Delivered electronically; see the refund policy.
Credits
Who made the video lessons
The video lessons in this course were created by the people below, not by EDWartens. Every lesson streams from its creator's own YouTube channel; EDWartens neither hosts nor sells that footage, and the creators are not affiliated with EDWartens and do not endorse this course. What EDWartens wrote is the study plan, the notes, the practice tasks and the assessments.
- Chandoothe getting-started and vocabulary lessons, Power Query, the star schema and data modelling, the DAX and Power Pivot examples, chart choice and the visuals masterclass, tooltip pages, and the three full dashboard builds
- Learn Skills Dailythe Power BI Full Course ladder, used as a second pass over the workflow and as the walkthrough beside the OEE, Pareto and reject-rate modules
If you are one of these creators and would like a lesson removed or credited differently, write to info@wartens.com.