Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Prophetを使った時系列予測
Search
Sponsored
·
Ship Features Fearlessly
Turn features on and off without deploys. Used by thousands of Ruby developers.
→
Kan Nishida
February 26, 2020
Technology
2k
1
Share
Prophetを使った時系列予測
- Prophetアルゴリズムの基本
- 検証のやり方
- 季節性での加法と乗法の使い分け
- 変数重要度と変数ごとの効果
Kan Nishida
February 26, 2020
More Decks by Kan Nishida
See All by Kan Nishida
Seminar #52 - Introduction to Exploratory Server
kanaugust
0
440
Exploratory セミナー #61 政府のオープンデータ e-Statの活用
kanaugust
0
1.2k
Exploratory セミナー #60 時系列データの加工、可視化、分析手法の紹介
kanaugust
0
1.3k
Seminar #51 - Machine Learning - How Variable Importance Works
kanaugust
0
750
Exploratory セミナー #59 テキストデータの加工
kanaugust
0
770
Seminar #50 - Salesforce Data, Clean, Visualize, Analyze, & Dashboard
kanaugust
1
510
Exploratory セミナー #58 Exploratory x Salesforce
kanaugust
0
380
Exploratory Seminar #49 - Introduction to Dashboard Cycle with Exploratory
kanaugust
0
530
Seminar #48 - Introduction to Exploratory v6.6
kanaugust
0
420
Other Decks in Technology
See All in Technology
ZOZOTOWNリプレイスでのSkills導入までの流れとこれから
zozotech
PRO
4
3.1k
AIがコードを書く時代の ジェネレーティブプログラミング
polidog
PRO
3
620
Databricks Lakebaseを用いたAIエージェント連携
daiki_akimoto_nttd
0
170
AIドリブン開発の実践知 ― AI-DLC Unicorn Gym実施から見えた可能性と課題
mixi_engineers
PRO
0
120
申請待ちゼロへ!AWS × Entra IDで実現した「権限付与」のセルフサービス化
mhrtech
1
110
Oracle Cloud Infrastructure(OCI):Onboarding Session(はじめてのOCI/Oracle Supportご利⽤ガイド)
oracle4engineer
PRO
2
17k
OCI技術資料 : ロード・バランサ 概要 - FLB・NLB共通
ocise
4
28k
推し活エージェント
yuntan_t
1
870
AWS DevOps Agent or Kiro の使いどころを考える_20260402
masakiokuda
0
190
Data Enabling Team立ち上げました
sansantech
PRO
0
290
不確実性と戦いながら見積もりを作成するプロセス/mitsumori-process
hirodragon112
1
200
Autonomous Database - Dedicated 技術詳細 / adb-d_technical_detail_jp
oracle4engineer
PRO
5
13k
Featured
See All Featured
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
31
2.7k
brightonSEO & MeasureFest 2025 - Christian Goodrich - Winning strategies for Black Friday CRO & PPC
cargoodrich
3
670
What's in a price? How to price your products and services
michaelherold
247
13k
Noah Learner - AI + Me: how we built a GSC Bulk Export data pipeline
techseoconnect
PRO
0
160
Unlocking the hidden potential of vector embeddings in international SEO
frankvandijk
0
760
ReactJS: Keep Simple. Everything can be a component!
pedronauck
666
130k
Code Review Best Practice
trishagee
74
20k
Exploring the relationship between traditional SERPs and Gen AI search
raygrieselhuber
PRO
2
3.8k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
38
2.8k
Taking LLMs out of the black box: A practical guide to human-in-the-loop distillation
inesmontani
PRO
3
2.1k
Large-scale JavaScript Application Architecture
addyosmani
515
110k
The World Runs on Bad Software
bkeepers
PRO
72
12k
Transcript
Exploratory ηϛφʔ #25 ProphetΛͬͨ࣌ܥྻ༧ଌ
EXPLORATORY
3 εϐʔΧʔ ా צҰ CEO EXPLORATORY ུྺ 2016य़ɺσʔλαΠΤϯεͷຽओԽͷͨΊɺExploratory, Inc Λཱ
্ͪ͛Δɻ Exploratory, Inc.ͰCEOΛΊΔ͔ͨΘΒɺσʔλαΠΤϯεɾϒʔ τΩϟϯϓɾτϨʔχϯάͳͲΛ௨ͯ͠σʔλαΠΤϯεͷٕज़ͱख ๏ͷීٴͱڭҭʹऔΓΉɻ ถΦϥΫϧຊࣾͰɺ16ʹΘͨΓσʔλαΠΤϯεͷ։ൃνʔϜΛ ͍ɺػցֶशɺϏοάɾσʔλɺϏδωεɾΠϯςϦδΣϯεɺσʔ λϕʔεʹؔ͢Δଟ͘ͷΛੈʹૹΓग़ͨ͠ɻ @KanAugust
Vision ΑΓΑ͍ҙࢥܾఆΛ͢ΔͨΊʹ σʔλΛ͏͜ͱ͕ͨΓલʹͳΔ
Mission σʔλαΠΤϯεͷຽओԽ
6 ୈ̏ͷ σʔλαΠΤϯεɺAIɺػցֶश౷ܭֶऀɺ։ൃऀͷͨΊ͚ͩͷͷͰ͋Γ·ͤΜɻ σʔλʹڵຯͷ͋ΔਓͳΒ୭͕ੈքͰ࠷ઌͷΞϧΰϦζϜΛͬͯ ϏδωεσʔλΛ؆୯ʹੳͰ͖Δ͖Ͱ͢ɻ Exploratory͕ͦ͏ͨ͠ੈքΛՄೳʹ͠·͢ɻ
ୈ1ͷ ୈ̎ͷ ୈ̏ͷ ϓϥΠϕʔτ(ߴ͍/ݹ͍) Φʔϓϯɾιʔε(ແྉ/࠷ઌ) UI & ϓϩάϥϛϯά ϓϩάϥϛϯά 2016
2000 1976 ϚωλΠθʔγϣϯ ίϞσΟςΟԽ ຽओԽ ౷ܭֶऀ σʔλαΠΤϯςΟετ Exploratory ΞϧΰϦζϜ Ϣʔβʔɾ ମݧ πʔϧ Φʔϓϯɾιʔε(ແྉ/࠷ઌ) UI & ࣗಈԽ ϏδωεɾϢʔβʔ ςʔϚ σʔλαΠΤϯεͷຽओԽ
質問 ExploratoryɹϞμϯˍγϯϓϧ UI 伝える データアクセス データ ラングリング 可視化 アナリティクス 統計/機械学習
Exploratory ηϛφʔ #25 ProphetΛͬͨ࣌ܥྻ༧ଌ
࣌ܥྻ༧ଌϞσϧ • ڭࢣ͋ΓֶशͷҰछɻ • աڈͷ࣌ܥྻσʔλΛτϨʔχϯάσʔλͱͯ͠ɺকདྷͷΛ༧ଌ ͢ΔϞσϧΛ࡞Δɻ 10
11 աڈNͷσʔλ͔Βɺ࣍ͷͷΛ༧ଌ͢ΔϞσϧΛ࡞͢Δɻ ࣌ܥྻ༧ଌ - ౷తͳΞϓϩʔν Day 1 Day 2 Day
3 Day 4 Day 2 Day 3 Day 4 Day 5 Day 3 Day 4 Day 5 Day 6
12 • σʔλؒͷִ࣌ؒؒσʔλΛ௨ͯ͠ҰఆͰ͋Δඞཁ͕͋Δɻ • ͕NA (ܽଛ)ͱͳΔ͕͋ͬͯͳΒͳ͍ɻ • ෳͷपظੑ (िͱ) Λಉ࣌ʹѻ͏ͷ͍͠ɻ
• ύϥϝʔλͷઃఆʹɺઐతͳ͕ࣝඞཁɻ ౷తͳΞϓϩʔνͰͷ࣌ܥྻ༧ଌͷ
13 • Facebookʹ͍ͨσʔλαΠΤϯςΟετ ʢSean J. Taylor & co.ʣ͕࡞ͬͨ࣌ܥྻ༧ ଌΞϧΰϦζϜͰɺΦʔϓϯιʔεͱͯ͠ ެ։͞Ε͍ͯΔɻ(https://
facebook.github.io/prophet) • ౷ܭɺ࣌ܥྻ༧ଌͷઐ͕ࣝͳͯ͘ ͑ΔΑ͏ʹσβΠϯ͞Ε͍ͯΔɻ Prophet Sean J. Taylor @seanjtaylor
14 • ҎԼͷཁૉͷͱͯ͠ද͢͜ͱͷͰ͖ΔΒ͔ͳۂઢͷ͏ͪɺաڈ σʔλʹ࠷ϑΟοτ͢ΔͷΛ୳͢ɻͦͷۂઢΛະདྷʹԆ͢Δ ͜ͱʹΑͬͯ༧ଌ͢Δɻ • େہతͳτϨϯυ • पظͷقઅੑ (ɺिɺͳͲ)
• ॕޮՌ - ΫϦεϚεɺ৽ɺ࣍ΠϕϯτɺͳͲɻ • ֎෦༧ଌม Prophet
15 େہతͳτϨϯυ
16 େہతͳτϨϯυ
17 पظͷقઅੑ
18 τϨϯυ + पظੑ
19 िपظͷมಈ
20 τϨϯυ + पظੑ + िपظੑ
21 τϨϯυ + पظੑ + िपظੑ 21
22 ॕޮՌ
23 τϨϯυ + पظੑ + िपظੑ + ॕޮՌ
24 • ࣌ؒͷൃలΛϞσϧͰදݱ͢Δ͜ͱ͖͋ΒΊΔɻ • ͔ΘΓʹɺ୯ʹۂઢΛݟ͚ͭΔͱ͍͏ʹ͢Δ͜ͱʹΑͬͯҎԼͷΑ͏ͳ རΛಘ͍ͯΔɻ • σʔλؒͷִ͕࣌ؒؒҰఆͰ͋Δඞཁͳ͍ɻ • ͕NA
(ܽଛ)ͱͳΔ͕͋ͬͯͳ͍ɻ • ෳͷपظੑ (िͱ) ͕σϑΥϧτͰߟྀ͞ΕΔɻ • σϑΥϧτͷઃఆͰͦΕͳΓͷ༧ଌ͕Ͱ͖ΔɻઃఆՄೳͳύϥϝʔλͷଟ ͘ઐࣝແ͠ͰཧղՄೳɻ Prophetͷར
Let’s do it! 25
Global Sales σʔλ 26
27 Sales (ച্)ΛϥΠϯνϟʔτͰՄࢹԽͯ͠ΈΔ • X࣠ʹOrder DateΛɺ࣌ؒ୯ҐΛ WEEKͱׂͯ͠ΓͯΔɻ • Y࣠ʹSalesΛɺؔΛSUM(߹ ܭ)ͱׂͯ͠ΓͯΔɻ
28
Salesʢച্ʣΛ༧ଌ͢ΔϞσϧΛ࡞Δ 29
ΞφϦςΟΫεɾϏϡʔΛબ͠ɺ࣌ܥྻ༧ଌΛબɻ 30
• /࣌ؒͷྻʹOrder DateΛ࣌ ؒ୯ҐΛWEEKͱׂͯ͠Γͯ Δɻ • ͷྻʹSalesΛɺؔΛ SUM(߹ܭ)ͱׂͯ͠ΓͯΔɻ 31
ϓϩύςΟɾμΠΞϩάΛͬͯɺ 1ؒͷ༧ଌΛ͢ΔͨΊʹɺ༧ଌظ ؒΛ52 (1ʹ52ि) ʹઃఆ͢Δɻ 32
࣮ߦϘλϯΛΫϦοΫ͢Δͱ༧ଌ͞Εͨσʔλ͕ΦϨϯδ৭ͷϥΠϯͰදࣔ͞ΕΔɻ 33 ΦϨϯδ৭ͷઢ͚ͩͷ۠ؒࠓޙ1ؒͷ༧ଌΛද͢ɻ ୶͍ΦϨϯδ৭༧ଌͷෆ֬ఆ۠ؒ(uncertainty interval)Λද͢ɻ
34 τϨϯυ λϒΛΫϦοΫ͢ΔͱτϨϯυϥΠϯͷೖͬͨνϟʔτ͕දࣔ͞ΕΔ άϦʔϯͷઢ͕τϨϯυϥΠϯ
35 ͷόʔɺτϨϯυʹมԽ͕͋ͬͨ࣌ʢνΣϯδϙΠϯτʣΛද͢ɻ ͷߴ͞ɺνΣϯδϙΠϯτͰͷτϨϯυϥΠϯͷ͖ͷมԽྔɻ
36 पظλϒΛΫϦοΫ͢Δͱपظͷνϟʔτ͕දࣔ͞ΕΔɻ
Every year, the sales doesn’t pick up until June, then
it goes down in July.
Weekly tab shows up only when the data is daily
or more granular levels (hour, minutes, etc.)
Every week, the sales are low on Sunday and Monday,
and the rest of the week is high.
40 िपظΛݟΔͨΊʹɺ࣌ؒ୯ҐΛʹมߋ࣮ͯ͠ߦ͢͠ɻ
σʔλͷલॲཧ ܽଛʢNAʣͷॲཧ
Somehow, the weekly seasonality doesn’t repeat exactly the same…
Somehow, the weekly seasonality doesn’t repeat exactly the same…
There are NA for some dates. You can impute NA
as part of the Data Preprocessing.
45 • จ͕Ұ݅ͳ͍ͷച্Λ0ͱͯ͠ѻ͏ͨ Ίɺͷྻʹ͕ͳ͍ͱ͖ͷॲཧʹ”θϩͰ ຒΊΔ”ΛબͿɻ • ͜ΕΛ͠ͳ͍߹ɺจ͕Ұ݅ͳ͍ ɺσʔλ͕ແ͍ͱͯ͠ѻΘΕΔɻ
None
None
Under the Importance tab, you can see which seasonality has
more effect on the forecasting outcome.
49 िपظλϒΛΫϦοΫ͢Δͱिपظͷνϟʔτ͕දࣔ͞ΕΔɻ
50 ޮՌλϒΛΫϦοΫ͢Δͱɺ༧ଌΛߏ͢Δ֤ཁૉʢτϨϯυɺقઅੑʣ͕දࣔ͞ΕΔɻ
51 มॏཁλϒΛΫϦοΫ͢ΔͱԿ͕༧ଌʹେ͖ͳӨڹΛ༩͍͑ͯΔͷ͔͕ݟ͑Δɻ
52 σʔλλϒΛΫϦοΫ͢Δͱ༧ଌ͖ͷσʔλ͕දࣔ͞ΕΔ
• forecasted_value - ༧ଌ • forecasted_value_high/forecasted_value_low - ෆ֬ఆ۠ؒ • trend
- େہతͳτϨϯυ • yearly - पظͷτϨϯυ • weekly - िपظͷτϨϯυ 53 ༧ଌ͖ͷσʔλͷಡΈํ
54 ࣌ܥྻ༧ଌͷධՁ
55 όοΫςετ • աڈσʔλͷ͏ͪɺ৽͍͠ظؒΛςετ༻ʹͱ͓ͬͯ͘ɻ • ςετظؒͷσʔλΛɺͦΕΑΓҎલͷσʔλΛͬͯ༧ଌ͢Δ • ༧ଌσʔλͱɺ࣮ࡍͷςετظؒͷσʔλΛൺֱධՁ͢Δɻ ࣌ܥྻ༧ଌͷςετ๏
σʔλΛ2ͭͷηΫγϣϯʹ͚Δɻ 56 τϨʔχϯάظؒ ςετظؒ
57 τϨʔχϯάσʔλΛͬͯ༧ଌϞσϧΛ࡞ΓɺςετظؒΛ༧ଌɻ ςετظؒͷ࣮ଌͱ༧ଌͷʮͣΕʯͷେ͖͞ΛධՁ͢Δɻ τϨʔχϯάظؒ ςετظؒ
58 • ࣌ؒͷ୯ҐʹMON(݄)Λࢦఆ͢Δɻ ςετϞʔυʹΓସ͑Δ
59 ςετϞʔυΛTRUEʹ͠ɺςετظؒΛ12 (݄) ͱ͢Δɻ
ࠨଆͷ੨͍ઢτϨʔχϯάσʔλɺӈଆͷਫ৭ͷઢςετ σʔλɻ 60
61 ੨৭ͷઢ͕τϨʔχϯάσʔλɻ ͜ͷൣғσʔλΛͱʹɺ༧ଌϞσϧ͕࡞ΒΕΔɻ
ΦϨϯδͷઢ͕ɺτϨʔχϯάσʔλΛݩʹ࡞ΒΕͨϞσϧʹ ΑΔ༧ଌσʔλɺബ͍ΦϨϯδͷྖҬͦͷ৴པ۠ؒͰ͋Δɻ 62
͜ͷൣғͷσʔλΛͱʹ༧ଌϞσϧ͕࡞ΒΕ͍ͯΔͨΊɺ ͜ͷൣғͷ࣮σʔλͱϞσϧʹΑΔ༧ଌσʔλ͔ͳΓҰக͍ͯ͠Δɻ 63
ςετظؒͷ༧ଌσʔλͱ࣮ଌͷζϨ͕ͲΕ͚ͩେ͖͍ͷ͔Λ ࢉग़͠ɺͦΕΛ࣋ͬͯϞσϧͷਫ਼ΛධՁ͍ͨ͠ɻ 64
ςετ݁ՌͷαϚϦ 65
66 • RMSE (Root Mean Square Error) : ༧ଌ͔ΒͷͣΕͷೋͷฏۉͷϧʔτ •
MAE (Mean Absolute Error) : ༧ଌ͔ΒͷͣΕͷઈରͷฏۉ • MAPE (Mean Absolute Percentage Error) : ύʔηϯτͰදͨ͠༧ଌ͔Βͷ ͣΕͷઈରͷฏۉ • MASE (Mean Absolute Scaled Error) : MAEΛɺτϨʔχϯάσʔλͰͷφ Πʔϒ༧ଌʢҰͭલͷظͱಉ͕͡ݱΕΔͰ͋Ζ͏ͱ͍͏୯७ͳ༧ଌʣ ͷMAEͰׂͬͨͷɻ ࣌ܥྻ༧ଌͷධՁࢦඪ
Rootʢฏํࠜʣ Meanʢฏۉʣ Squareʢ2ʣ Errorʢޡࠩʣ ͭ·Γɺ࣮ଌͱ༧ଌͷޡࠩ Λ2ͯ͠ɺͦͷฏۉΛͱΓɺͦ ͷͷฏํࠜΛͱͬͨͷ͜ ͱɻ 67 RMSE
(Root Mean Square Error)
22 + 22 + 22 + 42 4
(ͷ) 4 + 4 + 4 + 16 4 7 = 2.65 68 RMSE (Root Mean Square Error) 2 2 4 2 = = ྫ͑ɺ࣮ଌͱ༧ଌͷޡ͕ࠩͦΕ ͧΕ2, 2, 2, 4ͩͬͨͱ͢Δͱɺܭࢉ ҎԼͷΑ͏ʹͳΔɻ
Meanʢฏۉʣ Absoluteʢઈରʣ Errorʢޡࠩʣ ͭ·Γɺ࣮ଌͱ༧ଌͷޡࠩ ͷઈରͷฏۉ͜ͱɻ 69 MAE (Mean Absolute Error)
2 + 2 + 2 + 4 4
(ͷ) 70 ྫ͑ɺ࣮ଌͱ༧ଌͷޡ͕ࠩ ͦΕͧΕ2, 2, 2, 4ͩͬͨͱ͢Δ ͱɺܭࢉҎԼͷΑ͏ʹͳΔɻ = 2.5 MAE (Mean Absolute Error) 2 2 4 2
Meanʢฏۉʣ Absoluteʢઈରʣ Percentageʢׂ߹ʣ Errorʢޡࠩʣ ͭ·Γɺ࣮ଌͱ༧ଌͷޡࠩ ͷׂ߹ͷઈରͷฏۉ͜ͱɻ 71 MAPE (Mean Absolute
Percentage Error)
72 12 13 16 11 ·ͣɺ࣮ଌΛͱΊΔɻ MAPE (Mean Absolute Percentage
Error)
73 12 13 16 11 MAPE (Mean Absolute Percentage Error)
2 2 4 2 ࣍ʹɺ࣮ଌͱ༧ଌͷޡࠩ ΛͱΊΔɻ
74 100 100 100 100 MAPE (Mean Absolute Percentage Error)
16.6% 15.4% 25% 18.2% ࣮ଌͱ༧ଌͷޡࠩΛ࣮ଌͰ ׂͬͯ100Λ͔͚ɺͦΕͧΕͷ ύʔηϯςʔδΛͱΊΔɻ ࣈ͕ϚΠφεͷ߹ɺϚΠφε ͷූ߸ΛͱΔ (ઈର).
75 100 100 100 100 MAPE (Mean Absolute Percentage Error)
16.6% 15.4% 25% 18.2% 16.6 + 15.4 + 18.2 + 25 4 (ͷ) ࠷ޙʹɺ͜ΕΒͷͷฏۉΛग़͢ɻ = 18.8%
76 Meanʢฏۉʣ Absoluteʢઈରʣ ScaledʢεέʔϧௐࡁΈͷʣ Errorʢޡࠩʣ MAEΛҟͳΔεέʔϧͷσʔλ Ͱͷ༧ଌͲ͏͠ͰൺֱՄೳͳ Α͏ʹεέʔϧௐͨ͠ͷɻ MASE (Mean
Absolute Scaled Error)
77 MASE = ςετظؒͷMAE / τϨʔχϯάظؒͷφΠʔϒ༧ଌͷMAE MASE ςετظؒͷMAE τϨʔχϯάظؒͷφΠʔϒ༧ଌͷMAE
78 Ұظલͷ͕ɺࠓظͦͷ··ग़ΔͩΖ͏ɺͱ͍͏҆қͳ༧ଌɻ φΠʔϒ༧ଌ
79 φΠʔϒ༧ଌΛτϨʔχϯάظؒʹରͯ͠ߦͬͨͱ͖ͷMAEΛج४ͱͯ͠࠾༻ MASEͷεέʔϧௐͷج४
80 MASE = ςετظؒͷMAE / τϨʔχϯάظؒͷφΠʔϒ༧ଌͷMAE MASE ςετظؒͷMAE τϨʔχϯάظؒͷφΠʔϒ༧ଌͷMAE
81 قઅੑͷϞʔυ Ճ๏త vs ๏త
82 The difference between the actual line and the forecasted
line becomes wider as the time progresses.
Կ͕ى͖͍ͯΔͷ͔ʁ 83 • ച্͕͢ΔʹͭΕɺͦΕʹ͋ΘͤͯقઅੑʹΑΔมಈେ͖͘ͳΔͱ ߟ͑Δͷ͕ࣗવɻ • ͔͠͠ϞσϧقઅੑʹΑΔมಈͷେ͖͍ͭ͞ͰҰఆͰ͋Δͱ͍͏લ ఏͰ༧ଌ͍ͯ͠Δɻ • ͕࣌ؒͨͬͯച্͕ͨ͋͠ͱͰɺϞσϧ͕༧ଌ͢Δقઅมಈͷେ͖
͕͞ɺ࣮ࡍͷͷقઅมಈͷେ͖͞ʹ͍͍͚͍ͭͯͯͳ͍ͷͰͳ͍͔ʁ
ͱͯ͠Γཱ͍ͬͯΔͷϦχΞͳ৳ͼํ ੵͱͯ͠Γཱ͍ͬͯΔͷෳརޮՌͷ͋Δ৳ͼํ མͪண͍ͯΔձࣾͷैۀһͷਪҠ Amazonͷച্ߴͷਪҠ ͢Δͱ͖ͷͷ৳ͼํͷҧ͍ 84
ઌఔͷςετϞʔυͰͷ༧ଌ݁ՌΛ͏ҰݟͯΈΔͱ… 85 ࣮ࡍͷقઅมಈɺ༧ଌ݁ՌΑΓ େ͖͘ͳ͍ͬͯΔΑ͏ͩɻ
Կ͕ى͖͍ͯΔͷ͔ʁ 86 ച্ͷʹͱͳͬͯେ͖͘ͳΔقઅมಈΛϞσϧԽͰ͖ΕΑ͍ͷͰʁ • ച্͕͢ΔʹͭΕɺͦΕʹ͋ΘͤͯقઅੑʹΑΔมಈେ͖͘ͳΔͱ ߟ͑Δͷ͕ࣗવɻ • ͔͠͠ϞσϧقઅੑʹΑΔมಈͷେ͖͍ͭ͞ͰҰఆͰ͋Δͱ͍͏લ ఏͰ༧ଌ͍ͯ͠Δɻ •
͕࣌ؒͨͬͯച্͕ͨ͋͠ͱͰɺϞσϧ͕༧ଌ͢Δقઅมಈͷେ͖ ͕͞ɺ࣮ࡍͷͷقઅมಈͷେ͖͞ʹ͍͍͚͍ͭͯͯͳ͍ͷͰͳ͍͔ʁ
قઅੑϞʔυ 87 Ճ๏త ͠ࢉͰޮՌ͕ݱΕΔɻ ྫɿ12݄ϓϥε$100,000 ͱͷʹؔΘΒͣมಈͷେ͖͞Ұ ఆɻ ๏త ֻ͚ࢉͰޮՌ͕ݱΕΔ ྫɿ12݄ϓϥε10%
ͱͷ͕େ͖͚Εมಈେ͖ ͘ͳΔɻ
88 Ճ๏త ๏త
89 Ճ๏త ๏త قઅੑͷେ͖͞Ұఆ
90 Ճ๏త ๏త قઅੑͷେ͖͞Ұఆ قઅੑݩͷʢτϨϯυʣʹൺྫͯ͠େ͖͘ͳΔ
91 Ճ๏త ๏త قઅੑͷେ͖͞Ұఆ قઅੑݩͷʢτϨϯυʣʹൺྫͯ͠େ͖͘ͳΔ
قઅੑͷϞʔυʢՃ๏తɺ๏తʣͷΓସ͑ 92 ΞφϦςΟΫεɾϓϩύςΟͷقઅੑͷ ϞʔυͰɺՃ๏త͔๏త͔ΛΓ͔͑ Δ͜ͱ͕Ͱ͖Δɻ
93 Ճ๏త ๏త
94 Ճ๏త ๏త ๏తͳقઅੑΛͬͨ༧ଌͷ΄͏ ͕࣮ଌʹ༧ଌ͕ਵ͍ͯ͠Δɻ
95 Ճ๏త ๏త ςετ݁ՌΛΈΔͱɺ๏తͳقઅੑΛͬͨ༧ଌͷ΄͏͕ɺશͯͷࢦඪ ͰɺΑ͍݁Ռʢখ͍͞ʣʹͳ͍ͬͯΔɻ
قઅੑͷϞʔυʢՃ๏తɺ๏తʣͷൺֱ 96 قઅੑͷύλʔϯ͕ݟ͍͢Α͏ʹɺ࣌ ؒͷ୯ҐΛ͍ͬͨΜWEEK(ि)ʹͯ͠ɺ قઅੑͷϞʔυΛՃ๏తͱ๏తͷؒͰ Γସ͑ͯɺ༧ଌ݁ՌΛൺֱͯ͠ΈΔɻ
݄୯Ґʹͯ͠ɺςετ݁ՌΛൺֱ 97 ࣌ؒͷ୯ҐΛݩͷMON(݄)ʹͯ͠ɺقઅ ੑͷϞʔυΛՃ๏తͱ๏తͷؒͰΓ ସ͑ͯɺςετ݁ՌΛൺֱͯ͠ΈΔɻ
98 ʮ܁Γฦ͠ʯΛͬͯෳͷϞσϧΛ࡞Γɺ ͦΕΒΛൺֱ͢Δ
99 Ϛʔέοτ͝ͱʹ༧ଌϞσϧΛ࡞Γ͍ͨͷͰɺʮ܁Γฦ͠ʯʹ ’Market’ ྻΛબͿ
100
• RMSE, MAEͰݟΔͱɺAfrica (ΞϑϦΧ)ͷ΄͏͕Asia Pacific (ΞδΞଠฏ༸ Ҭ)ΑΓ༧ଌͱ࣮ଌͷ͕ࠩখ͍͜͞ͱ͕͔Δɻ • ͜ΕΛͬͯɺAfricaͷํ͕Α͘༧ଌͰ͖͍ͯΔͱݴ͑ΔͩΖ͏͔ʁ Ϟσϧͷ༧ଌਫ਼ͷࢦඪΛൺΔ
101
• Asia Pacific (ΞδΞଠฏ༸Ҭ) ͷํ͕Africa (ΞϑϦΧ)ΑΓച্ֹ͕େ͖͍ͷ ͰɺRMSE, MAE͕େ͖͘ͳΔͷͨΓલͱݴ͑Δɻ • ͷεέʔϧʹ͕ࠩ͋Δͱ͖ɺRMSEɺMAEʹΑΔ༧ଌੑೳͷൺֱҙຯΛ
ͳ͞ͳ͍ɻ Ϟσϧͷ༧ଌੑೳͷαϚϦͷදࣔ 102
• MAPEɺ༧ଌͱ࣮ଌͷࠩΛɺ࣮ଌͷύʔηϯτͰදͨ͠ͷɻ • ࣮ଌͷͱͱͷେ͖͞ʹؔͳ͘༧ଌੑೳͷൺֱ͕Ͱ͖Δɻ • RMSE, MAEͷେ͖͔ͬͨAsia Pacificͷ΄͏͕ɺMAPEΑΓখ͘͞ɺ࣮ AfricaΑΓΑ͍༧ଌ͕Ͱ͖͍ͯͨ͜ͱ͕͔Δɻ Ϟσϧͷ༧ଌੑೳͷαϚϦͷදࣔ
103
• MAPEಉ͡Α͏ʹɺ࣮ଌͷͱͱͷେ͖͞ʹؔͳ͘༧ଌੑೳͷൺֱ͕Ͱ͖Δɻ • MAPEɺ͕0Λ·͍ͨͩΓɺ0ʹۙ͘ͳΔͱ͖ෆ҆ఆʹͳΔ͕ɺMASEʹ͜ͷͳ͍ɻ • MASEͰݟͯɺRMSE, MAEͷେ͖͔ͬͨAsia Pacificͷ΄͏͕ɺ࣮ΑΓΑ͍༧ଌ͕Ͱ͖͍ͯͨ͜ͱ ͕͔Δɻ Ϟσϧͷ༧ଌੑೳͷαϚϦͷදࣔ
104
֎෦༧ଌม
ച্ʢSalesʣͱ૬ؔؔʹ͋Δม͕͋ͬͨͱͯ͠ɺ͞Βʹͦͷ มͷকདྷͷΛ༧ଌͰ͖Δɺ·ͨίϯτϩʔϧͰ͖Δͱͨ͠ Βɺച্ʢSalesʣΛ͞Βʹྑ͍ਫ਼Ͱ༧ଌͰ͖ΔͷͰͳ͍͔ʁ
Sales ͱ Sales Comp. ૬͍ؔͯ͠ΔΑ͏ͩɻ
Sales ͱ Marketing ૬͍ؔͯ͠ΔΑ͏ͩɻ
Sales ͱ Discount (Avg) ͋·Γ૬ؔͯͦ͠͏ʹͳ͍ɻ
ϚʔέςΟϯά ࣍ͷ3ϲ݄ɺͲΕ͚ͩࠂʹ͓ۚΛඅ͔͢ίϯτϩʔϧͰ͖Δͱͨ͠ ΒɺͦͷใΛϞσϧʹΈࠐΉ͜ͱͰ͖ͳ͍͔ʁ ྫ
ఱؾ ച্ఱؾʹΑͬͯӨڹΛड͚Δͱ͢Δͱɺ࣍ͷ10ؒͷؾԹ߱ਫ֬ Λ༧ଌͯ͠ɺͦΕΒΛച্ͷ༧ଌϞσϧʹΈࠐΉͱɺ͞Βʹྑ͍ਫ਼Ͱ ച্͛Λ༧ଌͰ͖ΔͷͰͳ͍ͩΖ͏͔ɻ ྫ
มʢྻʣΛ֎෦༧ଌมͱׂͯͯ͠ɺ༧ଌϞσϧΛ ࡞Δ͜ͱ͕Ͱ͖Δɻ Prophet֎෦༧ଌมʢྫɿϚʔέςΟϯάඅ༻ʣ͕ λʔήοτมʢྫɿച্ʣΛ༧ଌ͢ΔͨΊʹཱ͔ͭ Λௐɺͦͷ֎෦༧ଌมͷΛ୳͠ग़͢ɻ ֎෦༧ଌม
τϨϯυͱपظͷقઅੑΛͱʹͨ͠༧ଌϞσϧ
ϕʔεϞσϧͷධՁ
τϨϯυͱपظͷقઅੑͱച্ใुΛͱʹͨ͠༧ଌϞσϧ
ϞσϧͷධՁ ϕʔεϞσϧ ϕʔεϞσϧʹച্ใुΛ͚ͨ͠
τϨϯυͱपظͷقઅੑͱϚʔέςΟϯάඅ༻Λͱʹͨ͠༧ଌϞσϧ
ϕʔεϞσϧʹച্ใुΛ͚ͨ͠ ϕʔεϞσϧʹϚʔέςΟϯάඅ༻Λ͚ͨ͠
࣍ͷ3ͭશ෦ͯ͠ΈΔ Sales Comp., Marketing, and Discount
With Sales Comp., Marketing, Discount
The forecasting model quality has improved for a little bit.
ϕʔεϞσϧʹച্ใुΛ͚ͨ͠ ϕʔεϞσϧʹച্ใुɺϚʔέςΟϯάඅ༻ɺׂҾΛ͚ͨ͠
ޮՌλϒͷԼͰɺͦΕͧΕͷقઅੑͱ༧ଌม͕༧ଌʹͲͷΑ͏ʹ ӨڹΛ༩͑Δͷ͔ΛݟΔ͜ͱ͕Ͱ͖Δɻ
มॏཁλϒͷԼͰɺΘΕͨقઅੑͱ༧ଌมͷ͏ͪͲͷม͕ ΑΓӨڹ͕ڧ͍ͷ͔ΛݟΔ͜ͱ͕Ͱ͖Δɻ
Q & A
࣍ճηϛφʔ
σʔλαΠΤϯε X 3/5 () 1PM (ຊ࣌ؒʣ
None
5݄։࠵ܾఆʂ ฏ൛ɿ26ʢՐʣɺ27ʢਫʣɺ28ʢʣ ि൛ɿ23ʢʣɺ24ʢʣɺ30ʢʣ
• ϓϩάϥϛϯάͳ͠ RݴޠͷUIͰ͋ΔExploratoryΛੳπʔϧͱͯ͠༻͢ΔͨΊडߨதɺϏδωεͷ Λղܾ͢ΔͨΊʹඞཁͳσʔλαΠΤϯεͷख๏ͷशಘʹ100ˋूதͰ͖Δ • ੳπʔϧͷϕϯμʔϩοΫΠϯͳ͠ ExploratoryͰͷ࡞ۀશͯಠཱͨ͠ΦʔϓϯιʔεͷRڥͰ࠶ݱ͕Մೳ • ϏδωεͰ͑ΔࢥߟྗͱεΩϧͷशಘ σʔλαΠΤϯεͷεΩϧशಘ͚ͩͰͳ͘ɺσʔλੳʹඞཁͳࢥߟྗशಘͰ͖Δ
ಛ
࿈བྷઌ ϝʔϧ
[email protected]
ΣϒαΠτ https://ja.exploratory.io ϒʔτΩϟϯϓɾτϨʔχϯά https://ja.exploratory.io/training-jp Twitter @KanAugust