Creating and Uploading Capability Models

A capability model represents a set of capabilities defined and organized in a way, making easier to understand, assess, plan and monitor capabilities. CAMP includes a data model to define and organize any capability, and associated functionality to import/export and maintain the model.

The following diagram describes the two sides of the capability model.

The following two sections describe:

1. Defining the capability: The component model and methods for creating and maintaining the definition of the capability
2. Organizing capability models: Creating hierarchies i.e. organizing the set of capabilities into collections or point of views for navigation, communication and analysis

To import and export capability models in Excel spreadsheets, you need access to Utility page under Administration. To create or update the model on-line, you need edit access to Capability Model page under Portfolio menu.

If you don't see the above menu option, ask your administrator to add appropriate role to your account or add the above menu items to your current role.

Just like a project with work breakdown structures (WBS), an assembly with bill of material (BOM) or process with collection of activities and tasks, a capability is also defined as a collection of capability building blocks (CBBs). These capability building blocks are grouped into categories. Each capability building block is characterized along a maturity curve. Depending upon the scope, a capability building block may have one or more questions to assess the maturity. These questions can also be thought of as further breakdown of capability building blocks into set of questions.

In addition to describing the characteristics using CBBs along a maturity curve, the capability definition may also include implementation practices for achieving the desired level of maturity, and KPIs or metrics to measure and monitor performance and contribution of a capability.

The following components in the CAMP data model are used to define a capability.

The following components are OPTIONAL but recommended to enhance the body of knowledge about a capability. The additional information about the capability can help in identifying areas of improvements, identifying dependencies, quantifying value, monitoring performance and developing roadmaps.

The above information about a capability set can be added or updated in any order.

Both, batch (file-based) and on-line methods are available to create or update the information about a capability. All aspects of a capability can be exported and imported using Excel spreadsheet template. If a record already exists, it is updated.

The model relies upon certain reference data to appropriately classify, organize and leverage capability models. The default implementation includes basic setup of reference data. System Administrator can either use alias names for system-defined values or extend reference information with organization-specific items.

• Value Dial and Measure
  • Most likely, a capability maturity and importance measures are already defined as part of organization setup.
    Must have value dials and measures describing the maturity and importance levels. Without it, you won't be able to view the capability maturity model.
    
  • To create or edit value dials, go to “Value Dial” page under Reference from Administration menu.
    • Create a new value dial or edit an existing one with class = Maturity
    • Create a new value dial or edit an existing one with class = Importance
  • To create or edit maturity and importance measures for capability maturity model, go to “Measure” page under Reference from Administration menu.
    • Use the value dials created above to create maturity and importance measures.
    • To define maturity and importance levels, click on the arrow at the beginning of the record to open a form to create or edit measure scale.
• Entity Class And SubClass
  • Used for classify entities in the capability model e.g. capability set, capability class, capability, capability questions
  • Allows to navigate and filter capability models based on entity class and subsclass.
  • The pre-defined default value of “Capability Set” for entity class and “Capability Framework” for subclass may be sufficient.
  • Select these values when presented with the option of selecting entity class and subclass.
  • To change, go to “Entity Aliases” page under Reference from Administration menu. Update alias values for entity class CAPABILITYSET. (must be a system administrator to make changes)
• Capability Practice Class
  • Used to classify various practices. As a practice could pertain to any type of resource or activity to achieve a desired capability, it is good to classify and organize practices by practice class.
  • The pre-defined list of values are - people, process, technology, information, and financial. Use one of these values when defining a capability practice.
  • To change, go to “System Reference Data Aliases” page under Reference from Administration menu. Update alias values for object = CAPABILITYPRACTICE and attribute = CLASS
• Capability Document Category
  • Used to classify documents and links associated with a capability set into a handful of categories.
  • If you plan on storing documents or linking to external content or web pages, define a set of categories which can be used across all capability sets in the model.
  • To add or change, go to “Organization-specific Reference Data” page under Reference from Administration menu. Select object = CAPABILITYSET and attribute = DOCUMENTTYPE, and enter an unique name in the value field. Each name will appear as a document category choice when uploading or linking documents.
  • Update alias values for object = CAPABILITYPRACTICE and attribute = CLASS

CAMP currently uses a table-like structure to export and upload a capability model data. The template using fully qualifying names for reference fields and other attributes.

To download the template or current data, go to UTILITIES under Administration menu. Select “Capability Framework Models” under Export Data. The next panel of information gives you option to select one or more capability sets. Once you select at least one capability set, you will see the list of data you can export. Select all or the area you are interested in. Each item selected is a worksheet in the downloaded spreadsheet.

Add or edit records in the spreadsheet. Each worksheet is labels with system default name. You can name a copy or rename worksheet labels.

If you change an attribute which is part of a primary key e.g. name, it will create a new record with that name. You can make an existing record inactive by setting IsActive column to true. Inactive records are not included in the assessments or analysis. Use the on-line maintenance page to permanently delete the record.

