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

DeNAゲームタイトルの共通分析におけるLooker活用事例

DeNA_Tech
September 02, 2020

 DeNAゲームタイトルの共通分析におけるLooker活用事例

DeNAではこれまで内製BIツールが広く利活用されていましたが、この度Looker利用へと舵を切り、現在その移行途中です。今回は、内製BIツールが抱えていた課題、及びLookerへ移行する際に見えた課題を、技術的にどのように解決したかをお話します。

DeNA_Tech

September 02, 2020
Tweet

More Decks by DeNA_Tech

Other Decks in Technology

Transcript

  1. 6SHDNHU  ‡ ఍♫ ᰴᘧ఍♫䝕䜱䞊䞉䜶䝚䞉䜶䞊 ‡ ᡤᒓ 䝅䝇䝔䝮ᮏ㒊ศᯒ᥎㐍㒊䝕䞊䝍䜶䞁䝆䝙䜰䝸䞁䜾䜾䝹䞊䝥 ‡ ኚ㑄

    ‡ ᖺ᭶ࠥ<DKRR-DSDQ᪂༞ධ♫ ෆ〇䜰䝘䝸䝔䜱䜽䝇䝒䞊䝹䛾䝞䝑䜽䜶䞁䝗䜶䞁䝆䝙䜰 +DGRRS䜔7HUDGDWD䛺䛹䛾㞟ィ䝟䜲䝥䝷䜲䞁㛤Ⓨ ‡ ᖺ᭶ࠥ'H1$୰㏵ධ♫ +DGRRS9HUWLFD%LJ4XHU\䛺䛹౑䛳䛶䝀䞊䝮ඹ㏻㞟ィ ྛ✀㞟ィ䝟䜲䝥䝷䜲䞁ᩚഛ➼ /RRNHU䜢ά⏝䛧䛯ḟୡ௦䝕䞊䝍䝟䜲䝥䝷䜲䞁ᩚഛ 㕥ᮌᬒ἞ 䠄䝇䝈䜻䜿䜲䝆䠅
  2. 6SHDNHU  ‡ ఍♫ ᰴᘧ఍♫䝕䜱䞊䞉䜶䝚䞉䜶䞊 ‡ ᡤᒓ 䝀䞊䝮䞉䜶䞁䝍䞊䝔䜲䞁䝯䞁䝖஦ᴗᮏ㒊䝀䞊䝮஦ᴗ㒊䝬䞊䜿䝔䜱䞁䜾 ⤫ᣓ㒊ศᯒ㒊➨୍䜾䝹䞊䝥 ‡

    ኚ㑄 ‡ ᖺ᭶ࠥᰴᘧ఍♫䝕䜱䞊䞉䜶䝚䞉䜶䞊᪂༞ධ♫ 䝇䝬䞊䝖䝣䜷䞁䝀䞊䝮䛾䝃䞊䝞䝃䜲䝗䜶䞁䝆䝙䜰䜢⤒䛶ศᯒ㒊 䛻␗ື ‡ ⌧ᅾ䛿䜾䝹䞊䝥䝸䞊䝎䞊䛸䛧䛶㒊⨫ᶓ᩿᪋⟇䛾᥎㐍䜔䚸⤌⧊ స䜚䛻ᚑ஦ ‡ /RRNHUᑟධ䛻䛚䛔䛶䛿䚸䜰䝘䝸䝇䝖䝏䞊䝮䜢⋡䛔䛶/RRN0/㛤 Ⓨ䜔'HY6WGྥ䛡Ꮫ⩦䝁䞁䝔䞁䝒䛾ᣑ඘䜢᥎㐍 ฟཱྀ⿱ᕫ 䠄䝕䜾䝏䝠䝻䜻䠅
  3. 䜰䝆䜵䞁䝎  䝀䞊䝮ඹ㏻ศᯒ䛻฼⏝䛧䛶䛔䜛ෆ〇%,䝒䞊䝹䛾/RRNHU䜈䛾⛣⾜஦౛  ᪤Ꮡ䛾䝀䞊䝮䝍䜲䝖䝹ඹ㏻ศᯒ⎔ቃ䛾ᵓᡂ  ᪤Ꮡᵓᡂ䛸ㄢ㢟  /RRNHU䜢ᑟධ䛧䛯ゎỴ⟇ 

    3URMHFW䜲䞁䝫䞊䝖䛻䜘䜛ඹ㏻ᐃ⩏䝎䝑䝅䝳䝪䞊䝗᱌  3URMHFW䜲䞁䝫䞊䝖䛾✀㢮䛸᥇⏝䛧䛯᪉ᘧ  /RRN0/'DVKERDUG䛾ά⏝  䝕䞊䝍䝬䞊䝖୙ᅾ᫬䛾/RRN0/㛤Ⓨ  ᪤Ꮡ䝔䞊䝤䝹䜢YLHZ໬䛧䛯ᵓᡂ䛸䛭䛾ㄢ㢟  NSLẖ䛾YLHZ໬䛻䜘䜛ゎỴᡭἲ 
  4. 䝀䞊䝮䝍䜲䝖䝹ඹ㏻㞟ィ䛾ὶ䜜 䝀䞊䝮ඹ㏻ᇶ┙䛛䜙ศᯒ⏝䝕䞊䝍 䝻䜾䚸'%6QDS6KRW 䜢&ORXG6WRUDJH䛻⵳✚ %LJ4XHU\䛻䛶䝍䜲䝖䝹㛫ඹ㏻䛾ᙧᘧ䛻䝕䞊䝍䜢ຍᕤ ඹ㏻㞟ィ 䛧䛶䛔䜛  䝀䞊䝮䝥䝷䝑䝖 䝣䜷䞊䝮䝻䜾

    䝀䞊䝮䝥䝷䝑䝖 䝣䜷䞊䝮'% 䝍䜲䝖䝹$ 䝍䜲䝖䝹% 䝍䜲䝖䝹& 䝀䞊䝮 ඹ㏻ᇶ┙ ඹ㏻㞟ィ 䝍䜲䝖䝹$ 䝍䜲䝖䝹% 䝍䜲䝖䝹& 䝍䜲䝖䝹$3URMHFW 䝍䜲䝖䝹%3URMHFW 䝍䜲䝖䝹&3URMHFW 䝍䜲䝖䝹&䜾䝹䞊䝥 ෆ〇%,䝒䞊䝹 䝍䜲䝖䝹%䜾䝹䞊䝥 䝍䜲䝖䝹$䜾䝹䞊䝥 䜰䝘䝸䝇䝖Į 䜰䝘䝸䝇䝖ȕ
  5. 䝍䜲䝖䝹ศᯒ⎔ቃ䜈䛾ඹ㏻㞟ィ䝕䞊䝍䛾ᥦ౪ ඹ㏻㞟ィ䛧䛯䝔䞊䝤䝹䛿䚸ྛ䝍䜲䝖䝹䛷ศᯒ฼⏝䛩䜛%LJ4XHU\䛻ศ๭ᥦ౪䛧䛶䛔䜛 ෆ〇%,䝒䞊䝹䛿3URMHFW䛸䛔䛖༢఩䛷䝍䜲䝖䝹ẖ䛻タ䛡䜙䜜䚸3URMHFW༢఩䛷*RRJOH*URXS䛷ᶒ 㝈ไᚚ䛥䜜䛯⎔ቃ䛾୰฼⏝䛥䜜䛶䛔䜛  䝀䞊䝮䝥䝷䝑䝖 䝣䜷䞊䝮䝻䜾 䝀䞊䝮䝥䝷䝑䝖 䝣䜷䞊䝮'% 䝍䜲䝖䝹$

    䝍䜲䝖䝹% 䝍䜲䝖䝹& 䝀䞊䝮 ඹ㏻ᇶ┙ ඹ㏻㞟ィ 䝍䜲䝖䝹$ 䝍䜲䝖䝹% 䝍䜲䝖䝹& 䝍䜲䝖䝹$3URMHFW 䝍䜲䝖䝹%3URMHFW 䝍䜲䝖䝹&3URMHFW 䝍䜲䝖䝹&䜾䝹䞊䝥 ෆ〇%,䝒䞊䝹 䝍䜲䝖䝹%䜾䝹䞊䝥 䝍䜲䝖䝹$䜾䝹䞊䝥 䜰䝘䝸䝇䝖Į 䜰䝘䝸䝇䝖ȕ
  6. /RRN0/'DVKERDUG໬䛾㝿䛾ὀពⅬ  ᅛ᭷㡯┠䛿/RRN0/'DVKERDUG䝣䜯䜲䝹䛻グ㍕䛧䛺䛔䛣䛸 PRGHOྡ䛿/RRN0/'DVKERDUGᐃ⩏ྲྀᚓ᫬䛻᭩䛔䛶䛒䜛䛾䛷ᚲ䛪ᾘ䛩 ௚䛻䜒⥅ᢎඛ䛻䜘䜚␗䛺䜛್䜢᥇⏝䛧䛯䛔䜒䛾䠄䝍䜲䝖䝹ྡ䜔䝸䝸䞊䝇᪥䛺䛹䠅䛿๐㝖䜔䝕䝣䜷䝹䝖 ್䛻䛩䜛ᚲせ䛜䛒䜛  GDVKERDUGNSLKRXUO\ WLWOHᇶᮏ.3, +RXUO\

    OD\RXWQHZVSDSHU HOHPHQWV WLWOH⣼✚$5338 ᾘ㈝ QDPH⣼✚$5338 ᾘ㈝ PRGHOGHQDVJEDVH H[SORUHDUSSXBKRXUO\ W\SHWDEOH ILHOGV>DUSSXBKRXUO\KRXUDUSSXBKRXUO\GDWH DUSSXBKRXUO\DFFXPBDUSSX@ SLYRWV>DUSSXBKRXUO\GDWH@ GDVKERDUGNSLKRXUO\ WLWOHᇶᮏ.3, +RXUO\ OD\RXWQHZVSDSHU HOHPHQWV WLWOH⣼✚$5338 ᾘ㈝ QDPH⣼✚$5338 ᾘ㈝ H[SORUHDUSSXBKRXUO\ W\SHWDEOH ILHOGV>DUSSXBKRXUO\KRXUDUSSXBKRXUO\GDWH DUSSXBKRXUO\DFFXPBDUSSX@ SLYRWV>DUSSXBKRXUO\GDWH@
  7. 䝃䝬䝸䞊䝔䞊䝤䝹 䝀䞊䝮஦ᴗ䛾䝕䞊䝍ᇶ┙ᵓᡂ 䛚䛥䜙䛔ྵ䜐 ‡ 䝕䞊䝍䝺䜲䜽䛻*&6䚸䝕䞊䝍䜴䜵䜰䝝䜴䝇䛻%LJ4XHU\䜢᥇⏝ ‡ .3,䜢㞟ィ䛧䜔䛩䛟䛩䜛┠ⓗ䛾䝃䝬䝸䝔䞊䝤䝹䛜Ꮡᅾ ‡ 䛯䛰䛧䚸ྛ✀.3,⏝㏵ '$8䚸188䚸$538HWF

    䛻≉໬䛧䛯䝕䞊䝍䝬䞊䝖䛿↓䛧 䝀䞊䝮㛵㐃䝻䜾䜢 䜂䛯䛩䜙᱁⣡ ຍᕤ䞉㞟ィ WUDQVDFWLRQ BVXPPDU\ GDXBVXPPDU\ 䜰䜽䝉䝇㛵㐃䝔䞊䝤䝹 ኎ୖ㛵㐃䝔䞊䝤䝹 
  8. ‡ ึᮇᑟධ䛾ẁ㝵䛷䛿䚸%4䛾䝔䞊䝤䝹 YLHZ䛻ᑐᛂ䛥䛫䛶YLHZ䜢సᡂ /RRNHUึᮇᑟධ᫬䛾/RRN0/ᵓᡂ GDXBVXPPDU\YLHZ PHDVXUHGDX^` WUDQVDFWLRQBVXP PDU\ GDXBVXPPDU\ WUDQVDFWLRQBVXPPDU

    \YLHZ PHDVXUHㄢ㔠㢠 ^` %LJ4XHU\ /RRNHU YLHZ /RRNHU H[SORUH H[SORUHGDXBVXPPDU\^ MRLQWUDQVDFWLRQBVXPPDU\^` ` 䜰䜽䝉䝇㛵㐃䝔䞊䝤䝹 ኎ୖ㛵㐃䝔䞊䝤䝹 䝔䞊䝤䝹䛻䛴䛝䚸 YLHZ䛜స䜙䜜䜛 
  9. ‡ 」ᩘYLHZ䜢䜎䛯䛠ᣦᶆ䜢䛹䛣䛻᭩䛡䜀䜘䛔䛾䛛䜟䛛䜙䜣ၥ㢟 䝔䞊䝤䝹䛸YLHZ䜢ᑐᑐᛂ䛻䛧䛯஦䛻䜘䜛ㄢ㢟䐟 GDXBVXPPDU\YLHZ PHDVXUHGDX^` WUDQVDFWLRQBVXP PDU\ GDXBVXPPDU\ WUDQVDFWLRQBVXPPDU \YLHZ

    PHDVXUHㄢ㔠㢠 ^` %LJ4XHU\ /RRNHU YLHZ PHDVXUH$538^ VTOㄢ㔠㢠'$8 ` " " $538 ኎ୖ'$8 䛿䚸䛹䛱䜙䛾 YLHZ䛻᭩䛛䜜䜛䜉䛝䠛䠛 
  10. ‡ ୓⬟YLHZH[SORUH䛜⏕䜎䜜䛶䛧䜎䛖ၥ㢟 䝔䞊䝤䝹䛸YLHZ䜢ᑐᑐᛂ䛻䛧䛯஦䛻䜘䜛ㄢ㢟䐠 GDXBVXPPDU\YLHZ PHDVXUHGDX^` PHDVXUHDUSX^` PHDVXUHQXX^` WUDQVDFWLRQBVXP PDU\ GDXBVXPPDU\

    WUDQVDFWLRQBVXPPDU \YLHZ PHDVXUHㄢ㔠㢠 ^` %LJ4XHU\ /RRNHU YLHZ /RRNHU H[SORUH H[SORUHGDXBVXPPDU\^ MRLQWUDQVDFWLRQBVXPPDU\^` MRLQ┠ᶆ್⟶⌮䝔䞊䝤䝹^` MRLQ ` '$8䜒$538䜒188䜒䛬䞊䜣䜆 䛣䛣䛷䛔䛔䜘䛽䠛䠛 䛣䛾H[SORUH䛾ᙺ๭䛳䛶䛺䜣䛰䛳 䛡" ᚲせ䛺䝔䞊䝤䝹䛜䝗䞁䝗䞁 MRLQ䛥 䜜䛶䛔䛳䛶䜛䛡䛹኱୔ኵ" 
  11. .3,䛤䛸䛻YLHZH[SORUH䜢ᑐᛂ䛥䛫䜛䛣䛸䛷ゎỴ EDVHGDXBVXPPDU\ YLHZ GLPHQVLRQXVHUBLG WUDQVDFWLRQBVXP PDU\ GDXBVXPPDU\ EDVHWUDQVDFWLRQBVX PPDU\YLHZ GLPHQVLRQXVHUBLG

    %LJ4XHU\ /RRNHU YLHZ DUSXYLHZ LQFOXGHEDVH YLHZ GHULYHGBWDEOH^` /RRNHU EDVHYLHZ /RRNHU PRGHO H[SORUHDUSX^ MRLQ┠ᶆ್⟶⌮䝔䞊䝤䝹^` ` YLHZ䛾䝺䜲䝲䞊䛻EDVH䛸䛔䛖㝵ᒙ䜢స䜚䚸䝔䞊 䝤䝹䛻ᑐᛂ䛥䛫䛯YLHZ䜢㓄⨨ GDXYLHZ LQFOXGHEDVH YLHZ PHDVXUHGDX H[SORUHGDX^ MRLQ┠ᶆ್⟶⌮䝔䞊䝤䝹^` ` 
  12. .3,䛤䛸䛻YLHZH[SORUH䜢ᑐᛂ䛥䛫䜛䛣䛸䛷ゎỴ EDVHGDXBVXPPDU\ YLHZ GLPHQVLRQXVHUBLG WUDQVDFWLRQBVXP PDU\ GDXBVXPPDU\ EDVHWUDQVDFWLRQBVX PPDU\YLHZ GLPHQVLRQXVHUBLG

    %LJ4XHU\ /RRNHU YLHZ DUSXYLHZ LQFOXGHEDVH YLHZ GHULYHGBWDEOH^` /RRNHU EDVHYLHZ /RRNHU PRGHO H[SORUHDUSX^ MRLQ┠ᶆ್⟶⌮䝔䞊䝤䝹^` ` GDXYLHZ LQFOXGHEDVH YLHZ PHDVXUHGDX H[SORUHGDX^ MRLQ┠ᶆ್⟶⌮䝔䞊䝤䝹^` ` 䞉EDVHYLHZ䛾LQFOXGH䜔GHULYHGBWDEOH䜢⏝䛔 䛶䚸㢮ఝ䛧䛯.3,⩌䜢୍䛴䛾YLHZෆ䛷ᐃ⩏䚹 㛤Ⓨ⪅䛿᪤Ꮡ䝔䞊䝤䝹䛻ᘬ䛝䛪䜙䜜䜛஦↓䛟ᐇ ⿦䛩䜛஦䛜ྍ⬟ 䞉.3,䛤䛸䛻㛤Ⓨ䝯䞁䝞䞊䜢ศ䛡䚸ᐇ⿦ศᢸ 
  13. .3,䛤䛸䛻YLHZH[SORUH䜢ᑐᛂ䛥䛫䜛䛣䛸䛷ゎỴ EDVHGDXBVXPPDU\ YLHZ GLPHQVLRQXVHUBLG WUDQVDFWLRQBVXP PDU\ GDXBVXPPDU\ EDVHWUDQVDFWLRQBVX PPDU\YLHZ GLPHQVLRQXVHUBLG

    %LJ4XHU\ /RRNHU YLHZ DUSXYLHZ LQFOXGHEDVH YLHZ GHULYHGBWDEOH^` /RRNHU EDVHYLHZ /RRNHU PRGHO H[SORUHDUSX^ MRLQ┠ᶆ್⟶⌮䝔䞊䝤䝹^` ` GDXYLHZ LQFOXGHEDVH YLHZ PHDVXUHGDX H[SORUHGDX^ MRLQ┠ᶆ್⟶⌮䝔䞊䝤䝹^` ` H[SORUH䜒.3,䛻ᑐᛂ䛩䜛஦䛷䚸 ᙺ๭䛜᫂☜䛸䛺䜛䚹 MRLQ䛿ᚲせ᭱ᑠ㝈䛻䚹 
  14. 䜎䛸䜑 ‡ 'H1$䛷䛿ෆ〇%,䝒䞊䝹䛛䜙/RRNHU䜈⛣⾜୰ ‡ 3URMHFW䜲䞁䝫䞊䝖 ‡ UHPRWHBGHSHQGHQF\ ‡ /RRN0/'DVKERDUG䛷䛾3URMHFW䜢䜎䛯䛔䛰ᒎ㛤 ‡

    /RRN0/㛤Ⓨ䛻䛚䛔䛶䛿䚸᪤Ꮡ䛾䝔䞊䝤䝹ᵓᡂ䛻ᘬ䛝ᦾ䜙䜜㐣䛞䛪䚸.3,ẖ䛻 YLHZH[SORUH䛾ษ䜚᪉䜢ᐃ⩏