Project Intelligence Framework
by BI DEVELOPMENT

Features › Technical specification

Feature · Technical specification

Only its author can read it. Now every developer can.

A Key User's Excel often holds the whole logic of a process. Project Intelligence Framework reads every formula and every value, and produces a review file the Key User corrects and signs, and a complete specification for the developers.

Project Intelligence Framework is in continuous development. Some features may work differently from what this film shows.

What the specification holds

The logic, laid out.

Inputs, tables and outputs

What the user enters, the reference tables used, and every result.

Calculations in plain language

Every formula, explained in a sentence the Key User can check.

Test cases

Today's values become mandatory test cases for the developer.

Inconsistencies

A value typed over a formula, a row calculated differently: flagged.

Questions

What the Excel cannot say is asked: of the Key User, and of the requester, from the output format to its recipients and timing.

For the developers

Current process, target solution with diagrams, data sources, calculation rules, output, test cases, open questions and effort drivers.

Days → 15 minto understand a complex request
Every formularead and explained in plain language
Today's valuesmandatory test cases for the developer

The result

  • The Key User needs no technical experience.
  • The developer gets everything needed to build it right.

What you need

  • A project with the governance document switched on
  • The Key User's Excel, in the project's Governance/Input folder
  • A Microsoft 365 work account

How to use it