Your Dataset Is Certified. The Room Still Asks for the Excel

The workspace shows a certified badge. The endorsement looks official.

Someone in the QBR still asks for “the file.” Not because they hate Power BI. Because the certified dataset does not answer the question they already trust Excel to answer.

Endorsement is not trust. Trust is completeness, ownership, and a measure the room can defend.

Badges do not create belief

Mid-market manufacturers certify datasets to stop the wild west. That instinct is right. The failure mode is certifying a partial product: wrong grain for the decision, missing measures finance needs, and no named steward who will stand up in the room.

Leaders go back to the workbook they believe. Adoption slides while governance slides look green. This is the same pattern as we paid for Power BI and people still email Excel—except now the badge makes the miss look like user stubbornness instead of product gaps.

Certified versus wild west is a promotion path, not a sticker. If the certified model cannot say the sentence for revenue, margin, or on-hand at the grain the meeting uses, the room will invent a twin.

Why certified still loses to the spreadsheet

The grain is incomplete. The model stops at plant when the decision is line or customer. Excel still has the cut.

Measures the room cares about are missing or renamed. “Net revenue” in the badge does not match the controller’s exclusion list. See measures nobody can explain.

There is no steward in the meeting. The author left. The badge stayed. Nobody can change or defend the number—same ownership hole as who can change a measure.

Refresh and as-of are fuzzy. The workbook has a timestamp someone typed. The certified page is silent. Silence loses to a dated tab.

Late adjustments live only in the file. Ops fixed a shipment in Excel. The certified model never saw it. Certification without a path for corrections teaches people to keep the side ledger.

The costs of badge-without-trust

1. Dual systems become permanent. Certified for “official.” Excel for “real.” Every close reconciles both. The badge accelerated politics, not clarity.

2. Executives learn to ignore endorsement. After one confident wrong certified total, the ribbon means nothing. Future certifications start underwater.

3. Shadow measures multiply. Analysts export and rebuild logic offline. The semantic model is the product only if people use it. Forks recreate five Revenues under a certified roof.

4. Stewards become ticket routers. Without authority to demote or complete the model, ownership is a mailbox. The room still Slack-asks for the file.

5. Close time shifts to archaeology. Controllers spend hours proving which certified tile matches which Excel column. Month-end becomes a scavenger hunt.

6. Ops stand-ups fragment. Plant managers print or paste from the workbook because the certified app lacks scrap reason or shift grain. The floor leaves the product.

7. Governance theater spreads. Teams chase badge counts. Completeness, grain, and steward presence never make the scorecard. Metrics improve. Trust does not.

8. Change requests go to the wrong artifact. Leaders ask for “one more column in the Excel.” The certified model never gets the requirement. Debt compounds in the shadow system.

How to fix it: certify a product the room can use

1. Write the decision sentence before you certify. What question does this dataset answer at what grain on what calendar? If you cannot say it in one breath, do not endorse it. Certification without a sentence is costume jewelry.

2. Inventory the Excel the room still opens. List the cuts, measures, and as-of stamps people trust. Map each to the certified model. Gaps become the backlog—not “adoption training.”

3. Name a steward who attends the meeting. Not a distribution list. A person who will defend the measure, accept change requests, and demote the badge when trust breaks. Put the name on the dataset description and the close contacts.

4. Complete the grain the decision needs. If the QBR argues customer margin, ship customer grain—or explicitly certify a coarser number and stop pretending. Partial grain with a full badge is how Excel wins.

5. Publish the measure dictionary next to the badge. Inclusions, exclusions, currency, and calendar. Link from the app. When measures cannot be explained, certification should wait.

6. Put as-of and quality on the page. “Books as of 5:40 a.m. Reconciled to GL control.” Compete with the workbook’s handwritten timestamp. Pair with refresh succeeded, data still wrong gates so the badge is not green over garbage.

7. Define a correction path. How late adjustments enter the model before the next pack. If the only path is “fix it in Excel,” you certified a museum piece.

8. Demote loudly when the contract breaks. Missing steward, broken grain, or repeated Excel overrides should remove endorsement. Wild west rules need a reverse gear.

9. Retire the competing file on a schedule. After three closes where the certified model matches the decision, archive the old workbook with a redirect note. Do not leave dual truth “for convenience.”

10. Measure trust, not badge count. Track how often the room still requests the file for certified subjects. That is your real KPI. Falling requests mean certification worked. Flat requests mean you endorsed a hollow product.

What good looks like

The certified dataset answers the meeting’s first five questions at the right grain. The steward is in the room or on call. As-of is visible. Excel for that subject is archived or clearly labeled unofficial.

People still export for analysis. They stop treating a side workbook as the books. The badge means a contract kept—not a sticker applied.

Make certification a promotion, not a favor

Authors will ask to certify because the report is popular. Popularity is not readiness.

Require steward, sentence, grain checklist, measure dictionary, refresh SLA, and a retirement plan for the Excel twin. Same bar every time. Exceptions get a date and an owner, not a quiet badge.

When certification is earned, the room feels it. When it is granted as a favor, the room keeps the file.

Start with one certified subject

Pick the subject that still generates the Excel ask—often revenue, inventory, or scrap. Complete grain and measures. Put the steward on the invite. Run one close without the twin.

Document what still failed. Fix those before you stamp five more datasets. Breadth without trust multiplies badges and spreadsheets together.

Leaders should ask: “If we hid the Excel tomorrow, could this certified model run the meeting?” If the honest answer is no, the badge is early.

Executive takeaway

Certification does not create trust. Completeness, a named steward, and measures the room can defend do.

Stop counting badges. Close the grain gaps. Put ownership in the meeting. Retire the file when the product earns it. Then endorsement means something an executive can believe.

Need a hard look at why certified datasets still lose to Excel in your close or QBR? Contact Alluvium. We will map the Excel asks to model gaps, steward coverage, and the promotion bar that makes certification stick.