データドリブンを提供するサービス Brand Officialのアーキテクチャ / brand official architecture

Transcript

1. גࣜձࣾΞΠελΠϧ σʔλυϦϒϯΛఏڙ͢ΔαʔϏε
 Brand OfficialͷΞʔΩςΫνϟ גࣜձࣾΞΠελΠϧ @YASU11552288
2. Copyright (c) 2017 istyle, Inc. All rights reserved. !2 ࣗݾ঺հ @YASU11552288 - גࣜձࣾΞΠελΠϧ R&D෦ - BI΍෼ੳج൫ߏஙɾӡ༻ - Bigquery, digdag, embulk, Google Analytics, 
 Firebase Analytics, redash , tableau, hadoop ࠓ೔͸Խহ඼ϒϥϯυͷσʔλɾυϦϒϯΛ
 αϙʔτ͢ΔαʔϏεʹ͍ͭͯ࿩͠·͢
3. Copyright (c) 2017 istyle, Inc. All rights reserved. !3 ˏ̴̲̼̾͂ͱ͸ ίεϝɾඒ༰ͷ૯߹αΠτʮˏ̴̲̼̾͂ʯ ࠃ಺֎3ສҎ্ͷϒϥϯυɺ30ສ఺Ҏ্΋ͷίεϝͷ঎඼σʔλϕʔεͱɺΫν ίϛݕࡧػೳ΍৽঎඼৘ใͳͲΛඋ͑ͨ೔ຊ࠷େͷίεϝɾඒ༰ͷ૯߹αΠτɻ
 1999೥ͷΦʔϓϯҎདྷɺձһ਺ɾΫνίϛ݅਺ɾϖʔδϏϡʔ਺ͱ΋ʹ৳ͼଓ͚ɺ ྦྷܭΫνίϛ਺͸1,400ສ݅Λಥഁ͍ͯ͠·͢ɻ
4. Copyright (c) 2017 istyle, Inc. All rights reserved. !4 Brand Officialͱ͸ ˏ̴̲̼̾͂ͷσʔλϕʔεΛ
 ࣗࡏʹ׆༻ͨ͠ίϯςϯπൃ৴͕Մೳͳɺ੍ֹ݄ͷ ϓϥοτϑΥʔϜαʔϏεͰ͢ɻ ϒϥϯυʹର͢ΔϢʔ βʔͷঢ়ଶΛʮͭͳ͕ Γʯʮٸ઀ۙʯʮఆظ ๚໰ʯͱఆٛ͠ɺूܭ ͍ͯ͠Δ
5. Copyright (c) 2017 istyle, Inc. All rights reserved. !5 ΞʔΩςΫνϟ Ϋνίϛ ECɾ࣮ళฮ ߪങϩά αϚϦʔσʔλ BigQuery Ϣʔβʔͷߦಈϩά
6. Copyright (c) 2017 istyle, Inc. All rights reserved. 
 ▼ σʔλͷసૹ - Ճ޻લͷσʔλͷΠϯ ϙʔτ΍ूܭޙͷσʔ λΛWEB APP͔Βࢀর ͞ΕΔDB΁ͷΤΫε ϙʔτΛ୲͏ - yamlͳͷͰಡΈ΍͘͢ 10ߦ͘Β͍ͰΤΫεϙʔ τॲཧΛॻ͚Δ 
 ▼ େྔσʔλͷूܭ - Ϋνίϛɺϒϩάͷه ࣄͱ͍ͬͨαʔϏεͷ σʔλͱGoogle AnalyticsͰܭଌͨ͠ Ϣʔβʔͷߦಈσʔλ Λ૊Έ߹ΘͤɺϢʔβ ͷঢ়ଶΛࢉग़ - ݄ؒ3ԯPV͕ͩίετ ͸ͦ͜·Ͱ !6 BigQuery,embulk,digdag ͷ໾ׂ 
 ▼ ϫʔΫϑϩʔ؅ཧ - 1࣍ूܭޙʹ2࣍ूܭΛ ߦ͏ͳͲͱϑϩʔΛ؅ ཧ - ฒྻॲཧɺϦτϥΠॲ ཧɺslack௨஌ͳͲ؆୯ ʹͰ͖Δ - ҙ֎ͱϝϞϦ৯͏ʢݸ ਓతʹʣ
7. Copyright (c) 2017 istyle, Inc. All rights reserved. !7 ࠓͷΞʔΩςΫνϟͱܾผʁ ݱঢ়RDB޲͚ͷαϚϦʔσʔλ͸ϨίʔυΛ཈͍͑ͯΔ → େྔϨίʔυΛอ࣋Ͱ͖ͯɺϨεϙϯε͕ૣ͘ͳ͍ͱ׎͑ΒΕͳ͍
 ɹɹཁ๬͕૿͖͑ͯͨ × ετϨʔδΤϯδϯ kudu ΫΤϦΤϯδϯ impala BigQuery͔ΒHadoopج൫΁ͷҠߦΛਐΊ͍ͯΔ ʢݕূதʣ
8. Copyright (c) 2017 istyle, Inc. All rights reserved. !8 ·ͱΊ - Խহ඼ϒϥϯυʹಧ͚ΔBrand Officialͷ঺հ - BigQuery, embulk, digdagͱ͍ͬͨπʔϧΛ࢖͏ͱγϯϓϧͳେྔσʔ λूܭج൫Λར༻͢Δ͜ͱͰ׎͑ΒΕΔ - ͨͩɺϢʔβʔͷσʔλɾυϦϒϯͷ଎౓ʹॊೈʹରԠ͢ΔͨΊʹ ʮϦΞϧλΠϜʯʮେྔσʔλूܭʹର͢Δૣ͍Ϩεϙϯεʯ
 ɹ͕ͷͪʹඞཁʹͳΓɺٕज़ͷ࠶બఆ͕ඞཁʹͳΔ͔΋ WE ARE NOW HIRING!!