Upgrade to Pro — share decks privately, control downloads, hide ads and more …

エンゲージメント経営を支える TUNAGのETL基盤

457a32224e6ad774f17406984047f9ac?s=47 uuushiro
December 21, 2020

エンゲージメント経営を支える TUNAGのETL基盤

X-Tech JAWS 【第11回】 ~COVID-19に負けないオレたちX-Techイレブン~

457a32224e6ad774f17406984047f9ac?s=128

uuushiro

December 21, 2020
Tweet

More Decks by uuushiro

Other Decks in Technology

Transcript

  1. ΤϯήʔδϝϯτܦӦΛࢧ͑Δ 56/"(ͷ&5-ج൫ 95FDI+"84ʲୈճʳd$07*%ʹෛ͚ͳ͍ΦϨͨͪ95FDIΠϨϒϯd )35FDIºגࣜձࣾελϝϯ  দ୩༐࢙࿕!VVVTIJSP

  2. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE ࣗݾ঺հ 2 দ୩ ༐࢙࿕ Twitter @uuushiro • גࣜձࣾελϝϯ

    ࣥߦ໾һCTO • ޷͖ͳAWSαʔϏε͸AWS Athena 5XJUUFS
  3. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 3 w#J[56/"(ʹ͍ͭͯ w5FDI&5-ج൫ʹ͍ͭͯ ࠓ೔͓࿩͢Δ͜ͱ

  4. #J[56/"(ʹ͍ͭͯ

  5. ΤϯήʔδϝϯτܦӦϓϥοτϑΥʔϜ

  6. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE ैۀһҰਓͻͱΓͷੜ࢈ੑΛ্͍͛ͨ ΠΩΠΩͱಇ͘ैۀһΛ૿΍͍ͨ͠ ϦϑΝϥϧ࠾༻Ͱ༏लͳਓࡐΛ֫ಘ͍ͨ͠ ʮձࣾͱैۀһʯ͓Αͼʮैۀһಉ࢜ʯͷ૬ޓ৴པؔ܎ͷ͜ͱɻ͢ͰʹԤถͰ͸޿͘ਁಁͨ֓͠೦Ͱ͋Γɺ
 ਺೥લ͔Β೔ຊࠃ಺Ͱ΋ೝ஌͕ਐΈɺܦӦͷॏཁࢦඪͱͯ͠஫໨͕ߴ·͍ͬͯΔɻ Τϯήʔδϝϯτͱ͸

  7. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE اۀͷۀ੷޲্ʹେ͖ͳӨڹΛ༩͑Δ اۀͷۀ੷ͱ͸૬ؔؔ܎͕ͳ͍ ैۀһΤϯήʔδϝϯτ ैۀһຬ଍౓ ैۀһΤϯήʔδϝϯτʹ͍ͭͯɺௐࠪ΍ݚڀɺ࣮ূ࣮ݧΛਐΊΔੈքతͳίϯαϧςΟϯάاۀ ैۀһຬ଍౓ͱͷҧ͍

  8. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE ैۀһΤϯήʔδϝϯτͷۀ੷΁ͷӨڹ Τϯήʔδϝϯτͱ཭৬཰ͷ૬ؔ ΤϯήʔδϝϯτείΞ্͕Ґ25%ɾԼҐ25%ͷνʔϜͷதԝ஋ͷࠩ ग़ॴɿCEBʮCorporate Leadership Council 2004 Employee

    Engagement Surveyʯ
 ɹɹɹΛݩʹ౰ࣾ࡞੒ ग़ॴɿGALLUPʮEngagement Effect on Key Performance IndicatorsʯΛݩʹ౰ࣾ࡞੒ ऩӹੑ ੜ࢈ੑ גՁऩӹ཰ ސ٬ຬ଍౓ 10% 47% 21% 22% ඼࣭ͷܽؕ ཭৬཰ ࣄނ ܽۈ -37% -50% -40% -41% Τϯήʔδϝϯτͷ
 ಛʹऑ͍ैۀһ Τϯήʔδϝϯτͷ
 ಛʹڧ͍ैۀһ 1.2% Τϯήʔδϝϯτͷ
 ಛʹऑ͍ैۀһ Τϯήʔδϝϯτͷ
 ಛʹڧ͍ैۀһ 9.2% 1೥Ҏ಺ͷ ཭৬Մೳੑ - 87% ΤϯήʔδϝϯτΛߴΊΔ͜ͱͰɺ 1೥Ҏ಺ͷ཭৬Մೳੑ͕
 ࠷େͰ87%௿Լ͢Δɻ ೥ Ҏ ಺ ͷ ཭ ৬ Մ ೳ ੑ 1 Τϯήʔδϝϯτ޲্͕΋ͨΒ͢ޮՌ
  9. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE ࠃผͷΤϯήʔδϝϯτείΞ ग़ॴɿGALLUPʮState of the Global Workplace (2017)ʯΛݩʹ౰ࣾ࡞੒ ύφϚ

    (1Ґ) ϑΟϦϐϯ (5Ґ) ΞϝϦΧ (8Ґ) όϯάϥσγϡ (14Ґ) ϒϥδϧ (20Ґ) ϩγΞ (24Ґ) Ξϧθϯνϯ (30Ґ) γϯΨϙʔϧ (31Ґ) λΠ (32Ґ) Χφμ (42Ґ) έχΞ (53Ґ) α΢δΞϥϏΞ (62Ґ) ΠϯυωγΞ (83Ґ) υΠπ (86Ґ) ΦʔετϥϦΞ (90Ґ) Πϯυ (98Ґ) ΠΪϦε (118Ґ) ϕτφϜ (126Ґ) ؖࠃ (131Ґ) ೔ຊ(135Ґ) ௐࠪର৅ࠃ140ϲࠃதɺ೔ຊͷΤϯήʔδϝϯτείΞ͸135Ґ ೔ຊͷείΞৄࡉ Τϯήʔδϝϯτͷ
 ߴ͍ैۀһൺ཰ 6% Τϯήʔδϝϯτͷ
 ௿͍ैۀһൺ཰ 71% ձࣾʹ൓ײΛ
 ͍࣋ͬͯΔैۀһൺ཰ 23% ੈք֤ࠃͷΤϯήʔδϝϯτείΞ
  10. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE ଧͪखͷاըɾઃܭΛࢧԉ͢Δ ʮ૊৫ίϯαϧςΟϯάʯ ࢪࡦͷࣗ૸ԽͱվળΛࢧԉ͢Δ ʮࣾ಺੍౓ӡ༻Ϋϥ΢υʯ αʔϏεͷ֓ཁ

  11. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE ଧͪखͷاըɾઃܭΛࢧԉ͢Δ ʮ૊৫ίϯαϧςΟϯάʯ ࢪࡦͷࣗ૸ԽͱվળΛࢧԉ͢Δ ʮࣾ಺੍౓ӡ༻Ϋϥ΢υʯ ը໘Πϝʔδ TUNAGͷϝΠϯը໘Ͱɺ૊৫಺ͷ༷ʑͳ৘ใΛू໿͠ɺ
 ίϛϡχέʔγϣϯΛ׆ੑԽ͢ΔػೳΛଟ਺౥ࡌɻ ࣾ಺ϙʔλϧαΠτͱͯ͠΋׆༻Մೳɻ

    ӡ༻தͷࣾ಺੍౓ΛΧςΰϦʔຖʹ੔ཧͯ͠ Ұݩ؅ཧͰ͖Δػೳɻར༻৚݅΍ެ։৚݅ͳͲɺ χʔζʹ߹Θͤͯॊೈͳӡ༻Λ࣮ݱɻ ૊৫ߏ੒΍ɺϝϯόʔ̍ਓͻͱΓͷ৘ใΛ ू໿Ͱ͖ɺ૊৫ͷݟ͑ΔԽΛ࣮ݱɻ ࣾ಺ͷਓࡐσʔλϕʔεͱͯ͠΋׆༻Մೳɻ λΠϜϥΠϯ ࣾ಺੍౓Ұཡ ૊৫Ұཡ
  12. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE Ϋϥ΢υ׆༻ʹΑΔࣗ૸Խ ࣾ಺վળࢪࡦͷ໰୊ͱͯ͠ɺ͔ͤͬ࣌ؒ͘Λ͔͚ͯ࿅Γ্͛ͨऔΓ૊Έ͕ݱ৔ʹਁಁͤͣɺ࣮ߦϑΣʔζʹ ࢸΔલʹܗ֚Խͯ͠͠·͏఺͕͋ΔɻTUNAG͸ɺͦ͏͍ͬͨࣄଶΛ๷ࢭ͢Δ࢓૊ΈΛఏڙ͢Δɻ ࣗ૸ԽΛଅ͢TUNAGͷ࢓૊Έ σʔλۦಈܕͷ੍౓վળ ࣾ಺੍౓ΛҰݩ؅ཧͰݟ͑ΔԽ͠ɺ
 ैۀһ͕׆༻͠΍͍͢؀ڥΛఏڙɻ ୭੍͔͕౓Λར༻ͨ͠৘ใ͕ɺ

    λΠϜϥΠϯʹࣗಈͰڞ༗͞ΕΔɻ ར༻಺༰͔Βɺίϛϡχέʔγϣϯ͕ ੜ·Εɺ͞ΒͳΔར༻Λଅ͢ɻ ౤ߘ͕஝ੵ͞Ε͍ͯ͘͜ͱͰɺ࣍ୈʹɺ
 ࣾ಺จԽ͕ߏஙɺਁಁ͍ͯ͘͠ɻ γεςϜӡ༻ʹෆ׳Εͳਓࣄ୲౰ऀͰ΋ɺ ੍౓ͷӡ༻ঢ়گΛ௚ײతʹ೺Ѳ͢Δ͜ͱͷͰ͖Δ ߴػೳͳ෼ੳμογϡϘʔυΛఏڙɻ
  13. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 13 56/"(Ͱ஝ੵͨ͠
 ར༻σʔλͷ׆༻͕
 Ϗδωε্ॏཁͳ伴

  14. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 14 wಋೖاۀ਺͕ॱௐʹ૿͑ɺσʔλྔ͕૿Ճ͍ͯ͠Δ wσʔλ׆༻ΛՃ଎͍͖͍ͯͨ͠ wίΞͳՁ஋ͷ։ൃʹ΋ͬͱ஫ྗ͍ͨ͠ ࣄۀͷ੒௕ͱڞʹ

  15. 5FDI&5-ج൫ʹ͍ͭͯ

  16. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 16 wूܭॲཧͷεέʔϥϏϦςΟΛ֬อ͍ͨ͠ wࠓޙͷࣄۀల։ʹ߹Θ֦ͤͨுੑΛ֫ಘ͍ͨ͠ w&5-ج൫ͷҡ࣋ίετΛۃখԽ͍ͨ͠ ٻΊΒΕΔཁ݅

  17. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 17 w4Λ&5-ج൫ͷத৺ͱ͢Δ wαʔόʔϨεɾϚωʔδυαʔϏεΛ׆༻͢Δ ΞʔΩςΫνϟͷํ޲ੑ

  18. &5-ج൫ͷΞʔΩςΫνϟ

  19. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 19 &5-ج൫ͷΞʔΩςΫνϟ

  20. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 20 &5-ج൫ͷΞʔΩςΫνϟ 4ΛσʔλϨΠΫͱͯ͠ར༻͠ ͢΂ͯͷσʔλΛอଘ͢Δ

  21. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 21 &5-ج൫ͷΞʔΩςΫνϟ wଟ༷ͳσʔλΛஷΊ͓ͯ͘޿େͳྖҬ wσʔλͷอଘ࣌ʹ৻ॏʹઃܭ͢Δඞཁ͕ͳ͘
 ඞཁʹԠͯ͡σʔλΛൈ͖ग़ͤΕ͹Α͍ σʔλϨΠΫ

  22. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 22 &5-ج൫ͷΞʔΩςΫνϟ (MVFͰΫϩʔϦϯά͠ σʔλΧλϩάΛಉظ

  23. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 23 &5-ج൫ͷΞʔΩςΫνϟ Ϋϩʔϥʔͷ੒ޭΠϕϯτͰ ूܭॲཧͷϫʔΫϑϩʔΛ࣮ߦ

  24. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 24 &5-ج൫ͷΞʔΩςΫνϟ -BNCEB͔Β"UIFOBʹ$5"4Λ࣮ߦ͠ 4ʹूܭσʔλΛ࠶഑ஔ

  25. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 25 &5-ج൫ͷΞʔΩςΫνϟ աڈ෼ͷूܭδϣϒΛ424΁ΩϡʔΠϯά

  26. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 26 &5-ج൫ͷΞʔΩςΫνϟ w೔ผʹूܭΛฒྻॲཧ w4UFQ'VODUJPOͷϫʔΫϑϩʔΛ࣮ߦ

  27. 8FMM"SDIJUFDUFEͳͭͷϙΠϯτ

  28. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 28 ίετ࠷దԽ ӡ༻্ͷ༏लੑ 1 8FMM"SDIJUFDUFEͳͭͷϙΠϯτ 2

  29. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 29 wϚωʔδυαʔϏεͱαʔόʔϨεͰ ӡ༻্ͷਓతίετΛ࡟ݮ wσʔλྔʹԠͯ͡ैྔ՝ۚ ίετ࠷దԽ 1

  30. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 30 wϚωʔδυαʔϏεͱαʔόʔϨεͰ ӡ༻্ͷਓతίετΛ࡟ݮ wσʔλྔʹԠͯ͡ैྔ՝ۚ ίετ࠷దԽ 1

  31. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 31 w4".ͰϫʔΫϩʔυશମΛίʔυԽ w4UFQ'VODUJPOͰ෼ࢄΞϓϦέʔγϣϯ Λ؆୯ʹ؅ཧɾσόοάՄೳʹ w93BZͰύϑΥʔϚϯεͷ໰୊ΛՄࢹԽ ӡ༻্ͷ༏लੑ 2

  32. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 32 w4".ͰϫʔΫϩʔυશମΛίʔυԽ w4UFQ'VODUJPOͰ෼ࢄΞϓϦέʔγϣϯ Λ؆୯ʹ؅ཧɾσόοάՄೳʹ w93BZͰύϑΥʔϚϯεͷ໰୊ΛՄࢹԽ ӡ༻্ͷ༏लੑ 2

  33. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 33 w4".ͰϫʔΫϩʔυશମΛίʔυԽ w4UFQ'VODUJPOͰ෼ࢄΞϓϦέʔγϣϯ Λ؆୯ʹ؅ཧɾσόοάՄೳʹ w93BZͰύϑΥʔϚϯεͷ໰୊ΛՄࢹԽ ӡ༻্ͷ༏लੑ 2

  34. "844VNNJU5PLZP͔Β ೥൒ܦͬͨࠓ

  35. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 35 "844VNNJU5PLZP͔Β೥൒ͨͬͨࠓ w·ͩ·ͩ56/"(ͷ&5-ج൫ͱͯ͠ݱ໾ w8FMM"SDIJUFDUFEͷେ੾͞Λ਎Λ΋ͬͯײ͡Δ wҡ࣋ίετ͸΄΅θϩͰɺࣄۀͷίΞػೳ։ൃʹूதͰ͖͍ͯΔ w৽نࣄۀͰ΋׆༻ w$MPVE'PSNBUJPO؅ཧͳͷͰɺଞͷϝϯόʔ΋؆୯ʹ࠶ݱՄೳ wैྔ՝ۚͳͷͰɺॳظ౤ࢿΛ཈͑ΒΕΔ

  36. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 36 "844VNNJU5PLZP͔Β೥Ҏ্ͨͬͨࠓ w56/"(ͷσʔλ΋͞Βʹ૿Ճ͓ͯ͠Γɺաڈ਺೥෼ͷσʔλ Λ࠶ूܭ͢Δ৔߹ɺ"UIFOBͷಉ࣮࣌ߦ਺͕ϘτϧωοΫͱͳͬ ͍ͯΔ wաڈΛḪͬͯࢦඪͷ௥ՃɾมߋΛ΍Δ৔߹ʹ͸ผͷ࢓૊Έ͕ඞ ཁʹͳΓͦ͏ wطଘͷΞʔΩςΫνϟͷಘҙɾෆಘҙΛݟۃΊͭͭɺࣄۀͷཁ

    ٻʹ౴͑ଓ͚ΒΕΔΑ͏ʹΞοϓσʔτ͍ͯ͘͠
  37. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE 37 ΤϯδχΞશ৬छੵۃతʹืूͯ͠·͢ʂ wࣄۀͷ੒௕Λࢧ͑Δ4JUF3FMJBCJMJUZ&OHJOFFS wࣄۀͷ੒௕Λݟਾ͑ɺطଘγεςϜΛ࡮৽͢ΔΞʔΩςΫτ wେن໛ۀ຿ΞϓϦέʔγϣϯ։ൃΛϦʔυ͢ΔαʔόʔΤϯδχΞ wσʔλ׆༻ΛՃ଎ͤ͞ΔɺσʔλΤϯδχΞ ΤϯδχΞ࠾༻αΠτ 5XJUUFS!VVVTIJSP

    &5-ج൫Ҏ֎ͷٕज़΍ձࣾɾࣄۀɾ࠾༻ʹ͍ͭ ͯৄ͘͠஌Γ͍ͨํ͸ɺؾܰʹদ୩ !VVVTIJSP ͷ5XJUUFS·Ͱ%.͍ͩ͘͞