# Operational Center of Excellence

Each department files its numbers once a month, and leaders see one company scorecard with what needs attention.

When every department reports its month in its own spreadsheet, the monthly review spends its time finding the numbers instead of discussing them. At Acme Precision, Finance, Operations and Sales each file their month on an agreed scorecard by the 10th, and the review on the 15th reads one company score, the measures in the red, and an owner's note on every number that moved.

[Add it from the Marketplace](/tenant/?open=settings/marketplace)

## What it does

Each department registers what it measures and the balanced scorecard it is judged on. Once a month it files its numbers, by uploading its Excel data file or typing them in. Filing **freezes** the month: the numbers are kept with the scorecard version that scored them, lines that moved are flagged, and every department rolls up into one company score.

The module adds these pages under **Operational Center of Excellence** in the sidebar:

- **Overview**: the company scorecard for the month. The **Company score**, a card per department (its score, its four perspectives, **Submitted** or **Not submitted**, flags), **Measures below the yellow line**, **Flagged lines** with each owner's note, **Call-outs**, and **Submission status**.
- **Departments**: one department and month. A status strip, a tab per sub-department with every metric, **Scorecard** and **Call-outs** tabs, and **Charter**, **Download data file** and **Submit the month** at the top.
- **Call-outs**: everything departments want leadership to know, filtered by status, department and month.
- **Metric Definitions**: each department's metrics and the scorecard version in force, for people who set up the definitions.
- **Reports**: the platform's reports tab for the module.

Scores run from 0 at a measure's floor to 100 at its target. A perspective (**Financial**, **Customer**, **Internal process**, **Learning & growth**) is the average of its measures, a department the average of its four perspectives, and the company the average of its departments. **Green** is 90 or more, **Yellow** 70 or more, **Red** below 70.

## Set it up

A Workspace Admin does this first.

1. Open **Module Settings** from the ⋮ on the **Operational Center of Excellence** sidebar row. See [Module settings and versions](article:fb7c92e4-6dcc-4ef4-80bc-1b6e7482e540).
2. On **Preferences**, set **company_name** (shown on the Overview and in the data file's name), the Green and Yellow cut-offs (**band_green** 90, **band_yellow** 70), the **due_day** (10th), **lock_day** (12th) and **review_day** (15th) of the following month, and **require_flag_notes** (on: every flagged line needs an owner's note before the month can freeze).
3. On **Configuration**, review the six sample departments the module starts with (Finance & Accounting, Operations, Consulting, Sales, Service, Customer Service). Click **Edit** to change one, or untick it as active on its **Department** tab.
4. Click **New department** for each of your real departments, with the department head present (see below).
5. Give the permissions to your own roles. Only the standard Admin, Operator and Viewer roles get them automatically. See [Users and roles: create and edit roles](article:88d4e232-d5b8-4909-b452-cfe96d3d550f).
6. Open each department's **People** tab and click **Add member** (see below). A role alone reaches no department; people also need to be members.
7. Print each department's **Charter** for sign-off, and send each department its data file.

## Read the company scorecard

1. Open **Operational Center of Excellence**. It opens on **Overview**.
2. Pick the month at the top. **Refresh** reloads it.
3. Read the **Company score**, then each department's card: its score, its four perspectives, and whether the month is submitted.
4. Scroll to **Measures below the yellow line** and **Flagged lines**, which show each line's owner's note, then **Call-outs** and **Submission status**.
5. Click a department to open it.

People who can see every department see them all. Everyone else sees only the departments they are members of, and a member limited to some sub-departments sees only those sub-departments' lines, scored from those lines.

## Review a department's month

1. Open **Departments** and click a department, or click it on the **Overview**.
2. Pick the month in the header. The last 18 months are listed.
3. Read the status strip: **Frozen** or **Not submitted**, **Month locked**, how many lines are flagged and how many still need a note, blank KPIs, the scorecard version, and the due, lock and review dates.
4. Click a sub-department tab. Each metric shows **This month**, the **3-mo avg**, **Var %**, the **Flag** and the **Owner's note**. Click a metric's information icon to see how it is measured.
5. Click **Scorecard** for each measure's **Direction**, **Floor**, **Target**, **Actual**, **Score** and **Band**, and how the score is built.

