{"id":1785,"date":"2011-02-23T01:00:00","date_gmt":"2011-02-23T09:00:00","guid":{"rendered":"https:\/\/systematichr.com\/?p=1785"},"modified":"2011-02-05T17:58:53","modified_gmt":"2011-02-06T01:58:53","slug":"trend-drill-slice","status":"publish","type":"post","link":"https:\/\/systematichr.com\/?p=1785","title":{"rendered":"Trend, Drill, Slice"},"content":{"rendered":"

I love talking about and manipulating data.\u00a0 One of my favorite moments of the month is when I get together with one of the premier data people in HR and we just talk data for 30 minutes just for kicks.\u00a0 It\u2019s fun talking data with someone who gets data, but often, we\u2019re not really doing that.\u00a0 The number of really high quality data people in HR seems to be rather low.\u00a0 In fact, it\u2019s really quite problematic that we can\u2019t find enough people to fun our analytics engines that have a great depth in HR functionality and an understanding of how analytics works.\u00a0 I was working with a Fortune 100 company very recently where their top HR analytics person globally did not have any real idea how a data warehouse worked.\u00a0 Unfortunately, we seem to have started pulling in the best we have, which means a functionally good person, but not technically.\u00a0 I have seen some organizations start pulling in great data people from outside of HR, but they are obviously hampered by their lack of functional understanding.<\/p>\n

When we talk about analytics and a super-user, it\u2019s nice if we can assume there is a good grounding in HR.\u00a0 If we also think about how a data warehouse works, I think we can simplify analytics core capabilities in 3 easy concepts that I\u2019ll call\u00a0 trending, drilling and slicing.\u00a0 These are all based on a data mart or what is also called a star schema.\u00a0 I won\u2019t go into the technical details, but it enables the trending, drilling and slicing that sets OLAP analytics apart from operational reporting.\u00a0 Here\u2019s a quick and simple primer of how the technology can be used in functional terms.<\/p>\n

    \n
  1. Trending:\u00a0 Time is pretty much a standard dimension in the fact\/dimension schema in a data mart.\u00a0 Trending is the simplest concept and it simply allows the ability to easily look backwards in time whether it\u2019s in daily, weekly, monthly, quarterly, or annual chunks.\u00a0 Theoretically, you should even be able to take a graph report that is has an annualized trend and click on any year to see the representative quarters or months within that year.\u00a0 But that\u2019s part of the next concept, drilling.<\/li>\n
  2. Drilling: Drilling can really be done for any dimension represented in the schema.\u00a0 You can take the example above where we drill into smaller and smaller chunks of time, but the most commonly used form of drilling is through the organizational model.\u00a0 Let\u2019s say you\u2019re looking at a simple turnover report by division \u2013 you should be able to click on any division and see the layer below (say regions), and then click any of those and see the next layer of departments.\u00a0 You could even drill based on the people manager hierarchy if that works better.\u00a0 Either way, drilling means the ability to simply reveal a lower (or higher) level of detail.<\/li>\n
  3. Slicing: The ability to cut data based on ad hoc parameters is also one of the wonderful things about OLPA analytics.\u00a0 Let\u2019s say you\u2019re looking at that same turnover report and you find that one particular division has a particularly high turnover rate.\u00a0 In order to diagnose what is going on, you decide to run several slices of turnover within that division.\u00a0 The first is turnover by job, second by average hours of training by employee, third by compa-ratio, and lastly by engagement scores.\u00a0 Being able to easily view your data by slicing data with alternative data views is what allows us to be smart \u2013 it lets us diagnose, but you can also see the applications for decision support.\u00a0 In a similar vein, lets say you wanted to know what the contributors of low turnover are, you could simply run the same analysis backwards.<\/li>\n<\/ol>\n

    You can see the problem with analytics.\u00a0 The number of HR people that can translate data from a technical standpoint and understand HR functionally are actually pretty few.\u00a0 However, we are getting to the point where vendors are automatically bundling in great analytics tools with their applications or where our enterprises are getting around to implementing data warehouse solutions for HR (now that they are done with finance and operations).\u00a0 The problem is that we\u2019ve always been functional and we have not necessarily invested in creating the capability we will need to be powerful decision support contributors.\u00a0 If you don\u2019t have the tools now, you\u2019re going to have them very soon \u2013 don\u2019t assume the tools will do it all for you \u2013 you still need the right people.<\/p>\n","protected":false},"excerpt":{"rendered":"

    I love talking about and manipulating data.\u00a0 One of my favorite moments of the month is when I get together with one of the premier data people in HR and we just talk data for 30 minutes just for kicks.\u00a0…<\/p>\n","protected":false},"author":1,"featured_media":1807,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"categories":[27,2,16],"tags":[186,185,281,280,282,242],"class_list":["post-1785","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-metrics","category-hr-technology","category-workforce-planning","tag-data-mart","tag-data-warehouse","tag-drilling","tag-olap","tag-slicing","tag-trending"],"_links":{"self":[{"href":"https:\/\/systematichr.com\/index.php?rest_route=\/wp\/v2\/posts\/1785","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/systematichr.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/systematichr.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/systematichr.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/systematichr.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1785"}],"version-history":[{"count":1,"href":"https:\/\/systematichr.com\/index.php?rest_route=\/wp\/v2\/posts\/1785\/revisions"}],"predecessor-version":[{"id":1808,"href":"https:\/\/systematichr.com\/index.php?rest_route=\/wp\/v2\/posts\/1785\/revisions\/1808"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/systematichr.com\/index.php?rest_route=\/wp\/v2\/media\/1807"}],"wp:attachment":[{"href":"https:\/\/systematichr.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/systematichr.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/systematichr.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}