Slide 4
Slide 4 text
ੳج൫ͷมભ
~ 2018 2019 2020
● ࣾͷ༗ࢤͰϓϩμΫτͷΞΫη
εϩάΛBigQueryόονETL͠
ੳΛ͓͜ͳ͍͡ΊΔ
● Embulk + DigDagʢmf_etlʣ
● ͋͘·Ͱݟͷ͋ΔΤϯδχΞ
͕༻͢Δʹཹ·Δ
● ϓϩμΫτͷσʔλੳVDI͔
ΒͷΈΞΫηεग़དྷΔϚϧνϨϓ
ϦέʔγϣϯͷMySQLΛ༻
● ΞφϦετͱσʔλΤϯδχΞ͕
ࡏ੶͢Δੳਪਐ্ཱ͕͕ࣨͪΔ
ʢ3໊͔Βͷελʔτʣ
● ཧձܭͷଐਓԽഉআɾࣗಈԽͷ
ͨΊʹBigQuery׆༻͕ຊ֨Խ͢
Δ
● ֤छπʔϧͷಋೖʢLooker,
Google Analytics 360, Airflow,
Terraformʣ
● ηʔϧεɾϚʔέςΟϯά׆ಈ
ࠂӡ༻ԽͷͨΊͷ
BigQuery׆༻͕͡·Δ
● ֤෦ॺͷKPIཧɾՄࢹԽͷࢧԉ
Λ͓͜ͳ͏
● ച্KPIͷཧํ๏͕ཚཱ͠
͡ΊΔ
● ϓϩμΫτσʔλCRMπʔϧ
Ͱอ͍ͯ͠ΔσʔλͷBigQuery
సૹ͕׆ൃԽ͢ΔʢηϯγςΟϒ
ͳͷΛআ͘ʣ 4