Exploratory コラボレーション・サーバーの 活用例

2020/5/29(金)に開催したExploratory データサイエンス勉強会#13のBeacon Communications k.k.様のご登壇資料です。

Transcript

1. 2020.05.29 Exploratory     Exploratory    
   
3. Contents ձࣾ঺հ I. ೔ʑͷۀ຿ͱ՝୊ II. ౰ॳͷऔΓ૊ΈͱͿ͔ͭͬͨน III. ExploratoryಋೖޙͷมԽ I. Ϗʔίϯίϛϡχέʔγϣϯζ גࣜձࣾ II. ૯߹޿ࠂ୅ཧళ III. ϚʔέςΟϯάࢧԉશൠ ࣗݾ঺հ ෋ֽ ֶ ʢσʔλϕʔεΞυϛχετϨʔλʣ CRMνʔϜͰDBઃܭɺ෼ੳۀ຿Λ୲౰ ͓࿩͢͠Δ಺༰
4. Work Flow – As Is σʔλ෼ੳΛਐΊΔதͰɺԾઆઃఆ΍෼ੳʹ࣌ؒΛׂ͍ͯਂ͍ΠϯαΠτΛநग़͍͕ͨ͠ɺ ࣾ಺͔Β͸σʔλूܭ΍ՄࢹԽͷґཔ͕ଟ͋͘ΓɺϦιʔεΛṧഭ Ӧۀ ෼ੳ ՄࢹԽ ूܭ Ծઆ Ӧۀ Ӧۀ Ӧۀ ෼ੳऀ ෼ੳऀ ੍࡞ ੍࡞
5. Work Flow – To Be ෼ੳΛඞཁͱ͠ͳ͍୯७ͳूܭ/ՄࢹԽ͸ͳΔ΂ࣗ͘ಈԽͯ͠ɺԾઆઃఆ΍෼ੳʹϦιʔεΛ ഑෼͍ͨ͠ Ӧۀ ෼ੳ ՄࢹԽ ूܭ Ծઆ Ӧۀ Ӧۀ Ӧۀ ෼ੳऀ ෼ੳऀ ੍࡞ ੍࡞
6. Team Work – As Is CRM Team ֤୲౰ऀ͕ҟͳΔΫϥΠΞϯτͷ෼ੳ/Ϩϙʔτ࡞੒ͳͲΛ୲౰ ෼ੳ݁Ռ΍ϊ΢ϋ΢͸֤୲౰ऀຖʹ஝ੵ ΫϥΠΞϯτ$ ΫϥΠΞϯτ# ΫϥΠΞϯτ" ΫϥΠΞτ% ΫϥΠΞϯτ' ΫϥΠΞϯτ&
7. Team Work – To Be CRM Team Knowledge ֤୲౰ऀ͕࣮ࢪͨ͠෼ੳ΍ϨϙʔτΛڞ༗ՄೳͳφϨοδͱͯ͠஝ੵͰ͖Δ؀ڥ͕ඞཁ ΫϥΠΞϯτ$ ΫϥΠΞϯτ# ΫϥΠΞϯτ" ΫϥΠΞτ% ΫϥΠΞϯτ' ΫϥΠΞϯτ&
8. Issue I. ୯७ͳूܭ΍ՄࢹԽͷґཔ͕සൃ͠ɺखΛಈ͔ ͢ࣄʹ࣌ؒΛऔΒΕɺԾઆઃఆ΍෼ੳ/ಎ࡯ͷϦ ιʔε͕ṧഭ͞Ε͍ͯΔ II. νʔϜ಺ͰҟͳΔΫϥΠΞϯτɺҟͳΔ෼ੳΛ ࣮ࢪ͍ͯ͠ΔͨΊɺφϨοδΛڞ༗Ͱ͖͍ͯͳ ͍ʢଐਓԽʣ III. ୭͕Ͳ͏͍͏෼ੳΛ΍͍ͬͯΔ͔ɺ෼ੳ݁Ռͷ ೺Ѳʹͻͱख͔͔ؒͬͯ͠·͏ʢ࠶ݱੑʣ
9. Our Try I. ґཔऀ͕ࣗ਎ͰσʔλΛࢀরͰ͖ΔΑ͏ʹɺMS AccessͰσʔλΛࢀরͯ͠΋Β͏؀ڥΛߏங ⇒MS Accessͷར༻ϋʔυϧ͕ߴ͘ීٴͤͣ II. φϨοδΛϝʔϧͰڞ༗ ⇒ϝʔϧʹຒ΋Εɺಡ·Εͳ͍ III. Excelʹ෼ੳ݁Ռɺखॱɺར༻ίʔυͳͲΛ· ͱΊɺ ϑΝΠϧڞ༗αʔόͰ؅ཧ ⇒୳͠ʹ͍͘ ՝୊ʹରͯ͠ɺ͍͔ͭ͘ͷΞϓϩʔνΛऔΔ΋ɺ͍ͣΕ΋ීٴͤͣݱঢ়ͷ·· ඞཁͳࣄ͸ɺಛผͳεΩϧ΍஌͕ࣝͳ͘ʮ௚ײతʹσʔλ͕ݟΒΕΔʯ؀ڥΛߏங͢Δࣄͱ ϊ΢ϋ΢ΛʮΞΫηε͠қ͍ʯ৔ॴʹू໿͢Δࣄ
10. Exploratory Collaboration Server After Exploratory Analysis Dash Board Note Internal Database ΫϥΠΞϯ τ1 ΫϥΠΞϯ τ.
11. After Exploratory Ӧۀ ෼ੳ ՄࢹԽ ूܭ Ծઆ ෼ੳऀ Ӧۀ ෼ੳऀ ෼ੳऀ ੍࡞ ੍࡞ Analysis Analysis Note Dash Board Dash Board ෼ੳऀ Note Exploratoryಋೖޙ͸ɺࣾ಺ͷؔ܎ऀ͢΂ͯͷχʔζʹରԠ͕Մೳʹ Data Catalog
12. Why Exploratory Exploratory Collaboration Server - ҰͭͷϓϥοτϑΥʔϜͰूܭɺ෼ੳɺՄࢹԽɺใࠂ͕Ͱ͖Δ ʢ෼ੳ؀ڥͷҰຊԽɺμογϡϘʔυ࡞੒ɺϊ΢ϋ΢ڞ༗ͷશ͕ͯՄೳʣ - EDFϑΝΠϧʹΑͬͯखॱͱ੒Ռ෺͕ηοτͰ؅ཧɾڞ༗Ͱ͖Δ - ϊʔτʹφϨοδΛ·ͱΊͯڞ༗Ͱ͖ɺΠϯαΠτϖʔδ͔Β؆୯ʹ୳͢͜ͱ ͕Ͱ͖Δɻ ʢΞΫηε͕༰қʣ - GUIͰૢ࡞Ͱ͖ΔͨΊίʔυʹඅ΍͍ͯͨ࣌ؒ͠Λߟ͑Δ࣌ؒʹ࢖͑Δ - ΠϯτϥωοτͰར༻Ͱ͖ΔʢΫϥΠΞϯτͷσʔλΛࣾ֎ʹஔ͚ͳ ͍ͨΊʣ - σʔλαΠζΛؾʹͤͣར༻Ͱ͖Δ
13. αΠζ͕େ͖͍ςʔϒϧͷ৔߹͸ύϥϝʔλΛ࢖͍ɺ౎౓ɺσʔλϕʔεʹSQLΛ౤͛ΔΑ͏ʹ࣮૷ ͜ΕʹΑΓɺେن໛σʔλΛμογϡϘʔυͰՄࢹԽ͢Δ࣌΋εϜʔζʹ৘ใΛ൓өՄೳ SELECT ɾɾɾ WHERE COLUMN = ύϥϝʔλ νϟʔτʹඞཁͳσʔλͷΈूܭͯ͠ฦ͢ αΠζ͕େ͖͍ςʔϒϧͷμογϡϘʔυ
14. &%'ʹΑΔखॱͱ੒Ռ෺ͷڞ༗
15. ΠϯαΠτϖʔδ͔ΒφϨοδΛ୳͢
16. σʔλΧλϩά
17. - ྑ͔ͬͨ఺ - ಋೖ͕؆୯ʢDockerΠϝʔδΛىಈ͢Δ͚ͩʣ - SQL Server͕ར༻Ͱ͖Δ - ύϒϦογϡ͞Εͨ΋ͷΛViewerϥΠηϯε͕ແͯ͘΋ࢀর͢Δ͜ͱ͕Ͱ͖Δ - ͞ΒʹਐԽͯ͠΄͍͠఺ - μογϡϘʔυͷσʔλΛνϟʔτຖʹCSVͰμ΢ϯϩʔυ͢Δ - ύϒϦογϡͨ͠΋ͷͷڞಉฤूʢίϥϘϨʔγϣϯʣػೳ - ಈతύϥϝʔλ Other points
18. Thank you