Creating, populating and reporting on Data Tables


Creating, populating and reporting on Data Tables

 in-brief-button

What is a Data Table?

So you want to have some simple fields to capture suggested KPIs across our process activities. You want to identify and categorize risks. You want to capture and note improvement opportunities or pain points in a structured way across many activities and multiple diagrams? and then report on that information…Whatever you want to capture to add structured information to your diagrams at the activity level – you can create a data table template, attach it and add a record.

Like a row in a spreadsheet attached to an activity box

Put another way: A Data Table is a set of records of structured information stored against any number of activities within a Map or multiple Maps. You can think of it like a ‘user definable row of information in a spreadsheet’. Each row is associated with a record, (a filled-in table), captured against an activity. You define what the title of each column is as the structure. Each time you add a record to an activity, it’s like adding another row to your spreadsheet. The difference is that the information contained in your Process Maps is automatically included in your ‘spreadsheet view’ and is relatable through reporting and can be filtered to give you powerful insights and perspectives on all the Process Related information you are capturing.

When you setup a data table, you define how you want the data entered. Back to the spreadsheet analogy, it’s like saying “the cell in this column is a pick-list from the following, the next cell is free text, the next one is a nested list, the next one is y/n option, the next one ….” and so on. You can even say which are mandatory to be filled in and which are optional.

Now you attach the empty Data Tables to whatever activities are appropriate within your Map. When relevant, you open the Data Table attachment, add a record which is now there like a filled in row on a spreadsheet containing information in the context of the activityu that the Data Table is attached to.

Now you can run reports across a scope of Diagrams within your map and generate useful, actionable process knowledge. Where are all our outstanding pain points and which activities do they relate to and who is responsible for those? Which activities have we identified that could be automated or enhanced by the latest new functionality in this Salesforce Release? Which parts of our business will be impacted by us merging 3 instances of Salesforce and need to have the new end to end processes included in UAT?

 

deep-dive-button

How can I start using Data Tables?

Each Personal, Team or Public Space in Elements contains a library of Data Table definitions. Think of them as ‘blank form templates’ for filling in that row in the spreadsheet. It’s up to you and your fellow Team members to create a library of blank template Data Tables. Once you have the Data Table library in the Team, you can attach a blank form  to any activity to provide fields to capture information about that activity. Once attached, you can add a record (fill in the form against that activity).

If you copy a Map to your Team that contains Data Tables, the associated Data Table will be added to your Team’s library – so you can easily get other useful Data Tables into your Team and copy ones you find useful to other Teams.

Data Table --Overview

Can you provide a simple example of using a Data Table?

Say you want to identify which activities have problems associated with them. It would be useful to know how severe the problems are, what type of impact (quality, time, cost, customer experience etc…).

So you could

  • create a Data Table (give it a title – here let’s say “Pain Points”)
  • Add some fields to the data table (here, text description of problem, then a drop down list of Severity ; low, medium, high, drop then the ‘type of impact’; quality, time, cost, customer experience etc…)
  • From now on, Anyone in the Space you created this Data Table in, can add it as an attachment to activity box (right click on an activity box, select attachment, data table, “Pain Points”)
  • Having added the Data Table, you then need to click on the attachment to “Add a record”
  • Once you have captured your Pain Points across the processes you’ve mapped, you can then report on  them. (for example: show me all activities with High Severity Pain Points. You can then filter by type of impact e.g. customer experience etc…)
Since you can create any custom structure and even extend it later, this simple concept provides  enormously powerful and comprehensive analytical capabilities by building relationships between specific activities within your Maps and structured metadata about those activities.

So what kinds of things do people use them for?

Pretty much anything! Capturing System Requirements for Salesforce.com, SAP, Workday etc, custom development, enbedding Lean Six Sigma tools and techniques into your process models, Identifying risks, highlighting and detailing business controls, identifying  improvement opportunities, process feedback, open issues, waste, risk, FMEA, VOC (Voice Of Customer), bottlenecks…etc. The list is limited only to what information it would be valuable to capture and make visible in the context of your Process Knowledge.

Clearly they can be used for adding almost any metadata into your process descriptions. The question is why and for what purpose. Used well, they can be very powerful – if in doubt contact us at success@elements.cloud to check out what you’re planning to use them for.

The Data Structure defines and configures the list of data and selectable options you want to capture in a Data Table. You can then attach the Data Table to any number of Activity Boxes. Any user that has access to the diagram can then click on the Data table which pops up a form to add a new structured record. The reports aggregate the data for a Data Table across all the Activity Boxes.

Creating Data Tables

Data Table Managers can create and edit Data Tables and report on the resulting Data Table relationships across your maps. Click here to see how to give someone ‘Data Table Manager’ rights

To create or edit a Data Table, Select the space and go to the Manage Spaces page by clicking on the Space name in the top bar or the ‘Manage space” button in the right panel of your selected Space on the Spaces page. You can then select ‘Data Tables’ from the left menu.

Click on New Data Table, to create a new one, or select an existing Data Table from the list and click onSwitch to Edit Mode.

Define the fields in the Data Table by dragging and dropping fields onto a form. The form is what end users use to add data. Once you have defined the Data Table, you can add Data Tables to Activities.

If you want to change the name of the Data Table you can do so in edit mode in the right hand panel. Simply edit the name.

Adding Data Tables to Activities

Attaching a Data Table is simple. Any Diagram editor can right mouse click on an Activity Box and attach the Data Table.

Populating Data Tables with records

Any user that has edit rights to a Diagram can click on the Activity Box paperclip, select the Data Table and add a data record using the form that was designed by the Data Table Manager.

Editing a Data Table Template – what happens to existing completed records?

For Instance, in the above example (Pain Points) – you might want to go back and edit the Data Table template after you have captured lots of Pain Point records, adding “Deadline to be addressed, Nominated owner, initiative name that will fix it, completed Y/N” etc… Every instance of that Data Table (i.e. those attached and filled in), would now have these additional fields. People could then fill in this additional information in the existing records and report on  subsequent progress.

Reporting on Data Tables across a map

You report on Data Table data by running the report from any diagram. You set the scope of the report – this diagram or this diagram and lower levels.  So to report on a map, you run the report from the top level diagram. You can filter and reorder columns in the reporting capability in Elements, or export the report to Excel as appropriate. See reporting for more detail

 

  • Was this article helpful ?

  •    

BACK TO HELP CENTER