Skip to main content

Training Completion by Course (Chart)

The Training Completion by Course Chart is an out-of-the-box SharePoint chart for learning and compliance teams who need completion rates in front of employees rather than buried in a learning platform. The data is a two-column dataset of course and completion rate, and the Chart web part - the AI-powered chart web part in SharePoint - draws it as a donut with the courses ranked beside it and an average completion figure underneath. The gap between the best and worst course is the whole point of the page.
Author
SharePoint Maven
Built with
Web Parts
Chart
Features
Copilot in SharePoint
Keywords
Compliance, Training
Category
Dashboards

Want one like this?

Talk to Greg
  • Donut chart rendering completion rate by course, one of the thirteen chart forms the Chart web part can draw
  • A ranked percentage legend beside the ring and an average completion footnote beneath it, both generated from the same prompt
  • Percentage formatting carried through the legend and applied by the web part rather than configured
  • A muted earth-tone palette holding six categories apart without shouting, produced by asking for it – styling here is a conversation, not a property pane
  • The whole visual described in plain language in a chat on the page, with follow-up prompts to add data, change the look, or undo a step
  • Roughly thirteen chart forms available – bar, line, pie, donut, area, scatter, histogram, heatmap, funnel, sankey, gauge and more – so the shape follows the question rather than the tool
  • Authoring needs a Microsoft 365 Copilot license while readers need none, and the chart holds its data as a snapshot that is refreshed by asking
  • Names the courses people are avoiding, which is the only part of a compliance report anyone acts on
  • Puts the program average and the per-course detail together, so a healthy headline cannot hide a weak course
  • Makes the 37-point spread between the best and worst course impossible to miss
  • Sits on an intranet page where employees already are, which does more for completion rates than another reminder email
  • Takes minutes to build, because the chart is described in words rather than configured field by field
  • Needs no Power BI workspace, no gateway, and no report developer
  • Republished on a schedule that suits the audit cycle, without anyone rebuilding the visual
  • Chart Types: Donut chart
What is this training completion chart built with?

The Chart web part, the AI-powered chart web part that sits under the AI category in the SharePoint web part toolbox. The donut, the ranked percentage legend, and the average completion line all come from a plain-language prompt rather than a property pane. There is no learning-analytics add-on to buy and nothing to license beyond Microsoft 365 and a Copilot seat for whoever builds it – the kind of reporting Greg Zelfond builds for compliance teams.

What does the training completion by course chart show?

Six courses ranked by completion rate: Security Awareness 94 percent, Data Privacy 88 percent, Microsoft 365 Basics 81 percent, Records Management 76 percent, Copilot Fundamentals 68 percent, and Accessibility Standards 57 percent. The donut carries the relative sizes, the legend carries the exact rates, and a footnote gives the program average of 77.3 percent.

Where does the chart data come from?

A two-column dataset of course name and completion rate, held in a file the web part reads when the chart is created. The Chart web part does not bind to a SharePoint list, and it does not connect to a learning platform; it takes the numbers it is given and draws them.

Does the chart refresh automatically when the numbers change?

No. The Chart web part holds its data as a snapshot, so editing the source file does not redraw the chart on its own – you ask the web part to refresh the data and republish the page. Completion rates are usually reported monthly or quarterly, so a refreshed snapshot fits that cycle. When a live-refreshing view is the requirement instead, the classic Quick Chart web part can point straight at a SharePoint list, and Power BI handles scheduled refresh.

Should we use the Chart web part, a Copilot dashboard, or Power BI?

It depends on how much you need. The Chart web part is the quickest way to put one good-looking chart on a page, described in a sentence and styled by asking. A Copilot-generated dashboard suits a full page with filters and several linked charts that move together. Power BI earns its place when data volumes are large, sources need joining, or row-level security and scheduled refresh matter.

Can Greg build this chart for our organization?

Yes – this is exactly the kind of work Greg Zelfond does. As an independent SharePoint consultant and Microsoft MVP, he shapes the underlying data so the chart is worth drawing, picks the visual that answers the question your leadership actually asks, and puts it on a page your employees already visit. Reach out through the contact page.

Donut Chart for Training Completion by Course
Donut Chart for Training Completion by Course