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

Replacing Data Analysts with AI - Building Data...

Avatar for LINEヤフーTech (LY Corporation Tech) LINEヤフーTech (LY Corporation Tech) PRO
June 30, 2025
Technology
0
130

Replacing Data Analysts with AI - Building Data Pipelines and Automating Analysis with Generative AI

MCPサーバーを活用して、複雑だった多段階パイプラインのデータ分析ワークフローを革新する方法をご紹介します。単純にAIを利用してデータ分析を試みる際に失敗する原因を把握し、その解決策としてsemantic layeringをご紹介し、実際の実装戦略をデモンストレーションします。データアナリストの役割が消失するのではなく、どのように進化しているか、どのような能力が必要になるかについて議論いたします。

Avatar for LINEヤフーTech (LY Corporation Tech)

LINEヤフーTech (LY Corporation Tech) PRO

June 30, 2025
Tweet

More Decks by LINEヤフーTech (LY Corporation Tech)

See All by LINEヤフーTech (LY Corporation Tech)
マルチモーダル基盤モデルに基づく動画と音の解析技術
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
2
260
AI駆動開発 with MixLeap Study【大阪支部 #3】
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
0
270
Yahoo!しごとカタログ 新しい境地を創るエンジニア募集！
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
3
330
データグループにおけるフロントエンド開発
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
2
280
Yahoo!知恵袋におけるフロントエンド開発
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
0
270
"LINE Planet" and AI: Conversations with AI
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
0
58
Seamless inventory management with AI
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
0
34
AI Frontiers Revealed: Transforming LINE Shopping TW with LLM-Driven Product Attribute Extraction
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
0
56
LINEヤフーの音声AIがもたらす未来：ASR/TTSと対話技術の新たな可能性 / LY Corporation's Speech AI Vision: Towards Realtime Spoken Dialogue through Advanced ASR and TTS
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
0
63

Other Decks in Technology

See All in Technology
Kiroから考える AIコーディングツールの潮流
Avatar for Oikon s4yuba
1
350
ビジネス文書に特化した基盤モデル開発 / SaaSxML_Session_2
Avatar for Sansan R&D sansan_randd
0
130
CSPヘッダー導入で実現するWebサイトの多層防御：今すぐ試せる設定例と運用知見
Avatar for llamakko llamakko
1
270
隙間時間で爆速開発！ Claude Code × Vibe Coding で作るマニュアル自動生成サービス
Avatar for Akitomo Sato akitomonam
2
200
AI時代の知識創造 ─GeminiとSECIモデルで読み解く “暗黙知”と創造の境界線
Avatar for Yukinaga OISHI nyagasan
0
160
KCD Lima: eBee in Peru!
Avatar for Liz Rice lizrice
0
110
ファインディにおける Dataform ブランチ戦略
Avatar for Noriaki Hiraki hiracky16
0
210
Expertise as a Service via MCP
Avatar for Yoda Keisuke yodakeisuke
1
160
手動からの解放！！Strands Agents で実現する総合テスト自動化
Avatar for 井手亮太 ideaws
3
390
robocopy の怖い話/scary-story-about-robocopy
Avatar for emi emiki
0
400
Microsoft Learn MCP/Fabric データエージェント/Fabric MCP/Copilot Studio-簡単・便利なAIエージェント作ってみた -"Building Simple and Powerful AI Agents with Microsoft Learn MCP, Fabric Data Agent, Fabric MCP, and Copilot Studio"-
Avatar for 大竹礼二（REIJI OTAKE） reireireijinjin6
1
160
AIに全任せしないコーディングとマネジメント思考
Avatar for kichion kikuchikakeru
0
280

Featured

See All Featured
Music & Morning Musume
Avatar for Bryan Veloso bryan
46
6.7k
ピンチをチャンスに：未来をつくるプロダクトロードマップ #pmconf2020
Avatar for Aki / @LoveIdahoBurger aki_iinuma
126
53k
GraphQLの誤解/rethinking-graphql
Avatar for sonatard sonatard
71
11k
The Straight Up "How To Draw Better" Workshop
Avatar for Dennis Kardys denniskardys
235
140k
Code Review Best Practice
Avatar for Trisha Gee trishagee
69
19k
Performance Is Good for Brains [We Love Speed 2024]
Avatar for Tammy Everts tammyeverts
10
1k
Building Applications with DynamoDB
Avatar for Matt Wood mza
95
6.5k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
Avatar for mongodb mongodb
47
9.6k
ReactJS: Keep Simple. Everything can be a component!
Avatar for Pedro Nauck pedronauck
667
120k
Rails Girls Zürich Keynote
Avatar for Gregor Martynus gr2m
95
14k
Fantastic passwords and where to find them - at NoRuKo
Avatar for Phil Nash philnash
51
3.3k
The Pragmatic Product Professional
Avatar for Laura Van Doore lauravandoore
35
6.8k

