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

Redash made inter-team communication active -

zuckey_17
February 02, 2018

Redash made inter-team communication active -

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

Redashをチーム(会社)に導入したら

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

zuckey_17

February 02, 2018
Tweet

More Decks by zuckey_17

Other Decks in Technology

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