## File the month by typing it in

1. On your department, click **Submit the month**.
2. Under **Or type the month in**, type each **Value**. Type percentages as points: `5.5` for 5.5%. Lines marked *calculated* are worked out for you.
3. Click **Recalculate** to see the score and flags. Nothing is saved yet.
4. Write an **Owner's note** on every flagged line (see below).
5. Click **Freeze the month**. A green line confirms the score and how many lines are flagged.

**Close** shuts the form without saving. If you are limited to some sub-departments, you see and file only your own lines.

## File the month from the data file

1. On your department, click **Download data file**. It is the department's Excel workbook, with earlier frozen months already filled in.
2. Fill in the month's column in Excel.
3. Click **Submit the month**, and drop the file on the upload area, or click it to choose the file. Only a `.xlsx` made by **Download data file** is accepted.
4. Read the report. **Errors** must be fixed in the file; **Warnings** and **Notes** are for information. Check the preview score and flags.
5. Write an owner's note on every flagged line. The file's numbers are also in the typing form, so you can correct one line there.
6. Click **Freeze the month**.

If the file reports a different month, the page moves to that month and tells you. Earlier months in the file that were never filed are filed too, so the three-month averages are right. **Choose a different file**, **Remove** or **Discard the file** throws the loaded file away.

## Explain a flagged line

A line is flagged when it moves further from its three-month average than its limit (10% unless the metric says otherwise), up or down. A big improvement flags too. Lines that have reached their target, or have no earlier month to compare with, don't flag.

1. After **Recalculate**, flagged lines without a note turn red and say *Required — this line is flagged, say why*.
2. Click **Go to the first one**.
3. Write one sentence in the **Owner's note**: what happened, and whether anything needs doing. "Two large orders shipped in the same week, so hours spiked; back to normal next month" is a note. "Increase vs prior period" is not.
4. Click **Freeze the month** when every flagged line has a note.

## Correct a month already filed

- **Before the lock day**: file it again. **Freeze the month** asks **Replace the frozen month?**; the new numbers replace the old, and the earlier filing stays on the record.
- **After the lock day**: the month is locked and **Freeze the month** is turned off. Ask whoever runs the module to unlock it or to file it for you.
- **Filed against the wrong department or month**: ask them to back the month out, then file it again.

## Raise a call-out

1. Open **Call-outs** and click **Raise a call-out**, or use **Raise a call-out** on a department's **Call-outs** tab.
2. Pick the **Department** and **Type**: **Event**, **Risk**, **Decision** or **Win**.
3. Fill **Metric line (optional)**, the **Action** you need, and the **Call-out**: what leadership needs to know, written for someone who hasn't seen your numbers.
4. Click **Raise**.

A call-out stays open, and shows on later months, until someone closes it. Department managers, people who see every department, and people who set up the definitions can **Edit**, **Mark reviewed**, **Close** and **Reopen** it. Filter the list by **Open**, **Closed** or **All statuses**, by department and by month.

## Print the department charter

1. On a department, click **Charter**.
2. Read it: what the department measures, how each number is defined, its targets, when the month is due, and the flag rule.
3. Click **Print or save as PDF** for the signed copy, or **Download the file** to keep it.

The charter is built from the department's own definitions, so the policy it signs and what the module scores can't drift apart.

## Set up a new department

