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

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

Transcript

1. 2020.05.29
   Exploratory
   
   
   
   Exploratory
   

   View Slide

2. View Slide

3. Contents
   ձࣾ঺հ
   I. ೔ʑͷۀ຿ͱ՝୊
   II. ౰ॳͷऔΓ૊ΈͱͿ͔ͭͬͨน
   III. ExploratoryಋೖޙͷมԽ
   I. Ϗʔίϯίϛϡχέʔγϣϯζ גࣜձࣾ
   II. ૯߹޿ࠂ୅ཧళ
   III. ϚʔέςΟϯάࢧԉશൠ
   ࣗݾ঺հ
   ෋ֽ ֶ ʢσʔλϕʔεΞυϛχετϨʔλʣ
   CRMνʔϜͰDBઃܭɺ෼ੳۀ຿Λ୲౰
   ͓࿩͢͠Δ಺༰
   

   View Slide

4. Work Flow – As Is
   σʔλ෼ੳΛਐΊΔதͰɺԾઆઃఆ΍෼ੳʹ࣌ؒΛׂ͍ͯਂ͍ΠϯαΠτΛநग़͍͕ͨ͠ɺ
   ࣾ಺͔Β͸σʔλूܭ΍ՄࢹԽͷґཔ͕ଟ͋͘ΓɺϦιʔεΛṧഭ
   Ӧۀ
   ෼ੳ
   ՄࢹԽ
   ूܭ
   Ծઆ
   Ӧۀ
   Ӧۀ
   Ӧۀ
   ෼ੳऀ ෼ੳऀ
   ੍࡞ ੍࡞
   

   View Slide

5. Work Flow – To Be
   ෼ੳΛඞཁͱ͠ͳ͍୯७ͳूܭ/ՄࢹԽ͸ͳΔ΂ࣗ͘ಈԽͯ͠ɺԾઆઃఆ΍෼ੳʹϦιʔεΛ
   ഑෼͍ͨ͠
   Ӧۀ
   ෼ੳ
   ՄࢹԽ
   ूܭ
   Ծઆ
   Ӧۀ
   Ӧۀ
   Ӧۀ
   ෼ੳऀ ෼ੳऀ
   ੍࡞ ੍࡞
   

   View Slide

6. Team Work – As Is
   CRM Team
   ֤୲౰ऀ͕ҟͳΔΫϥΠΞϯτͷ෼ੳ/Ϩϙʔτ࡞੒ͳͲΛ୲౰
   ෼ੳ݁Ռ΍ϊ΢ϋ΢͸֤୲౰ऀຖʹ஝ੵ
   ΫϥΠΞϯτ$
   ΫϥΠΞϯτ#
   ΫϥΠΞϯτ"
   ΫϥΠΞτ%
   ΫϥΠΞϯτ'
   ΫϥΠΞϯτ&
   

   View Slide

7. Team Work – To Be
   CRM Team
   Knowledge
   ֤୲౰ऀ͕࣮ࢪͨ͠෼ੳ΍ϨϙʔτΛڞ༗ՄೳͳφϨοδͱͯ͠஝ੵͰ͖Δ؀ڥ͕ඞཁ
   ΫϥΠΞϯτ$
   ΫϥΠΞϯτ#
   ΫϥΠΞϯτ"
   ΫϥΠΞτ%
   ΫϥΠΞϯτ'
   ΫϥΠΞϯτ&
   

   View Slide

8. Issue
   I. ୯७ͳूܭ΍ՄࢹԽͷґཔ͕සൃ͠ɺखΛಈ͔
   ͢ࣄʹ࣌ؒΛऔΒΕɺԾઆઃఆ΍෼ੳ/ಎ࡯ͷϦ
   ιʔε͕ṧഭ͞Ε͍ͯΔ
   II. νʔϜ಺ͰҟͳΔΫϥΠΞϯτɺҟͳΔ෼ੳΛ
   ࣮ࢪ͍ͯ͠ΔͨΊɺφϨοδΛڞ༗Ͱ͖͍ͯͳ
   ͍ʢଐਓԽʣ
   III. ୭͕Ͳ͏͍͏෼ੳΛ΍͍ͬͯΔ͔ɺ෼ੳ݁Ռͷ
   ೺Ѳʹͻͱख͔͔ؒͬͯ͠·͏ʢ࠶ݱੑʣ
   

   View Slide

