Creating, populating and reporting on Data Tables
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?
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.
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…)
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 firstname.lastname@example.org 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. go to the Manage Spaces page and select Data Tables’ from the left menu. You can manage the space by clicking on the Space name in the top bar or the Manage button in the right panel on the page that lists all Spaces.
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
BACK TO HELP CENTER