ã¨ã³ã¸ãã¢ãããã¼ã¿åæã«ãªã£ã¦3ã¶æãçµã£ã
ããã¯ããã®1ãããªã³ã Advent Calendar 2015ã®21æ¥ç®ã®è¨äºã§ãã åæ¥ã¯ãå¥è¯éªããã®ç ä¿®ã§æ°è¦ã²ã¼ã ã¢ããªãã¢ãã«ã¨ãã¥ã¼ã«åãã¦ä½ã£ããè²ã ãããæã£ã話ã§ããããã®2ãããªã³ã Advent Calendar 2015ããããããé¡ããã¾ãã
ç§ã¯ã2015å¹´10æããããããã¤ãã£ãã²ã¼ã ã§ãã¼ã¿åæãæ
å½ãã¦ãã¾ãã
2015å¹´10æã¾ã§ã¯ãåããã¤ãã£ãã²ã¼ã ã§ã¨ã³ã¸ãã¢ãæ
å½ãã¦ãã¾ããã
æ¬è¨äºã¯ãç§ãã¨ã³ã¸ãã¢ãããã¼ã¿åæã¸ã¨å½¹å²ãå¤ããäºã«ãã£ã¦å¾ãçµé¨ãå ã«ããã¼ã¿åæãä½ãç®çã¨ãã¦ã©ããªäºãããå½¹å²ãªã®ãèªåãªãã«èããäºã説æãããã®ã§ãã
ç¾å¨ã¨ã³ã¸ãã¢ããã¦ãã¦ããã¼ã¿åæããã£ã¦ã¿ãããã¨æã£ã¦ãã人ããããã¼ã¿åæã£ã¦ä½ãããä»äºãªã®ãã¨æã£ã¦ãã人ã«ã¨ã£ã¦ãä¸ã¤ã®äºä¾ã¨ãã¦åèã«ãã¦ããããã°å¹¸ãã§ãã
ãªãä»åã®è¨äºã§ã¯ãå¼ç¤¾å ã§ã®å ·ä½çãªåæã®äºä¾ã¯è§¦ãã¦ããã¾ããã ã¾ããããã«æ¸ããå 容ã¯ãåæãã¼ã ã«æå±ãã¦ã¾ã ã¾ã æ¥ãæµ ãç§å人ã®èãã§ãããçµç¹ã®èãæ¹ã代表ãããã®ã§ã¯å ¨ãããã¾ããã
ãã¼ã¿åæã¯ã©ã®ãããªå½¢ã§ãã¼ã ã«è²¢ç®ã§ããã?
æåã«ããã¼ã¿åæã¯ã©ã®ãããªå½¢ã§ãã¼ã ã«è²¢ç®ã§ããã®ã? ã¨ããäºã«ã¤ãã¦ç§ãèããäºã説æãããã¨æãã¾ãã
åæ
ç§ãã¡ã®ååã¯ä½ã?
ãã¤ãã£ãã²ã¼ã ã®éçºãã¼ã ããã客æ§ã«æä¾ãã¦ãããååãã¨ã¯ä¸ä½ãªã®ã§ãããã?
ç§ã¯ã客æ§ãå¾ãä½æ
ã ã¨èãã¦ãã¾ãã
- ãæµããã®ãªã®ãªã®ã¨ããã¾ã§è¿½ãè©°ããªããããã¨1æ©ã®ã¨ããã§è² ãã¦ãã¾ã£ã
ãã®æãã
ã - ãã©ããã¦ã欲ããã£ããã®ä¸æããã¤ãã«ã¬ãã£ããå¼ãå½ã¦ã
ãã®è奮
ã
ãããã£ããä½æããããååã§ãããã²ã¼ã ã¯ãããå±ããããã®åªä»ã§ãã
æ¬å½ã®ååã¯ã²ã¼ã ããã¬ã¤ããã客æ§ã®é ã®ä¸ã§çã¾ãã¦ãã
ã¨ç§ã¯èãã¦ãã¾ãã
ãã¼ã¿ã¨ã¯ä½ãªã®ã?
ãç§ãã¡ãæä¾ãã¦ããååã¯ä½æã§ãããã¨ããåæã«ç«ã£ãæã
ãã¼ã¿
ãã¾ããã¼ã¿åæ
ã¯ã©ã®ãããªæå³ãæã¤ã§ãããã?
ãªããããã§è¨ã£ã¦ãããã¼ã¿ã¨ã¯ãæ¥ã ã客æ§ã®è¡åããçã¾ãããã©ã³ã¶ã¯ã·ã§ã³ãã¼ã¿(ã¦ã¼ã¶ã¼ãã¼ã¿)ã®äºãæãã¦ãã¾ãã
ãã¼ã¿ã¯ã客æ§ã®ä»è
ãã¼ã¿ã¨ã¯ã客æ§ã示ã"ä»è"ã§ãã
ã¨ç§ã¯èãã¦ãã¾ãã
ã¨ã¦ããã£ããããä¾ã§ããããã²ã¼ã ããã®é¢è±ãã¨ããè¡åãèµ·ãããã客æ§ã¯ããããããè¯ãä½æãå¾ã¦ããªãã£ããã®ã§ãããã
ãã£ã¨ç´°ããè¡åã観å¯ããã°ããã精緻ã«ã客æ§ãã©ããªä½æãå¾ãã®ã
æ¨æ¸¬ããäºãã§ãã¾ãã
ãã客æ§ãæããäºãæ¨æ¸¬ã§ããå
·ä½çãªç¾è±¡ã®è¨é²ãããã¼ã¿ã§ãã
ããã¯ã客æ§ã®ä»è
ã¨è¨ãæãããã¨ãåºæ¥ãã¨æãã¾ãã
ãã¼ã¿ã¯ã客æ§ã®å½±
ãã¤ãã£ãã²ã¼ã ã¯æã«è¨å¤§ãªæ°ã®ã客æ§ã«éãã§é ãã¾ããæ°ç¾ä¸ããããã¯ãã£ã¨æ²¢å±±ã®ãã¦ã³ãã¼ããè¨é²ãã¦ããã¢ããªãä¸ã«ã¯ããã¾ãã
ãã®ãããªè¨å¤§ãªæ°ã®ã客æ§ããã²ã¼ã å ã§æ¯ç§æ¯ç§ãæ§ã ãªè¡åãåãã¾ãã ãã®å ¨ã¦ãææ¡ããäºã¯ã人éã®èªèè½åã®éçãè¶ ãã¦ãã¾ãã
ããã§ãã¼ã¿ãå½¹ã«ç«ã¡ã¾ãã
ä¾ãã°ãã½ã¼ã·ã£ã«ã²ã¼ã ã®KPIã¨ãã¦ç¹ã«æåã§ããDAU
*1ã§ããã°ããã²ã¼ã ã«ã¢ã¯ã»ã¹ãããã¨ããä»èã示ããã客æ§ã®æ°ãåããã¾ãã
KPIã¯ãç¹å®ã®è¦ç¹ã®ã¿ãæ®ãããã®ä»ã®æ
å ±ãåãè½ã¨ãããæ
å ±ã§ãããå
¨ä½ã俯ç°ãã¦ãã¾ãã
ããã¯ãå½±
ã¨è¨ãæããäºãã§ããã¨æãã¾ãã
å¥ã®è¨ãæ¹ãããã¨ãææ¡ããããªãå
¨ä½åã«å¯¾ãã¦ãããé¢æ°ãé©ç¨ãã¦æ¬¡å
ãè½ã¨ããåå
ããã¼ã¿ã ã¨è¨ããããç¥ãã¾ããã
å½¹å²
ãã¦ãåè¿°ã®åæã«ãã£ãã¨ãããã¼ã¿åæããã¼ã ã§ã©ã®ãããªå½¹å²ãæããããã®ãã«ã¤ãã¦èããè¿°ã¹ããã¨æãã¾ãã
ä½ãããã£ãç©ãä½ããã®ãç¥ã
æ¬è¨äºã§ã¯ãã¤ãã£ãã²ã¼ã éçºãã¼ã ã®ååã¯ä½æ
ã ã¨ããåæãç½®ãã¾ããã
ä½æã¯ã客æ§ã®é ã®ä¸ã§çºçãã¾ãã
ç§ãã¡ãä½ããã®æ½çãå®æ½ããæãä½ãããã£ãä½æãä½ãããã©ãã? ã¯ã²ã¼ã ã ããè¦ã¦ãåããã¾ãããã客æ§ã®ä»èã観å¯ããä½æãæ¨æ¸¬ããã¯ããã¦æ¨æ¸¬ããäºãã§ãã¾ãããã®ãããªæã«ãã¼ã¿åæã¯å½¹ç«ã¡ã¾ãã
åé¡ãçºè¦ãã
ããä½ã®KPIãç¡ããã°ãè¨å¤§ãªæ°ã®ã客æ§ã«å¯¾ãã¦ãã®å ¨å¡ã®ååãææ¡ããäºã¯åºæ¥ã¾ããã
å
¨ä½åã俯ç°ããããè¦ç¹
ã§ããKPIãè¨å®ãããããå®å¸¸çã«è¦³å¯ããäºã§ãå
¨ä½ã®ã©ããã«ç°å¸¸ãèµ·ããæã«æ°ã¥ãäºãåºæ¥ã¾ãã
åé¡ããã解ããããå½¢ã«å¤æãã
è¨äºã®æ¬è«ã¨ããã¦ãã¾ãå½¢ã®å¼ç¨ã§ããæ縮ã§ããããã®è¨äºã«æ²è¼ããã¦ãããã¼ã¿åæã®äºä¾ãã¨ã¦ãè¯ãã£ãã®ã§å¼ç¨ããã¦ããã ãã¾ãã
ãç´è¿3ã¶æã®å£²ãä¸ããä¸ãã£ã¦ãããã¨ããåé¡æèã¯ãåºçºç¹ã¨ãã¦æã¾ããã§ããã ãç´è¿3ã¶æã®å£²ãä¸ããä¸ãã£ã¦ãããã©ããããè¯ãã?ãã¨ããåé¡è¨å®ã®ã¾ã¾ã§ã¯æ¼ ç¶ã¨ãã¦ãã¦è§£ãã®ãå°é£ã§ãããã®åã«ãã®ã¾ã¾çãããã¨ããã°ãçã§é å¼µããã¨è¨ã£ãæ¼ ç¶ã¨ãã解ããå¾ãããªãã§ãããã
ãã®äºä¾ã§ã¯ãåé¡ã®åå ã¨ãªã£ã¦ããäºè±¡ãçºè¦ããäºã§ã以ä¸ã®ããã«åé¡ãå¤æ
ãã¦ããã¨è§£éãã¾ããã
- å¤æå:ãç´è¿3ã¶æã®å£²ãä¸ããä¸ãã£ã¦ãããã©ããããè¯ãã?ã
- å¤æå¾: ã
ï¼ã¶æåãªã¼ãã³ããç¼ãé³¥åºãä¸å¿ã«ç«¶åãå¢ãã1次ä¼ã®å©ç¨ãæ¸ã£ã¦ãããã
ãç´è¿3ã¶æã®å£²ãä¸ããä¸ãã£ã¦ãããã©ããããè¯ãã?ã
å¤æå¾ã®åé¡è¨å®ã®æ¹ããã£ã¨å ·ä½çã§æå¹ãªè§£ãå°ããã¨æãã¾ãã
ãã¢ã³ã³ã³ããã¼ã©ãã«ãªå¤æ°ã«å¯¾ãã¦éæ¥çã«ä»å
¥ã§ãããã³ã³ããã¼ã©ãã«ãªå¤æ°ãè¦ã¤ãã
ãã¨è¨ãæãããã¨ãåºæ¥ãããç¥ãã¾ããã
å¾ãããç¥è¦ã貫éããã
ããã¼ã¿åæãã¨ããå½¹å²ã¯ãããæå³ã§ã¨ã¦ããå¼±ãã§ãã
ãã¼ã¿åæã§å¾ãããç¥è¦ã¯ãç解ããæ´»ç¨ãããã客æ§ã®å
ã«å±ããªãéã価å¤ãç¡ãããã§ãã
ææãåºããã©ããããã
ãã©ã³ãã¼ ãã¨ã³ã¸ãã¢ããã¶ã¤ãã¼ãªã©ä»ã®å°é家
ã«ç解ãã¦è²°ãããã©ãããä¿¡é ¼ãã¦è²°ãããã©ãããã«å¼·ãä¾åããå½¹å²ã§ããã¨è¨ãã¾ãã
ããã§ããããä»ã®å°é家ã®æ¹ã ã«ããã¼ã¿åæã«ã¤ãã¦è¯ãç解ãã¦ããã ããä¸å°ãä½ãäºãå¿ è¦ã ã¨èãã¦ãã¾ãã
ãã®ããã«ããã¼ã¿åæã«ã¤ãã¦ãã¼ã ã¡ã³ãã¼å ¨å¡ã«ãã詳ãããªã£ã¦è²°ãããããªæ´»åãè¡ã£ãããããã¨ã§ããã®ãããªä¸å°ã®å½¢æã«ç¹ããã¨èãã¦ãã¾ãã
ææã¯çµç¹ã®å¤
ã«ããããã¾ããã価å¤ãçµç¹ã®å¤ã¾ã§è²«éãããªããã°ãªãã¾ããã
ãã¼ã¿åæã®éå ·
ãã使ããã¦ããè¨èª
ãã¼ã¿åæã§ã¯ã©ã®ããããã°ã©ãã³ã°è¨èªã使ããã¦ããã§ãããã?
R
,Python
,SQL
, AWK
...è²ã
ããã¨æãã¾ããã
SQLã®
table
ããRã®data.frame
ã®ãããªè¡¨ã«è¿ãå½¢å¼ã®ãã¼ã¿æ§é ãæ±ãã¦ãSQLãã®ãã®ããRã®
dplyr
ã®ãããªãã¼ã¿ã«å¯¾ãã¦ã¯ã¨ãªãçºå¹ã§ããæ©è½ãæã£ãã
è¨èªã使ãããã±ã¼ã¹ãå¤ãããã«æãã¾ãã
ã¾ããRã®ggolot2
ã®ããã«ãã¼ã¿ãã°ã©ãã¨ãã¦ããããããæ©è½ã使ããã¨ãåºæ¥ãäºã®ç¨®é¡ããã£ã¨å¢ãã¾ãã
ãã£ããã¢ãã
ããã°ã©ãã³ã°è¨èªã®ç¿å¾æ¹æ³ã¨ãã¦ãä½ãæé ãªãµã¤ãºã®ããã°ã©ã ãçµãã§è¦ããã¨ããæ¹æ³ãããã¾ãããã¼ã¿åæã«ã¤ãã¦ãä½ãæé ãªåæããã¦ã¿ãã¨æªç¥ã®è¨èªã®ä½¿ãæ¹ãå¹ççã«å¦ç¿ã§ããã¨æãã¾ããkaggleã®ãã¥ã¼ããªã¢ã«èª²é¡ãªã©ããå§ãã§ãã
ãå§ãã®æ¸ç±
æå¾ã«ããã¼ã¿åæãè¡ã£ã¦ã¿ããã¨èãã¦ããæ¹ã«ãå§ãã®æ¸ç±ãç´¹ä»ãã¾ãã
ãã®æ¬ã¯ããã¼ã¿åæã®åå¦è ã«å¯¾ãã¦ããã¼ã¿åæã«ã¤ãã¦ã¨ã¦ãåºãè¦éã§è§£èª¬ãã¦ãããæ¬ã§ãã
åæã®ç®çãã©ã®ããã«è¨å®ãã¹ãã
ãåæã®çµæãã©ã®ããã«è£½åã«åæ ããã
ã¨ããåå¾ã®å·¥ç¨ãå«ãã¦è§£èª¬ãã¦ããã¦ããã¨ã¨ãã«ãåæãã®ç©ã«ã¤ãã¦ã®èãæ¹ã解説ãã¦ãããæ¬ã§å¤§å¤åèã«ãªãã¾ããã
ã¾ã¨ã
- ãã¤ãã£ãã¢ããªéçºãã¼ã ãä½ã£ã¦ããã®ã¯ã
ä½æ
ã¨ããååã§ãã ä½æ
ã¯ã客æ§ã®é ã®ä¸ã§çºçãã¦ãã¦ç´æ¥ç¥ã£ããæä½ãããããäºã¯åºæ¥ã¾ããã- ãã¼ã¿ã¯
ã客æ§ã®ä»è
ã§ããã客æ§ã®å½±
ã§ãã - ãã¼ã¿ãåæãããã¨ã§ãã客æ§ã®ä½æãæ¨æ¸¬ããããåé¡ããã解ããããå½¢ã«å¤æãããããäºãåºæ¥ã¾ãã
- ãã¼ã¿åæãéãã¦å¾ãããç¥è¦ã¯ã使ãããªããã°ä½ã®ä¾¡å¤ãçã¿ã¾ããã
- kaggleã¯ãã¼ã¿åæã®ããã®ããã°ã©ãã³ã°è¨èªç¿å¾ã®ç·´ç¿ã¨ãã¦é©ãã¦ãã¾ãã
- ããã¼ã¿è§£æã®å®åããã»ã¹å ¥éãããããã§ãã
以ä¸ã§ããä½ãã®åèã«ãªãã°å¹¸ãã§ãã
ããã®1ãããªã³ã Advent Calendar 2015ã®22æ¥ç®ã¯
Fuya
ããã®è¨äºã§ãã
*1:Daily Active Users: ããä¸æ¥ã®å ã«ã¢ã¯ãã£ãã«ãªã£ãã客æ§ã®æ°ããªã«ããã£ã¦ã¢ã¯ãã£ãã«ãªã£ãã¨èãããã«ã¯ããã¤ãã®èãæ¹ãããã¾ãããããã§ã¯åã«ã²ã¼ã ãèµ·åãã¦ãã ãã£ãæ¹ã®äººæ°ã¨ãã¾ãã