{"id":3221,"date":"2020-08-25T21:59:11","date_gmt":"2020-08-25T12:59:11","guid":{"rendered":"http:\/\/autooffice.co.kr\/?p=3221"},"modified":"2025-09-15T19:21:12","modified_gmt":"2025-09-15T10:21:12","slug":"bigquery-arima-%eb%aa%a8%eb%8d%b8-%eb%8b%a8%ec%9d%bc-%ec%8b%9c%ea%b3%84%ec%97%b4-%ec%98%88%ec%b8%a1","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/08\/25\/bigquery-arima-%eb%aa%a8%eb%8d%b8-%eb%8b%a8%ec%9d%bc-%ec%8b%9c%ea%b3%84%ec%97%b4-%ec%98%88%ec%b8%a1\/","title":{"rendered":"BigQuery: ARIMA \ubaa8\ub378 \ub2e8\uc77c \uc2dc\uacc4\uc5f4 \uc608\uce21"},"content":{"rendered":"\n<p>BigQuery \uc5d0\uc11c\ub294 \ub85c\uc9c0\uc2a4\ud2f1 \ud68c\uadc0\ubd84\uc11d, \uc120\ud615\ud68c\uadc0\ubd84\uc11d\uc744 \ube44\ub86f\ud574 \ub2e4\uc591\ud55c \uba38\uc2e0\ub7ec\ub2dd \ubaa8\ub378\ub9c1\uc73c\ub85c \uac12\uc744 \uc608\uce21\uc744 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uc774\ubc88 \ud3ec\uc2a4\ud305\uc5d0\uc11c\ub294 ARIMA \ubaa8\ub378 \ub2e8\uc77c \uc2dc\uacc4\uc5f4 \uc608\uce21\uc744 \uc0b4\ud3b4\ubcf4\uace0\uc790 \ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<p><a href=\"https:\/\/cloud.google.com\/bigquery-ml\/docs\/arima-single-time-series-forecasting-tutorial?hl=ko\" target=\"_blank\" rel=\"noreferrer noopener\">\uad6c\uae00 \uacf5\uc2dd \ub3c4\uc6c0\ub9d0<\/a>\uc5d0\uc11c\ub294 Google \uc560\ub110\ub9ac\ud2f1\uc2a4 360\uc758 \ub370\uc774\ud130\ub97c \uc0ac\uc6a9\ud558\uc9c0\ub9cc, \ubaa8\ub378\ub9c1\uc774 \uc5bc\ub9c8\ub098 \uc815\ud655\ud55c\uc9c0 \ubcf4\uae30 \uc704\ud574\uc11c <a href=\"https:\/\/www.hyundai.com\/kr\/ko\/company-intro\/ir-information\/sales\/sales-record\" target=\"_blank\" rel=\"noreferrer noopener\">\ud604\ub300\uc790\ub3d9\ucc28\uc758 \ud310\ub9e4 \ub370\uc774\ud130<\/a>\ub97c \uc0ac\uc6a9\ud588\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\">1 \ub370\uc774\ud130 \uc900\ube44<\/h4>\n\n\n\n<p>\ud604\ub300\uc790\ub3d9\ucc28\uc758 \uad6d\ub0b4 \ucc28\uc885\ubcc4 \ud310\ub9e4 \ub370\uc774\ud130\ub97c <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1JLOBxFHzL6U6GZDD8qO4HGciyD7Mb0qD2s5R45ebTmc\/edit?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">\uc900\ube44<\/a>\ud588\uc2b5\ub2c8\ub2e4. IONIQ, AVANTE AD, LF SONATA \ucc28\uc885\uc744 \uc0b4\ud3b4\ubcf4\uace0\uc790 \ud558\ub294\ub370\uc694. <\/p>\n\n\n\n<p>\ubaa8\ub378\ub9c1\uc744 \uc704\ud55c \ucda9\ubd84\ud55c \uae30\uac04\uc758 \ub370\uc774\ud130\uac00 \uc788\uace0, \uc608\uce21 \uacb0\uacfc\uc640 \uc2e4\uc81c\uac12\uc744 \ube44\uad50\ud574\ubcfc \uc218 \uc788\uc744\ub9cc\ud55c \ucc28\uc885\uc73c\ub85c \ubcf4\uc5ec \uc120\ud0dd\ud588\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uc6b0\uc120 \uad6c\uae00 \uc2dc\ud2b8\ub85c \ub370\uc774\ud130\ub97c \uc815\ub9ac\ud558\uace0 \ube45\ucffc\ub9ac\uc5d0 \uc5f0\uacb0\uc744 \uc9c4\ud589\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc900\ube44\ud569\ub2c8\ub2e4. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"973\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-67-1024x973.png\" alt=\"\ub370\uc774\ud130 \uc900\ube44\" class=\"wp-image-3223\" style=\"width:544px;height:517px\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-67-1024x973.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-67-300x285.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-67-768x730.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-67.png 1308w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1038\" height=\"687\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-68-edited.png\" alt=\"\ube45\ucffc\ub9ac \ub370\uc774\ud130\" class=\"wp-image-3233\" style=\"width:541px;height:358.7294921875px\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-68-edited.png 1038w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-68-edited-300x199.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-68-edited-1024x678.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-68-edited-768x508.png 768w\" sizes=\"auto, (max-width: 1038px) 100vw, 1038px\" \/><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\">2 ARIMA \ubaa8\ub378\ub9c1<\/h4>\n\n\n\n<p><strong>\uac01 \ucc28\uc885\ubcc4\ub85c ARIMA \ubaa8\ub378\ub9c1\uc744 \uc9c4\ud589<\/strong>\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\ub370\uc774\ud130\ub85c \uc0ac\uc6a9\ud558\ub294 \uc5f4\uc774 \ub2e4\ub974\uace0, \uadf8\uc5d0 \ub530\ub77c \ubaa8\ub378\ub9c1\ub3c4 \ub2ec\ub77c\uc838\uc57c\ud558\uae30 \ub54c\ubb38\uc5d0, \ucf54\ub4dc\uc5d0\uc11c <strong>\ubcfc\ub4dc \ud45c\uc2dc\ud55c \ubd80\ubd84\uc744 \uac01 \ucc28\ub7c9\uc5d0 \ub9de\uac8c \ubcc0\uacbd<\/strong>\ud558\uc5ec \uc801\uc6a9\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uc720\uc758\ud560 \uc810\uc73c\ub85c <strong>\ubaa8\ub378\ub9c1 \uc18c\uc2a4\ub85c \uc0ac\uc6a9\ud560 \uc2e4\uc81c \ub370\uc774\ud130\uc758 time \uc758 \ubc94\uc704<\/strong>\ub97c \uc124\uc815\ud574\uc8fc\uc5c8\ub294\ub370\uc694. <\/p>\n\n\n\n<p>IONIQ \uc740 2019-07-01 \uae4c\uc9c0\uc758 43\uac1c\uc758 \ub370\uc774\ud130\ub85c \ubaa8\ub378\ub9c1\uc744 \uc138\ud305\ud574\uc11c, 8\uc6d4\ubd80\ud130 12\uac1c\uc6d4\uc758 \uc608\uce21\uc744 \uc9c4\ud589\ud558\uace0 \uc2e4\uc81c\uac12\uacfc \ube44\uad50\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<p>AVANTE AD \ub294 2019-03-01 \uae4c\uc9c0\uc758 43\uac1c\uc758 \ub370\uc774\ud130\ub85c \ubaa8\ub378\ub9c1\uc744 \uc138\ud305\ud574\uc11c, 4\uc6d4\ubd80\ud130 \uc544\ubc18\ub5bc \uc2e0\ud615 CN7 \ucd9c\uc2dc\uc6d4 \uc804\uae4c\uc9c0 12\uac1c\uc6d4\uc758 \uc608\uce21\uc744 \uc9c4\ud589\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<p>LF SONATA \ub294 2014-04-01 \ubd80\ud130 2018-03-01\uae4c\uc9c0\uc758 48\uac1c\uc758 \ub370\uc774\ud130\ub85c \ubaa8\ub378\ub9c1\uc744 \uc138\ud305\ud574\uc11c, 2019\ub144 4\uc6d4\ubd80\ud130 2020\ub144 7\uc6d4\uae4c\uc9c0\ub97c \uc608\uce21\ud569\ub2c8\ub2e4. \uc774 \uacbd\uc6b0\ub294 2019-03\uc5d0 \ud6c4\uc18d \ubaa8\ub378\uc778 DN8 \uc774 \ucd9c\uc2dc\ub418\uc5c8\uc9c0\ub9cc, \ube44\uad50\ubd84\uc11d\uc744 \uc704\ud574 2020\ub144 7\uc6d4\uae4c\uc9c0\ub85c \uc138\ud305\ud588\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<pre class=\"wp-block-verse\">#standardSQL\nCREATE OR REPLACE MODEL bqml_tutorial.ga_arima_model<strong>_ioniq<\/strong>\n     OPTIONS\n     (model_type = 'ARIMA',\n      time_series_timestamp_col = 'parsed_date',\n      time_series_data_col = 'total_sales'\n      ) AS\n     SELECT\n          time AS parsed_date,\n          SUM(<strong>ioniq<\/strong>) AS total_sales\n     FROM\n          bqml_tutorial.hmc\n     WHERE <strong>time &lt;=\"2019-07-01\"<\/strong>\n     GROUP BY time<\/pre>\n\n\n\n<p>\ubaa8\ub378\ub9c1\uc5d0\ub294 \uc624\ub79c \uc2dc\uac04\uc774 \uac78\ub9ac\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ubaa8\ub378\ub9c1\uc774 \uc9c4\ud589\ub418\uace0 \ub098\uba74, \ud14c\uc774\ube14\uc774 \uc0dd\uc131\ub429\ub2c8\ub2e4. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"536\" height=\"361\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-69.png\" alt=\"\ud14c\uc774\ube14\" class=\"wp-image-3226\" style=\"width:400px;height:269px\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-69.png 536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-69-300x202.png 300w\" sizes=\"auto, (max-width: 536px) 100vw, 536px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\">3 ARIMA \ubaa8\ub378 \uae30\ubc18 \uc608\uce21<\/h4>\n\n\n\n<p>\uc774\uc81c \ubaa8\ub378\ub9c1\uc73c\ub85c \uc608\uce21\uc744 \uc9c4\ud589\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<p><strong>\ucc28\ub7c9\uc5d0 \ub530\ub77c \ucf54\ub4dc\uc5d0\uc11c \ubcfc\ub4dc\ub85c \ud45c\uc2dc\ud55c \ubd80\ubd84\ub9cc \ubc14\uafd4\uc90d\ub2c8\ub2e4.<\/strong> <\/p>\n\n\n\n<p>\uc608\uce21\ud560 \uae30\uac04\uc5d0 \ub530\ub77c\uc11c \uc22b\uc790\ub97c \ubcc0\uacbd\ud558\ub294\ub370, \uc774\ubc88 \uacbd\uc6b0\uc5d0\ub294 IONIQ \uc740 12, AVANTE \ub294 12, SONATA \ub294 28 \uc785\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\ubaa8\ub4e0 \uc608\uce21\uc5d0 \uc2e0\ub8b0\uc218\uc900\uc740 0.8\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<pre class=\"wp-block-verse\">#standardSQL\nSELECT\n     history_timestamp AS timestamp,\n     history_value,\n     NULL AS forecast_value,\n     NULL AS prediction_interval_lower_bound,\n     NULL AS prediction_interval_upper_bound\n     FROM\n     (\n     SELECT\n          time AS history_timestamp,\n          SUM(<strong>ioniq<\/strong>) AS history_value\n     FROM\n          bqml_tutorial.hmc\n     GROUP BY time\n     ORDER BY time ASC\n     )\n     UNION ALL\n     SELECT\n          forecast_timestamp AS timestamp,\n          NULL AS history_value,\n          forecast_value,\n          prediction_interval_lower_bound,\n          prediction_interval_upper_bound\n     FROM\n          ML.FORECAST(MODEL bqml_tutorial.ga_arima_model_<strong>ioniq<\/strong>,\n    STRUCT(<strong>12<\/strong> AS horizon, 0.8 AS confidence_level))<\/pre>\n\n\n\n<p>\uc774\uc81c \uacb0\uacfc\uac00 \uc5b4\ub5bb\uac8c \ub098\uc62c\uae4c\uc694? \ud558\ub098\uc529 \uc0b4\ud3b4\ubcf4\uc2dc\uc8e0.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h5 class=\"wp-block-heading\">1) IONIQ (<a href=\"https:\/\/datastudio.google.com\/reporting\/c58f8988-af4b-442b-a31d-70cb0000b5fc\" target=\"_blank\" rel=\"noreferrer noopener\">\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\ub85c \ubcf4\uae30<\/a>)<\/h5>\n\n\n\n<p>2016-01\ubd80\ud130 2019-07\uae4c\uc9c0\uc758 \ub370\uc774\ud130\ub85c \ubaa8\ub378\ub9c1\uc744 \uc9c4\ud589\ud558\uace0, 2019-08\ubd80\ud130 12\uac1c\uc6d4\uac04\uc758 \uc608\uce21\uc744 \uc9c4\ud589\ud588\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uacfc\uc5f0 \uc608\uce21\uc774 \uc5bc\ub9c8\ub098 \ub9de\uc744\uae4c\uc694? <\/p>\n\n\n\n<p>\uc2e4 \ud310\ub9e4\ub7c9\uc774 \ud30c\ub780\uc0c9 \uadf8\ub798\ud504\uc785\ub2c8\ub2e4. \uc5d0\uba54\ub784\ub4dc\uc0c9\uc774 \uc608\uce21\uac12\uc774\uace0, \uc8fc\ud669\uc0c9\uc774 \uc2e0\ub8b0\uc0c1\ud55c, \ud551\ud06c\uc0c9\uc774 \uc2e0\ub8b0\ud558\ud55c\uc785\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uc2e4 \ud310\ub9e4\ub7c9\uc774 \uc608\uce21\uac12\ubcf4\ub2e4 \ud56d\uc0c1 \uc544\ub798\uc5d0 \uc788\uc9c0\ub9cc <strong>\uc5b4\ub290 \uc815\ub3c4 \ub9de\ub294 \uac83 \uac19\uc2b5\ub2c8\ub2e4.<\/strong> <\/p>\n\n\n\n<p>\ud558\uc9c0\ub9cc, \uc544\uc774\uc624\ub2c9 \uc138\uc77c\uc988\ud300\uc5d0\uc11c\ub294 \uc774 \uacb0\uacfc\ub97c \ubcc4\ub85c \uc88b\uc544\ud558\uc9c0\ub294 \uc54a\uc744 \uac83 \uac19\ub124\uc694. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"380\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-70-1024x380.png\" alt=\"\uc544\uc774\uc624\ub2c9 \uc2e0\ub8b0\uc218\uc900 0.8\" class=\"wp-image-3227\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-70-1024x380.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-70-300x111.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-70-768x285.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-70-1536x569.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-70-2048x759.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\ubaa8\ub378\ub9c1\uc5d0 \uc0ac\uc6a9\ud55c \ub370\uc774\ud130\uac00 \uc801\uc740 \ud3b8\uc774\ub77c, \uc2e0\ub8b0\uc218\uc900\uc744 0.95\ub85c \uc62c\ub824\ubcf4\uc558\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\ubc88\uc5d0\ub294 \ubaa8\ub4e0 \uc2e4 \ud310\ub9e4\ub7c9\uc774 \uc0c1\ud558\ud55c \ubc94\uc704\uc5d0 \ub4e4\uc5b4\uc635\ub2c8\ub2e4. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"373\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-73-1024x373.png\" alt=\"\uc544\uc774\uc624\ub2c9 \uc2e0\ub8b0\uc218\uc900 0.95\" class=\"wp-image-3230\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-73-1024x373.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-73-300x109.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-73-768x280.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-73-1536x560.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-73-2048x746.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h5 class=\"wp-block-heading\">2) AVANTE AD (<a href=\"https:\/\/datastudio.google.com\/reporting\/fd011819-ca46-4cb6-b9b8-47b3b722403e\" target=\"_blank\" rel=\"noreferrer noopener\">\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\ub85c \ubcf4\uae30<\/a>)<\/h5>\n\n\n\n<p>2015-09\ubd80\ud130 2019-03\uae4c\uc9c0\uc758 \ub370\uc774\ud130\ub85c \ubaa8\ub378\ub9c1\uc744 \uc9c4\ud589\ud558\uace0, 2019-04\ubd80\ud130 2020-03\uae4c\uc9c0 12\uac1c\uc6d4\uac04\uc758 \uc608\uce21\uc744 \uc9c4\ud589\ud588\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uc2e0\ud615 \uc544\ubc18\ub5bc\uac00 2020-04\uc5d0 \ucd9c\uc2dc\ud558\uc5ec\uc11c \uc774\ud6c4 \uc608\uce21\uc740 \ub9de\uc744 \uc218\uac00 \uc5c6\uae30\uc5d0 \uc81c\uc678\ud588\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uc774\ubc88 \uacb0\uacfc\ub294 \uaf64 \ud765\ubbf8\ub86d\uc2b5\ub2c8\ub2e4. \ubaa8\ub378\ub9c1\uc5d0 \uc0ac\uc6a9\ud55c \ud45c\ubcf8\uc758 \uc218\ub294 IONIQ\uacfc \ub3d9\uc77c\ud55c\ub370, <strong>\ub354 \uc815\ud655\ud55c \uc608\uce21<\/strong>\uc774 \ub418\uc5c8\ub124\uc694. <\/p>\n\n\n\n<p>2019\ub144 12\uc6d4\ubd80\ud130 \uc608\uce21\uacfc \uc2e4\uc81c\uac00 \ub9de\uc9c0 \uc54a\ub294\ub370, <strong>\uc2e0\ud615 \uc544\ubc18\ub5bc\uc758 \ucd9c\uc2dc \uc608\uc815\uc77c\uc774 \uacf5\uac1c<\/strong>\ub418\uace0 \ucf54\ub85c\ub09819\ub85c \uacbd\uc81c\uac00 \uc704\ucd95\ub418\uc5b4\uc11c\uc77c\uae4c\uc694?<\/p>\n\n\n\n<p>\uadf8\ub798\ub3c4 2019\ub144 3\uc6d4 \uc2dc\uc810\uc5d0\uc11c \uc57d 8-9\uac1c\uc6d4\uac04\uc758 \ubbf8\ub798 \uc608\uce21\uc744 \uc815\ud655\ud558\uac8c \ud560 \uc218 \uc788\uc5c8\ub2e4\uba74 \ub9c8\ucf00\ud305\uc5d0 \uaf64 \ub3c4\uc6c0\uc774 \ub418\uc9c0 \uc54a\uc558\uc744\uae4c \uc2f6\uc2b5\ub2c8\ub2e4. (\ubb3c\ub860 \uadf8\ub807\uac8c \uc608\uce21\ud558\uace0 \ucd94\uc9c4\ud558\uace0 \uc788\uc73c\ub9ac\ub77c \uc0dd\uac01\ud569\ub2c8\ub2e4. )<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"373\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-71-1024x373.png\" alt=\"\uc544\ubc18\ub5bc\" class=\"wp-image-3228\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-71-1024x373.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-71-300x109.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-71-768x280.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-71-1536x559.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-71-2048x746.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h5 class=\"wp-block-heading\">3) LF SONATA (<a href=\"https:\/\/datastudio.google.com\/reporting\/40214e4b-44c7-4e5a-927c-d3daa08740ce\" target=\"_blank\" rel=\"noreferrer noopener\">\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\ub85c \ubcf4\uae30<\/a>)<\/h5>\n\n\n\n<p>2014-04\ubd80\ud130 2018-03\uae4c\uc9c0\uc758 \ub370\uc774\ud130\ub85c \ubaa8\ub378\ub9c1\uc744 \uc9c4\ud589\ud558\uace0, 2018-04\ubd80\ud130 2020-07\uae4c\uc9c0 \uc608\uce21\uc744 \uc9c4\ud589\ud588\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>2019-03\uc5d0 \ud6c4\uc18d \ubaa8\ub378\uc774 \ucd9c\uc2dc\ub418\uc5c8\uae30 \ub54c\ubb38\uc5d0 \uc608\uce21 \ub370\uc774\ud130\ub294 \ub9de\uc9c0 \uc54a\uc744 \uac83\uc774\uc9c0\ub9cc, \uc5b4\ub5a4\uc9c0 \ubcf4\uae30 \uc704\ud574 \uc608\uce21 \uae30\uac04\uc744 \uae38\uac8c \ud588\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>ARIMA \ubaa8\ub378\uc5d0\uc11c \uc77c\uc790\uc640 \uc2dc\uac04\uc740 TIMESTAMP \uac12\uc73c\ub85c \uc785\ub825\ud574\uc57c\ud558\ub294\ub370, \uad6c\ud560 \uc218 \uc788\ub294 \ub370\uc774\ud130\ub294 \uc6d4 \ud310\ub9e4\ub7c9\uc774\ub77c \ub9e4\uc6d4 1\uc77c\ub85c \uc6d4 \ud310\ub9e4\ub7c9\uc744 \uc138\ud305\ud574\uc11c \uadf8\ub7f0\uc9c0, \uc608\uce21\uc77c\uc790\ub4e4\uc774 \uc870\uae08\uc529 \ubc00\ub824\uc11c \uc911\uac04\uc5d0 \ub204\ub77d\ub418\ub294 \uc6d4(2019-02)\uc774 \uc0dd\uae34 \uac83 \uac19\uc2b5\ub2c8\ub2e4. \ud06c\uac8c \ubb38\uc81c\ub294 \uc548\ub418\ub294 \uac83 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc608\uce21 \ucc98\uc74c\ubd80\ud130 \uc798 \ub9de\uc9c0\uac00 \uc54a\uc2b5\ub2c8\ub2e4. <strong>\uc608\uc0c1\ubcf4\ub2e4 \ubd80\uc9c4\ud55c \ud310\ub9e4<\/strong>\uc5d0 \ubb34\uc2a8 \uc774\uc720\uac00 \uc788\uc744\uae4c\uc694? (<a href=\"https:\/\/www.mk.co.kr\/news\/business\/view\/2018\/12\/801033\/\" target=\"_blank\" rel=\"noreferrer noopener\">2018\ub144 \ud310\ub9e4 \ubd80\uc9c4\uc5d0 \ub300\ud55c \ub9e4\uacbd \uae30\uc0ac<\/a>)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"370\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-72-1024x370.png\" alt=\"\uc3d8\ub098\ud0c0 0.8 \" class=\"wp-image-3229\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-72-1024x370.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-72-300x108.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-72-768x278.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-72-1536x555.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-72-2048x740.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\uc2e0\ub8b0\uc218\uc900\uc744 0.95\ub85c \uc62c\ub838\uc2b5\ub2c8\ub2e4. \uc0c1\ud558\ud55c\uc774 \uc880 \ub354 \ub298\uc5b4\ub098\uac8c \ub418\ub294\ub370\uc694. \uadf8\ub798\ub3c4 \uaca8\uc6b0 \ub9de\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\ud558\ud55c\uc744 \ubc97\uc5b4\ub098\ub294 \uac12\uc774 \uc788\ub294 \uac83\uc740 \uc88b\uc740 \uacb0\uacfc\ub294 \uc544\ub2c8\uaca0\uc8e0. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"374\" src=\"http:\/\/autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-74-1024x374.png\" alt=\"\uc3d8\ub098\ud0c0 0.95\" class=\"wp-image-3231\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-74-1024x374.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-74-300x110.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-74-768x281.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-74-1536x561.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2020\/08\/image-74-2048x748.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\ub9cc\uc57d, \uc608\uce21 \uac12\ub300\ub85c \ud310\ub9e4\uac00 \ub418\uc5c8\ub2e4\uba74 \uc5b4\ub5bb\uac8c \ub418\uc5c8\uc744\uae4c\uc694? <\/p>\n\n\n\n<p>2018-04 ~ 2018-12 \uad6c\uac04\uc774 \uc608\uce21 \uac12\ub300\ub85c\uc600\ub2e4\uba74, 2018\ub144\uc5d0\ub294 \ucd1d 75,233\ub300\ub97c \ud310\ub9e4\ud588\uc744\ud150\ub370\uc694. <\/p>\n\n\n\n<p>\uadf8\ub807\ub2e4\uba74 \ucd1d \ud310\ub9e4\uc21c\uc704\uac00 7\uc704\uc5d0\uc11c 6\uc704 \uc3d8\ub80c\ud1a0\ub97c \uc81c\uce58\uace0 \ud55c \ub2e8\uacc4 \uc62c\ub77c\uac14\uaca0\ub124\uc694. 5\uc704 \uc544\ubc18\ub5bc AD\uc640\ub3c4 \uadfc\uc811\ud558\uae30 \ub54c\ubb38\uc5d0 5\uc704\uae4c\uc9c0\ub3c4 \uc62c\ub77c\uac14\uc744\uc9c0 \ubaa8\ub974\uaca0\uc2b5\ub2c8\ub2e4.  (<a href=\"http:\/\/www.autoview.co.kr\/content\/article.asp?num_code=66544\" target=\"_blank\" rel=\"noreferrer noopener\">2018\ub144 \uad6d\uc0b0 \ucc28\uc885 \ud310\ub9e4\ub7c9 \uc21c\uc704<\/a>)<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p>\uc774\ubc88 \ud3ec\uc2a4\ud305\uc744 \ud1b5\ud574\uc11c ARIMA \ubaa8\ub378 \uc2dc\uacc4\uc5f4 \uc608\uce21\uacfc \ube44\uad50\ub97c \uc9c4\ud589\ud558\uae30 \uc704\ud574\uc11c \uc5ec\ub7ec \uc790\ub8cc\ub97c \ucc38\uace0\ud588\uc5c8\ub294\ub370, \ub9c1\ud06c\ub97c \uacf5\uc720\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<p><a href=\"https:\/\/otexts.com\/fppkr\/data-methods.html\" target=\"_blank\" rel=\"noreferrer noopener\">Forecasting: Principles&nbsp;and&nbsp;Practice &#8211; \uc608\uce21 \ub370\uc774\ud130\uc640 \uae30\ubc95<\/a> : \ud310\ub9e4\ub7c9\ub9cc\uc744 \uac00\uc9c0\uace0 \ubbf8\ub798\ub97c \uc608\uce21\ud558\ub294 \uac83\uc758 \ud55c\uacc4\ub294 \uc874\uc7ac\ud568\uc744 \uc54c\ub824\uc90d\ub2c8\ub2e4. <\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\uac00\uc7a5 \ub2e8\uc21c\ud55c \uc2dc\uacc4\uc5f4 \uc608\uce21 \uae30\ubc95\uc740 \uc608\uce21\ud560 \ubcc0\uc218 \uc815\ubcf4\ub9cc \uc774\uc6a9\ud558\uace0, \ubcc0\uc218\uc758 \ud589\ub3d9\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\ub294 \ub2e4\ub978 \uc694\uc778\ub4e4\uc744 \uace0\ub824\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.\u00a0<\/p>\n<\/blockquote>\n\n\n\n<p>\uc2e0\ub8b0\uad6c\uac04\uc5d0 \ub300\ud55c \uc124\uba85 <a href=\"https:\/\/bioinformaticsandme.tistory.com\/256\" target=\"_blank\" rel=\"noreferrer noopener\">\ube14\ub85c\uadf8<\/a> : \uac04\ub2e8\uba85\ub8cc\ud558\uac8c \uc124\uba85\ud574\ub450\uc5b4\uc11c \uc88b\uc558\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p><a href=\"https:\/\/www.machinelearningplus.com\/time-series\/arima-model-time-series-forecasting-python\/\" target=\"_blank\" rel=\"noreferrer noopener\">ARIMA Model \u2013 Complete Guide to Time Series Forecasting in Python<\/a> : \ud30c\uc774\uc36c\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc740 \uc544\ub2c8\uc9c0\ub9cc, \uadf8\ub798\ud504\ub4e4\uc774 \uc774\ud574\ud558\ub294\ub370 \ub3c4\uc6c0\uc774 \ub418\uc5c8\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p><br><\/p>\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\/2025\/08\/image-27.png\" alt=\"\" class=\"wp-image-17075\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27.png 691w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27-300x222.png 300w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice\">\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\">\ud504\ub85c\uc81d\ud2b8 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/h2>\n\n\n\n<p><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSc-FiMM9foF0jEAWqL7IePJTEdQ0X9asQTENOIv_3mltyq2zg\/viewform?pli=1\" target=\"_blank\" rel=\"noopener\" title=\"\">\uc624\ud1a0\uc624\ud53c\uc2a4 \ud504\ub85c\uc81d\ud2b8 \ubb38\uc758<\/a><\/p>\n\n\n\n<p><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>BigQuery \uc5d0\uc11c\ub294 \ub85c\uc9c0\uc2a4\ud2f1 \ud68c\uadc0\ubd84\uc11d, \uc120\ud615\ud68c\uadc0\ubd84\uc11d\uc744 \ube44\ub86f\ud574 \ub2e4\uc591\ud55c \uba38\uc2e0\ub7ec\ub2dd \ubaa8\ub378\ub9c1\uc73c\ub85c \uac12\uc744 \uc608\uce21\uc744 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ubc88 \ud3ec\uc2a4\ud305\uc5d0\uc11c\ub294 ARIMA \ubaa8\ub378 \ub2e8\uc77c \uc2dc\uacc4\uc5f4 \uc608\uce21\uc744 \uc0b4\ud3b4\ubcf4\uace0\uc790 \ud569\ub2c8\ub2e4. \uad6c\uae00 \uacf5\uc2dd \ub3c4\uc6c0\ub9d0\uc5d0\uc11c\ub294 Google \uc560\ub110\ub9ac\ud2f1\uc2a4 360\uc758 \ub370\uc774\ud130\ub97c \uc0ac\uc6a9\ud558\uc9c0\ub9cc, \ubaa8\ub378\ub9c1\uc774 \uc5bc\ub9c8\ub098 \uc815\ud655\ud55c\uc9c0 \ubcf4\uae30 \uc704\ud574\uc11c \ud604\ub300\uc790\ub3d9\ucc28\uc758 \ud310\ub9e4 \ub370\uc774\ud130\ub97c \uc0ac\uc6a9\ud588\uc2b5\ub2c8\ub2e4. 1 \ub370\uc774\ud130 \uc900\ube44 \ud604\ub300\uc790\ub3d9\ucc28\uc758 \uad6d\ub0b4 \ucc28\uc885\ubcc4 \ud310\ub9e4 \ub370\uc774\ud130\ub97c \uc900\ube44\ud588\uc2b5\ub2c8\ub2e4. IONIQ, AVANTE AD, LF SONATA \ucc28\uc885\uc744&#8230;<\/p>\n","protected":false},"author":1,"featured_media":3228,"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":[41],"tags":[58,568,545,57,56],"class_list":["post-3221","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bigquery","tag-arima","tag-lookerstudio","tag-545","tag-57","tag-56"],"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\/3221","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=3221"}],"version-history":[{"count":2,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/3221\/revisions"}],"predecessor-version":[{"id":17268,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/3221\/revisions\/17268"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/3228"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=3221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=3221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=3221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}