{"id":16593,"date":"2024-11-21T20:09:16","date_gmt":"2024-11-21T11:09:16","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/?p=16593"},"modified":"2025-08-18T18:48:26","modified_gmt":"2025-08-18T09:48:26","slug":"%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/","title":{"rendered":"\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c YoY (Year-over-Year) \uad6c\ud604\ud558\uae30: \ube45\ucffc\ub9ac\ub97c \uc751\uc6a9\ud55c \ube44\uad50"},"content":{"rendered":"<div class=\"wp-block-aioseo-table-of-contents\"><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-1\">1. \ube45\ucffc\ub9ac \ub370\uc774\ud130 \uc18c\uc2a4 \uc0dd\uc131<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2\">2. \ucc28\ud2b8 \ucd94\uac00<\/a><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-1\">2.1 \uc2dc\uacc4\uc5f4 \ucc28\ud2b8<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-2\">2.2 \ud45c \ucc28\ud2b8<\/a><\/li><\/ul><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\">\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice\n\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/a><\/li><\/ul><\/div>\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c YoY (Year-over-Year)\ub97c \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 \uae30\ubcf8 \uae30\ub2a5\uc73c\ub85c \uad6c\ud604\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">YoY (Year-over-Year)\ub294 \ud55c \uc5f0\ub3c4\uc758 \ud2b9\uc815 \uae30\uac04\uc744 1\ub144 \uc804 \uac19\uc740 \uae30\uac04\uacfc \ube44\uad50\ud558\uc5ec \uc131\uc7a5\ub960\uc774\ub098 \uc131\uacfc \ubcc0\ud654\ub97c \ub098\ud0c0\ub0b4\ub294 \ubd84\uc11d \uc9c0\ud45c\ub85c, \uc8fc\ub85c \uae30\uc5c5\uc758 \ub9e4\ucd9c\uc774\ub098 \uc774\uc775\uacfc \uac19\uc740 \uc8fc\uc694 \uc2e4\uc801\uc744 \ud655\uc778\ud560 \ub54c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud558\uc9c0\ub9cc \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \ud45c \ucc28\ud2b8\uc758 \ube44\uad50 \uae30\ub2a5\uc740 \ube44\uad50 \uae30\uac04\uc758 \uac12\uc744 \ud45c\uc2dc\ud560 \uc218 \uc5c6\uace0 \uc99d\uac10\uc561\uacfc \uc99d\uac10\ub960\ub85c\ub9cc \ud45c\uc2dc\ud574\uc57c \ud55c\ub2e4\ub294 \ub2e8\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc804\ub144\ub3c4\uc758 \uac12\uc744 \ud655\uc778\ud558\ub824\uba74 \uc544\ub798\uc640 \uac19\uc774 2\uac1c\uc758 \ucc28\ud2b8\ub97c \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"714\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-7-2-1024x714.png\" alt=\"\" class=\"wp-image-16595\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-7-2-1024x714.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-7-2-300x209.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-7-2-768x536.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-7-2.png 1320w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 \uae30\ubcf8 \ube44\uad50 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\uc5ec YoY (Year-over-Year)\ub97c \uad6c\ud604\ud55c \ub300\uc2dc\ubcf4\ub4dc<\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\ud83d\udca1\uc624\ub298 \ub2e4\ub8e8\ub294 \ub300\uc2dc\ubcf4\ub4dc\uc758 \uae30\ubcf8 \ud654\uba74\uc740 \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \uc0dd\uc131\ud588\ub358 \ub300\uc2dc\ubcf4\ub4dc\uc785\ub2c8\ub2e4. \uacfc\uc815\uacfc \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uc2dc\ub824\uba74 \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\ub97c \uba3c\uc800 \uc77d\uc5b4\ubcf4\uc2dc\uae38 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%ea%b8%b0%eb%b3%b8-%eb%b9%84%ea%b5%90-%ea%b8%b0%eb%8a%a5\/\" target=\"_blank\" rel=\"noopener\" title=\"\">\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c YoY (Year-over-Year) \uad6c\ud604\ud558\uae30: \uae30\ubcf8 \ube44\uad50 \uae30\ub2a5<\/a><\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud558\uc9c0\ub9cc \ube45\ucffc\ub9ac SQL\uc744 \uc0ac\uc6a9\ud558\uba74 \uc120\ud0dd \uae30\uac04\uacfc \ube44\uad50 \uae30\uac04\uc758 \ub9e4\ucd9c, \uc99d\uac10\uc561, \uc99d\uac10\ub960\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \ud558\ub098\uc758 \ucc28\ud2b8\uc5d0 \ub2f4\uc544 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub354 \uae54\ub054\ud558\uc9c0\uc694?<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"726\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-8-2-1024x726.png\" alt=\"\" class=\"wp-image-16596\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-8-2-1024x726.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-8-2-300x213.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-8-2-768x544.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-8-2-1536x1088.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-8-2.png 1898w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\uc624\ub298\uc740 \ube45\ucffc\ub9ac SQL\uc744 \uc0ac\uc6a9\ud558\uc5ec YoY (Year-over-Year)\ub97c \uad6c\ud604\ud558\uace0, \uc120\ud0dd \uc5f0\ub3c4\uc640 \uc804\ub144\ub3c4\uc758 \ub9e4\ucd9c, \uc99d\uac10\uc561\uacfc \uc99d\uac10\ub960\uae4c\uc9c0 \ud558\ub098\uc758 \ucc28\ud2b8\uc5d0\uc11c \ubcf4\uc5ec\uc8fc\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud558\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-1\">1. \ube45\ucffc\ub9ac \ub370\uc774\ud130 \uc18c\uc2a4 \uc0dd\uc131<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\uc608\uc2dc\uc5d0\uc11c \uc0ac\uc6a9\ud560 \ube45\ucffc\ub9ac \uc2a4\ud0a4\ub9c8\uc758 \uad6c\uc870\ub97c \ub2e4\uc2dc \uc0b4\ud3b4\ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \ucffc\ub9ac\uc5d0\uc11c\ub294 \ud544\uc694\ud55c \uc5f4\ub9cc \uc120\ud0dd\ud558\uc5ec \uc0ac\uc6a9\ud560 \uac83\uc785\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"344\" height=\"456\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-9-2.png\" alt=\"\" class=\"wp-image-16597\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-9-2.png 344w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-9-2-226x300.png 226w\" sizes=\"auto, (max-width: 344px) 100vw, 344px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><br>\uba3c\uc800 \uc9c4\ud589\ud560 \uc791\uc5c5\uc740 \uc0ac\uc804 \uc124\uc815\uc744 \uc704\ud55c \ucffc\ub9ac\ub97c \uc791\uc131\ud558\uc5ec \ube45\ucffc\ub9ac\uc758 \ubdf0 (View)\ub85c \uc800\uc7a5\ud558\uace0 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\ub97c \uc704\ud55c \ud14c\uc774\ube14\uc744 \uc138\ud305\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \ucffc\ub9ac\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>--1. \uc6d4\ubcc4 \ub370\uc774\ud130 \uc9d1\uacc4\nWITH sales_data AS (\n    SELECT \n        shopName,\n        item,\n        color,\n        location,\n        channel,\n        PARSE_DATE('%Y-%m-%d', FORMAT_DATE('%Y-%m-01', salesDate)) AS thisMonth,\n        SUM(revenue) AS revenueSum\n    FROM \n        `autoofficeshare.commerce_sample.LS_salesData`  \n    GROUP BY \n        shopName, item, color, location, channel, thisMonth\n   \n),\n\n--2. \uc9d1\uacc4\ub41c \ub370\uc774\ud130\ub85c 1\ub144\uc804 \ub370\uc774\ud130 \ub9e4\uce6d\njoin_data AS (\nSELECT \n    COALESCE(L.shopName, R.shopName) AS shopName, \n    COALESCE(L.item, R.item) AS item,\n    COALESCE(L.color, R.color) AS color,\n    COALESCE(L.location, R.location) AS location,\n    COALESCE(L.channel, R.channel) AS channel,\n    COALESCE(L.thisMonth, DATE_ADD(R.thisMonth, INTERVAL 12 MONTH)) AS thisMonth,\n    COALESCE(DATE_SUB(L.thisMonth, INTERVAL 12 MONTH), R.thisMonth) AS compareMonth,\n    COALESCE(L.revenueSum, 0) AS thisMonthRevenue, --\uc62c\ud574 \ub9e4\ucd9c\n    COALESCE(R.revenueSum, 0) AS compareMonthRevenue, --\uc804\ub144\ub3c4 \ub9e4\ucd9c\n    COALESCE(L.revenueSum, 0) - COALESCE(R.revenueSum, 0) AS monthDiffRevenue, \n\nFROM \n    sales_data AS L\nFULL OUTER JOIN \n    sales_data AS R\nON \nL.shopName = R.shopName\n    AND L.item = R.item\n    AND L.color = R.color\n    AND L.location = R.location\n    AND L.channel = R.channel\n    AND L.thisMonth = DATE_ADD(R.thisMonth, INTERVAL 12 MONTH) --1\ub144\uc804\uacfc \ub370\uc774\ud130\uc640 \ub9e4\uce6d\n)\n\n--3. \ubc18\uae30, \ubd84\uae30, \uc6d4\ubcc4 \ubc84\ud2bc\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud55c \uc5f4 \ucd94\uac00\nSELECT \n  J.*,\n  EXTRACT(YEAR FROM J.thisMonth) as year,\n  EXTRACT(MONTH FROM J.thisMonth) as month,\n  CASE \n    WHEN EXTRACT(MONTH FROM J.thisMonth) in (1,2,3,4,5,6) THEN '\uc0c1\ubc18\uae30'\n    WHEN EXTRACT(MONTH FROM J.thisMonth) in (7,8,9,10,11,12) THEN '\ud558\ubc18\uae30' \n  END as half,\n  CASE \n    WHEN EXTRACT(MONTH FROM J.thisMonth) in (1,2,3) THEN '1\ubd84\uae30'\n    WHEN EXTRACT(MONTH FROM J.thisMonth) in (4,5,6) THEN '2\ubd84\uae30'\n    WHEN EXTRACT(MONTH FROM J.thisMonth) in (7,8,9) THEN '3\ubd84\uae30'\n    WHEN EXTRACT(MONTH FROM J.thisMonth) in (10,11,12) THEN '4\ubd84\uae30'\n  END as quarter\n FROM join_data AS J\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>sales_data(CTE):<\/strong> \uc774 \ucffc\ub9ac\ub294 \uc6d0\ubcf8 \ub370\uc774\ud130\uc5d0\uc11c \uc6d4\ubcc4 \ub9e4\ucd9c\uc744 \uc9d1\uacc4\ud569\ub2c8\ub2e4. thisMonth \uc5f4\uc740 \ud310\ub9e4 \uc6d4\uc758 \uccab\ub0a0\ub85c \ubcc0\ud658\ud558\uc5ec \uc6d4 \ub2e8\uc704\ub85c \uadf8\ub8f9\ud654\ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \uc6d4\ubcc4 \ub9e4\ucd9c\uc744 \uac01\uac01 \ud569\uc0b0\ud569\ub2c8\ub2e4. \ucd5c\uc885\uc801\uc73c\ub85c\ub294 \uac70\ub798\ucc98\uba85, \ud488\ubaa9\uba85, \uc0c9\uc0c1, \ud310\ub9e4\uc9c0\uc5ed, \ud310\ub9e4\ucc44\ub110\uc744 \uae30\uc900\uc73c\ub85c \uadf8\ub8f9\ud654\ud558\uc5ec \ub9e4\ucd9c\uc744 \uc9d1\uacc4\ud569\ub2c8\ub2e4.<br><br><\/li>\n\n\n\n<li><strong>join_data(CTE):<\/strong> FULL OUTER JOIN\uc758 \uc870\uac74\uc73c\ub85c \ud604\uc7ac \uc6d4\uacfc 1\ub144 \uc804 \ub3d9\uc6d4\uc758 \ub370\uc774\ud130\ub97c \uc870\uc778\ud569\ub2c8\ub2e4. thisMonthRevenue, compareMonthRevenue \uc5f4\uc744 \ud1b5\ud574 \ud604\uc7ac \uc6d4\uacfc \ube44\uad50 \uc6d4\uc758 \ub9e4\ucd9c\uc744 \uac01\uac01 \uac00\uc838\uc635\ub2c8\ub2e4. monthDiffRevenue\ub294 \ub9e4\ucd9c\uc758 \uc804\ub144\ub300\ube44 \ucc28\uc774\ub97c \uacc4\uc0b0\ud569\ub2c8\ub2e4.<br><br><\/li>\n\n\n\n<li>\ucd5c\uc885 \ucffc\ub9ac\ub294 \ud544\ud130\ub9c1 \ubc84\ud2bc\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud574 \uc5f0\ub3c4, \ubc18\uae30, \ubd84\uae30, \uc6d4\uc744 \uac01\uac01\uc758 \ub2e8\uc704\ub85c \uad6c\ubd84\ud55c \uac83\uc785\ub2c8\ub2e4. \uc774\ub807\uac8c \uae30\uac04 \ub2e8\uc704\uc758 \uc5f4\uc744 \ucd94\uac00\ud558\uba74 \ubc84\ud2bc \ud544\ud130 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\uc5ec \ucc28\ud2b8\uc5d0 \ub098\uc628 \uae30\uac04\uc744 \uac04\ub2e8\ud788 \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br><\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774\ub807\uac8c SELECT\ud55c \ucffc\ub9ac\ub97c \ud65c\uc6a9\ud558\uae30 \uc704\ud574\uc11c \ubdf0(View)\ub97c \ub9cc\ub4e4\uc5b4 \uc90d\ub2c8\ub2e4. \ubdf0(View)\ub294 \ubb3c\ub9ac\uc801\uc778 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc9c0 \uc54a\uace0\ub3c4 \ucffc\ub9ac\uc758 \uacb0\uacfc\ub97c \ub370\uc774\ud130\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uac00\uc0c1\uc758 \ud14c\uc774\ube14\uc785\ub2c8\ub2e4. \uc2e4\uc81c \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uc9c0 \uc54a\uace0 \ub370\uc774\ud130\ub97c \ud638\ucd9c\ud560 \ub54c\uc5d0 \uc815\uc758\ub41c \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\uc5ec \ucd5c\uc2e0 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\ud83d\udca1\ube45\ucffc\ub9ac \ubdf0(View) \uae30\ub2a5\uc5d0 \ub300\ud574\uc11c \uc790\uc138\ud788 \uc54c\uc544\ubcf4\ub824\uba74 \ub2e4\uc74c\uc758 \uacf5\uc2dd \ub808\ud37c\ub7f0\uc2a4\ub97c \ucc38\uc870\ud574\uc8fc\uc138\uc694.<\/p>\n<\/blockquote>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full is-resized\"><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/views-intro?hl=ko\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"392\" height=\"129\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/Google-1.png\" alt=\"\" class=\"wp-image-16598\" style=\"width:252px;height:auto\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/Google-1.png 392w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/Google-1-300x99.png 300w\" sizes=\"auto, (max-width: 392px) 100vw, 392px\" \/><\/a><figcaption class=\"wp-element-caption\"><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/views-intro?hl=ko\" target=\"_blank\" rel=\"noopener\" title=\"\">\ubdf0 \uc18c\uac1c &nbsp;|&nbsp; BigQuery &nbsp;|&nbsp; Google Cloud<\/a><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><br><br><br><br><br><br><br><br>\uc0c1\ub2e8\uc758 \u2018<strong>\uc800\uc7a5<\/strong>\u2019 \u2192 \u2018<strong>\ubdf0 \uc800\uc7a5<\/strong>\u2019 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"730\" height=\"525\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-10-2.png\" alt=\"\" class=\"wp-image-16599\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-10-2.png 730w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-10-2-300x216.png 300w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\ub2e4\uc74c \ud654\uba74\uc774 \ub098\uc624\uba74 \ub370\uc774\ud130 \uc138\ud2b8\ub97c \uc120\ud0dd\ud55c \ub4a4\uc5d0 \ubdf0 \ud14c\uc774\ube14\uba85\uc744 \uc791\uc131\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"927\" height=\"412\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-11-2.png\" alt=\"\" class=\"wp-image-16600\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-11-2.png 927w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-11-2-300x133.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-11-2-768x341.png 768w\" sizes=\"auto, (max-width: 927px) 100vw, 927px\" \/><figcaption class=\"wp-element-caption\">\ubdf0 \ud14c\uc774\ube14\uc774\ub77c\ub294 \uac83\uc744 \uad6c\ubd84\ud558\uae30 \uc704\ud574\uc11c \ubdf0(View)\ub97c \uc758\ubbf8\ud558\ub294 \u2018V_\u2019\ub97c \uc55e\uc5d0 \ubd99\uc5ec\uc8fc\uc5c8\uc2b5\ub2c8\ub2e4.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u2018\uc800\uc7a5\u2019<\/strong> \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba74 \ud0d0\uc0c9\uae30\uc5d0 \ubdf0(View) \ud14c\uc774\ube14\uc774 \ucd94\uac00\ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"286\" height=\"178\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-12-2.png\" alt=\"\" class=\"wp-image-16601\" style=\"width:412px;height:auto\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><br>\ubdf0(View)\ub97c \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c \ubd88\ub7ec\uc62c \uc218\ub3c4 \uc788\uc9c0\ub9cc, BI \uc5d4\uc9c4\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c \ubb3c\ub9ac\uc801\uc778 \ud14c\uc774\ube14\uc744 \ub9cc\ub4dc\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4. \ubdf0(View) \uacb0\uacfc\ub97c \ubb3c\ub9ac\uc801\uc778 \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud558\ub294 \ucffc\ub9ac\ub97c \uc791\uc131\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE OR REPLACE TABLE `autoofficeshare.commerce_sample.LS_salesCompare` AS \nSELECT * FROM `autoofficeshare.commerce_sample.V_salesCompare`<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><mark style=\"background-color:#dddddd\" class=\"has-inline-color\">CREATE OR REPLACE TABLE<\/mark> \uad6c\ubb38\uc740 \uc9c0\uc815\ub41c \uc774\ub984\uc758 \ud14c\uc774\ube14\uc774 \uc5c6\ub2e4\uba74 LS_salesCompare \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\uace0, \uc774\ubbf8 \uc874\uc7ac\ud558\uba74 \uae30\uc874 \ud14c\uc774\ube14\uc744 \ub36e\uc5b4\uc4f0\uae30 \ud569\ub2c8\ub2e4.<br><\/li>\n\n\n\n<li>\uc774 \ucf54\ub4dc\ub294 V_salesCompare\ub97c SELECT\ud558\uace0 \uc788\uc73c\ubbc0\ub85c \ucffc\ub9ac\uac00 \uc2e4\ud589\ub420 \ub54c\ub9c8\ub2e4 \ucd5c\uc2e0 \ub370\uc774\ud130\ub97c \ubd88\ub7ec\uc640\uc11c LS_salesCompare \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud569\ub2c8\ub2e4.<br><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\uc774 \ucffc\ub9ac\ub97c \uc608\uc57d\ud558\uba74 \uc8fc\uae30\uc801\uc73c\ub85c \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0 \ucd5c\uc2e0 \ub370\uc774\ud130\ub97c \uac00\uc838\uc624\uac8c \ub429\ub2c8\ub2e4. \ucffc\ub9ac\ub97c \uc608\uc57d\ud558\ub294 \ubc29\ubc95\uc740 \uc544\ub798 \uad6c\uae00 \uacf5\uc2dd \ub808\ud37c\ub7f0\uc2a4\uc640 \uc624\ud1a0\uc624\ud53c\uc2a4\uc5d0\uc11c\ub3c4 \ub2e4\ub8e8\uace0 \uc788\uc73c\ub2c8 \ucc38\uc870\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full is-resized\"><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/scheduling-queries?hl=ko\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"392\" height=\"129\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/Google-2.png\" alt=\"\" class=\"wp-image-16602\" style=\"width:286px;height:auto\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/Google-2.png 392w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/Google-2-300x99.png 300w\" sizes=\"auto, (max-width: 392px) 100vw, 392px\" \/><\/a><figcaption class=\"wp-element-caption\"><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/scheduling-queries?hl=ko\" target=\"_blank\" rel=\"noopener\" title=\"\">\ucffc\ub9ac \uc608\uc57d &nbsp;|&nbsp; BigQuery &nbsp;|&nbsp; Google Cloud<\/a><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><br><br><br><br><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2024\/02\/06\/%eb%b9%85%ec%bf%bc%eb%a6%ac%ec%97%90%ec%84%9c-%ec%bf%bc%eb%a6%ac-%ec%98%88%ec%95%bd%ec%9c%bc%eb%a1%9c-%ec%a3%bc%ea%b8%b0%ec%a0%81%ec%9c%bc%eb%a1%9c-%ec%8b%a0%ea%b7%9c-%eb%8d%b0%ec%9d%b4%ed%84%b0\/\" target=\"_blank\" rel=\"noopener\" title=\"\">\ube45\ucffc\ub9ac\uc5d0\uc11c \ucffc\ub9ac \uc608\uc57d\uc73c\ub85c \uc8fc\uae30\uc801\uc73c\ub85c \uc2e0\uaddc \ub370\uc774\ud130 \uac31\uc2e0\ud558\uae30<\/a><br><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ube45\ucffc\ub9ac \ud14c\uc774\ube14\uc744 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0 \uc5f0\uacb0 \ud6c4 \ucd5c\uc885\uc801\uc73c\ub85c \uc544\ub798\uc640 \uac19\uc740 \ud544\ub4dc \ubaa9\ub85d\uc744 \ubd88\ub7ec\uc654\uc2b5\ub2c8\ub2e4. \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 \uae30\ubcf8 \ube44\uad50 \uae30\ub2a5\uacfc \ub2e4\ub978 \uc810\uc740, <span style=\"text-decoration: underline;\"><strong>\ube45\ucffc\ub9ac\uc5d0\uc11c \uc804\ub144\ub3c4 \ub9e4\ucd9c\uacfc \uc99d\uac10 \ub9e4\ucd9c\uc744 \uc9d1\uacc4\ud654\ud558\ub294 \uac00\uacf5 \uacfc\uc815\uc744 \uac70\ucce4\ub2e4\ub294 \uac83\uc774\uc9c0\uc694<\/strong>.<\/span> \uc774\ub807\uac8c \ub9e4\ucd9c\uacfc \uc804\ub144\ub3c4 \ub9e4\ucd9c\uc744 \uac01\uac01\uc758 \ud56d\ubaa9 \ucc98\ub9ac\ud558\uba74 \ubcf4\ub2e4 \uc0c1\uc138\ud55c \ub370\uc774\ud130\ub4e4\uc744 \ud558\ub098\uc758 \ucc28\ud2b8\uc5d0\uc11c \uad6c\ud604\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"360\" height=\"369\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-13-2.png\" alt=\"\" class=\"wp-image-16603\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-13-2.png 360w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-13-2-293x300.png 293w\" sizes=\"auto, (max-width: 360px) 100vw, 360px\" \/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-2\"><br>2. \ucc28\ud2b8 \ucd94\uac00<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-2-1\">2.1 \uc2dc\uacc4\uc5f4 \ucc28\ud2b8<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\uc774\uc81c \uc2dc\uacc4\uc5f4 \ucc28\ud2b8\ub97c \ucd94\uac00\ud55c \ub4a4, <strong><span style=\"text-decoration: underline;\">\uce21\uc815 \ud56d\ubaa9\uc5d0 \ub9e4\ucd9c\uacfc \uc804\ub144\ub3c4 \ub9e4\ucd9c\uc744 \ub123\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4.<\/span><\/strong> \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \uc5f0\ub3c4\ub97c \uc124\uc815\ud558\ub294 2\uac00\uc9c0 \ubc29\ubc95\uc774 \uc788\uc2b5\ub2c8\ub2e4.<br><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong><span style=\"text-decoration: underline;\">\uc5f0\ub3c4 \ud544\ud130\ub97c \uc0ac\uc6a9<\/span><\/strong><\/li>\n\n\n\n<li><strong><span style=\"text-decoration: underline;\">\uae30\ubcf8 \uae30\uac04\uc744 \u2018\uc62c\ud574\u2019\ub85c \uc124\uc815<\/span><\/strong><\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\uae30\ubcf8 \uae30\uac04\uc744 \uc124\uc815\ud558\uba74 \ub370\uc774\ud130\ub294 \uc62c\ud574\uc758 \uac83\uc73c\ub85c\ub9cc \uace0\uc815\uc774 \ub418\uc9c0\ub9cc \uc5f0\ub3c4 \ud544\ud130\ub97c \uc0ac\uc6a9\ud558\uba74 \ub4dc\ub86d\ub2e4\uc6b4\uc73c\ub85c \uac04\ud3b8\ud558\uac8c \ub2e4\ub978 \uc5f0\ub3c4\ub97c \uc120\ud0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\ud83d\udca1\ube45\ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uba74 \uc804\ub144\ub3c4 \ub370\uc774\ud130\uac00 \uc9c1\uc811 \uce21\uc815 \ud56d\ubaa9\uc73c\ub85c \ub4e4\uc5b4\uac00\uae30 \ub54c\ubb38\uc5d0 \uadf8\ub798\ud504\uc758 \uc2a4\ud0c0\uc77c\uc744 \uac01\uac01 \ub2e4\ub974\uac8c \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubc18\uba74\uc5d0 \uae30\ubcf8 \u2018\ube44\uad50 \uae30\uac04\u2019 \uae30\ub2a5\uc740 \ube44\uad50\ud558\ub294 \uae30\uac04\uc5d0 \ub300\ud55c \uc11c\uc2dd \uc9c0\uc815\uc774 \ubd88\uac00\ud558\uace0, \ub3d9\uc77c\ud55c \uceec\ub7ec\uc5d0 \uba85\ub3c4\uac00 \ub0ae\uc740 \uc0c9\uc0c1\uc73c\ub85c \uc790\ub3d9 \uc9c0\uc815\ub429\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"539\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-14-2-1024x539.png\" alt=\"\" class=\"wp-image-16604\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-14-2-1024x539.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-14-2-300x158.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-14-2-768x405.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-14-2.png 1232w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">2\ubc88\uc758 \uae30\ubcf8 \uae30\uac04\uc744 \uc0ac\uc6a9\ud55c\ub2e4\uba74 \uae30\uac04\uc744 \u2018\uc62c\ud574\u2019\ub85c \uc124\uc815, \ube44\uad50 \uae30\uac04\uc740 \ubcc4\ub3c4\uc758 \uc124\uc815\uc774 \ud544\uc694\uce58 \uc54a\uc2b5\ub2c8\ub2e4. \ube45\ucffc\ub9ac\uc5d0\uc11c \uc774\ubbf8 \uc5f0\uc0b0\uc744 \uac70\uccd0 \ud544\ub4dc\ub97c \uc0dd\uc131\ud574\ub193\uc558\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-2-2\">2.2 \ud45c \ucc28\ud2b8<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\ud45c \ucc28\ud2b8\uc5d0 \ub9e4\ucd9c, \uc804\ub144\ub3c4 \ub9e4\ucd9c, \uc99d\uac10\ub9e4\ucd9c \ud544\ub4dc\ub97c \uce21\uc815 \ud56d\ubaa9\uc5d0 \ub123\uc73c\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uad6c\uc131\uc758 \ucc28\ud2b8\ub97c \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc5d0 \uac01 \uc6d4\uc758 \ub9e4\ucd9c \ube44\uc911\uc774 1\ub144 \ub9e4\ucd9c\uc758 \uba87%\ub97c \ucc28\uc9c0\ud558\ub294\uc9c0, \ub9e4\ucd9c\uc758 \uc99d\uac10\ub960\uc740 \uba87 %\uc778\uc9c0 \uce21\uc815\ud56d\ubaa9\uc5d0 \ucd94\uac00\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"327\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-15-2-1024x327.png\" alt=\"\" class=\"wp-image-16605\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-15-2-1024x327.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-15-2-300x96.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-15-2-768x246.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-15-2-1536x491.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-15-2.png 1548w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br><strong><mark style=\"background-color:#fffba3\" class=\"has-inline-color\">\uac01 \uc6d4\uc758 \ub9e4\ucd9c \ube44\uc911\uc740 \uac04\ub2e8\ud558\uac8c \uad6c\ud604 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/mark><\/strong> \uac01\uac01 \ub9e4\ucd9c\uc744 \ud654\uba74\uc5d0 \uc5b4\ub5bb\uac8c \ubcf4\uc5ec\uc904 \uac83\uc778\uc9c0 \uc9c0\uc815\ud558\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4. \uba3c\uc800, \ub9e4\ucd9c\uacfc \uc804\ub144\ub3c4 \ub9e4\ucd9c \ud544\ub4dc\ub97c \uce21\uc815 \ud56d\ubaa9\uc5d0 1\uac1c\uc529 \ub354 \ucd94\uac00\ud569\ub2c8\ub2e4. \uc544\uc9c1\uc740 \ub9e4\ucd9c \uac12\uc73c\ub85c \ud45c\ud604\ub418\uace0 \uc788\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"278\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-16-2-1024x278.png\" alt=\"\" class=\"wp-image-16606\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-16-2-1024x278.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-16-2-300x82.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-16-2-768x209.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-16-2-1536x417.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-16-2.png 1542w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\uc774\uc81c \ube44\uc911\uc744 \ud45c\ud604\ud558\ub824\ub294 \ud544\ub4dc\uc758 \uc88c\uce21\uc758 \u2018SUM\u2019\ubc84\ud2bc\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"406\" height=\"229\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-17-2.png\" alt=\"\" class=\"wp-image-16607\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-17-2.png 406w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-17-2-300x169.png 300w\" sizes=\"auto, (max-width: 406px) 100vw, 406px\" \/><figcaption class=\"wp-element-caption\">SUM\uc740 \ub9e4\ucd9c\uc774 \uc9d1\uacc4\ub41c \uac12\uc784\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4.<\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ub370\uc774\ud130 \uc720\ud615\uc744 \u2018<strong>\uc22b\uc790<\/strong>\u2019 \u2192 \u2018<strong>\ube44\uc728<\/strong>\u2019 \ub85c \uc120\ud0dd\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"796\" height=\"571\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-18-2.png\" alt=\"\" class=\"wp-image-16608\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-18-2.png 796w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-18-2-300x215.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-18-2-768x551.png 768w\" sizes=\"auto, (max-width: 796px) 100vw, 796px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\uc774\uc81c \ud654\uba74\uc774 \uc5b4\ub5bb\uac8c \ubc14\ub00c\uc5c8\ub294\uc9c0 \ud655\uc778\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130 \uc720\ud615\uc744 \ube44\uc728\ub85c \ubcc0\uacbd\ud558\uc600\uc9c0\ub9cc, \uc544\uc9c1\ub3c4 \ub9e4\ucd9c \uac12\uc744 \ubcf4\uc5ec\uc8fc\uace0 \uc788\ub124\uc694. \uc774\uc720\ub294 \ubb34\uc5c7\uc744 \uae30\uc900\uc73c\ub85c \ube44\uc728\uc744 \uacc4\uc0b0\ud560 \uac83\uc778\uc9c0 \uc9c0\uc815\ub418\uc5b4 \uc788\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"496\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-19-2-1024x496.png\" alt=\"\" class=\"wp-image-16609\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-19-2-1024x496.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-19-2-300x145.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-19-2-768x372.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-19-2.png 1493w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\uc804\uccb4\uc758 \uac12\uc5d0\uc11c \ucc28\uc9c0\ud558\ub294 \ube44\uc728\uc744 \ubcf4\uc5ec\uc8fc\ub824\uba74 \u2018<strong>\ube44\uad50 \uacc4\uc0b0<\/strong>\u2019 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud574\uc11c \ud45c\ud604\ud574\uc57c \ud569\ub2c8\ub2e4. \ud558\ub2e8\uc5d0 \uc788\ub294 \u2018<strong>\ube44\uad50 \uacc4\uc0b0<\/strong>\u2019 \ubc84\ud2bc\uc744 \ub20c\ub7ec\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"459\" height=\"687\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-20-2.png\" alt=\"\" class=\"wp-image-16610\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-20-2.png 459w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-20-2-200x300.png 200w\" sizes=\"auto, (max-width: 459px) 100vw, 459px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><br>\u2018<strong>\ube44\uad50 \uacc4\uc0b0<\/strong>\u2019 \uc5d0\ub294 \ud2b9\uc815 \uae30\uc900\uc744 \ube44\uad50 \uacc4\uc0b0\ud558\uc5ec \ubc31\ubd84\uc728\ub85c \ubcf4\uc5ec\uc8fc\ub294 \uae30\ub2a5\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc6b0\ub9ac\uac00 \ubcf4\uace0\uc790 \ud558\ub294 \uac83\uc740 \ucd1d\uacc4\uc5d0 \ub300\ud55c \ubc31\ubd84\uc728\uc774\ubbc0\ub85c \u2018<strong>\ucd1d\uacc4 \ubc31\ubd84\uc728<\/strong>\u2019\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"357\" height=\"279\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-21-2.png\" alt=\"\" class=\"wp-image-16611\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-21-2.png 357w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-21-2-300x234.png 300w\" sizes=\"auto, (max-width: 357px) 100vw, 357px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><br>\ub9e4\ucd9c\uc774 \uc804\uccb4 \uac12\uc5d0\uc11c \ucc28\uc9c0\ud558\ub294 \uac12\uc744 \ube44\uc728\ub85c \uc798 \ud45c\ud604\ud558\uace0 \uc788\uc9c0\uc694? \uc18c\uc218\uc810 \uc790\ub9ac\ub294 \u2018<strong>\ud45c\uc2dc \ud615\uc2dd<\/strong>\u2019\uc5d0\uc11c \uc120\ud0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Percent(0) \ucc98\ub7fc \uad04\ud638 \uc548\uc5d0 \uc788\ub294 \uc22b\uc790\uac00 \uc18c\uc218\uc810 \ubbf8\ub9cc\uc758 \uc790\ub9ac \uc218\ub97c \uc758\ubbf8\ud569\ub2c8\ub2e4. \uc774\uc81c \uc5f4 \uc774\ub984\uc744 \u2018<strong>\ube44\uc911<\/strong>\u2019\uc73c\ub85c \ubcc0\uacbd\ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc5f4 \uc774\ub984\uc744 \ubc14\uafb8\ub824\uba74 \uc6b0\uce21\uc5d0 \u2018<strong>\uc774\ub984<\/strong>\u2019 \uc774\ub77c\uace0 \uc801\ud78c \ubd80\ubd84\uc5d0 \uc6d0\ud558\ub294 \uc774\ub984\uc744 \uae30\uc785\ud558\uba74 \ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"893\" height=\"650\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-22-2.png\" alt=\"\" class=\"wp-image-16612\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-22-2.png 893w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-22-2-300x218.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-22-2-768x559.png 768w\" sizes=\"auto, (max-width: 893px) 100vw, 893px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\uc6d0\ubcf8 \ud544\ub4dc\uc758 \uc774\ub984\uc740 \uc6b0\uce21\uc5d0 \ud45c\uc2dc\ud55c \uac83\ucc98\ub7fc \uc791\uac8c \ud558\ub2e8\uc5d0 \ud45c\uae30\ub429\ub2c8\ub2e4. \uc804\ub144\ub3c4 \ub9e4\ucd9c\uc758 \ube44\uc911\ub3c4 \ub3d9\uc77c\ud558\uac8c \uc124\uc815\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"679\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-23-2-1024x679.png\" alt=\"\" class=\"wp-image-16613\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-23-2-1024x679.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-23-2-300x199.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-23-2-768x509.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-23-2.png 1139w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\uc774\uc81c \uc99d\uac10\ub960(%)\ub3c4 \ucc28\ud2b8\uc5d0 \ucd94\uac00\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc99d\uac10\ub960\uc740 \ud544\ub4dc \uacc4\uc0b0\uc744 \ud55c\ubc88 \uac70\uccd0\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc6b0\uce21 \ud558\ub2e8\uc758 \u2018<strong>\ud544\ub4dc \ucd94\uac00<\/strong>\u2019 \u2192 \u2018<strong>\uacc4\uc0b0\ub41c \ud544\ub4dc \ucd94\uac00<\/strong>\u2019 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"542\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-24-2.png\" alt=\"\" class=\"wp-image-16614\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-24-2.png 680w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-24-2-300x239.png 300w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\ud544\ub4dc \uc774\ub984\uc744 \u2018<strong>\ub9e4\ucd9c\uc99d\uac10\ub960<\/strong>\u2019\ub85c \uc124\uc815 \ud6c4, \uc218\uc2dd\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \uc785\ub825\ud569\ub2c8\ub2e4.<br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SUM(\uc99d\uac10\ub9e4\ucd9c) \/ SUM(\uc804\ub144\ub3c4 \ub9e4\ucd9c) <\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"332\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-25-2-1024x332.png\" alt=\"\" class=\"wp-image-16615\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-25-2-1024x332.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-25-2-300x97.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-25-2-768x249.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-25-2-1536x498.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-25-2.png 1768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\ud83d\udca1\uc218\uc2dd\uc774 \u2018\uc99d\uac10\ub9e4\ucd9c \/ \uc804\ub144\ub3c4 \ub9e4\ucd9c\u2019\uc774 \uc544\ub2c8\ub77c \u2018SUM(\uc99d\uac10\ub9e4\ucd9c) \/ SUM(\uc804\ub144\ub3c4 \ub9e4\ucd9c)\u2019\uc778 \uc774\uc720\ub294 \ubb34\uc5c7\uc77c\uae4c\uc694?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2018SUM(\uc99d\uac10\ub9e4\ucd9c) \/ SUM(\uc804\ub144\ub3c4 \ub9e4\ucd9c)\u2019 \uc218\uc2dd\uc740 \uac01 \ud56d\ubaa9\uc758 \uc99d\uac10 \ub9e4\ucd9c\uc744 \ubaa8\ub450 \ub354\ud558\uace0, \uc804\ub144\ub3c4 \ub9e4\ucd9c\uc744 \ubaa8\ub450 \ub354\ud55c \ub4a4 \uc774 \ub458\uc744 \ub098\ub204\ub294 \ubc29\uc2dd\uc785\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc774 \ubc29\ubc95\uc774 \uc804\uccb4 \ub9e4\ucd9c \uaddc\ubaa8\uc5d0\uc11c\uc758 \ubcc0\ud654\ub97c \ub098\ud0c0\ub0b4\ub294\ub370 \uc801\ud569\ud558\uc9c0\uc694.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ubc18\uba74\uc5d0 \u2018\uc99d\uac10\ub9e4\ucd9c\/\uc804\ub144\ub3c4 \ub9e4\ucd9c\u2019\uc740 \uac1c\ubcc4 \ud589\ub4e4\uc758 \uc99d\uac10 \ub9e4\ucd9c\uc744 \uc804\ub144\ub3c4 \ub9e4\ucd9c\ub85c \ub098\ub208 \ub4a4, \uadf8 \ube44\uc728\uc744 \uac00\uacf5\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \ub530\ub77c\uc11c \uac01 \uac1c\ubcc4 \ud56d\ubaa9\ub4e4\uc758 \ubcc0\ud654\uc728\ub9cc \ubcf4\uc5ec\uc904 \ubfd0, \uc804\uccb4\uc801\uc778 \ube44\uc728\uc744 \ub098\ud0c0\ub0b4\uc9c0\ub294 \uc54a\uc2b5\ub2c8\ub2e4. \ub610 SUM, AVG \ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc5d0 \ub530\ub77c \ubaa9\uc801\ud558\ub294 \uac12\uacfc\ub294 \uc804\ud600 \ub2e4\ub978 \uac12\uc774 \uacc4\uc0b0\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ube44\uc728\uc744 \ud45c\uc2dc\ud558\ub294 \ubc29\ubc95\uc5d0\uc11c \ud754\ud788 \uc2e4\uc218\ud560 \uc218 \uc788\ub294 \ubd80\ubd84\uc73c\ub85c, \uc774 \uc810\uc5d0 \ub300\ud574 \ub354 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uae38 \uc6d0\ud55c\ub2e4\uba74 \ub2e4\uc74c\uc758 \ud3ec\uc2a4\ud2b8\ub97c \ucc38\uc870\ud574\uc8fc\uc138\uc694.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2024\/06\/23\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4-%ed%8f%89%ea%b7%a0-%ea%b0%92-%ec%a0%95%ec%83%81%ec%a0%81%ec%9c%bc%eb%a1%9c-%ed%91%9c%ec%8b%9c%ed%95%98%ea%b8%b0\/\" target=\"_blank\" rel=\"noopener\" title=\"\">\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \ud3c9\uade0 \uac12 \uc815\uc0c1\uc801\uc73c\ub85c \ud45c\uc2dc\ud558\uae30<\/a><\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\uc774\uc81c \uc0dd\uc131\ub41c \u2018<strong>\ub9e4\ucd9c\uc99d\uac10\ub960<\/strong>\u2019 \ud544\ub4dc\ub97c \ucc28\ud2b8\uc5d0 \ucd94\uac00\ud55c \ub4a4\uc5d0, \ub370\uc774\ud130 \uc720\ud615\uc744 \u2018<strong>\ube44\uc728<\/strong>\u2019\ub85c \uc124\uc815\ud558\uace0 \ub9c8\ubb34\ub9ac\ud569\ub2c8\ub2e4. \uc99d\uac10\ub960\uc744 \ud45c\uc2dc\ud558\ub294 \uac83\uc774\ubbc0\ub85c \u2018\ube44\uad50 \uacc4\uc0b0\u2019\uc740 \uc124\uc815\ud558\uc9c0 \uc54a\uc558\uc2b5\ub2c8\ub2e4.<br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u27a1\ufe0f&nbsp;<strong>\ucd5c\uc885\uc801\uc73c\ub85c \uad6c\uc131\ub41c \ud654\uba74\uc744 \uc0b4\ud3b4\ubcfc\uae4c\uc694?<\/strong><br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"720\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-26-2-1024x720.png\" alt=\"\" class=\"wp-image-16616\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-26-2-1024x720.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-26-2-300x211.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-26-2-768x540.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-26-2.png 1271w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\ub9e4\ucd9c \ucd94\uc774 \ube44\uad50:<\/strong> \uc5f0\ub3c4 \ud544\ud130\uc5d0\uc11c \uc120\ud0dd\ud55c \uc5f0\ub3c4\uc640 \uadf8 \uc774\uc804 \uc5f0\ub3c4\uc758 \ub9e4\ucd9c\uc744 \ud558\ub098\uc758 \ucc28\ud2b8\uc5d0\uc11c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<br><\/li>\n\n\n\n<li><strong>\uc6d4\ubcc4 \ub9e4\ucd9c \ube44\uc911:<\/strong> \uc120\ud0dd\ud55c \uc5f0\ub3c4\uc758 \uc804\uccb4 \ub9e4\ucd9c\uc5d0\uc11c \uac01 \uc6d4\uc774 \ucc28\uc9c0\ud558\ub294 \ube44\uc911\uc744 \ud45c\ud604\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<br><\/li>\n\n\n\n<li><strong>\uc6d4\ubcc4 \ub9e4\ucd9c \ube44\uad50:<\/strong> \uc120\ud0dd \uc5f0\ub3c4\uc758 \ub9e4\ucd9c\uacfc \ube44\uc911, \uc804\ub144\ub3c4\uc758 \ub9e4\ucd9c\uacfc \ube44\uc911, \uc99d\uac10 \ub9e4\ucd9c\uacfc \uc99d\uac10\ub960 \ub370\uc774\ud130\ub97c \ud558\ub098\uc758 \ucc28\ud2b8\uc5d0\uc11c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. <strong><mark style=\"background-color:#fcff81\" class=\"has-inline-color\">\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 \uae30\ubcf8 \uae30\ub2a5\ub9cc\uc73c\ub85c \uad6c\ud604\ud558\ub824\uba74 \ucc28\ud2b8\ub97c 2\uac1c\ub85c \ub098\ub204\uc5b4\uc57c \ud558\uae30 \ub54c\ubb38\uc5d0 \uac00\ub3c5\uc131\uc774 \ub5a8\uc5b4\uc9c0\ub294 \ubb38\uc81c\uac00 \uc788\uc5c8\uc2b5\ub2c8\ub2e4.<\/mark><\/strong> \ud558\uc9c0\ub9cc \ube45\ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\ub2c8 \ud558\ub098\uc758 \ucc28\ud2b8\uc5d0 \uc6d0\ud558\ub294 \ub370\uc774\ud130\ub97c \ubaa8\ub450 \ubcfc \uc218 \uc788\uac8c \ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\ub300\uc2dc\ubcf4\ub4dc\uac00 \ud55c \ub208\uc5d0 \ubcf4\uae30 \uc88b\uac8c \ub9cc\ub4e4\uc5b4\uc84c\uc9c0\uc694? \uc624\ub298\uc740 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c YoY( Year-over-Year)\ub97c \ube45\ucffc\ub9ac SQL\uc744 \uc0ac\uc6a9\ud574\uc11c \uad6c\ud604\ud558\ub294 \ubc29\ubc95\uc744 \ud3ec\uc2a4\ud305 \ud574\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \uc774\ud6c4 \ud3ec\uc2a4\ud2b8\ub294 \uc624\ub298 \ud568\uaed8 \ub9cc\ub4e4\uc5b4\ubcf4\uc558\ub358 \ub300\uc2dc\ubcf4\ub4dc\ub97c \ud65c\uc6a9\ud558\uc5ec \ub2e4\uc74c\uc758 \uae30\ub2a5\ub4e4\uc744 \ub2f4\uc544\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<br><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\ubc84\ud2bc\uc73c\ub85c \ucc28\ud2b8\uc758 \uce21\uc815 \ud56d\ubaa9\uc744 \ubcc0\uacbd\ud558\ub294 \ubc29\ubc95<\/strong><\/li>\n\n\n\n<li><strong>\ucc28\ud2b8 \uac00\ub3c5\uc131\uc744 \ub192\uc774\ub294 \ub514\uc790\uc778\uc801 \uc694\uc18c\ub97c \ucd94\uac00\ud558\ub294 \ubc29\ubc95<\/strong><\/li>\n\n\n\n<li><strong>\uc120\ud0dd \uc5f0\ub3c4\uc640 \ube44\uad50 \uc5f0\ub3c4\ub97c \uac01\uac01 \uc120\ud0dd\ud558\uc5ec \ube44\uad50\ud558\ub294 \uae30\ub2a5<\/strong><br><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">\ud2b8\ub80c\ub4dc\uc640 \ud328\ud134\uc744 \ubd84\uc11d\ud558\ub294\ub370\uc5d0 YoY (Year-over-Year) \ucc28\ud2b8\ub294 \ud6cc\ub96d\ud55c \uc9c0\ud45c \ub3c4\uad6c \uc785\ub2c8\ub2e4. \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 \uae30\ubcf8 \uae30\ub2a5\ub9cc\uc73c\ub85c\ub3c4 \uc5b4\ub290 \uc815\ub3c4 \uad6c\ud604\uc774 \uac00\ub2a5\ud558\uc9c0\uc694. \ud558\uc9c0\ub9cc \uae30\uc5c5\uc774 \uc131\uc7a5\ud558\uba70 \ud30c\uc545\ud574\uc57c\ud558\ub294 \ub370\uc774\ud130\uc758 \ubc94\uc704\uac00 \ubc29\ub300\ud574\uc9c0\uba74 \uadf8\ub9cc\ud07c \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 \uae30\ubcf8 \uae30\ub2a5\ub9cc\uc73c\ub85c\ub294 \uc6d0\ud558\ub294 \ucc28\ud2b8\ub97c \uad6c\ud604\ud558\uae30\uac00 \uae4c\ub2e4\ub85c\uc6b8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\uc624\ub298 \uc0b4\ud3b4\ubcf8 \uac83\ucc98\ub7fc \ube45\ucffc\ub9ac\ub294 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 \ud55c\uacc4\ub97c \ub6f0\uc5b4\ub118\ub3c4\ub85d \ub3c4\uc6c0\uc744 \uc8fc\ub294 \uc720\uc6a9\ud55c \ub3c4\uad6c\uc785\ub2c8\ub2e4. \ube45\ucffc\ub9ac\ub97c \ud65c\uc6a9\ud558\uc5ec \ub354 \uc720\uc5f0\ud558\uace0 \uac15\ub825\ud558\uac8c \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud574\ubcf4\uc2dc\uae38 \ubc14\ub78d\ub2c8\ub2e4!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"691\" height=\"512\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-27-5.png\" alt=\"\" class=\"wp-image-17096\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-27-5.png 691w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/image-27-5-300x222.png 300w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\"><strong>\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<br>\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSfh9CSxm4aKG4Rhh6Xdh7Y6p5e_8ZhwWS_ryvxGOeQVIpmaRw\/viewform\" target=\"_blank\" rel=\"noopener\" title=\"\">\uc624\ud1a0\uc624\ud53c\uc2a4 \ud504\ub85c\uc81d\ud2b8 \ubb38\uc758<\/a><br><br><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c YoY (Year-over-Year)\ub97c \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 \uae30\ubcf8 \uae30\ub2a5\uc73c\ub85c \uad6c\ud604\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4. YoY (Year-over-Year)\ub294 \ud55c \uc5f0\ub3c4\uc758 \ud2b9\uc815 \uae30\uac04\uc744 1\ub144 \uc804 \uac19\uc740 \uae30\uac04\uacfc \ube44\uad50\ud558\uc5ec \uc131\uc7a5\ub960\uc774\ub098 \uc131\uacfc \ubcc0\ud654\ub97c \ub098\ud0c0\ub0b4\ub294 \ubd84\uc11d \uc9c0\ud45c\ub85c, \uc8fc\ub85c \uae30\uc5c5\uc758 \ub9e4\ucd9c\uc774\ub098 \uc774\uc775\uacfc \uac19\uc740 \uc8fc\uc694 \uc2e4\uc801\uc744 \ud655\uc778\ud560 \ub54c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \ud45c \ucc28\ud2b8\uc758 \ube44\uad50 \uae30\ub2a5\uc740 \ube44\uad50 \uae30\uac04\uc758 \uac12\uc744 \ud45c\uc2dc\ud560 \uc218 \uc5c6\uace0 \uc99d\uac10\uc561\uacfc \uc99d\uac10\ub960\ub85c\ub9cc&#8230;<\/p>\n","protected":false},"author":6,"featured_media":16594,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[6],"tags":[551,47,568,100,45,546,559,12],"class_list":["post-16593","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-lookerstudio","tag-autooffice","tag-datastudio","tag-lookerstudio","tag-100","tag-45","tag-546","tag-559","tag-12"],"translation":{"provider":"WPGlobus","version":"3.0.5","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":false},"en":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"1. \ube45\ucffc\ub9ac \ub370\uc774\ud130 \uc18c\uc2a4 \uc0dd\uc1312. \ucc28\ud2b8 \ucd94\uac002.1 \uc2dc\uacc4\uc5f4 \ucc28\ud2b82.2 \ud45c \ucc28\ud2b8\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694! \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c YoY (Year-over-Year)\ub97c \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 \uae30\ubcf8 \uae30\ub2a5\uc73c\ub85c \uad6c\ud604\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4. YoY (Year-over-Year)\ub294 \ud55c \uc5f0\ub3c4\uc758 \ud2b9\uc815 \uae30\uac04\uc744 1\ub144 \uc804 \uac19\uc740 \uae30\uac04\uacfc \ube44\uad50\ud558\uc5ec \uc131\uc7a5\ub960\uc774\ub098 \uc131\uacfc \ubcc0\ud654\ub97c \ub098\ud0c0\ub0b4\ub294 \ubd84\uc11d \uc9c0\ud45c\ub85c, \uc8fc\ub85c \uae30\uc5c5\uc758 \ub9e4\ucd9c\uc774\ub098 \uc774\uc775\uacfc \uac19\uc740\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"autooffice\"\/>\n\t<meta name=\"keywords\" content=\"autooffice,datastudio,lookerstudio,\ub300\uc2dc\ubcf4\ub4dc,\ub370\uc774\ud130\uc2a4\ud29c\ub514\uc624,\ub370\uc774\ud130\uc2dc\uac01\ud654,\ub8e8\ucee4\uc2a4\ud29c\ub514\uc624,\uc624\ud1a0\uc624\ud53c\uc2a4,\ub370\uc774\ud130 \uc2a4\ud29c\ub514\uc624\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Tech Blog of autooffice - Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c YoY (Year-over-Year) \uad6c\ud604\ud558\uae30: \ube45\ucffc\ub9ac\ub97c \uc751\uc6a9\ud55c \ube44\uad50 - Tech Blog of autooffice\" \/>\n\t\t<meta property=\"og:description\" content=\"1. \ube45\ucffc\ub9ac \ub370\uc774\ud130 \uc18c\uc2a4 \uc0dd\uc1312. \ucc28\ud2b8 \ucd94\uac002.1 \uc2dc\uacc4\uc5f4 \ucc28\ud2b82.2 \ud45c \ucc28\ud2b8\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694! \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c YoY (Year-over-Year)\ub97c \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 \uae30\ubcf8 \uae30\ub2a5\uc73c\ub85c \uad6c\ud604\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4. YoY (Year-over-Year)\ub294 \ud55c \uc5f0\ub3c4\uc758 \ud2b9\uc815 \uae30\uac04\uc744 1\ub144 \uc804 \uac19\uc740 \uae30\uac04\uacfc \ube44\uad50\ud558\uc5ec \uc131\uc7a5\ub960\uc774\ub098 \uc131\uacfc \ubcc0\ud654\ub97c \ub098\ud0c0\ub0b4\ub294 \ubd84\uc11d \uc9c0\ud45c\ub85c, \uc8fc\ub85c \uae30\uc5c5\uc758 \ub9e4\ucd9c\uc774\ub098 \uc774\uc775\uacfc \uac19\uc740\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t\t<meta property=\"og:image:height\" content=\"210\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2024-11-21T11:09:16+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-08-18T09:48:26+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c YoY (Year-over-Year) \uad6c\ud604\ud558\uae30: \ube45\ucffc\ub9ac\ub97c \uc751\uc6a9\ud55c \ube44\uad50 - Tech Blog of autooffice\" \/>\n\t\t<meta name=\"twitter:description\" content=\"1. \ube45\ucffc\ub9ac \ub370\uc774\ud130 \uc18c\uc2a4 \uc0dd\uc1312. \ucc28\ud2b8 \ucd94\uac002.1 \uc2dc\uacc4\uc5f4 \ucc28\ud2b82.2 \ud45c \ucc28\ud2b8\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694! \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c YoY (Year-over-Year)\ub97c \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 \uae30\ubcf8 \uae30\ub2a5\uc73c\ub85c \uad6c\ud604\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4. YoY (Year-over-Year)\ub294 \ud55c \uc5f0\ub3c4\uc758 \ud2b9\uc815 \uae30\uac04\uc744 1\ub144 \uc804 \uac19\uc740 \uae30\uac04\uacfc \ube44\uad50\ud558\uc5ec \uc131\uc7a5\ub960\uc774\ub098 \uc131\uacfc \ubcc0\ud654\ub97c \ub098\ud0c0\ub0b4\ub294 \ubd84\uc11d \uc9c0\ud45c\ub85c, \uc8fc\ub85c \uae30\uc5c5\uc758 \ub9e4\ucd9c\uc774\ub098 \uc774\uc775\uacfc \uac19\uc740\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2024\\\/11\\\/21\\\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\\\/#blogposting\",\"name\":\"\\ub8e8\\ucee4 \\uc2a4\\ud29c\\ub514\\uc624\\uc5d0\\uc11c YoY (Year-over-Year) \\uad6c\\ud604\\ud558\\uae30: \\ube45\\ucffc\\ub9ac\\ub97c \\uc751\\uc6a9\\ud55c \\ube44\\uad50 - Tech Blog of autooffice\",\"headline\":\"\\ub8e8\\ucee4 \\uc2a4\\ud29c\\ub514\\uc624\\uc5d0\\uc11c YoY (Year-over-Year) \\uad6c\\ud604\\ud558\\uae30: \\ube45\\ucffc\\ub9ac\\ub97c \\uc751\\uc6a9\\ud55c \\ube44\\uad50\",\"author\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/dev_eb\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/WP-Thumb-3.jpg\",\"width\":2088,\"height\":1200},\"datePublished\":\"2024-11-21T20:09:16+09:00\",\"dateModified\":\"2025-08-18T18:48:26+09:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2024\\\/11\\\/21\\\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2024\\\/11\\\/21\\\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\\\/#webpage\"},\"articleSection\":\"\\ub370\\uc774\\ud130 \\uc2a4\\ud29c\\ub514\\uc624, autooffice, DataStudio, lookerstudio, \\ub300\\uc2dc\\ubcf4\\ub4dc, \\ub370\\uc774\\ud130\\uc2a4\\ud29c\\ub514\\uc624, \\ub370\\uc774\\ud130\\uc2dc\\uac01\\ud654, \\ub8e8\\ucee4\\uc2a4\\ud29c\\ub514\\uc624, \\uc624\\ud1a0\\uc624\\ud53c\\uc2a4\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2024\\\/11\\\/21\\\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/lookerstudio\\\/#listItem\",\"name\":\"\\ub370\\uc774\\ud130 \\uc2a4\\ud29c\\ub514\\uc624\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/lookerstudio\\\/#listItem\",\"position\":2,\"name\":\"\\ub370\\uc774\\ud130 \\uc2a4\\ud29c\\ub514\\uc624\",\"item\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/lookerstudio\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2024\\\/11\\\/21\\\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\\\/#listItem\",\"name\":\"\\ub8e8\\ucee4 \\uc2a4\\ud29c\\ub514\\uc624\\uc5d0\\uc11c YoY (Year-over-Year) \\uad6c\\ud604\\ud558\\uae30: \\ube45\\ucffc\\ub9ac\\ub97c \\uc751\\uc6a9\\ud55c \\ube44\\uad50\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2024\\\/11\\\/21\\\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\\\/#listItem\",\"position\":3,\"name\":\"\\ub8e8\\ucee4 \\uc2a4\\ud29c\\ub514\\uc624\\uc5d0\\uc11c YoY (Year-over-Year) \\uad6c\\ud604\\ud558\\uae30: \\ube45\\ucffc\\ub9ac\\ub97c \\uc751\\uc6a9\\ud55c \\ube44\\uad50\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/lookerstudio\\\/#listItem\",\"name\":\"\\ub370\\uc774\\ud130 \\uc2a4\\ud29c\\ub514\\uc624\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\",\"name\":\"\\uc624\\ud1a0\\uc624\\ud53c\\uc2a4\",\"description\":\"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/\",\"telephone\":\"+821024904264\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-new2023.png\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2024\\\/11\\\/21\\\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\\\/#organizationLogo\",\"width\":1461,\"height\":250},\"image\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2024\\\/11\\\/21\\\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/dev_eb\\\/#author\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/dev_eb\\\/\",\"name\":\"autooffice\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2024\\\/11\\\/21\\\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\\\/#webpage\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2024\\\/11\\\/21\\\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\\\/\",\"name\":\"\\ub8e8\\ucee4 \\uc2a4\\ud29c\\ub514\\uc624\\uc5d0\\uc11c YoY (Year-over-Year) \\uad6c\\ud604\\ud558\\uae30: \\ube45\\ucffc\\ub9ac\\ub97c \\uc751\\uc6a9\\ud55c \\ube44\\uad50 - Tech Blog of autooffice\",\"description\":\"1. \\ube45\\ucffc\\ub9ac \\ub370\\uc774\\ud130 \\uc18c\\uc2a4 \\uc0dd\\uc1312. \\ucc28\\ud2b8 \\ucd94\\uac002.1 \\uc2dc\\uacc4\\uc5f4 \\ucc28\\ud2b82.2 \\ud45c \\ucc28\\ud2b8\\uc5c5\\ubb34 \\ud6a8\\uc728\\uc131 200% \\uc62c\\ub9ac\\uae30, with autooffice \\ub8e8\\ucee4 \\uc2a4\\ud29c\\ub514\\uc624 \\uac1c\\ubc1c \\ubb38\\uc758\\ub294 \\uad6c\\uae00\\ud3fc\\uc744 \\uc774\\uc6a9\\ud574\\uc8fc\\uc138\\uc694! \\uc9c0\\ub09c \\ud3ec\\uc2a4\\ud2b8\\uc5d0\\uc11c YoY (Year-over-Year)\\ub97c \\ub8e8\\ucee4 \\uc2a4\\ud29c\\ub514\\uc624\\uc758 \\uae30\\ubcf8 \\uae30\\ub2a5\\uc73c\\ub85c \\uad6c\\ud604\\ud558\\ub294 \\ubc29\\ubc95\\uc744 \\uc0b4\\ud3b4\\ubcf4\\uc558\\uc2b5\\ub2c8\\ub2e4. YoY (Year-over-Year)\\ub294 \\ud55c \\uc5f0\\ub3c4\\uc758 \\ud2b9\\uc815 \\uae30\\uac04\\uc744 1\\ub144 \\uc804 \\uac19\\uc740 \\uae30\\uac04\\uacfc \\ube44\\uad50\\ud558\\uc5ec \\uc131\\uc7a5\\ub960\\uc774\\ub098 \\uc131\\uacfc \\ubcc0\\ud654\\ub97c \\ub098\\ud0c0\\ub0b4\\ub294 \\ubd84\\uc11d \\uc9c0\\ud45c\\ub85c, \\uc8fc\\ub85c \\uae30\\uc5c5\\uc758 \\ub9e4\\ucd9c\\uc774\\ub098 \\uc774\\uc775\\uacfc \\uac19\\uc740\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2024\\\/11\\\/21\\\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/dev_eb\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/dev_eb\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/11\\\/WP-Thumb-3.jpg\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2024\\\/11\\\/21\\\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\\\/#mainImage\",\"width\":2088,\"height\":1200},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2024\\\/11\\\/21\\\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\\\/#mainImage\"},\"datePublished\":\"2024-11-21T20:09:16+09:00\",\"dateModified\":\"2025-08-18T18:48:26+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/\",\"name\":\"\\uc624\\ud1a0\\uc624\\ud53c\\uc2a4\",\"alternateName\":\"autooffice\",\"description\":\"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c YoY (Year-over-Year) \uad6c\ud604\ud558\uae30: \ube45\ucffc\ub9ac\ub97c \uc751\uc6a9\ud55c \ube44\uad50 - Tech Blog of autooffice","description":"1. \ube45\ucffc\ub9ac \ub370\uc774\ud130 \uc18c\uc2a4 \uc0dd\uc1312. \ucc28\ud2b8 \ucd94\uac002.1 \uc2dc\uacc4\uc5f4 \ucc28\ud2b82.2 \ud45c \ucc28\ud2b8\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694! \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c YoY (Year-over-Year)\ub97c \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 \uae30\ubcf8 \uae30\ub2a5\uc73c\ub85c \uad6c\ud604\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4. YoY (Year-over-Year)\ub294 \ud55c \uc5f0\ub3c4\uc758 \ud2b9\uc815 \uae30\uac04\uc744 1\ub144 \uc804 \uac19\uc740 \uae30\uac04\uacfc \ube44\uad50\ud558\uc5ec \uc131\uc7a5\ub960\uc774\ub098 \uc131\uacfc \ubcc0\ud654\ub97c \ub098\ud0c0\ub0b4\ub294 \ubd84\uc11d \uc9c0\ud45c\ub85c, \uc8fc\ub85c \uae30\uc5c5\uc758 \ub9e4\ucd9c\uc774\ub098 \uc774\uc775\uacfc \uac19\uc740","canonical_url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/","robots":"max-image-preview:large","keywords":"autooffice,datastudio,lookerstudio,\ub300\uc2dc\ubcf4\ub4dc,\ub370\uc774\ud130\uc2a4\ud29c\ub514\uc624,\ub370\uc774\ud130\uc2dc\uac01\ud654,\ub8e8\ucee4\uc2a4\ud29c\ub514\uc624,\uc624\ud1a0\uc624\ud53c\uc2a4,\ub370\uc774\ud130 \uc2a4\ud29c\ub514\uc624","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/#blogposting","name":"\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c YoY (Year-over-Year) \uad6c\ud604\ud558\uae30: \ube45\ucffc\ub9ac\ub97c \uc751\uc6a9\ud55c \ube44\uad50 - Tech Blog of autooffice","headline":"\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c YoY (Year-over-Year) \uad6c\ud604\ud558\uae30: \ube45\ucffc\ub9ac\ub97c \uc751\uc6a9\ud55c \ube44\uad50","author":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/dev_eb\/#author"},"publisher":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/WP-Thumb-3.jpg","width":2088,"height":1200},"datePublished":"2024-11-21T20:09:16+09:00","dateModified":"2025-08-18T18:48:26+09:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/#webpage"},"isPartOf":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/#webpage"},"articleSection":"\ub370\uc774\ud130 \uc2a4\ud29c\ub514\uc624, autooffice, DataStudio, lookerstudio, \ub300\uc2dc\ubcf4\ub4dc, \ub370\uc774\ud130\uc2a4\ud29c\ub514\uc624, \ub370\uc774\ud130\uc2dc\uac01\ud654, \ub8e8\ucee4\uc2a4\ud29c\ub514\uc624, \uc624\ud1a0\uc624\ud53c\uc2a4"},{"@type":"BreadcrumbList","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/#listItem","position":1,"name":"Home","item":"https:\/\/www.autooffice.co.kr\/en\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/lookerstudio\/#listItem","name":"\ub370\uc774\ud130 \uc2a4\ud29c\ub514\uc624"}},{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/lookerstudio\/#listItem","position":2,"name":"\ub370\uc774\ud130 \uc2a4\ud29c\ub514\uc624","item":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/lookerstudio\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/#listItem","name":"\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c YoY (Year-over-Year) \uad6c\ud604\ud558\uae30: \ube45\ucffc\ub9ac\ub97c \uc751\uc6a9\ud55c \ube44\uad50"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/#listItem","position":3,"name":"\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c YoY (Year-over-Year) \uad6c\ud604\ud558\uae30: \ube45\ucffc\ub9ac\ub97c \uc751\uc6a9\ud55c \ube44\uad50","previousItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/lookerstudio\/#listItem","name":"\ub370\uc774\ud130 \uc2a4\ud29c\ub514\uc624"}}]},{"@type":"Organization","@id":"https:\/\/www.autooffice.co.kr\/en\/#organization","name":"\uc624\ud1a0\uc624\ud53c\uc2a4","description":"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","url":"https:\/\/www.autooffice.co.kr\/en\/","telephone":"+821024904264","logo":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/logo-new2023.png","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/#organizationLogo","width":1461,"height":250},"image":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/dev_eb\/#author","url":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/dev_eb\/","name":"autooffice"},{"@type":"WebPage","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/#webpage","url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/","name":"\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c YoY (Year-over-Year) \uad6c\ud604\ud558\uae30: \ube45\ucffc\ub9ac\ub97c \uc751\uc6a9\ud55c \ube44\uad50 - Tech Blog of autooffice","description":"1. \ube45\ucffc\ub9ac \ub370\uc774\ud130 \uc18c\uc2a4 \uc0dd\uc1312. \ucc28\ud2b8 \ucd94\uac002.1 \uc2dc\uacc4\uc5f4 \ucc28\ud2b82.2 \ud45c \ucc28\ud2b8\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694! \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c YoY (Year-over-Year)\ub97c \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 \uae30\ubcf8 \uae30\ub2a5\uc73c\ub85c \uad6c\ud604\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4. YoY (Year-over-Year)\ub294 \ud55c \uc5f0\ub3c4\uc758 \ud2b9\uc815 \uae30\uac04\uc744 1\ub144 \uc804 \uac19\uc740 \uae30\uac04\uacfc \ube44\uad50\ud558\uc5ec \uc131\uc7a5\ub960\uc774\ub098 \uc131\uacfc \ubcc0\ud654\ub97c \ub098\ud0c0\ub0b4\ub294 \ubd84\uc11d \uc9c0\ud45c\ub85c, \uc8fc\ub85c \uae30\uc5c5\uc758 \ub9e4\ucd9c\uc774\ub098 \uc774\uc775\uacfc \uac19\uc740","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#website"},"breadcrumb":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/#breadcrumblist"},"author":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/dev_eb\/#author"},"creator":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/dev_eb\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2024\/11\/WP-Thumb-3.jpg","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/#mainImage","width":2088,"height":1200},"primaryImageOfPage":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/#mainImage"},"datePublished":"2024-11-21T20:09:16+09:00","dateModified":"2025-08-18T18:48:26+09:00"},{"@type":"WebSite","@id":"https:\/\/www.autooffice.co.kr\/en\/#website","url":"https:\/\/www.autooffice.co.kr\/en\/","name":"\uc624\ud1a0\uc624\ud53c\uc2a4","alternateName":"autooffice","description":"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#organization"}}]},"og:locale":"en_US","og:site_name":"Tech Blog of autooffice - Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","og:type":"article","og:title":"\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c YoY (Year-over-Year) \uad6c\ud604\ud558\uae30: \ube45\ucffc\ub9ac\ub97c \uc751\uc6a9\ud55c \ube44\uad50 - Tech Blog of autooffice","og:description":"1. \ube45\ucffc\ub9ac \ub370\uc774\ud130 \uc18c\uc2a4 \uc0dd\uc1312. \ucc28\ud2b8 \ucd94\uac002.1 \uc2dc\uacc4\uc5f4 \ucc28\ud2b82.2 \ud45c \ucc28\ud2b8\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694! \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c YoY (Year-over-Year)\ub97c \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 \uae30\ubcf8 \uae30\ub2a5\uc73c\ub85c \uad6c\ud604\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4. YoY (Year-over-Year)\ub294 \ud55c \uc5f0\ub3c4\uc758 \ud2b9\uc815 \uae30\uac04\uc744 1\ub144 \uc804 \uac19\uc740 \uae30\uac04\uacfc \ube44\uad50\ud558\uc5ec \uc131\uc7a5\ub960\uc774\ub098 \uc131\uacfc \ubcc0\ud654\ub97c \ub098\ud0c0\ub0b4\ub294 \ubd84\uc11d \uc9c0\ud45c\ub85c, \uc8fc\ub85c \uae30\uc5c5\uc758 \ub9e4\ucd9c\uc774\ub098 \uc774\uc775\uacfc \uac19\uc740","og:url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/","og:image":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png","og:image:secure_url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png","og:image:width":400,"og:image:height":210,"article:published_time":"2024-11-21T11:09:16+00:00","article:modified_time":"2025-08-18T09:48:26+00:00","twitter:card":"summary_large_image","twitter:title":"\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c YoY (Year-over-Year) \uad6c\ud604\ud558\uae30: \ube45\ucffc\ub9ac\ub97c \uc751\uc6a9\ud55c \ube44\uad50 - Tech Blog of autooffice","twitter:description":"1. \ube45\ucffc\ub9ac \ub370\uc774\ud130 \uc18c\uc2a4 \uc0dd\uc1312. \ucc28\ud2b8 \ucd94\uac002.1 \uc2dc\uacc4\uc5f4 \ucc28\ud2b82.2 \ud45c \ucc28\ud2b8\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694! \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c YoY (Year-over-Year)\ub97c \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 \uae30\ubcf8 \uae30\ub2a5\uc73c\ub85c \uad6c\ud604\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4. YoY (Year-over-Year)\ub294 \ud55c \uc5f0\ub3c4\uc758 \ud2b9\uc815 \uae30\uac04\uc744 1\ub144 \uc804 \uac19\uc740 \uae30\uac04\uacfc \ube44\uad50\ud558\uc5ec \uc131\uc7a5\ub960\uc774\ub098 \uc131\uacfc \ubcc0\ud654\ub97c \ub098\ud0c0\ub0b4\ub294 \ubd84\uc11d \uc9c0\ud45c\ub85c, \uc8fc\ub85c \uae30\uc5c5\uc758 \ub9e4\ucd9c\uc774\ub098 \uc774\uc775\uacfc \uac19\uc740","twitter:image":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png"},"aioseo_meta_data":{"post_id":"16593","title":null,"description":null,"keywords":null,"keyphrases":{"focus":[],"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2024-11-21 11:09:18","updated":"2026-08-20 01:42:38","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.autooffice.co.kr\/en\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/lookerstudio\/\" title=\"\ub370\uc774\ud130 \uc2a4\ud29c\ub514\uc624\">\ub370\uc774\ud130 \uc2a4\ud29c\ub514\uc624<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c YoY (Year-over-Year) \uad6c\ud604\ud558\uae30: \ube45\ucffc\ub9ac\ub97c \uc751\uc6a9\ud55c \ube44\uad50\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.autooffice.co.kr\/en\/"},{"label":"\ub370\uc774\ud130 \uc2a4\ud29c\ub514\uc624","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/lookerstudio\/"},{"label":"\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c YoY (Year-over-Year) \uad6c\ud604\ud558\uae30: \ube45\ucffc\ub9ac\ub97c \uc751\uc6a9\ud55c \ube44\uad50","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/"}],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=16593"}],"version-history":[{"count":7,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16593\/revisions"}],"predecessor-version":[{"id":17131,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16593\/revisions\/17131"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/16594"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=16593"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=16593"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=16593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}