Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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

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

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

Ikuya Murasato

May 29, 2020
Tweet

More Decks by Ikuya Murasato

Other Decks in Business

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