Transcript

  1. 3FQMBDJOH%BUB"OBMZTU+PCTXJUI"* -*/& .-1SPEVDU4USBUFHZ .JOTFP1BSL 4IJOBF$IPJ

  2. 'BNJMJBS%BTICPBSE*OTJHIUT 5IFEBTICPBSETZPVDSFBUFFWFSZEBZ

  3. 1MPU5XJTU"*$SFBUFE5IJT • $SFBUFEXJUIBTJOHMFTJNQMFQSPNQU $SFBUFEWJB*OIPVTF.$14FSWFS 4BNFJOTJHIUT SFWPMVUJPOBSZBQQSPBDI • 5PPLNJOVUFTUPDSFBUF TBWJOHEBZTPGNFUSJDDSFBUJPO

  4. 5IF%BUB"OBMZTJT$IBMMFOHF $PNQMFYXPSLGMPXTXFBMMSFDPHOJ[F FWFOU@MPH TVCTDSJQUJPO@MPH VB@EBJMZ VTFS@TFHNFOUBUJPO NPEFM@DPTU LQJ@VTFS@DPVOU MPH@TVNNBSZ LQJ@GVODUJPO

    LQJ@TFTTJPO VTBHF@GMPX %BUBTPVSDF 0"4*4 *OIPVTF%BUB1MBUGPSN 7JTVBMJ[BUJPO &YDFM *OTJHIUEFSJWBUJPO 3FQPSUJOH 3FRVFTU

  5. 5IF.$14FSWFS1SPNJTF 'SPNDPNQMFYQJQFMJOFTUPOBUVSBMMBOHVBHF FWFOU@MPH TVCTDSJQUJPO@MPH %BUBTPVSDF *O)PVTF .$14FSWFS *OIPVTF%BUB1MBUGPSN 3FRVFTU --.

  6. 1BSU.$14FSWFST5IF$POUFYU1SPCMFN 1BSU5IF4FNBOUJD-BZFS4PMVUJPO 1BSU4PMVUJPOJO"DUJPO 1BSU8IBU`T/FYU 1BSU$MPTJOH5IPVHIUT GSPN 4FUVQ UP 4USBUFHZ 5IFSPBENBQ

    GPSJOUFHSBUJOH--.T JOUPZPVSEBUBXPSL

  7. 6OEFSTUBOEJOHUIFQPXFSBOEUIFDPOUFYUDIBMMFOHF .$14FSWFST5IF$POUFYU1SPCMFN

  8. *OUSPEVDJOH.$14FSWFST #SJEHJOH--.TBOEEBUBCBTFT 6TFS $MJFOU %PUIJT 8IBUJTUIJT --. 

  9. *OUSPEVDJOH.$14FSWFST #SJEHJOH--.TBOEEBUBCBTFT "OBMZ[FUIJT $SFBUFUIJT NFUSJD 6TFS $MJFOU %# %BUBCBTF 9

    --.

  10. *OUSPEVDJOH.$14FSWFST #SJEHJOH--.TBOEEBUBCBTFT "OBMZ[FUIJT $SFBUFUIJT NFUSJD 6TFS .$1$MJFOU %# %BUBCBTF --.

     .$14FSWFS .$14FSWFS

  11. "*1PXFSFE"OBMZTJT8PSLGMPX 'SPNOBUVSBMMBOHVBHFUPEBUBCBTFSFTVMUT 6TFS .$1$MJFOU .POHP%# .$1TFSWFS .POHP%# 3FRVFTUUBTL "OBMZ[FSFRVFTU %FDJEFPOUPPMTSFTPVSDFUPVTF

    $BMMUPPMPSSFRVFTUSFTPVSDFT &YFDVUFUPPMSFTPVSDF 4FOESFTVMU 4FOESFTVMU 'PSNBUBOEJOUFSQSFUSFTVMU 1SFTFOUGPSNBUUFESFTVMU

  12. #BTJD*NQMFNFOUBUJPO*TTVFT &YQFDUBUJPOTWTBDUVBMPVUDPNFT 6TFS &YQFDUBUJPO 8IBUJT UIFDIVSOSBUF GPSUIJTNPOUI &WFOU MPH 4VCTDSJQUJPO

    MPH Event log Subscription log "DUJWF VTFSTMBTUNPOUI *OBDUJWF 03$BODFMFE VTFST &YUSBDU BDUJWFVTFS EBUB &YUSBDU TVCTDSJQUJPO EBUB &YUSBDU BDUJWFVTFS EBUB "DUJWF VTFSTMBTUNPOUI *OBDUJWF VTFST "DUVBMPVUDPNF

  13. 5IF3PPU1SPCMFN 8IZCBTJD.$1TFSWFSTQSPEVDFXSPOHSFTVMUT #FDBVTFʜ

  14. • ʜVOEFSTUBOEXIBUUIFVTFSXBOUT • ʜDBOOPUNBQOBUVSBMMBOHVBHFUPRVFSJFT • ʜVOEFSTUBOEUIFCVTJOFTTDPOUFYU • ʜLOPXUIFEBUBTUSVDUVSF • ʜSFDPHOJ[FCVTJOFTTUFSNT

    • ʜ 5IF3PPU1SPCMFN 8IZCBTJD.$1TFSWFSTQSPEVDFXSPOHSFTVMUT #FDBVTF--.EPFTO`Uʜ

  15. • ʜVOEFSTUBOEXIBUUIFVTFSXBOUT • ʜDBOOPUNBQOBUVSBMMBOHVBHFUPRVFSJFT • ʜVOEFSTUBOEUIFCVTJOFTTDPOUFYU • ʜLOPXUIFEBUBTUSVDUVSF • ʜSFDPHOJ[FCVTJOFTTUFSNT

    • ʜ 5IF3PPU1SPCMFN.JTTJOH$POUFYU 8IZCBTJD.$1TFSWFSTQSPEVDFXSPOHSFTVMUT #FDBVTF--.EPFTO`Uʜ ˠ/0$0/5&95

  16. • ʜVOEFSTUBOEXIBUUIFVTFSXBOUT • ʜDBOOPUNBQOBUVSBMMBOHVBHFUPRVFSJFT • ʜVOEFSTUBOEUIFCVTJOFTTDPOUFYU • ʜLOPXUIFEBUBTUSVDUVSF • ʜSFDPHOJ[FCVTJOFTTUFSNT

    • ʜ 5IF3PPU1SPCMFN.JTTJOH$POUFYU 8IZCBTJD.$1TFSWFSTQSPEVDFXSPOHSFTVMUT #FDBVTF--.EPFTO`Uʜ • 1SPWJEFSFRVFTUJOUFSQSFUBUJPO • 1SPWJEFRVFSZNBQQJOH • 1SPWJEFCVTJOFTTDPOUFYUT • 1SPWJEFEBUBTDIFNBBOENFUBEBUB • 1SPWJEFEFGJOJUJPOTGPSCVTJOFTTUFSNT • ʜ 1SPWJEF--.XJUIDPOUFYUEBUB ˠ)"4$0/5&95

  17. 5ISFFBQQSPBDIFTUPBEECVTJOFTTJOUFMMJHFODFUP"* 5IF4FNBOUJD-BZFS4PMVUJPO

  18. • "OJOUFSNFEJBSZMBZFSUIBUUSBOTMBUFT OBUVSBMMBOHVBHFRVFTUJPOTJOUPQSFDJTF CVTJOFTTMPHJD *OUSPEVDJOHUIF4FNBOUJD-BZFS )PXUPBEECVTJOFTTJOUFMMJHFODFUP"*BOBMZTJT 8IBUJTTFNBOUJDMBZFSJOH /BUVSBMMBOHVBHFRVFTUJPO 1SFDJTFCVTJOFTTMPHJD •

    1SPWJEFTCVTJOFTTBOEEBUBDPOUFYUUPUIF NPEFM • "EETNFBOJOHDPOUFYUUPUIFSBXUPPMT BOESFTPVSDFTJO.$1 8IBUSPMFEPFTJUQMBZ 4FNBOUJD-BZFS $0/5&95ˠ

  19. • -*/&0GGJDJBM"DDPVOU • "O"*DIBUCPUUIBUVTFTPGGFSTWBSJPVT"* CBTFETFSWJDFT TVDIBTXFCTFBSDI  USBOTMBUJPO 0$3 BOENPSF

    • 6TFTGSFFNJVNCVTJOFTTNPEFM $BTF4UVEZ"*"TTJTUBOU4FSWJDF "GSFFNJVN-*/&"*DIBUCPU "*"TTJTUBOU

  20. %FGJOJOH#VTJOFTT$POUFYU 5FSNT NFUSJDT BOEEBUBSFMBUJPOTIJQT &YBNQMFDPOUFYUUZQF #VTJOFTTUFSNT

  21. • 'SJFOE6TFSUIBUIBTBEEFE"*"TTJTUBOUBTBGSJFOE • 'SFF6TFS6TFSUIBUIBTBHSFFEUPUIFUFSNTPGVTFPG"*"TTJTUBOU • %"6/VNCFSPGVOJRVFVTFSTUIBUIBWFBUMFBTUPOFFWFOUMPHUIBUJTOPUVOTVCTDSJCFBOE CMPDL %FGJOJOH#VTJOFTT$POUFYU 5FSNT NFUSJDT

    BOEEBUBSFMBUJPOTIJQT &YBNQMFDPOUFYUUZQF #VTJOFTTUFSNT

  22. • 'SJFOE6TFSUIBUIBTBEEFE"*"TTJTUBOUBTBGSJFOE • 'SFF6TFS6TFSUIBUIBTBHSFFEUPUIFUFSNTPGVTFPG"*"TTJTUBOU • %"6/VNCFSPGVOJRVFVTFSTUIBUIBWFBUMFBTUPOFFWFOUMPHUIBUJTOPUVOTVCTDSJCFBOE CMPDL %FGJOJOH#VTJOFTT$POUFYU 5FSNT NFUSJDT

    BOEEBUBSFMBUJPOTIJQT &YBNQMFDPOUFYUUZQF #VTJOFTTUFSNT &YBNQMFDPOUFYUUZQF r %BUBTDIFNB

  23. • 'SJFOE6TFSUIBUIBTBEEFE"*"TTJTUBOUBTBGSJFOE • 'SFF6TFS6TFSUIBUIBTBHSFFEUPUIFUFSNTPGVTFPG"*"TTJTUBOU • %"6/VNCFSPGVOJRVFVTFSTUIBUIBWFBUMFBTUPOFFWFOUMPHUIBUJTOPUVOTVCTDSJCFBOE CMPDL %FGJOJOH#VTJOFTT$POUFYU 5FSNT NFUSJDT

    BOEEBUBSFMBUJPOTIJQT &YBNQMFDPOUFYUUZQF #VTJOFTTUFSNT -- Users Table users ( user_id: VARCHAR, reg_date: DATE, status: CHAR(1), -- 'A'=Active, 'I'=Inactive msg_count: INTEGER ) &YBNQMFDPOUFYUUZQF r %BUBTDIFNB -- Events Table events ( event_id: VARCHAR, user_id: VARCHAR, date: DATE, type: CHAR(1) -- 'T'=Text, 'M'=Media, 'V'=Voice )

  24. 5ISFF4PMVUJPO"QQSPBDIFT $MJFOU TFSWFS BOEEBUBCBTFMFWFMTFNBOUJDJOUFHSBUJPO 6TFS .$1$MJFOU .POHP%# .$1TFSWFS .POHP%#

  25. 5ISFF4PMVUJPO"QQSPBDIFT $MJFOU TFSWFS BOEEBUBCBTFMFWFMTFNBOUJDJOUFHSBUJPO 6TFS .$1$MJFOU .POHP%# .$1TFSWFS .POHP%# $POUFYU

    4FNBOUJD -BZFSJOH 4FNBOUJD -BZFSJOH 4FNBOUJD -BZFSJOH

  26. $MJFOUMFWFM4FNBOUJD-BZFSJOH 4ZTUFNQSPNQUFOIBODFNFOUBQQSPBDI 4FNBOUJD -BZFSJOH 6TFS .$1$MJFOU .POHP%# .$1TFSWFS .POHP%#

  27. $MJFOUMFWFM4FNBOUJD-BZFSJOH 4ZTUFNQSPNQUFOIBODFNFOUBQQSPBDI 4FNBOUJD -BZFSJOH 6TFS .$1$MJFOU .POHP%# .$1TFSWFS .POHP%# 4ZTUFN1SPNQUT

  28. #BTJDWT&OIBODFE1SPNQUJOH You are a data assistant. Help users query the

    users and events tables. #BETZTUFNQSPNQU XP4FNBOUJD-BZFSJOH 5IFEJGGFSFODFDPOUFYUNBLFT

  29. #BTJDWT&OIBODFE1SPNQUJOH You are a messenger platform analyst with access to

    our messaging database. DATA SCHEMA: - users table: user_id, reg_date, status ('A'=Active, 'I'=Inactive), msg_count - events table: event_id, user_id, date, type ('T'=Text, 'M'=Media, 'V'=Voice) BUSINESS TERMS: • Friend: User that has added AI Assistant as a friend • Free User: User that has agreed to the terms of use of AI Assistant • DAU: Number of unique users that have at least one event log that is not unsubscribe and block Always translate technical codes into business terms and provide strategic insights. (PPETZTUFNQSPNQU X4FNBOUJD-BZFSJOH 5IFEJGGFSFODFDPOUFYUNBLF

  30. 4FSWFSMFWFM4FNBOUJD-BZFSJOH $POGJHVSBUJPOESJWFOBQQSPBDI 4FNBOUJD -BZFSJOH 6TFS .$1$MJFOU .POHP%# .$1TFSWFS .POHP%#

  31. 4FSWFSMFWFM4FNBOUJD-BZFSJOH $POGJHVSBUJPOESJWFOBQQSPBDI 4FNBOUJD -BZFSJOH 6TFS .$1$MJFOU .POHP%# .$1TFSWFS .POHP%# $POGJHVSBUJPOGJMFT

  32. :".-$POGJHVSBUJPO'JMFT business_terms: metrics: friend: description: "6TFSUIBUIBTBEEFE"*"TTJTUBOUBTBGSJFOE” definition: ”events.type=‘add_friend’ exists and

    events.type=‘agree’ doesn’t” business_value: "12% of user base generating 67% of platform engagement” ... #VTJOFTTUFSNTˠCVTJOFTT@UFSNTZBNM 4USVDUVSFECVTJOFTTMPHJDEFGJOJUJPO

  33. :".-$POGJHVSBUJPO'JMFT data_schema: tables: users: description: "Platform user accounts and activity

    metrics” fields: user_id: type: "VARCHAR” description: "Unique user identifier” primary_key: true ... %BUB4DIFNBˠTDIFNBZBNM 4USVDUVSFECVTJOFTTMPHJDEFGJOJUJPO

  34. 4FSWFS*OUFHSBUJPO&YBNQMF messenger_mcp_server/ ├── main.py ├── server.py ├── semantics/ │ ├──

    schema.yaml │ ├── business_terms.yaml │ └── semantic_orchestrator.py └── requirements.txt "EETFNBOUJDTBOEMBZFSTUPTFSWFSDPEF $PEFJNQMFNFOUBUJPOXJUITFNBOUJDUPPMT 4FSWFSOPXVTFTTFNBOUJDTGPSRVFSZQSPDFTTJOHBOESFTQPOTFFOIBODFNFOU

  35. %#MFWFM4FNBOUJD-BZFSJOH "VUPNBUFENFUBEBUBBQQSPBDI 4FNBOUJD -BZFSJOH 6TFS .$1$MJFOU .POHP%# .$1TFSWFS .POHP%#

  36. %#MFWFM4FNBOUJD-BZFSJOH "VUPNBUFENFUBEBUBBQQSPBDI 4FNBOUJD -BZFSJOH 6TFS .$1$MJFOU .POHP%# .$1TFSWFS .POHP%# .FUBEBUB

    DPMMFDUJPOT

  37. 5SJHHFSTBOE7JFX(FOFSBUJPO messenger_platform_db/ ├── users ├── events ├── schema_metadata ├── business_terms

    ├── business_intelligence │ ├── daily_metrics │ └── user_segments └── semantic_views ├── dau_view └── engagement_summary "EEDPMMFDUJPOTUSJHHFSTUP%# 3FBMUJNFCVTJOFTTJOUFMMJHFODFVQEBUFT

  38. 5SJHHFSTBOE7JFX(FOFSBUJPO messenger_platform_db/ ├── users ├── events ├── schema_metadata ├── business_terms

    ├── business_intelligence │ ├── daily_metrics │ └── user_segments └── semantic_views ├── dau_view └── engagement_summary "EEDPMMFDUJPOTUSJHHFSTUP%# 3FBMUJNFCVTJOFTTJOUFMMJHFODFVQEBUFT

  39. 5SJHHFSTBOE7JFX(FOFSBUJPO messenger_platform_db/ ├── users ├── events ├── schema_metadata ├── business_terms

    ├── business_intelligence │ ├── daily_metrics │ └── user_segments └── semantic_views ├── dau_view └── engagement_summary "EEDPMMFDUJPOTUSJHHFSTUP%# 3FBMUJNFCVTJOFTTJOUFMMJHFODFVQEBUFT

  40. 5SJHHFSTBOE7JFX(FOFSBUJPO messenger_platform_db/ ├── users ├── events ├── schema_metadata ├── business_terms

    ├── business_intelligence │ ├── daily_metrics │ └── user_segments └── semantic_views ├── dau_view └── engagement_summary "EEDPMMFDUJPOTUSJHHFSTUP%# 3FBMUJNFCVTJOFTTJOUFMMJHFODFVQEBUFT

  41. 5SJHHFSTBOE7JFX(FOFSBUJPO messenger_platform_db/ ├── users ├── events ├── schema_metadata ├── business_terms

    ├── business_intelligence │ ├── daily_metrics │ └── user_segments └── semantic_views ├── dau_view └── engagement_summary "EEDPMMFDUJPOTUSJHHFSTUP%# 3FBMUJNFCVTJOFTTJOUFMMJHFODFVQEBUFT messenger_mcp_server/ ├── main.py ├── server.py └── requirements.txt .PEJGZTFSWFSDPEF

  42. 4FNBOUJD-BZFSJOH4VNNBSZ ,FZ%JGGFSFODFT#FUXFFO-FWFMT -FWFM $MJFOU 4FSWFS %BUBCBTF 4FNBOUJD TUPSBHF 4ZTUFNQSPNQU :".-DPOGJHGJMF

    .FUBEBUBDPMMFDUJPO *NQMFNFOUBUJPO 3FRVFTUFOIBODFNFOU .$1TFSWFSDPEF JOUFHSBUJPO 4DIFNBFNCFEEFE TFNBOUJDT "VUPNBUJPO .BOVBMQSPNQUJOH 4FNJBVUPNBUFE 'VMMZBVUPNBUFE 1FSGPSNBODF 3FBMUJNFUSBOTMBUJPO $BDIFEQSPDFTTJOH 1SFDPNQVUFEWJFX

  43. 3FBMJNQSPWFNFOUTBOEQSBDUJDBMRVFSZDBQBCJMJUJFT 4PMVUJPOJO"DUJPO

  44. 8IZ4FNBOUJD-BZFSJOH.BUUFST "IBOETPOFYQMPSBUJPOXJUIBDUVBMBOBMZTJTRVFTUJPOT 𝐴𝑝𝑟𝑖𝑙 𝑐ℎ𝑢𝑟𝑛 𝑟𝑎𝑡𝑒 = 𝐴𝑝𝑟𝑖𝑙 𝐼𝑛𝑎𝑐𝑡𝑖𝑣𝑒 𝑂𝑅 𝐶𝑎𝑛𝑐𝑒𝑙𝑒𝑑

    𝑢𝑠𝑒𝑟𝑠 𝑀𝑎𝑟𝑐ℎ 𝐴𝑐𝑡𝑖𝑣𝑒 𝑢𝑠𝑒𝑟𝑠 8IBU`TUIFDIVSOSBUF GPS"QSJM

  45. 1JQFMJOF8JUI4FNBOUJD-BZFSJOH 3FDBQ 6TFS .$1$MJFOU .POHP%# .$1TFSWFS .POHP%# 4FNBOUJD -BZFSJOH 4FNBOUJD

    -BZFSJOH 4FNBOUJD -BZFSJOH

  46. 6TFS .$1$MJFOU .POHP%# .$1TFSWFS .POHP%# 1JQFMJOF8JUI4FNBOUJD-BZFSJOH 3FDBQ

  47. #BTJD*NQMFNFOUBUJPO-JNJUBUJPOT 4UBHF%JSFDU--.RVFSZQSPDFTTJOHWJB.POHP%#.$1TFSWFS 5IF2VFTUJPOl8IBU`TUIFDIVSOSBUFGPS"QSJM z 5IF3FTVMU • $BMDVMBUFE3FTVMU • $BMDVMBUJPO-PHJD "QSJM*OBDUJWF6TFST

    .BSDI"DUJWF6TFST ʷ      ʷ  • 1SPCMFN.JTTJOHDBODFMMFEVTFS EBUB • --.GPVOEUIFEBUBCVUMBDLFE CVTJOFTTDPOUFYUVOEFSTUBOEJOH • $IVSO*OBDUJWF $BODFMMFE à 0OMZDBMDVMBUFEJOBDUJWF • 3BXEBUBBOBMZTJTXJUIPVUEPNBJO LOPXMFEHFMFBETUPJODPNQMFUF BOBMZTJT $PSF*TTVF

  48. 4UBHF4UFQ#VTJOFTT-PHJD*OUFHSBUJPO 4FSWFSMFWFM4FNBOUJD1SPDFTTJOH l8IBUJTUIFDIVSOSBUFGPS"QSJM z ᶃ /BUVSBM-BOHVBHF*OUFSQSFUBUJPO \JOUFOUlNFUSJD@RVFSZz  TVCKFDUlDIVSO@SBUFz^ #VTJOFTTUFSNMPPLVQ

    ᶄ 2VFSZ.BQQJOH .FUSJD@JE lDVTUPNFS@DIVSO@SBUFz #VTJOFTTDPOUFYUDMBSJGJDBUJPO ᶅ .FUSJD%FGJOJUJPO $BMDVMBUJPOzQSFW@NPOUI@NBV WT DVSSFOU@NPOUI@JOBDUJWF@PS@DBODFMFEz %PNBJOTQFDJGJDFYFDVUJPO ᶆ #VTJOFTT-PHJD&YFDVUJPO 3FTVMUPGDIVSOSBUF

  49. &OIBODFE*NQMFNFOUBUJPO3FTVMUT 4UBHF#VTJOFTTDPOUFYUJOUFHSBUJPOPVUDPNFT 5IF3FTVMU • *OBDUJWF6TFST  • 4VCTDSJQUJPO$BODFMMBUJPO OFXMZ EJTDPWFSFE

    • 5PUBM$IVSOFE$VTUPNFST  • *NQSPWFE3FTVMU     .BSDI"DUJWF6TFST "QSJM*OBDUJWF6TFST 5IF2VFTUJPOl8IBU`TUIFDIVSOSBUFGPS"QSJM z

  50. &OIBODFE*NQMFNFOUBUJPO3FTVMUT 4UBHF#VTJOFTTDPOUFYUJOUFHSBUJPOPVUDPNFT • *OBDUJWF6TFST  • 4VCTDSJQUJPO$BODFMMBUJPO OFXMZ EJTDPWFSFE •

    5PUBM$IVSOFE$VTUPNFST  • *NQSPWFE3FTVMU     "QSJM$BODFMFE6TFST 5IF3FTVMU 5IF2VFTUJPOl8IBU`TUIFDIVSOSBUFGPS"QSJM z .BSDI"DUJWF6TFST "QSJM*OBDUJWF6TFST

  51. &OIBODFE*NQMFNFOUBUJPO3FTVMUT 4UBHF#VTJOFTTDPOUFYUJOUFHSBUJPOPVUDPNFT • *OBDUJWF6TFST  • 4VCTDSJQUJPO$BODFMMBUJPO OFXMZ EJTDPWFSFE •

    5PUBM$IVSOFE6TFST  • *NQSPWFE3FTVMU     5IF3FTVMU 5IF2VFTUJPOl8IBU`TUIFDIVSOSBUFGPS"QSJM z "QSJM$BODFMFE6TFST .BSDI"DUJWF6TFST "QSJM*OBDUJWF6TFST

  52. &OIBODFE*NQMFNFOUBUJPO-JNJUBUJPOT -PHJDBMDPSSFDUOFTTBDIJFWFE CVUMBDLJOHFYFDVUJPOFGGJDJFODZ -PHJDWT&YFDVUJPO • %FTJHOFE $PNQMFUFDIVSODBMDVMBUJPO JOBDUJWF  DBODFMMFE

    • 3FBMJUZ --.TJNQMJGJFTXIFOGBDJOHDPNQMFYJUZ • "QQSPBDI 'VMMDPMMFDUJPOTDBOOJOH • 4USBUFHZ /PTFMFDUJWFGJMUFSJOHPSJOEFYJOH • %FTJHO .JTTJOHRVFSZPQUJNJ[BUJPOQBUUFSOT 3PPU$BVTF ,FZ*OTJHIUT --.BVUPNBUJDBMMZSFEVDFTMPHJDDPNQMFYJUZXIFOFYFDVUJPOCFDPNFTJOFGGJDJFOU ˠ/FYU %BUBCBTFMFWFMPQUJNJ[BUJPOUPTVQQPSUPSJHJOBMTFNBOUJDEFTJHO

  53. 4UBHF.FUBEBUBPQUJNJ[BUJPOGPSTFNBOUJDRVFSZFYFDVUJPO %#MFWFM4FNBOUJD1SPDFTTJOH Metadata Strategy Example // Strategic index design {order_type:

    1, dt: 1, emid: 1} // Churn calculation requirements: // - Find who cancelled (order_type filter) // - Within target month (dt filter) // - From previous active users (emid filter) • #FGPSF • 'VMMDPMMFDUJPOTDBO • 1SPDFTTJOHNJMMJPOTPGSFDPSET • "GUFS • 5BSHFUFEEBUBBDDFTT • 'PDVTPOMZPOUIFDBODFMMFEVTFSTJO TQFDJGJDNPOUI Execution Enhancement #FOFGJUT .FUBEBUBPQUJNJ[BUJPOFOBCMFTPSJHJOBMTFNBOUJDEFTJHOFYFDVUJPO

  54. • *OBDUJWF6TFST  • 4VCTDSJQUJPO$BODFMMBUJPO • 5PUBM$IVSOFE$VTUPNFST  • *NQSPWFE3FTVMU

        5IF3FTVMU $PNQMFUF*NQMFNFOUBUJPO3FTVMUT 4UBHF.FUBEBUBPQUJNJ[BUJPOGPSTFNBOUJDRVFSZFYFDVUJPO 5IF2VFTUJPOl8IBU`TUIFDIVSOSBUFGPS"QSJM z "QSJM$BODFMFE6TFST .BSDI"DUJWF6TFST "QSJM*OBDUJWF6TFST

  55. $PNQMFUF*NQMFNFOUBUJPO3FTVMUT 4UBHF.FUBEBUBPQUJNJ[BUJPOGPSTFNBOUJDRVFSZFYFDVUJPO 5IF2VFTUJPOl8IBU`TUIFDIVSOSBUFGPS"QSJM z • *OBDUJWF6TFST  • 4VCTDSJQUJPO$BODFMMBUJPO DPSSFDUFEGSPN

    • 5PUBM$IVSOFE6TFST  • 'JOBM3FTVMU    5IF3FTVMU "QSJM$BODFMFE6TFST .BSDI"DUJWF6TFST "QSJM*OBDUJWF6TFST

  56. *NQMFNFOUBUJPO4VNNBSZ -BZFSCZ-BZFS1SPCMFN3FTPMVUJPO   83.0%   ?  

    83.6%   112   83.4%   76 %#MFWFM0QUJNJ[BUJPO 4FSWFSMFWFM#VTJOFTT-PHJD

  57. &YBNQMFTPG/BUVSBM-BOHVBHF2VFSJFTJO"DUJPO 8IBU:PV$PVME "TL 2.POUIMZ"DUJWF6TFST 8IBUXBTUIFOVNCFSPGBDUJWFVTFSTJO +VOF l BDUJWFVTFSTz 2)JTUPSJDBM$IVSO"OBMZTJT 8IBUXBTUIFDVTUPNFSDIVSOSBUFJO

    'FCSVBSZ lz ᶅ 3FMBUJWF5JNF2VFSJFT )PXNBOZVTFSTXFSFBDUJWF MBTUNPOUI l BDUJWFVTFSTJO.BZz ᶆ 3FHJPOBM%JTUSJCVUJPO $BO*TFFBCSFBLEPXOPGVTFST CZSFHJPOGPSUIJTNPOUI l+1  58  5) z

  58. .VMUJTZTUFNBVUPNBUJPO 8IBU`T/FYU

  59. .$1*OUFHSBUJPO $POOFDUJOHNVMUJQMFTZTUFNTUISPVHIBVOJGJFEIVC .$1$MJFOU %BUBCBTF .$14FSWFS .POHP%# .POHP%# .$14FSWFS

  60. .$1*OUFHSBUJPO $POOFDUJOHNVMUJQMFTZTUFNTUISPVHIBVOJGJFEIVC .POHP%# .$14FSWFS .POHP%# 1PTUHSF42- .$1$MJFOU 4ZTUFN .$14FSWFS 5BCMFBV

    4MBDL

  61. .$1*OUFHSBUJPO $POOFDUJOHNVMUJQMFTZTUFNTUISPVHIBVOJGJFEIVC .POHP%# .$14FSWFS .POHP%# 1PTUHSF42- .$1$MJFOU 4ZTUFN .$14FSWFS 5BCMFBV

    4MBDL 1PTUHSF42- .$14FSWFS 5BCMFBV .$14FSWFS 4MBDL .$14FSWFS

  62. 8PSL5PPMT 8PSLJOH5PHFUIFS 4JOHMF1MBUGPSN .VMUJQMF4ZTUFNT .$1 $MJFOU )VC 5BCMFBV .POHP%# 1PTUHSF42-

    4MBDL (JUIVC $POGMVFODF ʜ

  63. 8PSLJOH5PHFUIFS 6TF$BTFT  #VTJOFTT"OBMZTJT .POHP%# *OEJWJEVBMVTFSTFSWJDF VTBHFGSFRVFODZ SFWJTJU QBUUFSOT 3FTVMU

    l  PG VTFST XJUI  NPOUIMZ VTBHF XJMMJOH UP DPOWFSU UP TVCTDSJQUJPOz 3FRVFTUl8PVMEDPOWFSUJOHPVSTFSWJDFUPBTVCTDSJQUJPONPEFMJNQSPWFQSPGJUBCJMJUZ z 1PTUHSF42- $VSSFOUVTFST`QVSDIBTF DZDMFT "WHQVSDIBTF BNPVOUT $POGMVFODF 6TFSJOUFSWJFXSFTVMUT  TVCTDSJQUJPOJOUFOUJPO TVSWFZT

  64. 8PSLJOH5PHFUIFS 6TF$BTFT  3FBMUJNF.POJUPSJOH 5BCMFBV 3FBMUJNFVTFSDPVOU 3FTVMU l  VTFST

    QFSGPSNBODFNFUSJDT BMFSUTEFUFDUFEz 3FRVFTUl$IFDLPVSTFSWJDFSFBMUJNFTUBUVTz .POHP%# -BTUIPVSFSSPSMPHT  VTFSDIVSOQBUUFSOT 4MBDL *ODJEFOUSFMBUFE DPOWFSTBUJPOTJO DIBOOFMT

  65. 8PSLJOH5PHFUIFS 6TF$BTFT  %BJMZ8PSLGMPX (JUIVC 5PEBZ`TEFBEMJOF1VMM 3FRVFTUT QFOEJOHDPEF SFWJFXT 3FTVMU

    1SJPSJUJ[FEUPEPMJTUGPSFBDIJOEJWJEVBM 3FRVFTUl0SHBOJ[FUPEBZ`TUFBNUBTLTz $POGMVFODF %PDVNFOUTOFFEJOH VQEBUFT BDUJPOJUFNT  UPEBZ`TNFFUJOHBHFOEBT

  66. "EBQUJOHUPUIFBHFPG"*ESJWFOBOBMZUJDT $MPTJOH5IPVHIUT

  67. 5IF'VUVSF"OBMZTU /FX1BSUOFSTIJQ)VNBO "* 8IBU--.T&YDFMBU • -BSHFTDBMFEBUBQSPDFTTJOHBOEQBUUFSO SFDPHOJUJPO • 4JNVMUBOFPVTNVMUJTZTUFNRVFSZ FYFDVUJPO

    • 3FQFUJUJWFBOBMZTJTUBTLBVUPNBUJPO • SFBMUJNFNPOJUPSJOHBOEBMFSUJOH • 4UBOEBSEJ[FESFQPSUHFOFSBUJPO 8IBU0OMZ)VNBOT$BO%P • %FTJHOJOHMPHJDTZTUFNTGPS--.TUP VOEFSTUBOECVTJOFTTDPOUFYU • #VJMEJOHTFNBOUJDMBZFSTBOEDPOUFYU TZTUFNT • 4USBUFHJDRVFTUJPOEFTJHOBOEGSBNJOH • 4USVDUVSJOHEPNBJOLOPXMFEHFGPS"* VUJMJ[BUJPO • "OBMZTJTSFTVMUJOUFHSJUZWFSJGJDBUJPO

  68. .VMUJ1MBUGPSNBOBMZTJT $POEVDUDPNQSFIFOTJWFBOBMZTJTBDSPTT.POHP%#VTFSCFIBWJPS 1PTUHSF42-USBOTBDUJPOEBUB BOE5BCMFBVEBTICPBSET TJNVMUBOFPVTMZ CFZPOEJOEJWJEVBMBOBMZUJDBMDBQBDJUZ 5IF'VUVSF"OBMZTU /FX1BSUOFSTIJQ)VNBO "* $POUFYU"XBSF8PSLGMPX"VUPNBUJPO

    "VUPNBUFBOBMZUJDBMXPSLGMPXTUIBUBEBQUUPEBUBQBUUFSOTBOPNBMZEFUFDUJPOUSJHHFSTEFFQFSJOWFTUJHBUJPO TFBTPOBMUSFOETBEKVTU GPSFDBTUJOHNPEFMT BOEPVUMJFSTQSPNQUWBMJEBUJPOQSPDFTTFT "EWBODFE"OBMZUJDT*NQMFNFOUBUJPO %FQMPZNPEFMTGPSDVTUPNFSTFHNFOUBUJPO EFNBOEGPSFDBTUJOH BOE"#UFTUJOHŠ XJUIPVUSFRVJSJOHEFFQUFDIOJDBMJNQMFNFOUBUJPO  XIFUIFSTUBUJTUJDBM SVMFCBTFE PSNBDIJOFMFBSOJOH

  69. .VMUJ1MBUGPSNBOBMZTJT $POEVDUDPNQSFIFOTJWFBOBMZTJTBDSPTT.POHP%#VTFSCFIBWJPS 1PTUHSF42-USBOTBDUJPOEBUB BOE5BCMFBVEBTICPBSET TJNVMUBOFPVTMZ CFZPOEJOEJWJEVBMBOBMZUJDBMDBQBDJUZ 5IF'VUVSF"OBMZTU /FX1BSUOFSTIJQ)VNBO "* $POUFYU"XBSF8PSLGMPX"VUPNBUJPO

    "VUPNBUFBOBMZUJDBMXPSLGMPXTUIBUBEBQUUPEBUBQBUUFSOTBOPNBMZEFUFDUJPOUSJHHFSTEFFQFSJOWFTUJHBUJPO TFBTPOBMUSFOETBEKVTU GPSFDBTUJOHNPEFMT BOEPVUMJFSTQSPNQUWBMJEBUJPOQSPDFTTFT "EWBODFE"OBMZUJDT*NQMFNFOUBUJPO %FQMPZNPEFMTGPSDVTUPNFSTFHNFOUBUJPO EFNBOEGPSFDBTUJOH BOE"#UFTUJOHŠ XJUIPVUSFRVJSJOHEFFQUFDIOJDBMJNQMFNFOUBUJPO  XIFUIFSTUBUJTUJDBM SVMFCBTFE PSNBDIJOFMFBSOJOH l--.TBSFQPXFSGVMQBSUOFSTUIBUFYQBOEPVSBOBMZUJDBMDBQBCJMJUJFTz

  70. *GZPVIBWFBOZRVFTUJPOT GFFMGSFFUPGJOEVTJOUIF2"TFDUJPO 5IBOL:PV