{"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><br><\/p>\n\n\n\n<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.<\/p>\n\n\n\n<p>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>\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><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\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><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><br><\/p>\n\n\n\n<p>\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><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><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><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><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>\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>\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><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><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><br><\/p>\n\n\n\n<p><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><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><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>\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><br><br><br><br><br><\/p>\n\n\n\n<p><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>\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><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><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>\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><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><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><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><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><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><br><\/p>\n\n\n\n<p>\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><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><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><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><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><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><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>\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><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><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><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\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>\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>\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>\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><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><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>\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><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><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>\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>\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><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p><\/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><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><br><\/p>\n\n\n\n<p><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":{"_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.2","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":false},"en":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"_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}]}}