9. Our Try
   I. ґཔऀ͕ࣗ਎ͰσʔλΛࢀরͰ͖ΔΑ͏ʹɺMS
   AccessͰσʔλΛࢀরͯ͠΋Β͏؀ڥΛߏங
   ⇒MS Accessͷར༻ϋʔυϧ͕ߴ͘ීٴͤͣ
   II. φϨοδΛϝʔϧͰڞ༗
   ⇒ϝʔϧʹຒ΋Εɺಡ·Εͳ͍
   III. Excelʹ෼ੳ݁Ռɺखॱɺར༻ίʔυͳͲΛ·
   ͱΊɺ
   ϑΝΠϧڞ༗αʔόͰ؅ཧ
   ⇒୳͠ʹ͍͘
   ՝୊ʹରͯ͠ɺ͍͔ͭ͘ͷΞϓϩʔνΛऔΔ΋ɺ͍ͣΕ΋ීٴͤͣݱঢ়ͷ··
   ඞཁͳࣄ͸ɺಛผͳεΩϧ΍஌͕ࣝͳ͘ʮ௚ײతʹσʔλ͕ݟΒΕΔʯ؀ڥΛߏங͢Δࣄͱ
   ϊ΢ϋ΢ΛʮΞΫηε͠қ͍ʯ৔ॴʹू໿͢Δࣄ
   

   View Slide

10. Exploratory Collaboration Server
    After Exploratory
    Analysis
    Dash Board
    Note
    Internal Database
    ΫϥΠΞϯ
    τ1
    ΫϥΠΞϯ
    τ.
    

    View Slide

11. After Exploratory
    Ӧۀ
    ෼ੳ
    ՄࢹԽ
    ूܭ
    Ծઆ
    ෼ੳऀ
    Ӧۀ
    ෼ੳऀ ෼ੳऀ
    ੍࡞ ੍࡞
    Analysis Analysis
    Note
    Dash Board Dash Board
    ෼ੳऀ
    Note
    Exploratoryಋೖޙ͸ɺࣾ಺ͷؔ܎ऀ͢΂ͯͷχʔζʹରԠ͕Մೳʹ
    Data Catalog
    

    View Slide

12. Why Exploratory
    Exploratory
    Collaboration
    Server
    - ҰͭͷϓϥοτϑΥʔϜͰूܭɺ෼ੳɺՄࢹԽɺใࠂ͕Ͱ͖Δ
    ʢ෼ੳ؀ڥͷҰຊԽɺμογϡϘʔυ࡞੒ɺϊ΢ϋ΢ڞ༗ͷશ͕ͯՄೳʣ
    - EDFϑΝΠϧʹΑͬͯखॱͱ੒Ռ෺͕ηοτͰ؅ཧɾڞ༗Ͱ͖Δ
    - ϊʔτʹφϨοδΛ·ͱΊͯڞ༗Ͱ͖ɺΠϯαΠτϖʔδ͔Β؆୯ʹ୳͢͜ͱ
    ͕Ͱ͖Δɻ
    ʢΞΫηε͕༰қʣ
    - GUIͰૢ࡞Ͱ͖ΔͨΊίʔυʹඅ΍͍ͯͨ࣌ؒ͠Λߟ͑Δ࣌ؒʹ࢖͑Δ
    - ΠϯτϥωοτͰར༻Ͱ͖ΔʢΫϥΠΞϯτͷσʔλΛࣾ֎ʹஔ͚ͳ
    ͍ͨΊʣ
    - σʔλαΠζΛؾʹͤͣར༻Ͱ͖Δ
    

    View Slide

13. αΠζ͕େ͖͍ςʔϒϧͷ৔߹͸ύϥϝʔλΛ࢖͍ɺ౎౓ɺσʔλϕʔεʹSQLΛ౤͛ΔΑ͏ʹ࣮૷
    ͜ΕʹΑΓɺେن໛σʔλΛμογϡϘʔυͰՄࢹԽ͢Δ࣌΋εϜʔζʹ৘ใΛ൓өՄೳ
    SELECT ɾɾɾ WHERE COLUMN = ύϥϝʔλ
    νϟʔτʹඞཁͳσʔλͷΈूܭͯ͠ฦ͢
    αΠζ͕େ͖͍ςʔϒϧͷμογϡϘʔυ
    

    View Slide

14. &%'ʹΑΔखॱͱ੒Ռ෺ͷڞ༗
    

    View Slide

15. ΠϯαΠτϖʔδ͔ΒφϨοδΛ୳͢
    

    View Slide

16. σʔλΧλϩά
    

    View Slide

17. - ྑ͔ͬͨ఺
    - ಋೖ͕؆୯ʢDockerΠϝʔδΛىಈ͢Δ͚ͩʣ
    - SQL Server͕ར༻Ͱ͖Δ
    - ύϒϦογϡ͞Εͨ΋ͷΛViewerϥΠηϯε͕ແͯ͘΋ࢀর͢Δ͜ͱ͕Ͱ͖Δ
    - ͞ΒʹਐԽͯ͠΄͍͠఺
    - μογϡϘʔυͷσʔλΛνϟʔτຖʹCSVͰμ΢ϯϩʔυ͢Δ
    - ύϒϦογϡͨ͠΋ͷͷڞಉฤूʢίϥϘϨʔγϣϯʣػೳ
    - ಈతύϥϝʔλ
    Other points
    

    View Slide

18. Thank you
    

    View Slide