I keep seeing organizations that try to use their data warehouse platforms as data hubs.\u00a0 While on the surface this might seem like a good idea, it really might not be depending on your utilization of each.\u00a0 The data warehouse serves primarily as a business intelligence and analytics tool.\u00a0 If implemented correctly, it contains vast amounts of data from many disparate HR sources and therefore, it\u2019s a good assumption that perhaps this might be used as the integration engine for HR as well.\u00a0 After all, HR usually has way too many interfaces sitting around requiring constant maintenance.\u00a0 If you could perform all integration out of a single platform rather than maintaining one of those octopus-like diagrams, all the better.<\/p>\n
The truth of the matter is that data warehouses are inherently bad at being data hubs.\u00a0 An essential part of the data warehouse is the ETL engine.\u00a0 ETL stands for Extract, Translate, Load, and it\u2019s the translate part that gives us problems.\u00a0 When the translations occur, what is actually happening (simplistically) is the data goes through a transformation so that when you report in the end stat of a data warehouse the data definitions are the same.\u00a0 The transformation is really an alteration of the data so that analytics are made simpler and possible at the same time.\u00a0 However, transformed data does not really work well for integration.<\/p>\n
Let\u2019s take salary grades as an example.\u00a0 When you do a global analysis of salaries, you would probably load in global employee salaries, currency conversion rates, and then perform a calculation to convert the data into the home currency.\u00a0 The report then might look at the distribution of salaries across several bands.\u00a0 These bands however, have been transformed into global bands as opposed to using the home country\u2019s salary grades.\u00a0 In many cases, the original salary grades may not have gotten into the data warehouse intact.\u00a0 (just an example I thought of off the top of my head).<\/p>\n
I would suggest that to be a true data hub, you would want to have the original data from the original system.\u00a0 Let\u2019s say that you need global employee data from many sources to load into a single global succession system.\u00a0 Not only will you be taking employee indicative data, but you\u2019ll want performance scores, education, goals, etc\u2026\u00a0 Once again, the problem with a data warehouse here is that performance scores in each country may utilize different rating scales, etc.\u00a0 The normalized data out of a data warehouse may not be suitable for the succession application depending on the decisions you make when you implement.<\/p>\n
The alternative is to use what is usually called the ODS, or the Operational Data Store.\u00a0 The ODS often exists within the DW application, but is a loading area (after the E in ETL, but before the TL).\u00a0 The ODS is not ideal because it\u2019s really just a storage tank before translation, but does hold untransformed data from all the systems.\u00a0 While not intended as an interface engine, its tables could be used for it (I suppose), but the actual transformed data tables are simply not appropriate for use as an interface engine in my opinion.<\/p>\n","protected":false},"excerpt":{"rendered":"
I keep seeing organizations that try to use their data warehouse platforms as data hubs.\u00a0 While on the surface this might seem like a good idea, it really might not be depending on your utilization of each.\u00a0 The data warehouse…<\/p>\n","protected":false},"author":1,"featured_media":0,"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,34],"tags":[],"class_list":["post-1068","post","type-post","status-publish","format-standard","hentry","category-data-metrics","category-hr-technology","category-implementation"],"_links":{"self":[{"href":"https:\/\/systematichr.com\/index.php?rest_route=\/wp\/v2\/posts\/1068","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=1068"}],"version-history":[{"count":1,"href":"https:\/\/systematichr.com\/index.php?rest_route=\/wp\/v2\/posts\/1068\/revisions"}],"predecessor-version":[{"id":1069,"href":"https:\/\/systematichr.com\/index.php?rest_route=\/wp\/v2\/posts\/1068\/revisions\/1069"}],"wp:attachment":[{"href":"https:\/\/systematichr.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/systematichr.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1068"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/systematichr.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}