Slide 1
Slide 1 text
Redashͷಋೖͱ
νʔϜΛ·͍ͨͩมԽͷ
2018/02/02 #WEBΤϯδχΞษڧձ05
@zuckey_17
Slide 2
Slide 2 text
-zuckeyʢ͖ͣͬʔʣ
-͕͠ͳ͍ϥδΦύʔιφϦςΟ
-גࣜձࣾYappli
-ιϑτΣΞΤϯδχΞ
-PHP(Laravel) / React.js
ࣗݾհ
Slide 3
Slide 3 text
https://redash.io/
Slide 4
Slide 4 text
※ ҙ ※
-ࣗ৮Γ࢝Ίͯ1ϲ݄ऑͰ͢
-͋·Γٕज़తʹৄ͍͠ग़͖ͯ·ͤΜ
Slide 5
Slide 5 text
Redash?
-ΦʔϓϯιʔεͷσʔλՄࢹԽπʔϧ
- ๛ͳσʔλιʔεΛ1ͭʹ
- ݁ՌΛάϥϑԽɺμογϡϘʔυʹ
- ΫΤϦΛڞ༗͢Δ͜ͱ͕Մೳ
- ରతͳΠϯλʔϑΣʔε
- Ξϥʔτػೳ
re:dash
Slide 6
Slide 6 text
Redash ϋϯζΦϯ
ref: https://github.com/kakakakakku/redash-hands-on
- ࣮σʔλͰֶΔRedashϋϯζΦϯΛͬͯΈͨΒશʹٻΊ͍ͯͨͷͩͬͨ
- http://blog.zuckey17.org/entry/2017/12/29/152921
Slide 7
Slide 7 text
ref: https://redash.io/integrations/
Slide 8
Slide 8 text
ref: https://redash.io/integrations/
Slide 9
Slide 9 text
+ Python
Slide 10
Slide 10 text
ΈΜͳʁ
-Biz
-ఆৗతͳӡ༻ۀ͕BizνʔϜͰ݁
-Dev
-Զͨͪͷ࠷ߴͳμογϡϘʔυΛରతʹ࡞Δ
Slide 11
Slide 11 text
ΫϥΠΞϯτͷϨϙʔτۀ
݄࣍Ϩϙʔτͷ
CSVΛ͍ͩ͘͞
ͪΐͬͱ
͍ͬͯͩ͘͞Ͷʔ
Slide 12
Slide 12 text
PythonσʔλιʔεʹΑͬͯ
Redisͷมߋ࡞ۀΛϚχϡΞϧԽ
σʔλιʔεͱ͍͑PythonͰͰ͖Δ͜ͱ͍͍ͨͯͰ͖Δ
Slide 13
Slide 13 text
ະདྷͷμογϡϘʔυΛࡧ
“ͳʹ͔͍͍ͷ͕Ͱ͖ΔΜͩΖ͏ͳ”
ͱ͍͏യવͱͨ͠ظ͚͕ͩΕ্͕Δ
Slide 14
Slide 14 text
ΫΤϦͷ݁Ռ͕͙͢ʹ
ࢹ֮ԽͰ͖Δ
Slide 15
Slide 15 text
ϓϩτλΠϓΛͨ͘͞Μ࡞ͬͯظΛௐ
Slide 16
Slide 16 text
ࠓޙऔΓΜͰ͍͖͍ͨ͜ͱ
-՝ۚςʔϒϧͷߋ৽ΛSlackʹ௨
-σΟϨΫλʔͱSQLͳͲͷษڧձ
-౷ҰͷDWHΛߏங
Slide 17
Slide 17 text
·ͱΊ
-DevνʔϜͷґཔ͕ݮͬͨ
-BizνʔϜ͔Β৽͘͜͠͏͍͏͜ͱΘ͔ͬͨʂ
ͱ͍͏ใࠂ
-͍ͯͨ͠σʔλ׆༻ʹޫ໌͕Έ͑ͨ
Slide 18
Slide 18 text
- cf
- ެࣜϖʔδ
- https://redash.io/
- redash-hands-on
- https://github.com/kakakakakku/redash-hands-on
- Re:DashͰpythonσʔλιʔεΛͬͯΫΤϦ݁ՌΛ͝ʹΐ͝ʹΐ͍ͨ͠
- https://qiita.com/axm-aoki/items/4982cf8999aebc46b3d4