Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
re:dashについて
Search
Takuya Arita
June 15, 2016
Programming
0
700
re:dashについて
社内勉強会向けの資料を再編して公開しています
Takuya Arita
June 15, 2016
Tweet
Share
More Decks by Takuya Arita
See All by Takuya Arita
Hosted Redash の EOL と移行ツール redash-migrate / You should know about Hosted Redash EOL and redash-migrate
ariarijp
0
2.7k
Redash で踏み出す BI 導入はじめの一歩 / DataEngineeringStudy Redash
ariarijp
1
1.5k
Redash のいま / Redash in 2021
ariarijp
2
920
Redash 導入・運用を4年ぐらいやって変わったこと・変わらなかったこと / Changed and unchanged things with Redash and me
ariarijp
0
1.2k
5年前の自分に伝えたい広告 API 周辺の歩き方 / SOT Tech Night vol.1
ariarijp
1
410
使われていない、を知る / How do we know unused things in the real world?
ariarijp
0
370
MULTI_ORG について / What is MULTI_ORG in Redash
ariarijp
1
3k
あらためて振り返る Redash の使いどころ / Why I strongly recommend Redash
ariarijp
2
1.1k
PHP Data Structures
ariarijp
1
490
Other Decks in Programming
See All in Programming
1BRC--Nerd Sniping the Java Community
gunnarmorling
0
340
if constexpr文はテンプレート世界のラムダ式である
faithandbrave
3
630
Blue/Greenデプロイの導入による 運用フローの改善
kudoas
1
360
大規模Reactアプリのリアーキテクチャ~8万行のTanStack Query移行の軌跡~
kj455
4
940
Compose-View Interop in Practice (mDevCamp 2024)
stewemetal
0
110
Random\Randomizer クラスで日常のあれこれを解決しよう! / Random\Randomizer class solves familiar trouble
cocoeyes02
0
170
SwiftUIで使いやすいToastの作り方 / How to build a Toast system which is easy to use in SwiftUI
lovee
3
130
Nealle_Autify_LT_Slide202403
nealle
0
150
HUIT新歓2024「競技プログラミング、やってみませんか?」
slephy2784
1
270
FigmaとPHPで作る1ミリたりとも表示崩れしない最強の帳票印刷ソリューション
ttskch
43
18k
MetricKitで予期せぬ終了を検知する話 / Detect unexpected termination with MetricKit
nekowen
0
180
VS Code をプロダクトにどう取り込むか
onomax
1
350
Featured
See All Featured
Bash Introduction
62gerente
604
210k
Code Review Best Practice
trishagee
55
15k
No one is an island. Learnings from fostering a developers community.
thoeni
16
2.1k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
25
2.3k
Java REST API Framework Comparison - PWX 2021
mraible
PRO
18
6.9k
Designing on Purpose - Digital PM Summit 2013
jponch
110
6.5k
What's new in Ruby 2.0
geeforr
337
31k
Become a Pro
speakerdeck
PRO
11
4.5k
ParisWeb 2013: Learning to Love: Crash Course in Emotional UX Design
dotmariusz
104
6.6k
The Cost Of JavaScript in 2023
addyosmani
16
3.8k
Learning to Love Humans: Emotional Interface Design
aarron
267
39k
Making Projects Easy
brettharned
108
5.5k
Transcript
re:dashʹ͍ͭͯ @ariarijp
re:dashͱ • Open Source Data Collaboration and Visualization Platform(ެࣜυΩϡϝϯτΑΓ) •
Φʔϓϯιʔεͷσʔλੳπʔϧ • BI(Business Intelligence)πʔϧͷΑ͏ͳͷ • PythonͰॻ͔Ε͍ͯΔ
RebuildͰͷݴٴ • ep 145Ͱre:dashʹ͍ͭͯͷݴٴ͕͋ͬͨ • https://rebuild.fm/145/ • (ҏ౻ࢯ͕RebuildͰݴٴͨ͠ϓϩμΫτ ɺͳʹ͔ͱόζΓ͍͢ͷͰɺࠃͰͷར ༻͕͜Ε͔Β૿͑Δ͔ʁ
re:dashͷࠃಋೖࣄྫ • ͬ͟ͱௐͯΈͨͱ͜ΖҎԼͷاۀ͕ಋೖ͍ͯͦ͠͏ɾಋೖ͍ͯ͠Δ(͍͓ͪ͏50 Իॱ • גࣜձࣾΠϓϩε͞Μ(ษڧձओ࠵͞Εͯͨ • גࣜձࣾΤϨΧ͞Μ(ษڧձొஃ͞Εͯͨ • M.T.Burnגࣜձࣾ͞Μ(re:dashʹ͍ͭͯͷεϥΠυ͕͋ͬͨ
• ΫοΫύουגࣜձࣾ͞Μ(εϥΠυʹre:dashͬͯॻ͍ͯ͋ͬͨ • גࣜձࣾmediba͞Μ(هࣄ͕͋ͬͨ • ʢ΄͔ʹ͍Ζ͍Ζ͋Γͦ͏
re:dashͷԿ͕͍͍ͷ͔ • SQLͷϑϩϯτΤϯυͱͯ͠ͷػೳͱ͋ΘͤͯɺՄࢹԽɺμο γϡϘʔυͷػೳΛඋ͍͑ͯΔ • ଟ͘ͷσʔλιʔεʹରԠ͍ͯ͠Δ • UIͱSQLΛ࣮ߦ͢ΔλεΫϥϯφʔ͕͞Ε͓ͯΓɺλεΫϥ ϯφʔʹΑͬͯఆظ࣮ߦͰ͖Δ •
ΦʔϓϯιʔεͰGithubͰެ։͞Ε͓ͯΓɺ։ൃ͕׆ൃͰ͋Δ • AWS/GCPͷެࣜΠϝʔδ͕͋Δ
re:dashͷߏ(ؒҧͬͯΔ͔ 8FC6* 'MBTL λεΫϥϯφʔ $FMFSZ ཧ%# 1PTUHSF42- σʔλιʔε .Z42-ͳͲ 42-ͷϑϩϯτΤϯυ
ՄࢹԽɺμογϡϘʔυػೳͷఏڙ σʔλιʔεʹରͯ͠42-Λ ଈ࣌ఆظ࣮ߦ ཧใΩϟογϡΛอ࣋
ରԠ͍ͯ͠Δσʔλιʔε(ൈਮ • PostgreSQL / Redshift • MySQL • Google BigQuery
• ElasticSearch • Hive / Presto • Treasure Data • ͦͷଞެࣜυΩϡϝϯτΛࢀর • http://docs.redash.io/en/latest/datasources.html
re:dashͷಋೖ • AWS/GCPͳΒެࣜΠϝʔδΛ͏ͷ͕͍͍ͷ͔ • AWS/GCPҎ֎ͰͲ͏͢Δ͔ • ެࣜυΩϡϝϯτͷखॱʹ͕ͨͬͯ͠͏·͍͔͘ͳ͍͜ͱ͋Δ • ʮ։ൃ͕׆ൃ͔ͩΒํͳ͍ʯͱׂͯ͠ΓΔ •
ΤϥʔϩάͱυΩϡϝϯτͱGoogleΛཔΓʹ͕ΜΔ • VagrantͰ͓ࢼ͠Ͱ͖Δ • ͜Εखॱ௨Γʹͬͯ͏·͍͔͘ͳ͍͜ͱ͕͋ͬͨ • গͳ͘ͱ 6bc0e7a7 ͷίϛοτ(masterϒϥϯν)ͰͰ͖ͨ • http://docs.redash.io/en/latest/dev/vagrant.html
ը໘ʹ͍ͭͯ • ެࣜαΠτΛோΊͯงғؾΛ͔ͭΉ • http://redash.io/ • σϞαΠτΛ৮ͬͯΈΔ • https://demo.redash.io/ •
GoogleΞΧϯτͰೝূ͢Ε͑Δ • (ࣾษڧձͰ࣮ࡍʹӡ༻͍ͯ͠Δre:dashͰσϞΛ͢Δ
ΤϯδχΞͰͳͯ͘৮Γ͍͢ • ϒϥβʔ͕͋Ε͑Δ • ࣾͷSQLษڧձͰͬͯΈͨͱ͜ΖɺಛʹࠔΒͳ͔ͬͨ • طଘͷΫΤϦͷ݁ՌΛݟΔ͚ͩͳΒSQLΛॻ͘ඞཁ͕ͳ͍ • طଘͷΫΤϦΛForkͯ͠୳Γ୳ΓͰSQLΛ֮͑ΒΕΔɾSQLΛ֮͑ Δ͖͔͚ͬʹͳΔ
• μογϡϘʔυͰ͋Δఔ͍͍ײ͡ʹՄࢹԽͰ͖Δ • ࠔͬͨΒCSVͰμϯϩʔυͯ͠ExcelͰ͕ΜΕ͍͍
re:dashͷඍົͳͱ͜Ζ • (2016/6/15࣌Ͱࢥͬͨ͜ͱΛॻ͍͓͖ͯ·͢ • ྑ͘ѱ͘มԽ͕ܹ͍͠ • ·ͩ҆ఆ൛ԕͦ͏ͳؾ͕͢Δ • υΩϡϝϯτʹॻ͍͍ͯͳ͍͜ͱଟ͍ؾ͕͢ΔʢݸਓͷײͰ͢ •
ݖݶཧ͕ࠓͷͱ͜Ζૈ͍ • άϧʔϓʹରͯ͠ઃఆͰ͖ɺݱ࣌ͰʮϑϧΞΫηεʯ·ͨʮಡΈࠐΈͷΈʯͷ2 • ຊޠͷใ͕·ͩগͳΊ • େͨ͠Ͱͳ͍͚Ͳɺͱ͔͔ͬΓͱͯ͠ຊޠใ͕ཉ͍͜͠ͱ͋Δ
·ͱΊ • re:dashΦʔϓϯιʔεͷσʔλੳɾՄࢹԽπʔϧ • ଟ༷ͳσʔλιʔεʹରԠ͠ɺΫΤϦͷఆظ࣮ߦՄ ೳ • ඇΤϯδχΞ͕SQLʹ৮ΕΔ͖͔͚ͬͱͯ͠׆༻Ͱ ͖Δ •
ࣾͰӡ༻։࢝ͨ͠ͷͰɺঃʑʹΊ͍͖͍ͯͨ
ࢀߟࢿྉ • re:dash is awesome • http://www.slideshare.net/toyama0919/ redash-is-awesome • Rebuild.fm
• ep 145 Benchmarking Placebo (naoya) • https://rebuild.fm/145/