If you want to use simple average when calculating maturity score, do not enter weights. For weighted average, enter appropriate weight between zero (0) and 100. System does not compute or check if the total weight across all items is 100. It is up to you to assign appropriate weight to each item.

To upload the data, go to UTILITIES under Administration menu. Select “Capability Framework Models” under Import Data. The next panel of will ask for the file name with the data you want to upload. Once the file is uploaded in the system, the next panel will show the list of data items you want to process. The worksheets with the system default names for automatically selected. If you have renamed the worksheet or want to use another worksheet, pick the worksheet from the drop-down list.

Upon successful processing, the system will produce an on-line report of number of records added or updated. If an error was encountered, the processing will stop and it will display the error message with the line number in the worksheet where problem was encountered. Most likely, either the reference data does not exist either due to typing error or reference record was not created. Once you fix the error, upload the file again and process it.

Create or maintain data using on-line forms.

Select PORTFOLIO menu to create or update

• Capability model
• Dependencies between capabilities
• Value measures related to a capability

Capability Model
Core Attributes: update abbreviation and description. Sent name field to display a more user-friendly name.
Capabilities: update capability class, capability building blocks and questions. Assign weight if necessary.
Maturity Model: update capability or question description at each level of maturity.
Practices: update list of practices, including outcomes and metrics.
Performance Measures: Link value dials and measures to the capability.
Scoring Performance Metrics: Manually enter measure data for associated metrics.

Dependencies
Select Provider: the “source” capability set. Navigate to select the capability set.
Select Consumer: the “recipient” capability set.
Load: display the capability model of the selected provider and consumer.

Click on the capability building block of the focus (consumer) capability to see the description and list of dependencies.

Drag and drop a maturity level from dependency capability table to box in Focus capability table. Add a comment on the nature or content of the dependency.

You may increase the width of the panel to see two tables side-by-side. Click the panel width or full screen options in the panel header to adjust the width.

Value Measures
Use it to create dependencies between measures and capability model.

Select Category: select the category of value dials and measures defined in the system. It is will display the list of measures in the selected category.
Select Object: Select the capability set.
Load: display the measures and the capability model of the selected capability set.

Drag and drop a measure to a box in Focus capability table. Add a comment on the nature or content of the dependency.

To manage, navigate, communicate, report or focus, we like to organize items into an hierarchy. Moreover, different stakeholders may want to view them differently thus requiring multiple hierarchies.

CAMP provides a simple, consistent yet flexible ways to organize capabilities into one or more hierarchies.

There are three parts or levels to an hierarchy.

1. Collection or category
   • Overall name for the hierarchy
   • Multiple collections. Each collection represents an hierarchy.
2. Domain
   • Top level in the collection.
   • One or more domains in a collection
   • A domain can belong to only one collection
3. Cluster
   • Second level in the collection
   • One or more clusters in domain
   • A cluster can only belong to one domain

A capability set may be associated with multiple clusters. In other words, same capability set can appear in multiple collections.

Both, batch (file-based) and on-line methods are available to create or update collections, domains and clusters. A complete hierarchy can be exported and imported using Excel spreadsheet template.

To download the template or current data, go to UTILITIES under Administration menu. Select “Organization Reference Information” under Export Data. If you happen to have access to more than one organization, next panel displays the list of organizations. Select an organization. Then select collections, domains and clusters to download.

Add or edit records in the spreadsheet. Each worksheet is labels with system default name. You can name a copy or rename worksheet labels.

If you change an attribute which is part of a primary key e.g. name, it will create a new record with that name. You can make an existing record inactive by setting IsActive column to true. Inactive records are not included in the display or navigation of the hierarchy. Use the on-line maintenance page to permanently delete the record.

To upload the data, go to UTILITIES under Administration menu. Select “Organization Reference Information” under Import Data. The next panel of will ask for the file name with the data you want to upload. Once the file is uploaded in the system, the next panel will show the list of data items you want to process. The worksheets with the system default names for automatically selected. If you have renamed the worksheet or want to use another worksheet, pick the worksheet from the drop-down list.

Upon successful processing, the system will produce an on-line report of number of records added or updated. If an error was encountered, the processing will stop and it will display the error message with the line number in the worksheet where problem was encountered. Most likely, either the reference data does not exist either due to typing error or reference record was not created. Once you fix the error, upload the file again and process it.

To create or update data using on-line forms, select Reference choice from Administration menu.

Use Collection, Domain and Cluster pages in the order to create hierarchy levels.

Use the default values for Entity Class and Subclass. Choose a color to used to for the background in heatmaps or wherever the hierarchy is used in data visualization. Set the default to true for the collection to be the default hierarchy in data visualization.

Once the collection, domain and cluster are defined, the capability sets can be linked to one or more clusters. You can use file-based import/export or on-line forms to add or edit clustering of capability sets.

Use the same method described about to import/export capability data. Select the cluster capability set option in import or export page to download or upload data.

Follow the same method for maintaining capability sets. Select Collection from the second panel to add or edit cluster membership.

• Capability Set - a collection of capabilities organized as a single unit for management communication, control, assessment and planning.
• Collection - a hierarchical organization of capability sets.