{"id":118,"date":"2012-06-01T16:07:05","date_gmt":"2012-06-02T00:07:05","guid":{"rendered":"http:\/\/awaconsulting.ca\/?p=118"},"modified":"2013-02-21T20:07:33","modified_gmt":"2013-02-22T04:07:33","slug":"presenting-data-entity-relationships","status":"publish","type":"post","link":"http:\/\/awaconsulting.ca\/?p=118","title":{"rendered":"Presenting data: entity relationships"},"content":{"rendered":"

Very, very few business units operate in complete isolation within a company.\u00a0\u00a0 (If they do, I suspect they are close to being closed down or sold.)\u00a0\u00a0\u00a0 Thus, to truly develop an impact assessment of what will happen when a given business unit (BU) halts operations, it is really important to understand the web of dependencies within which the business unit operates.<\/p>\n

The way I explain this concept is to talk about a flow of data or products.\u00a0\u00a0 In essence, there are those \u201cupstream\u201d and \u201cdownstream\u201d of the BU.\u00a0\u00a0 Those \u201cupstream\u201d are those providing the BU with needed input (data or product) and are the BU\u2019s suppliers who the BU will yell at if the input stops arriving.\u00a0\u00a0 Those \u201cdownstream\u201d are those consuming the output of the BU and are stakeholders who will be yelling at the BU if it fails to deliver that output.<\/p>\n

Using a payroll department as a simple example: one of the suppliers will be those providing the number of hours worked by employees and one of the stakeholders would be the employees.\u00a0\u00a0 Without the hours worked the payroll department cannot calculate the appropriate pay for the employees.\u00a0\u00a0 If the employees are not paid, you can be very sure it won\u2019t take long before they will be yelling at the payroll department about it.\u00a0\u00a0 This is turn, is likely to add motivation (if nothing else) to the payroll department\u2019s yelling at those failing to provide the critical numbers.<\/p>\n

During your BIA process you will have determined the BU\u2019s stakeholders and suppliers.\u00a0\u00a0 These \u201cother entities\u201d can be inside the company (e.g., the payroll area of the finance department) or they can be external (e.g., the company that hosts your corporate web site).\u00a0\u00a0 Taken together, this is a very wide range of options and so I prefer to use the term \u201centity\u201d when talking about the business units.\u00a0\u00a0 Further, these entities can vary in size from a team within another operational area to an entire independent company to your entire client base.\u00a0\u00a0 They can also vary in importance from \u201cnice-to-have\u201d to \u201cmust-keep-happy-at-all-costs\u201d.<\/p>\n

The basic aims of your data collection are to:
\n1. identify the entities,
\n2. determine whether they are stakeholders or suppliers,
\n3. determine their importance,
\n4. determine how quickly the \u201cflow\u201d needs to resume,
\n5. and, of course, what it is that is needed or supplied.<\/p>\n

Reporting this information for a single BU can be a challenge.\u00a0\u00a0 Reporting it for multiple BUs (e.g., a division) or for the entire company is even more of a challenge.\u00a0\u00a0 An approach I\u2019ve found to be useful is to map the information out with nodes representing the various entities and connecting lines depicting the relationships.<\/p>\n

Depending on what you wish to emphasise, you can then play with various options such as using different colours for nodes to represent internal\/external entities, line thickness to represent the criticality of the relationship.\u00a0\u00a0 Deciding how to do this is something of an art and you may find it necessary to use different options for different audiences.\u00a0\u00a0 Some people may prefer to see criticality, others want to see resumption windows, etc.<\/p>\n

\"\"<\/a>

Example of an entity relationship map<\/p><\/div>\n

In the attached stakeholder graphic (which uses dummy data), I\u2019ve used colour to indicate the type of entity, filled circles to indicate entities and yellow-filled boxes to indicate departments.\u00a0\u00a0 As you can see, this map shows us that “DivA_Dept1” (upper left corner) has identified a feedback loop and provides output to only the “Clients” and “CCA” stakeholders.\u00a0\u00a0 On the other hand, “DivB_Dept8” (bottom middle) has a great many stakeholders.<\/p>\n

There are, of course, many alternative options.\u00a0\u00a0 Let your inner information artist free!<\/p>\n","protected":false},"excerpt":{"rendered":"

Very, very few business units operate in complete isolation within a company.\u00a0\u00a0 (If they do, I suspect they are close to being closed down or sold.)\u00a0\u00a0\u00a0 Thus, to truly develop an impact assessment of what will happen when a given business unit (BU) halts operations, it is really important to understand the web of dependencies within which the business unit operates. The way I explain this concept is to talk about a flow of data or products.\u00a0\u00a0 In essence, there are those \u201cupstream\u201d and \u201cdownstream\u201d of the BU.\u00a0\u00a0 Those \u201cupstream\u201d are those providing the BU with needed input (data or product) and are the BU\u2019s suppliers who the BU will … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"gallery","meta":[],"categories":[7,3],"tags":[8,10],"_links":{"self":[{"href":"http:\/\/awaconsulting.ca\/index.php?rest_route=\/wp\/v2\/posts\/118"}],"collection":[{"href":"http:\/\/awaconsulting.ca\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/awaconsulting.ca\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/awaconsulting.ca\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/awaconsulting.ca\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=118"}],"version-history":[{"count":12,"href":"http:\/\/awaconsulting.ca\/index.php?rest_route=\/wp\/v2\/posts\/118\/revisions"}],"predecessor-version":[{"id":140,"href":"http:\/\/awaconsulting.ca\/index.php?rest_route=\/wp\/v2\/posts\/118\/revisions\/140"}],"wp:attachment":[{"href":"http:\/\/awaconsulting.ca\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/awaconsulting.ca\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=118"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/awaconsulting.ca\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}