Redash made inter-team communication active -

# WEBエンジニア勉強会 #05 (東京都, 渋谷)の発表資料です
https://web-engineer-meetup.connpass.com/event/75898/

Redashをチーム（会社）に導入したら

# 宣伝
「しがないラジオ」というPodcastをやっています。
https://shiganai.org/
までアクセスください！

Transcript

1. Redashͷಋೖͱ
   νʔϜΛ·͍ͨͩมԽͷ࿩
   2018/02/02 #WEBΤϯδχΞษڧձ05
   @zuckey_17
   

   View Slide

2. -zuckeyʢ͖ͣͬʔʣ
   -͕͠ͳ͍ϥδΦύʔιφϦςΟ
   -גࣜձࣾYappli
   -ιϑτ΢ΣΞΤϯδχΞ
   -PHP(Laravel) / React.js
   ࣗݾ঺հ
   

   View Slide

3. https://redash.io/
   

   View Slide

4. ※ ஫ҙ ※
   -๻ࣗ਎৮Γ࢝Ίͯ1ϲ݄ऑͰ͢
   -͋·Γٕज़తʹৄ͍͠࿩͸ग़͖ͯ·ͤΜ
   

   View Slide

5. Redash?
   -ΦʔϓϯιʔεͷσʔλՄࢹԽπʔϧ
   - ๛෋ͳσʔλιʔεΛ1ͭʹ
   - ݁ՌΛάϥϑԽɺμογϡϘʔυʹ
   - ΫΤϦΛڞ༗͢Δ͜ͱ͕Մೳ
   - ର࿩తͳΠϯλʔϑΣʔε
   - Ξϥʔτػೳ
   re:dash
   

   View Slide

6. Redash ϋϯζΦϯ
   ref: https://github.com/kakakakakku/redash-hands-on
   - ࣮σʔλͰֶ΂ΔRedashϋϯζΦϯΛ΍ͬͯΈͨΒ׬શʹٻΊ͍ͯͨ΋ͷͩͬͨ
   - http://blog.zuckey17.org/entry/2017/12/29/152921
   

   View Slide

7. ref: https://redash.io/integrations/
   

   View Slide

8. ref: https://redash.io/integrations/
   

   View Slide

9. + Python
   

   View Slide

10. ΈΜͳʁ
    -Biz
    -ఆৗతͳӡ༻ۀ຿͕BizνʔϜͰ׬݁
    -Dev
    -Զͨͪͷ࠷ߴͳμογϡϘʔυΛର࿩తʹ࡞Δ
    

    View Slide

11. ΫϥΠΞϯτ΁ͷϨϙʔτۀ຿
    ݄࣍Ϩϙʔτͷ

    CSVΛ͍ͩ͘͞
    ͪΐͬͱ
    ଴͍ͬͯͩ͘͞Ͷʔ
    

    View Slide

12. PythonσʔλιʔεʹΑͬͯ

    Redisͷมߋ࡞ۀΛϚχϡΞϧԽ
    σʔλιʔεͱ͸͍͑PythonͰͰ͖Δ͜ͱ͸͍͍ͨͯͰ͖Δ
    

    View Slide

13. ະདྷͷμογϡϘʔυΛ໛ࡧ
    “ͳʹ͔͍͍΋ͷ͕Ͱ͖ΔΜͩΖ͏ͳ”
    ͱ͍͏യવͱͨ͠ظ଴͚͕ͩ๲Ε্͕Δ
    

    View Slide

14. ΫΤϦͷ݁Ռ͕͙͢ʹ

    ࢹ֮ԽͰ͖Δ
    

    View Slide

15. ϓϩτλΠϓΛͨ͘͞Μ࡞ͬͯظ଴஋Λௐ੔
    

    View Slide

16. ࠓޙऔΓ૊ΜͰ͍͖͍ͨ͜ͱ
    -՝ۚςʔϒϧͷߋ৽ΛSlackʹ௨஌
    -σΟϨΫλʔͱSQLͳͲͷษڧձ
    -౷ҰͷDWHΛߏங
    

    View Slide

17. ·ͱΊ
    -DevνʔϜ΁ͷґཔ͕ݮͬͨ
    -BizνʔϜ͔Β৽͘͜͠͏͍͏͜ͱ΋Θ͔ͬͨʂ

    ͱ͍͏ใࠂ΋
    -΋΍΋΍͍ͯͨ͠σʔλ׆༻ʹޫ໌͕Έ͑ͨ
    

    View Slide

18. - cf
    - ެࣜϖʔδ
    - https://redash.io/
    - redash-hands-on
    - https://github.com/kakakakakku/redash-hands-on
    - Re:DashͰpythonσʔλιʔεΛ࢖ͬͯΫΤϦ݁ՌΛ͝ʹΐ͝ʹΐ͍ͨ͠
    - https://qiita.com/axm-aoki/items/4982cf8999aebc46b3d4
    

    View Slide