1. Open **Module Settings → Configuration** and click **New department**. A five-step setup opens.
2. **Department**: **Name**, **Manager**, **Manager title**, **First scorecard month**, and **What this department is responsible for** (the charter's opening line). Click **Next**; this creates the department.
3. **Sub-departments**: the parts of the department and an owner for each. At least one.
4. **Metrics**: for each line, its name, part, **Unit**, flag limit, whether it is a **KPI**, how it is measured, what it tells us, and whether it is calculated.
5. **Scorecard**: **Perspective**, **Measure**, **Direction**, **Floor** and **Target**, at least one measure per perspective. Click **Save the scorecard**.
6. **Review**: **Open the department charter** or **Download the data template**, then **Finish**.

Until it files its first real month, the new department shows example numbers built from its own targets, marked *Loaded as example data*.

## Change a department's metrics and scorecard

1. On **Configuration**, click **Edit** on the department, or **Open** on **Metric Definitions**.
2. Use the tabs: **Department**, **Sub-departments**, **Metrics**, **Scorecard** and **People**.
3. On **Metrics**, click **Add a metric**, or edit or remove one. Editing a metric rescores the department's whole history; removing one keeps the values already frozen.
4. For new targets, open **Scorecard** and click **New version**, pick the month it starts, set the floors and targets, and save. Months already scored keep their version.

**Export the catalog** on **Metric Definitions** downloads every department's definitions as a file.

## Choose who reports for a department

1. Open the department's **People** tab and click **Add member**.
2. Pick **Who** and **What they can do**: **View** is always on; add **Submit the month**, and **Close call-outs** for a department manager.
3. Under **What they see**, tick sub-departments, or none for **The whole department**. A member limited to some sub-departments sees and files only those, on every page.
4. Save, then read the row's warnings. *Cannot open the module* means none of their roles carry a Center of Excellence permission; *Can open the module but not file the month* means their roles lack **Submit monthly numbers**.

Saving the list is all or nothing: if it fails, the department keeps the people it already had. Removing a member doesn't change anything already filed.

## Lock months and back one out

1. Open **Module Settings → Configuration**.
2. Under **Months and submissions**, pick a department and month and click **Show** to see every filing: when, by whom, from a file or typed, how many values, and *after lock* where it came in late.
3. In the months table, click **Lock** or **Unlock**. A month appears there once something is filed for it.
4. To clear a month filed against the wrong department or month, click **Back out** and confirm. **This cannot be undone.** For an ordinary correction, have the department file again.

Under **Catalog**, **Export** saves the definitions, **Import a catalog file** adds what the workspace doesn't have (it never rewrites an existing metric), and **Recompute every score** rescores every department and month after a definition change.

## Who can do what

Each action in the module needs a permission. A Workspace Admin gives permissions to roles; see [Users and roles: create and edit roles](article:88d4e232-d5b8-4909-b452-cfe96d3d550f). **Out of the box** shows the module's starting roles that have it.

| Permission | What it lets someone do | Out of the box |
|---|---|---|
| **View their departments' scorecards** | See the departments you are a member of: their metrics, scorecard, history and call-outs. | Admin, Operator, Viewer |
| **Submit monthly numbers** | Submit a month for a department you are a submitter or manager of: upload the data file, enter numbers, write flag notes, freeze the month. | Admin, Operator |
| **View every department** | See every department and the company roll-up (President, Finance, board); also unlocks the COE reporting datasets on platform dashboards. | Admin |
| **Set up departments, metrics and scorecards** | Register departments and sub-departments, edit metric definitions, create scorecard versions, lock and unlock periods, change a frozen month. **Give with care.** | Admin |
| **Manage members and configuration** | Manage department members and module configuration. **Give with care.** | Admin |
| **Raise a call-out** | Raise an executive call-out (event, risk, decision or win) for your department. | Admin, Operator, Viewer |

- Permissions say what someone can do; department membership says which departments it reaches. Both are needed, except for people who can view every department.
- Being named a department's manager gives no permission by itself.

## Good to know

- Filing, backing a month out, rescoring, importing a catalog, adding a department and saving a department's people each finish completely or change nothing.
- A locked month still opens, previews and recalculates. Only people who set up the definitions can freeze it.
- Next year's scorecard can't change last year's scores: each month keeps the version it was scored with. Editing a metric's definition does rescore history, so say so at the review.
- Some lines can be written automatically by another module. Their status says *Written by a connector*.
- People who can view every department can chart the module on dashboards from four datasets: metric scores, department scores, call-outs and monthly submissions. See [Dashboard](article:1d8a33a4-3a13-4874-b8e5-5ef9da22df95).
- The module has no assistant of its own. The workspace's AI chat suggests questions for it, such as "Which departments are in the red this month?" and "What call-outs are still open?".

## More help

Click **Help** at the top right of any page for the full reference: **Overview**, **Scores, flags and call-outs**, **Who can do what**, **Questions**, **What's new** and, for administrators, **Setup**. The module has no runbooks yet. See [Find and follow a runbook](article:4b62ad1f-577a-4998-8bce-f00226376522) for modules that have them.


Source: https://datavisions.ai/docs/module-guides/operational-center-of-excellence
