Data Transformation — How to convert a single piece of data into a visual display of 16 elements

With data transformation, each piece of data or single cell might be decomposed into another layer. Amplify this approach even further by splitting your four cells into sixteen.

Therefore, see the chart below. We can now ask, generate, and record sixteen pieces of information on a large Post-It® for each assignment. Note how we take the four basic criteria below and expand them into four additional details (for illustrative purposes only). 

Other Best Practices articles instructed that one key to facilitating effective analysis mandates the facilitator to ask open-ended questions, not simple, close-ended (i.e., yes or no) confirmations. For example, and pardon the simplicity, do not ask “Does the sport of curling involve any sweat?” Someone will make a compelling argument that it does, albeit minimal perhaps. The superior question, simply re-phrased:  “To what extent does the sport of curling involve sweat? (a lot, little, or somewhere in between)”.

When building a roles and responsibilities matrix for example, the classic approach identifies who is going to be ‘Responsible’ for some apportioned activity or assignment, and the appropriate single cell is given a large, red “R”.  At minimum you might ask four questions, such as:

  1. What role will be responsible for this assignment? (e.g., Business Analyst)
  2. When will we reach completion? (e.g., date specific)
  3. How much financial resources will be required to complete it? (eg, $,$$$)
  4. What is the estimated FTE required to bring it to completion? (FTE = full-time equivalent, such as 0.25 which is one person, full-time, for three months)
Power of a Single Cell to Make Your Deliverables More Robust

Power of the Single Cell

  1. What role will be responsible for this assignment? (e.g., RASI Chart)

    1. What role is ultimately being held Accountable and paying for this initiative? (e.g., EVP)
    2. What role will be Responsible for this assignment? (e.g., Business Analyst)
    3. What roles will be Supporting this assignment? (e.g., Project Manager)
    4. What roles need to be Informed about this assignment? (e.g., Customer)

  2. At what estimated point in time will we reach completion? (e.g., date specific)

    1. When does concerted effort begin? (e.g., date specific)
    2. What is the projected halfway point? (e.g., date specific)
    3. At what estimated point in time will completion be final? (e.g., date specific)
    4. When will the effort be reviewed such as Retrospective or Look Back? (e.g., date specific)

  3. How much financial resources will be required to complete it? (eg, $,$$$)

    1. What are the estimated research costs? (e.g., $,$$$)
    2. What are the estimated acquisition costs? (e.g., $,$$$)
    3. What are the estimated operational costs? (e.g., $,$$$)
    4. What are the estimated termination costs? (e.g., $,$$$)

  4. What is the estimated FTP required to bring it to completion? (FTP = full-time person, such as 0.25 which is one person, full-time, for three months)

    1. What maximum number of people work at the same time? (e.g., Quantity)
    2. Call on which special subject matter experts? (e.g., Title[s])
    3. How much FTP will bring it to completion? (e.g., FTP)
    4. Codify any special issues not described above. (narrative, perhaps coded)

Having left a meeting can be comforting because the amount of detail described above is substantial, but knowing that it was consensually built and is now owned by the meeting participants is reassuring. When applied to a project plan, using questions similar to the ones shown above, you will deliver a more detailed GANTT chart than most people build in their cubicles alone. Hand this off to an intern who claims to be an “expert” with Microsoft Project Manager® and tell them to bring you back a full resource-allocated project plan so that you can go on to your next meeting.

______

Lead the Change—One Meeting at a Time

Are you ready to transform how decisions are made, problems are solved, and alignment is built in your organization?

True meeting leadership goes beyond setting an agenda. It requires a facilitator who can navigate complexity, balance voices, and drive toward outcomes with clarity and consensus. Our Professional Meeting Leadership Workshop and facilitation training equips you to do just that—blending human-centric methods with structured analytical tools to foster rigor, inclusivity, and results that stick.

  • Practice live.
  • Get expert feedback.
  • Build confidence that lasts.

Whether your meetings suffer from unclear objectives, disengaged participants, or decision fatigue, this workshop will help you identify the root causes, apply proven facilitation techniques, and emerge as the leader every team needs.

Take the first step today—transform your meetings and magnify your impact.

👉 Click here to reserve your seat now.

(Limited availability)

Because every meeting should be a catalyst for change—not just another calendar event.

______

And earn up to 40 professional development credits.

  • CDUs (IIBA)
  • CLPs (Federal Acquisition)
  • PDUs (SAVE International)
  • SEUs (Scrum Alliance)
  • 4.0 CEUs (General Professions)

______

With Bookmarks no longer a feature in WordPress, we provide the following for your benefit and reference.

______

Related video

Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.