{"id":11752,"date":"2022-10-01T09:14:41","date_gmt":"2022-10-01T00:14:41","guid":{"rendered":"https:\/\/prodskill.com\/?p=11752"},"modified":"2022-10-10T21:07:28","modified_gmt":"2022-10-10T12:07:28","slug":"data-standard-checker-1-overview","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/data-standard-checker-1-overview\/","title":{"rendered":"Data standard inspection tool_1.Overview"},"content":{"rendered":"<p>Introducing a data standard inspection tool that can be helpful for field DAs (Data Architects) who suffer from repetitive manual work in data standardization work. By reducing manual time, you can focus on more productive tasks and eliminate or reduce overtime.<\/p>\n\n\n\n<p>This tool was created with Excel VBA. (reference: <a href=\"https:\/\/prodskill.com\/en\/excel-vba-lecture-1-overview\/\">Excel VBA Course(1): Overview of Excel VBA<\/a>)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"1._\ub370\uc774\ud130_\ud45c\uc900\uc810\uac80_\ub3c4\uad6c_\uac1c\uc694\">1. Overview of Data Standards Check Tool<\/h2>\n\n\n\n<p>Data standardization, one of the tasks of a data architect, is quite a daunting task.<\/p>\n\n\n\n<p>Collect the current property name (logical name, physical name), data type, and length from the database table\/column comment, table definition, etc., separate the semantic unit into words, and bind columns with the same meaning to the same logical name, physical name, and data. The process of defining a single term with type and length requires many manual repetitions.<\/p>\n\n\n\n<p>(Note. This article does not explain the detailed concept of data standardization. Please refer to the URL below.)<br><a href=\"https:\/\/dataonair.or.kr\/db-tech-reference\/d-guide\/da-guide\/?mod=document&amp;uid=269\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/dataonair.or.kr\/db-tech-reference\/d-guide\/da-guide\/?mod=document&amp;uid=269<\/a><\/p>\n\n\n\n<p>Data standardization can be summarized as a process of reviewing basic dictionaries and current attribute names repeatedly, creating word\/term\/domain dictionaries in Excel sheets, and supplementing and finalizing them through review with standard managers.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image.png\"><img loading=\"lazy\" decoding=\"async\" width=\"671\" height=\"442\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image.png\" alt=\"\ub370\uc774\ud130 \ud45c\uc900\ud654 \uc791\uc5c5\uc758 \ud750\ub984 \uc694\uc57d\" class=\"wp-image-11753\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image.png 671w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-300x198.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-36x24.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-48x32.png 48w\" sizes=\"auto, (max-width: 671px) 100vw, 671px\" \/><\/a><figcaption>Data Standardization Workflow Summary<\/figcaption><\/figure>\n<\/div>\n\n\n<p>In this process, several detailed tasks are executed, such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Attribute logical name change<\/li><li>Change word physical name<\/li><li>Assignment\/deactivation of word attribute classifier<\/li><li>Specify domain classification name for attribute classifier<\/li><li>Register two (or more) words as compound words<\/li><li>Specify synonym relationships: make only one word canonical and other synonyms non-canonical<\/li><li>Change the domain&#039;s data type, length<\/li><li>etc\u2026<\/li><\/ul>\n\n\n\n<p>For the current property name and data type\/length, the above operations are repeated to 1) use standard words, 2) designate standard domains, and finally 3) make standard terms and standardize them.<\/p>\n\n\n\n<p>Most data architects (DAs) who perform data standardization work in the field are doing manual work using Excel. There are products of various companies for metadata management solutions that manage data standards, but most of these products focus on the function of managing the standard data dictionary after it is created rather than the function of creating a standard data dictionary.<\/p>\n\n\n\n<p>I also went through a lot of difficulties while performing data standardization work at various clients. In 2012, I first tried tooling, and I developed a tool with basic functions in April 2016 by constantly developing it in my spare time. The tool was developed using Excel VBA, and the screen is as follows.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"992\" height=\"588\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1.png\" alt=\"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c \ud654\uba74\" class=\"wp-image-11754\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1.png 992w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1-300x178.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1-768x455.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1-24x14.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1-36x21.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1-48x28.png 48w\" sizes=\"auto, (max-width: 992px) 100vw, 992px\" \/><\/a><figcaption>Data standard check tool screen<\/figcaption><\/figure>\n<\/div>\n\n\n<p>This tool can be found in the github repository below.<\/p>\n\n\n\n<p><a href=\"https:\/\/github.com\/DAToolset\/ToolsForDataStandard\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/github.com\/DAToolset\/ToolsForDataStandard<\/a><\/p>\n\n\n\n<p>Alternatively, you can download directly from this URL.<\/p>\n\n\n\n<p><a href=\"https:\/\/github.com\/DAToolset\/ToolsForDataStandard\/blob\/main\/%EC%86%8D%EC%84%B1%20%ED%91%9C%EC%A4%80%EC%A0%90%EA%B2%80%20%EB%8F%84%EA%B5%AC_v1.33_20210606_1.xlsm?raw=true\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/github.com\/DAToolset\/ToolsForDataStandard\/blob\/main\/Property standard check tool_v1.33_20210606_1.xlsm?raw=true<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>In the next article, we will take a look at the composition of the data standard dictionary and the standard checking function.<\/p>\n\n\n\n<p>&lt;&lt;&nbsp;<strong>List of related articles<\/strong>&nbsp;&gt;&gt;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/en\/data-standard-checker-1-overview\/\">Data standard inspection tool_1.Overview<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/data-standard-checker-2-ui-function-license\/\">Data standard inspection tool_2.1. Screen composition, 2.2. Standard inspection function<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/data-standard-checker-3-standard-dictionary\/\">Data standard inspection tool_2.3. Data standard dictionary composition<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/data-standard-checker-4-case-study\/\">Data Standard Check Tool_3. Standard Check Case Results<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/data-standard-checker-5-appendix\/\">Data standard check tool_4.Attachment<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/data-standard-checker-memory-error\/\">How to Fix Data Standard Check Tool_v1.33 Error \u201cNot enough memory\u201d<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/data-standard-checker-toc\/\">Data Standard Check Tool Description Contents , Download<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>Introducing a data standard inspection tool that can be helpful to DAs (Data Architects) in the field who suffer from repetitive manual work in data standardization work. By reducing manual time, you can focus on more productive tasks and eliminate or reduce overtime. This tool was created with Excel VBA. (See: Excel VBA...<\/p>","protected":false},"author":1,"featured_media":11753,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[17,73,113,114,115,116],"class_list":["post-11752","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-standard-checker","tag-vba","tag-excel-vba","tag-113","tag-114","tag-data-standard","tag-data-standard-check"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c_1.\uac1c\uc694 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\ub370\uc774\ud130 \ud45c\uc900\ud654 \uc5c5\ubb34\uc5d0\uc11c \ubc18\ubcf5\uc801\uc778 \uc218\uc791\uc5c5\uc73c\ub85c \uace0\uc0dd\ud558\ub294 \ud604\uc7a5\uc758 DA(Data Architect, \ub370\uc774\ud130 \uc544\ud0a4\ud14d\ud2b8)\uc5d0\uac8c \ub3c4\uc6c0\uc774 \ub420 \ub9cc\ud55c \ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c \ub97c \uc18c\uac1c\ud55c\ub2e4. \uc218\uc791\uc5c5 \uc2dc\uac04\uc744 \uc904\uc5ec \uc880 \ub354 \uc0dd\uc0b0\uc801\uc778 \uc5c5\ubb34\uc5d0 \uc9d1\uc911\ud558\uace0 \uc57c\uadfc\uc744 \uc5c6\uc560\uac70\ub098 \uc904\uc77c \uc218 \uc788\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/en\/data-standard-checker-1-overview\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c_1.\uac1c\uc694 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\ub370\uc774\ud130 \ud45c\uc900\ud654 \uc5c5\ubb34\uc5d0\uc11c \ubc18\ubcf5\uc801\uc778 \uc218\uc791\uc5c5\uc73c\ub85c \uace0\uc0dd\ud558\ub294 \ud604\uc7a5\uc758 DA(Data Architect, \ub370\uc774\ud130 \uc544\ud0a4\ud14d\ud2b8)\uc5d0\uac8c \ub3c4\uc6c0\uc774 \ub420 \ub9cc\ud55c \ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c \ub97c \uc18c\uac1c\ud55c\ub2e4. \uc218\uc791\uc5c5 \uc2dc\uac04\uc744 \uc904\uc5ec \uc880 \ub354 \uc0dd\uc0b0\uc801\uc778 \uc5c5\ubb34\uc5d0 \uc9d1\uc911\ud558\uace0 \uc57c\uadfc\uc744 \uc5c6\uc560\uac70\ub098 \uc904\uc77c \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/data-standard-checker-1-overview\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-01T00:14:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-10T12:07:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image.png\" \/>\n\t<meta property=\"og:image:width\" content=\"671\" \/>\n\t<meta property=\"og:image:height\" content=\"442\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-1-overview\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-1-overview\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c_1.\uac1c\uc694\",\"datePublished\":\"2022-10-01T00:14:41+00:00\",\"dateModified\":\"2022-10-10T12:07:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-1-overview\/\"},\"wordCount\":52,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-1-overview\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image.png\",\"keywords\":[\"\uc5d1\uc140VBA\",\"Excel VBA\",\"\ub370\uc774\ud130 \ud45c\uc900\",\"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80\",\"Data Standard\",\"Data Standard Check\"],\"articleSection\":[\"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/prodskill.com\/data-standard-checker-1-overview\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-1-overview\/\",\"url\":\"https:\/\/prodskill.com\/data-standard-checker-1-overview\/\",\"name\":\"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c_1.\uac1c\uc694 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-1-overview\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-1-overview\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image.png\",\"datePublished\":\"2022-10-01T00:14:41+00:00\",\"dateModified\":\"2022-10-10T12:07:28+00:00\",\"description\":\"\ub370\uc774\ud130 \ud45c\uc900\ud654 \uc5c5\ubb34\uc5d0\uc11c \ubc18\ubcf5\uc801\uc778 \uc218\uc791\uc5c5\uc73c\ub85c \uace0\uc0dd\ud558\ub294 \ud604\uc7a5\uc758 DA(Data Architect, \ub370\uc774\ud130 \uc544\ud0a4\ud14d\ud2b8)\uc5d0\uac8c \ub3c4\uc6c0\uc774 \ub420 \ub9cc\ud55c \ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c \ub97c \uc18c\uac1c\ud55c\ub2e4. \uc218\uc791\uc5c5 \uc2dc\uac04\uc744 \uc904\uc5ec \uc880 \ub354 \uc0dd\uc0b0\uc801\uc778 \uc5c5\ubb34\uc5d0 \uc9d1\uc911\ud558\uace0 \uc57c\uadfc\uc744 \uc5c6\uc560\uac70\ub098 \uc904\uc77c \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-1-overview\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/data-standard-checker-1-overview\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-1-overview\/#primaryimage\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image.png\",\"width\":671,\"height\":442},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prodskill.com\/data-standard-checker-1-overview\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prodskill.com\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c_1.\uac1c\uc694\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/prodskill.com\/ko\/#website\",\"url\":\"https:\/\/prodskill.com\/ko\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/prodskill.com\/ko\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\"},\"url\":\"https:\/\/prodskill.com\/en\/author\/proda\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data Standard Check Tool_1. Overview - Productivity Skill","description":"Introducing a data standard inspection tool that can be helpful for field DAs (Data Architects) who suffer from repetitive manual work in data standardization work. By reducing manual time, you can focus on more productive tasks and eliminate or reduce overtime.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prodskill.com\/en\/data-standard-checker-1-overview\/","og_locale":"en_US","og_type":"article","og_title":"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c_1.\uac1c\uc694 - \uc0dd\uc0b0\uc131 Skill","og_description":"\ub370\uc774\ud130 \ud45c\uc900\ud654 \uc5c5\ubb34\uc5d0\uc11c \ubc18\ubcf5\uc801\uc778 \uc218\uc791\uc5c5\uc73c\ub85c \uace0\uc0dd\ud558\ub294 \ud604\uc7a5\uc758 DA(Data Architect, \ub370\uc774\ud130 \uc544\ud0a4\ud14d\ud2b8)\uc5d0\uac8c \ub3c4\uc6c0\uc774 \ub420 \ub9cc\ud55c \ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c \ub97c \uc18c\uac1c\ud55c\ub2e4. \uc218\uc791\uc5c5 \uc2dc\uac04\uc744 \uc904\uc5ec \uc880 \ub354 \uc0dd\uc0b0\uc801\uc778 \uc5c5\ubb34\uc5d0 \uc9d1\uc911\ud558\uace0 \uc57c\uadfc\uc744 \uc5c6\uc560\uac70\ub098 \uc904\uc77c \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/data-standard-checker-1-overview\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-01T00:14:41+00:00","article_modified_time":"2022-10-10T12:07:28+00:00","og_image":[{"width":671,"height":442,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/data-standard-checker-1-overview\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/data-standard-checker-1-overview\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c_1.\uac1c\uc694","datePublished":"2022-10-01T00:14:41+00:00","dateModified":"2022-10-10T12:07:28+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/data-standard-checker-1-overview\/"},"wordCount":52,"commentCount":2,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/data-standard-checker-1-overview\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image.png","keywords":["\uc5d1\uc140VBA","Excel VBA","\ub370\uc774\ud130 \ud45c\uc900","\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80","Data Standard","Data Standard Check"],"articleSection":["\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/data-standard-checker-1-overview\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/data-standard-checker-1-overview\/","url":"https:\/\/prodskill.com\/data-standard-checker-1-overview\/","name":"Data Standard Check Tool_1. Overview - Productivity Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/data-standard-checker-1-overview\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/data-standard-checker-1-overview\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image.png","datePublished":"2022-10-01T00:14:41+00:00","dateModified":"2022-10-10T12:07:28+00:00","description":"Introducing a data standard inspection tool that can be helpful for field DAs (Data Architects) who suffer from repetitive manual work in data standardization work. By reducing manual time, you can focus on more productive tasks and eliminate or reduce overtime.","breadcrumb":{"@id":"https:\/\/prodskill.com\/data-standard-checker-1-overview\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/data-standard-checker-1-overview\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/data-standard-checker-1-overview\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image.png","width":671,"height":442},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/data-standard-checker-1-overview\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"\ub370\uc774\ud130 \ud45c\uc900\uc810\uac80 \ub3c4\uad6c_1.\uac1c\uc694"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"Productivity Skills","description":"Meta Thinking, Meta Working","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/en\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11752","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/comments?post=11752"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11752\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11753"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}