Tableau事例紹介 / Tableau Case Study of Eureka

2024.04.15 【Tableau ユーザー向け】ITサービス Meet up 登壇スライド

ハイパーリンクはnoteで一覧化しています。
https://note.com/jedi_trickstar/n/n94e68e7df042

Transcript

1. © 2024 Eureka, Inc. Tableau Case Study of Eureka 2024.04.15 ʲTableau Ϣʔβʔ޲͚ʳITαʔϏε Meet up
2. © 2024 Eureka, Inc. ͸͡Ίʹ
3. © 2024 Eureka, Inc. εϥΠυ͸ެ։͠·͢ɻϝϞɺࣸਅ౳͸ෆཁͰ͢ɻ https://speakerdeck.com/kazuya_araki_tokyo
4. © 2024 Eureka, Inc. About me Profile - kazuya.araki | Tableau Public HUNTER×HUNTERͷ೦ೳྗ6ܥ౷Ͱᄻ͑Δσʔλ෼ੳεΩϧ one year later
5. ग़యɿMMDݚڀॴʮ2023೥ϚονϯάαʔϏεɾΞϓϦͷར༻࣮ଶௐࠪʯ
6. ϖΞʔζ͸Match GroupͷҰһ and more… Pairs Tinder match okcupid Plenty of Fish Chispa Hinge Hakuna meetic BLK league azar
7. © 2024 Eureka, Inc. ☕ ฐࣾ͸Tableauྺ7೥໨
8. © 2024 Eureka, Inc. ☕ Creator : Explorer : Viewer ≒ 1 : 1 : 8
9. © 2024 Eureka, Inc. ӡ༻ϑΣʔζͱͯ͠͸ԁख़ظ(10 -> 50ͳ͍͠50 -> 100ͷஈ֊) 0 -> 1 1 -> 10 10 -> 100 Tableauಋೖ௚ޙͷঢ়ଶ Prototype Dashboard΍ Ad hoc Report͕ओྲྀͷঢ়گɻ ۀ຿ར༻ͷ֦େظ ύϫʔϢʔβʔͷݗҾʹΑΓɺ ެࣜμογϡϘʔυͷఏڙ͕Ճ଎͠ ͍ͯΔঢ়گɻ ߴ౓Խɺߴޮ཰Խӡ༻ظ มԽͷܹ͍͠Ϗδωεཁ݅ʹ ରͯ͠ॊೈʹରԠͰ͖Δঢ়گɻ
10. © 2024 Eureka, Inc. ӡ༻ϑΣʔζͱͯ͠͸ԁख़ظ(10 -> 50ͳ͍͠50 -> 100ͷஈ֊) 0 -> 1 1 -> 10 10 -> 100 Tableauಋೖ௚ޙͷঢ়ଶ Prototype Dashboard΍ Ad hoc Report͕ओྲྀͷঢ়گɻ ۀ຿ར༻ͷ֦େظ ύϫʔϢʔβʔͷݗҾʹΑΓɺ ެࣜμογϡϘʔυͷఏڙ͕Ճ଎͠ ͍ͯΔঢ়گɻ ߴ౓Խɺߴޮ཰Խӡ༻ظ มԽͷܹ͍͠Ϗδωεཁ݅ʹ ରͯ͠ॊೈʹରԠͰ͖Δঢ়گɻ
11. © 2024 Eureka, Inc. ΍͍ͬͯΔ͜ͱ(ۀ຿಺) BigQueryͷനຐज़ࢣ͕dbtͱ͍͏࠷ڧΫϥεͷ৮ഔΛ༻͍͍͍ͯײ͡ʹੈքΛٹ͏ํ๏
12. © 2024 Eureka, Inc. ΍͍ͬͯΔ͜ͱ(ۀ຿֎) ಈ͖ग़͢σʔλυϦϒϯ૊৫ͷͭ͘Γ͔ͨ Tableau BlueprintʹֶͿ࣮ફతΞϓϩʔν Best of Tableau Web 2023೥10݄߸ σʔλυϦϒϯͳ૊৫Λ࣮ݱ͢Δ࣮ફతख๏Λ͝঺հ ʰ࠷ڧͷσʔλ෼ੳ؀ڥʱΛߏஙͯ͠ ϏδωεΛՃ଎ͤ͞Ζʂʂ ࠓߋղઆ͢Δಈ͖ग़͢σʔλυϦϒϯ૊৫ͷͭ͘Γ͔ͨ ষผ߈ུฤ - 2ষ ΞδϟΠϧੑ
13. © 2024 Eureka, Inc. Agenda 1. Recap: σβΠϯγεςϜΛ༻͍ͨDashboardͷ࡞੒ 2. Data Enablingͷ঺հͱࠓޙͷల๬ 3. Tableauͷࠓޙʹظ଴͢Δ͜ͱ
14. © 2024 Eureka, Inc. Recap: σβΠϯγεςϜΛ༻͍ͨDashboardͷ࡞੒
15. © 2024 Eureka, Inc. Recap: લճͷIssue જࡏతͳ՝୊ - Tableauࣄྫ঺հ & ՝୊ڞ༗
16. © 2024 Eureka, Inc. Recap: લճͷSolution Dashboard Design - Tableauࣄྫ঺հ & ՝୊ڞ༗ ࠓ೔͸͜͜ΛޠΓ·͢ - Tableauࣄྫ঺հ & ՝୊ڞ༗
17. © 2024 Eureka, Inc. After one year…
18. © 2024 Eureka, Inc. Summary ෦෼࠷దԽ -> ղফ ৘ใͷ෼ࢄɺ֦ࢄ -> ղফ ೝ஌ෛՙͷߴ͍Visualization -> σβΠϯγεςϜͷPros / Cons
19. © 2024 Eureka, Inc. Keep: "෦෼࠷దԽ"ɺ"৘ใͷ෼ࢄɺ֦ࢄ"ͷղফ Executive Dashboard Marketing Insights Product Monitoring ※࿈ܞઌ͸ΠϝʔδͰ͢ɻ࣮ࡍͱ಺༰͕ҟͳΓ·͢ɻ
20. © 2024 Eureka, Inc. Keep: "༗༻ͳ" Report / Dashboard͕૿͖͑ͯͨ ݟͤΒΕͳͯ͘ ͝ΊΜͳ͍͞ɻ
21. © 2024 Eureka, Inc. Problem: σβΠϯγεςϜͷӡ༻͸͏·͘ఆண͠ͳ͔ͬͨ σβΠϯγεςϜӡ༻ͷ໰୊఺ͱؾ෇͖ ޻਺ͷ໰୊ • ߴ඼࣭Λ୲อ͢ΔͨΊʹɺ·ͱ·ͬͨ޻਺͕ඞཁɻ • ProjectͰ޻਺֬อ͢Ε͹ՄೳɻยखؒͰͷۀ຿Ͱ͸ෆՄೳɻ • σβΠφʔͷׂ͕͚࣌ؒͳ͍ɻ εΩϧͷ໰୊ • ඇσβΠφʔ͕FigmaΛ࢖͍͜ͳ͢োนΛߟྀ͠ͳ͚Ε͹ͳΒͳ͍ɻ • Figma -> Tableauʹམͱ͠ࠐΉ೉қ౓͕ߴ͍ɻref. ॻࣜઃఆͷπϥϛ - Tableauࣄྫ঺հ & ՝୊ڞ༗ • ద੾ͳεΩϧτϥϯεϑΝʔΛߦΘͳ͍ͱଐਓԽ͕ਐΉɻ BIπʔϧͷ໰୊ • σβΠϯςϯϓϨʔτػೳ͕ͳ͍BIπʔϧ͸σβΠϯγεςϜʹ޲͔ͳ͍ɻ • ॻࣜઃఆͷ੍໿͕ڧ͍πʔϧ΄ͲɺσβΠϯઃܭͷ෯͕ڱ·Δɻ • ख਺͕ଟ͍ͱͦͷ෼޻਺͕͔͔ΔͨΊɺσβΠϯγεςϜΛ࠾༻͠ʹ͘͘ͳΔɻ
22. © 2024 Eureka, Inc. ·ͱΊ ෦෼࠷దԽ -> ղফ 👍 ެࣜReport / DashboardԽΛଅਐɻ 👍 ࣄۀͰݟΔ΂͖΋ͷΛPortalͰҰͭʹू໿ɺ౷Ұͨ͠ɻ ৘ใͷ෼ࢄɺ֦ࢄ -> ղফ 👍 redashΛެࣜ؅ཧ͔Βഇࢭɻ 👍 TableauͷݕࡧػೳͰ͸୳ͤͳ͍ϢʔβʔͷͨΊʹPortalΛ࡞੒͠ɺಈઢΛ֬อͨ͠ɻ ೝ஌ෛՙͷߴ͍Visualization -> σβΠϯγεςϜͷPros / Cons 👍 σβΠϯγεςϜʹΑΓɺReport / Dashboardͷັͤํ͕มԽͨ͠ɻ ◦ CreatorͷσβΠϯҙ͕ࣝશମతʹ޲্ɻ ◦ ߴ඼࣭ͳReport / Dashboard͕૿͑ɺೝ஌ෛՙͷରࡦͱͳͬͨɻ 😢 σβΠϯγεςϜͷӡ༻͸ఆண͠ͳ͔ͬͨɻ ◦ Figmaͷӡ༻޻਺͕ߴ͍ͨΊɺద੾ʹӡ༻Ͱ͖ͳ͔ͬͨɻ ◦ σβΠϯΛ୲͏ϝϯόʔ͕ݶΒΕɺଐਓԽ͕ਐΜͰ͠·ͬͨɻ
23. © 2024 Eureka, Inc. Data Enablingͷ঺հͱࠓޙͷల๬
24. © 2024 Eureka, Inc. What is "Data Enabling" ? Data Enablement͸૊৫͕σʔλࢿ࢈ͷՄೳੑΛ࠷େݶʹ׆༻Ͱ͖ΔΑ͏ʹ͢ΔઓུతͳϓϩηεͰ͢ɻ ͜Εʹ͸ɺσʔλʹ؆୯ʹΞΫηεͰ͖ɺద੾ʹ؅ཧ͞ΕɺҙࢥܾఆͱΠϊϕʔγϣϯΛଅਐ͢ΔͨΊʹޮՌతʹ࢖༻͞ΕΔ؀ڥΛߏங͢Δ ͜ͱؚ͕·Ε·͢ɻ atran: Data Enablement: What is It & How to Get Started? Data Enablement͸૊৫಺ͷϢʔβʔ͕؆୯ʹΞΫηε࣮ͯ͠ߦͰ͖ΔΑ͏ʹσʔλΛ੔ཧ͓Αͼ؅ཧ͢Δ࣮ફΛࢦ͠·͢ɻ ͜Εʹ͸σʔλ ιʔεͷҰݩԽɺσʔλͷݕূͱ෼ྨ͔Βɺσʔλมߋʹؔ͢ΔϦΞϧλΠϜͷߋ৽ͷఏڙ·Ͱɺ෯޿͍׆ಈؚ͕·Ε·͢ɻ Secoda: What is Data Enablement? Data EnablementʹΑΓɺνʔϜ͸ٕज़తͳઐ໳஌ࣝʹؔ܎ͳ͘ɺσʔλΛཧղ͠ɺͦͷՄೳੑΛ࠷େݶʹ׆༻Ͱ͖ΔΑ͏ʹͳΓ·͢ɻ ϫʔΫϑϩʔΛվળ͠ɺϓϩηεΛڧԽ͠ͳ͕ΒɺνʔϜ͕૊৫಺ͷ஌ࣝΛൃݟɺจॻԽɺڞ༗͢ΔͨΊͷπʔϧΛఏڙ͠·͢ɻ Michelle Hunt: What is Data Enablement?
25. © 2024 Eureka, Inc. զʑ͕໨ࢦ͢΂͖Data Enablingͷੈք؍ Mission: Eurekaʹରͯ͠ͳ͢΂͖͜ͱ Eureka͕σʔλʹج͍ͮͨՁ஋͋ΔҙࢥܾఆΛͰ͖ΔΑ͏ʹ͢Δɻ Vision: ໨ࢦ͢΂͖࢟ Ձ஋͋Δ΋ͷΛਖ਼͘͠ߦ͏ɻ Value: ۩ମతʹ΍Δ΂͖͜ͱ QCDS*Λ౰ͨΓલʹମݱ͢ΔूஂͰ͋Δ͜ͱɻ * QCDS = Quality, Cost, Delivery, Service
26. © 2024 Eureka, Inc. Tableau Blueprintʹྫ͑ΔͱɺҎԼΛॏ఺తʹରԠத Tableau Blueprint Assessment | Start your data journey
27. © 2024 Eureka, Inc. ௚ۙͷ(Tableau໰Θͣ)BIπʔϧͷ՝୊ײ Report / Dashboardͷෆಁ໌ੑ͕෷১Ͱ͖͍ͯͳ͍ • ఆৗతɺજࡏతʹେྔͷReport / DashboardΛ๊͓͑ͯΓɺͦΕΒ͢΂ͯΛ؅ཧͰ͖͍ͯͳ͍ɻ • ෦෼࠷దԽ͸͋Δఔ౓ղফ͕ͨ͠ɺຊ౰ʹॏཁͳReport / Dashboardͳͷ͔ఆྔ൑அ͕Ͱ͖ͳ͍ɻ • ΧελϜSQLΛ࢖༻ͨ͠Report / Dashboard͕ଘࡏ͢Δɻ Report / Dashboardͷ࡞੒ίετ͕ߴ͍ • Report / DashboardΛ࡞੒͢Δ༨༟͕ͳ͍ɻ • ࣭ͷߴ͍Report / Dashboardͷχʔζ͕ߴ·͍ͬͯΔɻ • σβΠϯͷ౷Ұ͕Ͱ͖ͳ͍ͷͰ࡞੒ʹ͕͔͔࣌ؒΔɻ Report / Dashboardͷཤྺ؅ཧ͕೉͍͠ • ෳ਺ਓͷಉ࣌ฤूͰ্ॻ͖ࣄނ͕ൃੜ͠΍͍͢ɻ • มߋՕॴ͕Θ͔Βͳ͍ɻ • GitHubͰߏ੒؅ཧ͍͕ͨ͠ɺGitHubͱ࿈ܞͰ͖ΔBIπʔϧ͕ݶΒΕΔɻ
28. © 2024 Eureka, Inc. Tableau͚ͩͰ͸ղܾ͠ͳ͍՝୊΋ଟ͍ Data WarehouseɺELT(dbt)ͱͷ࿈ܞ͕ബ͍ • Data ManagementΛಋೖͰ͖͍ͯͳ͍ͷͰ಺੡ͰऔΓ૊Ήඞཁ͕͋Δɻ • Data MartͱBIπʔϧͷؔ܎ੑΛ؅ཧͰ͖͍ͯͳ͍ɻ • ഇࢭ͍ͨ͠ΞΠςϜͷௐࠪʹ͕͔͔࣌ؒͬͯ͠·͏ɻ σʔλؔ࿈ͷυΩϡϝϯτ੔උ͕௥͍͍͍ͭͯͳ͍ • ॏཁࢦඪͷఆ͕ٛΘ͔Βͳ͍ɻ • ৽͍͠σʔλϞσϧΛ࡞੒ͨ͠ࡍͷ৘ใڞ༗͕ෆ଍͍ͯ͠Δɻ • ૯ͯ͡ɺଐਓతʹͳΓɺෆ҆ఆͳӡ༻ͱͳ͍ͬͯΔɻ
29. © 2024 Eureka, Inc. ଞͷιϦϡʔγϣϯ΋ۦ࢖ͯ͠ղܾʹಋ͘ ✓ dbt Exposuresͷ੔උ ✓ Data Catalogͷಋೖ ✓ υΩϡϝϯτ੔උ(Metrics Store)
30. © 2024 Eureka, Inc. dbt Exposures Add Exposures to your DAG | dbt Developer Hub staging data intermediate / mart data Report / Dashboard
31. © 2024 Eureka, Inc. dbt Exposures Add Exposures to your DAG | dbt Developer Hub Data MartͱReport / Dashboardͷ ؔ܎ੑΛ؅ཧ & ՄࢹԽ͍ͨ͠ɻ ͕ɺࣗಈੜ੒Ͱ͖ͳ͍ͷ͕೰Έ(ޙड़)
32. © 2024 Eureka, Inc. Metadata Management Metadata Management: Benefits, Automation & Use Cases
33. © 2024 Eureka, Inc. Metadata Management Metadata Management: Benefits, Automation & Use Cases σʔλʹ·ͭΘΔ͋ΒΏΔ৘ใΛϝλσʔλͱͯ͠Ұݩ؅ཧ͢Δɻ Data CatalogΛ࣠ʹɺෆ଍ͨ͠Օॴ͸υΩϡϝϯτπʔϧͰิ͏ɻ
34. © 2024 Eureka, Inc. Tableauͷࠓޙʹظ଴͢Δ͜ͱ
35. © 2024 Eureka, Inc. ࠓճͷςʔϚҰཡ • Tableau Pulse • Tableau AI • Slack Integration • ͦͷଞɺIdeasΑΓϐοΫΞοϓ
36. © 2024 Eureka, Inc. Tableau Pulse
37. © 2024 Eureka, Inc. Metrics΋ͱ͍Pulse͸ظ଴஋͕ߴ͍ػೳ How Tableau Pulse powered by Tableau AI is Reimagining the Data Experience
38. © 2024 Eureka, Inc. ͔͠͠ɺPulse͕ఏڙ͢ΔMetrics Layer͚ͩͩͱ଍Γͳ͍ How Tableau Pulse powered by Tableau AI is Reimagining the Data Experience
39. © 2024 Eureka, Inc. Metrics Storeʹ֘౰͢Δػೳ͕ෆՄܽ Metrics Store - Modern Data Stack
40. © 2024 Eureka, Inc. Metrics Storeʹ֘౰͢Δػೳ͕ෆՄܽ Metrics Store - Modern Data Stack • KGI/KPI • ֤ࢦඪͷఆٛ • ΠϯαΠτͷڞ༗ • ͳͲ Ұ؏ͯ҆͠ఆڙڅՄೳͳ؀ڥͱɺ ܧଓͯ͠੔උ͢Δӡ༻ઓུ͕ඞཁɻ
41. © 2024 Eureka, Inc. Metrics Store͕੔උ͞Ε͍ͯͳ͍ͱൃੜ͠͏Δྫ
42. © 2024 Eureka, Inc. Metrics Store͕੔උ͞Ε͍ͯͳ͍ͱൃੜ͠͏Δྫ ֤෦໳ͷMAU(Monthly Active Users)ͷ஋͕ ඍົʹͣΕ͍ͯΔ🤔
43. © 2024 Eureka, Inc. Metrics Store͕੔උ͞Ε͍ͯͳ͍ͱൃੜ͠͏Δྫ ݄ʹΑͬͯ೔਺͸ҟͳΔ ೔਺͸ߟྀ͠ͳͯ͘΋͍͍ (ࣙॻతͳҙຯͰͷMAU) 30೔Ͱฏ४Խ͍ͨ͠ 28೔Ͱฏ४Խ͍ͨ͠ (೔਺ͷগͳ͍2݄ʹ߹Θ͍ͤͨ) ݪҼ
44. © 2024 Eureka, Inc. Metrics Store͕੔උ͞Ε͍ͯͳ͍ͱൃੜ͠͏Δྫ TableauͰࢦඪͷܭࢉΛߦ͍ͬͯΕ͹ɺܭࢉϩδοΫ͸ࢀরՄೳɻ (Tableau CatalogͰ͋Ε͹Web͔Β΋֬ೝͰ͖Δ) ͔͠͠ɺHow͕Θ͔ͬͯ΋Whyͷ৘ใ͕ͳ͍ͷͰɺσʔλར༻ऀ ಉ࢜ͷ໨ઢ͕߹Θͳ͍έʔε͕ൃੜ͠ಘΔɻ • ͳͥɺ͜ͷܭࢉϩδοΫͳͷ͔ʁ • ҰൠతͳMAUͷఆٛͱҟͳΔͷ͸͸͔ͥʁ • ͳͥɺ͜ͷఆٛͳͷ͔ʁҙਤ͸͋Δͷ͔ʁ • etc... ࢦඪʹؔ͢Δ͋ΒΏΔ৘ใΛҰݩू໿͢Δ؀ڥ͕ඞཁ
45. © 2024 Eureka, Inc. AI + Analytics | Tableau
46. © 2024 Eureka, Inc. ݸਓతʹײ͡ΔAIؔ࿈(Einstein Copilot for Tableau)ͷݒ೦ ೔ຊޠͷݒ೦ • ӳޠରԠ༏ઌͳͷ͸࢓ํ͕ͳ͍ɻ • (ຊ݅ʹݶΒͣ)೔ຊޠରԠࣗମ͕ͦ΋ͦ΋೉қ౓͕ߴ͍ͷͰϦϦʔε࣌ظ͸஗͍ͷͰ͸ʁ • Ask DataͷϦϦʔεঢ়گɺ͓ΑͼఫୀΛؑΈͯ΋ɺ৻ॏʹ൑அ͠ͳ͚Ε͹ͳΒͳ͍ɻ Trust & Safetyͷݒ೦ • ΫϦςΟΧϧσʔλ(ݸਓ৘ใɺӦۀػີͳͲ)ΛTableauʹ౉͢ϦεΫΛߟྀ͠ͳ͚Ε͹ͳΒͳ͍ɻ • ݁Ռʹରͯ͠৴༻ʹ஋͢Δ͔ͷ൑அ͕ͱͯ΋೉͍͠ɻ • Tableau CloudͷΈͷϦϦʔε(Tableau ServerͷϦϦʔεൃද͸ͳ͔ͬͨ͸ͣ)ɻ TableauΛ༻͍ͨAIۀ຿Λߦ͏΂͖͔ͷ൑அ • AI PromptΛ࢖͍͜ͳ͢εΩϧΛཁ͢ΔͨΊɺ࢖͍ํʹΑͬͯ͸ޡͬͨ݁ՌΛੜΈग़͢ՄೳੑΛൿΊ͍ͯΔɻ • Pythonଞϓϩάϥϛϯάݴޠ΍ɺ֤छCloud PlatformͰߦ͍ͬͯΔσʔλαΠΤϯεۀ຿Λ୅ସͰ͖Δͷ͔ɻ • ຊདྷͷTableauͰߦ͖ͬͯͨۀ຿͕ͲͷΑ͏ʹ࡮৽͞ΕΔͷ͔ɻ
47. © 2024 Eureka, Inc. Tableau + Slack
48. © 2024 Eureka, Inc. Repeat: Slack࿈ܞͷϦΫΤετ Slack࿈ܞڧԽ - Tableauࣄྫ঺հ & ՝୊ڞ༗
49. © 2024 Eureka, Inc. νϟϯωϧѼͷૹड৴͕ඞਢ Idea: Slack integration by channel
50. © 2024 Eureka, Inc. https://twitter.com/tableau/status/1723031116041294127
51. © 2024 Eureka, Inc. dbt࿈ܞػೳ(͋Δ͍͸dbt࿈ܞʹඞཁͳAPI) Idea: dbt lineage models and meta data dbtͷϞσϧͱTableau্Ͱ࢖ΘΕ͍ͯΔWorkbookͷґଘؔ܎Λ exposureͰදݱͯ͠ɺσʔλ؅ཧΛޮ཰తʹߦͳ͓͏ - yasuhisa's blog
52. © 2024 Eureka, Inc. σβΠϯςϯϓϨʔτػೳ Idea: Template Dashboards That Have Default Images & Text (Example: Company Logo, Bord Idea: Alter Default Formats / Save as Style Template
53. © 2024 Eureka, Inc. ॻࣜؔ࿈ͷػೳڧԽͱॆ࣮ and more… Idea: Conditional Formatting of Measure Names/Measure Values Idea: Customise the default font permanently Idea: Formatting legends: wrapping texts Idea: Ability to drag Layout Containers into Layout Heirarchy
54. © 2024 Eureka, Inc. ͍͞͝ʹ
55. © 2024 Eureka, Inc. Ҿ͖ଓ͖ɺIdeasͷ௥Ճɺ͓ΑͼVoteΛ͓ئ͍͠·͢🙇 https://community.tableau.com/s/ideas
56. © 2024 Eureka, Inc.
57. © 2024 Eureka, Inc. APPENDIX
58. © 2024 Eureka, Inc. ࢖༻ૉࡐҰཡ μௗ्ٔը https://chojugiga.com/ unDraw https://undraw.co/illustrations Adobe Express QRίʔυ࡞੒ https://new.express.adobe.com/tools/generate-qr-code
59. © 2024 Eureka, Inc. URLू Speaker DeckͰ͸ϋΠύʔϦϯΫ͕ແޮͳͷͰɺϋΠύʔϦϯΫͷϦετΛҎԼʹ·ͱΊ·ͨ͠ɻ https://note.com/jedi_trickstar/n/n94e68e7df042