Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

CTO N&D 2025 Morning Session Track2(11:00-11:45...

Avatar for Yasuhiro Aoshiba Yasuhiro Aoshiba
October 29, 2025
Business
11
0

CTO N&D 2025 Morning Session Track2(11:00-11:45) ClickHouse＆リアルタイムKPI分析紹介

Avatar for Yasuhiro Aoshiba

Yasuhiro Aoshiba

October 29, 2025

Other Decks in Business

See All in Business
【株式会社カオナビ】会社紹介資料 for engineer / kaonavi/introduction-for-engineer
Avatar for 株式会社カオナビ kaonavi
3
62k
Dopagaki Driven Design
Avatar for pokotyamu pokotyamu
0
190
営業が見てきた"AI導入ガバナンス"のリアル — あなたの会社は今どのステージ？
Avatar for kurata_ryuichi kuraryu0128
0
200
FY2026.6 Impact Report JP
Avatar for Mercari, Inc. mercari_inc
1
130k
FY2026.6 Impact Report EN
Avatar for Mercari, Inc. mercari_inc
0
12k
コンテキストをデータとして扱うDynatraceのAIアーキテクチャ
Avatar for Katsuyoshi Sumida sukatsu1222
1
160
Trend Cloud OneからTrendAI Vision Oneへの切替 - 事前に押さえたい疑問とつまずきやすいポイント
Avatar for cm-toda-tomohiro todatomohiro
0
230
Crisp Code inc.｜わたしたちの事例 / 実績 - Works
Avatar for So Kotani / Crisp Code inc. CEO so_kotani
0
2.4k
タケウチグループRecruit
Avatar for タケウチグループ takeuchigroup
0
14k
uniam_事業概要.pdf
Avatar for uniam Inc. uniam
PRO
0
1.1k
KEELLプロダクト紹介資料_202610
Avatar for Shunsuke Takeuchi shunsuke_takeuchi
PRO
0
200
「仕訳」から「取引」へ（fAD2026）
Avatar for Shunsuke Takeuchi shunsuke_takeuchi
PRO
1
1.5k

Featured

See All Featured
Joys of Absence: A Defence of Solitary Play
Avatar for Sebastian Deterding codingconduct
1
550
GitHub's CSS Performance
Avatar for Jon Rohan jonrohan
1033
470k
Mind Mapping
Avatar for Hélio Medeiros helmedeiros
1
400
How to make the Groovebox
Avatar for あそなす asonas
2
2.5k
How to audit for AI Accessibility on your Front & Back End
Avatar for davetheseo davetheseo
0
600
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
Avatar for panda_program panda_program
123
22k
Fashionably flexible responsive web design (full day workshop)
Avatar for Andy Clarke malarkey
409
67k
Six Lessons from altMBA
Avatar for Skipper Chong Warson skipperchong
29
4.5k
How to Build an AI Search Optimization Roadmap - Criteria and Steps to Take #SEOIRL
Avatar for Aleyda Solis aleyda
1
2.2k
Optimising Largest Contentful Paint
Avatar for Harry Roberts csswizardry
37
4k
GraphQLの誤解/rethinking-graphql
Avatar for sonatard sonatard
75
12k
Into the Great Unknown - MozCon
Avatar for Noah Learner thekraken
41
2.8k

Transcript

  1. CTO N&D 2025 Morning Session Track2(11:00-11:45) ClickHouse ÿú²û¿´ðKPI V÷}Ï1÷ò1QA

  2. AWS x~fuöó~ÿ÷ü¿V÷1AI o²k~üùûx ClickHouse 1ú²û¿´ ÷ü¿ ¶·²ÿ¶¹1ÿ»ng1ó¸ý¹ ´óöú¸·ó¹1øÿ1or AI ½úõü·÷ó{zq»´þùü·÷ó

    ²òŸy»sx²oöxwv1AWS x 5 ~—~fuö³ùüüü·÷óY} (SCA) ²2024 ~12 oý}w~w2s¼{¸º1zûùAWS ~]rz´ óõùNwClickHouse ~¿ŸV÷ý?²g/Ö{ow}~y2 AWS µüó¹x~·üü¹z³~ Amazon S3, EC2, EKS, Bedrock zy1AWS ~‰µüó¹xClickHouse ²} \w1÷ü¿´÷ù´ó²W2ç[~AWS ¸³·¹ö{¹üº{ }¿±~y2 wRöz¹Áüùóúö³xõ¹üþó¹ AWS ~÷ßzú½ü¹²oy»sxw1÷ü¿ß~ßò{÷ß{ÿß2 ߉{ßxvú½ü¹²ãw1ú¿´ø~÷ü¿V÷w²/¯w ¿Ÿõ¹üþó¹²ßÿw~y2 ]rz»½õúö³xï¼g AWS ~Àýüû´óõù|óßy»¿þ~»½õúö³xï¼g~N w1ÿó·÷ó¿úö³»ûzV÷ôÛ²ëû2÷ü¿~Ûyg²úß w1ÛÛwÛo²µýüøw~y2 MPPO,CPPO,AOO {¸»ó¸ý¹³~ _öçzûùx~Y}²tvt~y|1AWS þüÁóø÷üü¹}u w~×_²ÝŸwvzº~y2q_øù´²û³o_PoC ³MP ?Ý|/® öz×_~m¼xzsvt~y2 AWS x~³~{¸º1ClickHouse ÷ü¿V÷~ÿýg²u¹{ßr1zûù~ó¸ý¹rÿ²?{µýüø
  3. None
  4. None
  5. None
  6. None
  7. None
  8. None

  9. z|Îú²û¿´ðKPI V÷z~{ ÿï~ó¸ý¹ôÛ{ztv1KPI [z»<š³=wz1Omr ÿ²_y»<í_üðü=xx²Wwvt~y2ÿû¯×²^|ï |²û[OwYWy»Îo1no~u_{ÿuto}~Ûw1 _my1ß^Îÿ~qÝót1·¹öðžû~³—xtsú¹¿² ¶€sx|w}~{³2 ú²û¿´ðKPI V÷1~u{<Îÿ}vt»YW=²ÿŸWw1}

    ~|w¯×~[¯×ö{²¿·÷ó²ÿsy±~fuözß} wy2s¼{¸º1dßþ_²úß{kxvrÿ²òŸu{1e Ûo³¹ø²gùWwvú½ü¹²oûow1fó¸ý¹ú¹¿² sÿ{}÷wv«û²g/Ö{óx»sx|ÿý{zº~y2

  10. ú²û¿´ðV÷|²¹yw_öït o}~Û~¿ŸW ßg~ok'±küýüøw1^|YW ´öü¶ü¯×~Y×{ÿttsx|w }~{³2û[Ow~KPI ÷Ÿ{¸º1ó¸ ý¹ñó󹲓uz1_my²g/Ö{ óx»sx|ÿý{zº~y2 þ\{Og~ú ú²û¿´ðV÷ý?1¹¿üø²ó÷

    |/Om{ßv»u]zto~~/twy2 ÷ü¿ùúöózo}~Û¹ôüùw^| {zq»núzÿwW²ßÿw~w·v2 Ûo³¹ø~gùW ClickHouse zy¿gý÷ü¿ùü¹~o{ ¸º1ßg~DWH Ûo³¹ø²/_{Z wz|¹1¸º¿þw×zV÷|ÿý{ zº~y2³¹øxgý~o²ßÿw~ y2 w_özó¸ý¹ûÿ ßþg/W ÿöí1ï|¯Û1ß^/o²" Î~—‰" {\¿{vsf¿uy»sx w1³óðü¸÷ó÷²uñü»óøUNu{~y2 ³¹øZ u~øùõ³ó¿1qÝz¿úó¿1·¹öðÝí{}÷'þí y»sxw1ß^¿´´óõù³¹ø²uñü»óø{¹/iüùûw Zw}~y2 ú¹¿O ~nyw÷´¸ùüüüø~eNg²sÿ{}÷w15 <15 VïÕ{ok ë²›x»sxw1ÿû{¹~æå´ö±²/_{óvw~y2 ÿû_›UN ·¹öðÕþ´žû~" Ww" ÿžwÿ÷y»sxw1NPS ¹³²~UNx ÿûýÿ÷~}Õ²ßÿw~y2·Ïø|\xù´öKPI ²qoy»s xw1o}~Û|V[O{òŸw~y2

  11. rßy»ú²û¿´ðKPI fu y~KPI ²ú²û¿´ðWyy}{ " ú²û¿´ð~o}~Ûüðü{ö}y»²~" {»sx|rß~÷wy2víÿþxwv1dY×|Ÿt1ew_özsq?|r»1fß¹¼»ÿ þ|Ûo³¹ø²NÞ»1xtv3 t~gþ|ãsvt»{²úw~w·v2 ï

    {Yþ¿( Îyp?²sv») ¸ùü÷'~nrß÷ xÿW¼öí ß^/oûÿ ·¹öðžûWY · {YþO( okwOK) ÿ{÷~þÿzww¿¿ _Šý±÷v õUqüóõüÏý rº|qzywxÞÿ g{|[y~» Þÿ: øó÷10 g{{º¿1Lagging g{xLeading g{²5:5 wðùó¹¸Ý w~y2 ÷ü¿Õî|OÛÛ Þÿ: ¹½üþY}²^/w1Õþ´o m²÷Ÿy»øû¹KPI ²n¿u{~y2 " ÷Ÿ" wo~» Þÿ: Runbook ´¯×²¿·÷ó( ¿t Þf~øùõ³ó¿vÿ'/o¿uzy) ² }¿~y2 ²ùüø÷¼ Þÿ: SLO ùü¹~[ÿw}ttx÷ùµ ü÷²ßÍw1" ³ÿx V" ²gþ{¯Ûw~ y2 ³¹øùÿ Þÿ: ß[—1÷ü¿þþ1w~÷² ÿŸWw1ûóø/ ³üûù¹øüü¸²ù W{tVq~y2

  12. úNKPI ~" û" V÷ ú²û¿´ðÿ{'ARPU 'îû÷÷Ÿ ßÍ~}¹t EC 'µö¹¿ú÷·÷óó¸ý¹~‰ KPI

    ²<t~s~ÿ—=wÿŸWw~y2 Black Friday ´/ß½óóúüóf~úN ×U²û[Owÿíw1ú²û¿´ðw ~fÛ¿u²ÿý{w~y2 ÿ{÷~ÿ—özY×}÷ ARPU ~ú²û¿´ðëû CVR ~û[Ow~÷Ÿ ClickHouse ~®ý´óø Materialized View x Aggregating/Summing ¸ó¸ó{¸º1 /ß~øù󶿷÷ó÷ü¿²û<V [Ow֊÷v2Late arrival Üký w1Õþ÷ü¿²kú{ßfw~y2 AWS ³~ñ¿üó Amazon Kinesis Data Streams/MSK {¹ ClickHouse x~¹øúüÿó°×º¿ 1Àó·õüüùAmazon QuickSight wëûw~y2

  13. CAC 'LTV 'Payback ~¿Ÿò÷úóÀ Àýü¹ß˜~öûóø¸³þÿ¿¹²" }~|w" V÷ ¹¿üø²ó÷~o}ÿwr»ÿûsß³¹øÿCAC  1ÿûoïïtÿLTV

     1÷ÏÞß—ÿPayback ²ÿf{ÿû'ÿŸWw~y2ßgokw¯ svtV÷²ok1u¹{f—[Ow߯ÿý{w~y2 01 /k÷ü¿}\ uUü³üù~ÿû¯×÷ü¿²¿Ÿ}\w1³ ûüøV÷²ßf—w߯w~y2 02 ¶³óù¶·uo û÷özSQL ÷v{¸º1×zLTV Šÿ²ßg ~1/10 ~f—wßÎu{~y2 03 ¯×÷ü¿ûv TTL ýw÷tn}÷ü¿²¯×uvw1¹øü ü¸³¹ø²gùWw~y2 AWS Glue/S3 ÷ü¿ü´¿{¹ClickHouse x~û÷özETL ÷v1QuickSight {¸»³ûüøÿŸWw1÷ÏÿUqüýüø²sÿ{orw}~y2

  14. ÷ýð¿øKPI ~A/B ö¹øsfßï ߛ~}û?UNxo}~ÛòŸ ÷ýÀ¿ø}Õ~±~A/B ö¹ø²1ßg~±kßï{¹V[Ow~vÛ{ÿ~w~ y2}Šöoog~í}û{¸º1ywߛ~my²g/Ww1rßñ¿üó~}ít ]Ÿ²ßÿw~y2 ¿Ÿ}Š÷v~ßÿ p95/p99

    zy~VOù²ú²û¿´ðŠÿ [kSôüóø{¸»û}»ÀñóøV÷ }Šö}û?~×ö÷Ÿ Amazon EventBridge/Kinesis ²šxߛ÷ü¿~׺¿1}ÿQuickSight ~ Streamlit on ECS/Fargate wÿŸWw~y2

  15. ß^'²øúóõü·÷óKPI ~þ ûñ¿óñ֊ 1 ßg~okgùW ß^ûÿnÛ24 f—Õ¼1ÎÿÝV~_my|~o 2 VkgùWx~îû ú²û¿´ðß^ûÿnÛw1Îÿ²gùzñóýûxsÿ{·õø

    3 ROI g/W~ßÿ þûñ¿óñ²øúóõü·÷ó{¸º1~®ñóýû²{Û »ó·÷ó'öü¶üþþw~»¹¿þü¸óüûüV÷²¿Ÿß¯2ClickHouse ~ý üû²ó÷¯Š{¸º1݊ÿ³¹ø²/_Zwz|¹1×z²øúóõü·÷ó ò÷û²Ûow}~y2 S3 ~ß÷ü¿{¹ClickHouse x~û÷özETL ÿAWS Glue o 1Clean Rooms ³~² }Žw1÷ù´ð·üßÿx¿þþV÷²ow~y2

  16. FinOps ÿ³¹øKPI ~gùWxÿŸW ¿_SaaS ²Þ_Wy»COSS ÿCost of Served Session ¿x»W

    ¹¿üø²ó÷{xsvõ}öz<u{zt¿_µüó¹=²yw~y2»ó·÷ó'öü¶ü'ý[O w~~³¹øë°²ÿŸWw1÷ýÀ¿ø~ßþg²kú{êãw}»¸v{w~y2 ClickHouse {¸»³¹øgùW WgUw~w¹øüü¸³¹ø90% Z û÷özýüû²ó÷w¿¸ú÷v²¿ŸW ¿¸ú÷ýõ±´ûwqÝz÷v²{Û'óö 90% ¹øüü¸Z WgUw~{¸»ûÿ 75% ¿¸ú¿ŸW ßgDWH w~÷vf—ÿ~ 60% Ûo³¹øZ ÿbo³¹øÿTCO ~}Õ S3/IAM ýüû/BYOC Ûo~gùW1AWS Cost & Usage Report ÿCUR ׺¿{¸»ú²û¿´ð³¹ø÷Ÿw1uyzÏmrÿ²o÷w~y2

  17. AI oÿë}ÎW× ù¿øû} ßg~utùü¹ë}ÎWV÷{1üóõü´_t\¿{ö½¹ø~owöÞg²}\¿{¿õö²÷ýüñwy2öü¶ü~åYW²íß ÷w1÷ý²¿ö³özë}¶oý²ßÿw~y2 ÿ´öúóù}{¸º1 <ÞwOî²ctöü¶ü~ë}ñ¿üó=²~¿w1[wÿß~{YžO²¯×~Ûw~y2 ö½¹øßÖ üóõü'_t\¿{'SNS w~¿Û²ßÖ

    ß±¿or Amazon Bedrock/SageMaker wù¿øûW ClickHouse |} ù¿øûWw~¿Ÿ}'ÞV÷ ÎW¹³²ÿû utKPI xö½¹øå~}\V÷

  18. ²÷úSLO× ó¸ý¹KPI ~þ·V÷ ÿ»ng÷ü¿xó¸ý¹g{~}\{¸»ßmÿŸW ·¹öð~ü´öó·óW|úN´öü¶ü_›{Nx»ßŸ~my²ÛßWw~y2ßgw5{ûvwvt âÛg{xó¸ý¹g{²\/¸ó¸ówV÷w1¸ó¸û²úóÀ÷Ï~ó¸ý¹´óñ¿ø²núWw ~y2 ñøú¿¹ßÖ ²÷úÁü·÷óñõ¹üþó¹g{ ýÀ}\

    ¸ùüýÀxžûñ¿üóV÷ øüü¹V÷ Vg·¹öð~üøûýó¿{Û ó¸ý¹þ· CVR 'ë}÷x~ÿþnÛ Amazon OpenTelemetry Collector {¹ClickHouse x~}\׺¿1u~}÷f~Amazon SNS ²ùüø³~ {¸º1âÛö_Ü~ó¸ý¹x~ÿ²sÿ{êãw}~y2

  19. {m'ÿKPI ~ú²û¿´ð÷Ÿ oÕ'Þrÿ~\fO{¸»ßþgUN EC ó¸ý¹~ßþ²ÿóy»ÿgùW²1wßw'WÕw{ú²û¿´ð÷Ÿw~y2—‰eY´{ mÕþ{¸»_my²g/Ww1½óó·õõýü~uyg²ßcw~y2 ¿þzfÿW'wvV÷ fÿW¸÷´ó{¸»—‰Înx~®ÿ÷Ÿ H3/Geo ·u²owwßgùWV÷

    {mûüøxÿÝ~×ögùW {ûY×'´ùóø³×~¯×Ük AWS IoT Core/Kinesis Data Streams {¹ClickHouse x~ú²û¿´ð׺¿1QuickSight/Mapbox ³ ~{¸»öözw÷ÿŸW²ßÿw~y2 25% ÿ³¹øZ ùkÿß~×ö¿u{¸»ûÿ 15% oÕ÷}Õ —‰ÎnþþUN{¸»_myZ 30% {mû÷UN gùûüö³ó°{¸»Ý‘f—ÿ~

  20. Îo{¹Û±»k~¹öó÷ PoC ôÛ~ëû ÎÞ~öó÷üüø²owv1g²Ý‰zKPI {¹î›Ûo²ŸÛw~w· v2/uÛ±v/}zrÿ²ogw~y2 Áüð³~~W ¸ó¸û²'÷ýÀ¿ø'ó¸ý¹Áüð—w~KPI qo_v²ëûw1y öz÷ü¿ùúöóoW²¹rw~y2

    ýÿöz}Õ ú²û¿´ðKPI V÷{¹ß¹¼ß²ÿ{1÷ýÀ¿ø'ó¸ý¹ò ÷û~ýÿö}Õµ´¿û²úw~y2 ÷ü¿õwtoýwrº~{³2÷ü¿õwtÿwy2ùW{oy¼€1 ó¸ý¹~r¹¶»t¯²w¹w1òŸu{»sx|w}~y2 ClickHouse × AWS ~}\¿{{¸º1¹¿üø²ó÷|/Om{{uy»÷ü¿V÷ ý?²?{/¼»fï|rgw~w2Îo³€?ý²ßýw1þÏ{Og²úw vt}~w·v2