[B! looker] stibbarã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

stibbar id:stibbar

lookerã«é–¢ã™ã‚‹stibbarã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ä¼šç¤¾è¦æ¨¡ã¨éƒ¨ç½²åˆ¥ã§è€ƒãˆã‚‹ã€é©åˆ‡ãªBIãƒ„ãƒ¼ãƒ«ã®é¸ã³æ–¹
ã¿ãªã•ã‚“ã“ã‚“ã«ã¡ã¯ã€‚æ ªå¼ä¼šç¤¾INVOXã®ä½è—¤ã§ã™ã€‚ æœ¬è¨˜äº‹ã§ã¯ã€ä¼šç¤¾è¦æ¨¡ã‚„éƒ¨ç½²ã«å¿œã˜ã¦é©åˆ‡ãªBIãƒ„ãƒ¼ãƒ«ã‚’é¸ã¶æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚BIãƒ„ãƒ¼ãƒ«å°Žå…¥ã‚’æ¤œè¨Žã—ã¦ã„ã‚‹ä¼æ¥ã®çµŒå–¶é™£ã‚„éƒ¨ç½²ãƒªãƒ¼ãƒ€ãƒ¼ã€å°Žå…¥æ‹…å½“è€…ãªã©ã®æ–¹ã«å‚è€ƒã«ã—ã¦ã„ãŸã ã‘ã‚‹ã¨å¬‰ã—ã„ã§ã™ã€‚ BIãƒ„ãƒ¼ãƒ«ã®åŸºæœ¬æ¦‚å¿µ ãƒ“ã‚¸ãƒã‚¹ã‚¤ãƒ³ãƒ†ãƒªã‚¸ã‚§ãƒ³ã‚¹ï¼ˆBIï¼‰ãƒ„ãƒ¼ãƒ«ã¨ã¯ã€ä¼æ¥å†…å¤–ã®ãƒ‡ãƒ¼ã‚¿ã‚’åŽé›†ãƒ»åˆ†æžãƒ»å¯è¦–åŒ–ã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚BIãƒ„ãƒ¼ãƒ«ã®ä¸»ãªæ©Ÿèƒ½ã«ã¯ã€ãƒ‡ãƒ¼ã‚¿åŽé›†ãƒ»çµ±åˆã€åˆ†æžã€ãƒ¬ãƒãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã€ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ä½œæˆãªã©ãŒã‚ã‚Šã¾ã™ã€‚ å¤šãã®BIãƒ„ãƒ¼ãƒ«ã¯ã‚¯ãƒ©ã‚¦ãƒ‰ãƒ™ãƒ¼ã‚¹ã§æä¾›ã•ã‚Œã¦ãŠã‚Šã€å®¹æ˜“ã«å°Žå…¥ãƒ»é‹ç”¨ãŒå¯èƒ½ã§ã™ã€‚é©åˆ‡ãªBIãƒ„ãƒ¼ãƒ«ã‚’é¸ã¶ã“ã¨ã§ã€è¿…é€Ÿã‹ã¤æ£ç¢ºãªæ„æ€æ±ºå®šã‚’è¡Œã†ã“ã¨ãŒã§ãã€äº‹æ¥æˆé•·ã«çµã³ã¤ã‘ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ä¼šç¤¾è¦æ¨¡åˆ¥ã®BIãƒ„ãƒ¼ãƒ«é¸ã³ ä¼šç¤¾ã®è¦æ¨¡ã«ã‚ˆã£ã¦ã€æ±‚ã‚ã‚‰ã‚Œã‚‹BIãƒ„ãƒ¼ãƒ«ã®æ©Ÿèƒ½ã‚„äºˆç®—ãŒç•°ãªã‚Šã¾ã™ã€‚ä»¥ä¸‹ã§ã¯ã€å°è¦æ¨¡ä¼æ¥ã€ä¸è¦æ¨¡ä¼æ¥ã€å¤§è¦æ¨¡ä¼æ¥ã®ãã‚Œ
stibbar 2023/12/15
https://www.designet.co.jp/ossinfo/selection/bitool.html

zenn

bi

looker

metabase

redash
ãƒªãƒ³ã‚¯
Amazon QuickSight VS Looker VS SASã®æ¯”è¼ƒ |ã€ITreviewã€‘ITè£½å“ã®ãƒ¬ãƒ“ãƒ¥ãƒ¼ãƒ»æ¯”è¼ƒã‚µã‚¤ãƒˆ
å–¶æ¥ãŒä½¿ç”¨ã™ã‚‹SFAã®ãƒ‡ãƒ¼ã‚¿ã‚’ã€Amazon QuickSightã«é€£æºã—ã¦ã€BIä¸Šã§ã€Œè¨ªå•ä»¶æ•°ã€ã€Œå—æ³¨æ•°ã€ã€Œè¦‹è¾¼ã¿é¡§å®¢æ•°ã€ãªã©æ§˜ã€…ãªè¦–ç‚¹ã§åˆ†æžã‚’ã—ã¦ã„ã¾ã™ã€‚å–¶æ¥ã®å€‹äººã”ã¨ã®ãƒ‡ãƒ¼ã‚¿ã‚„å–¶æ¥çµ„ç¹”å…¨ä½“ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¿ãƒ–ã§åˆ†ã‘ã¦è¡¨ç¤ºã•ã›ãŸã‚Šã€ãã‚Œä»¥å¤–ã®çµŒå–¶è¦–ç‚¹ã§ã®åˆ†æžãƒ‡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã¯åˆ¥ã®ã‚¿ãƒ–ã§ä½œæˆã—ãŸã‚Šã¨ã€ã»ã¼æ€ã„é€šã‚Šã®ã“ã¨ãŒã§ãã¦ã„ã¾ã™ã€‚ æ“ä½œã‚‚ç°¡å˜ã§ã€ãƒ‰ãƒ©ãƒƒã‚°ï¼†ãƒ‰ãƒãƒƒãƒ—ã§ãƒ¬ã‚¤ã‚¢ã‚¦ãƒˆãŒç°¡å˜ã«æ•´ãˆã‚‹ã“ã¨ãŒã§ãã€ã¾ãŸã€å††ã‚°ãƒ©ãƒ•ã‚„æ£’ã‚°ãƒ©ãƒ•ãªã©ã®å¤‰æ›ã‚‚ãƒœã‚¿ãƒ³ä¸€ã¤ã§å³åº§ã«ç”Ÿæˆã§ãã¾ã™ã€‚ SFAä¸Šã«ã‚‚åˆ†æžæ©Ÿèƒ½ã¯ã¤ã„ã¦ã„ã¾ã™ãŒã€ã©ã†ã—ã¦ã‚‚ç°¡ç´ ãªåˆ†æžã—ã‹ã§ããªã„ãŸã‚ã€ã“ã‚Œã¨ã“ã‚Œã‚’çµ„ã¿åˆã‚ã›ã¦åˆ†æžã—ãŸã„ã€ã¨ã„ã£ãŸç´°ã‹ãªè¦æœ›ã‚’æº€ãŸã™ã“ã¨ãŒã§ãã‚‹ã®ã§ã€Amazon QuickSightã‚’é‡å®ã—ã¦ã„ã¾ã™ã€‚
stibbar 2021/04/09
https://aws.amazon.com/jp/quicksight/

quicksight

looker
ãƒªãƒ³ã‚¯
dimension_group Â |Â Looker Â |Â Google Cloud
stibbar 2019/08/15
looker
ãƒªãƒ³ã‚¯
Lookerã«ãŠã‘ã‚‹ãƒãƒ¼ãƒ«ãƒ»ãƒ‘ãƒ¼ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚»ãƒƒãƒˆãƒ»ãƒ¢ãƒ‡ãƒ«ã‚»ãƒƒãƒˆã®è€ƒãˆæ–¹(ï¼†ãƒ¦ãƒ¼ã‚¶ãƒ¼ä½œæˆå…¥é–€) #looker | DevelopersIO
Lookerã§ã¯åˆ©ç”¨ã®éš›ã«ã€Œãƒ¦ãƒ¼ã‚¶ãƒ¼ã€ã‚’ä½œæˆã—ã€åˆ©ç”¨è€…ã¯ãã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚’ä½¿ã£ã¦Lookerã«ãƒã‚°ã‚¤ãƒ³ã—ã¦ãã‚Œãžã‚Œã®ä½œæ¥ã‚’è¡Œã„ã¾ã™ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ã¯åŸºæœ¬çš„ãªè¨å®šé …ç›®ã®ä¸ã«ã€ãã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒã©ã®ã‚ˆã†ãªæ“ä½œã‚’ã©ã†ã„ã£ãŸç¯„å›²ã€ãƒªã‚½ãƒ¼ã‚¹ã«å¯¾ã—ã¦è¡Œãˆã‚‹ã®ã‹ã©ã†ã‹ã‚’å®šã‚ã¦ã„ã‚‹ã€Œãƒãƒ¼ãƒ«ã€ã¨ã„ã†æ¦‚å¿µãŒå‚™ã‚ã£ã¦ã„ã¾ã™ã€‚å½“ã‚¨ãƒ³ãƒˆãƒªã§ã¯ãã®ã€Œãƒãƒ¼ãƒ«ã€å‘¨ã‚Šã«ã¤ã„ã¦åŸºæœ¬çš„ãªéƒ¨åˆ†ã‚’è¦‹ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ ç›®æ¬¡ ã€Œãƒ¦ãƒ¼ã‚¶ãƒ¼ä½œæˆã€åŸºæœ¬æ“ä½œå®Ÿè·µ Lookerã«ãŠã‘ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼å‘¨ã‚Šã®æ¦‚å¿µã«ã¤ã„ã¦è¦‹ã¦ã¿ã‚‹ ãƒ¦ãƒ¼ã‚¶ãƒ¼(User) ã‚°ãƒ«ãƒ¼ãƒ—(Group) ãƒãƒ¼ãƒ«(Role) ãƒ‘ãƒ¼ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚»ãƒƒãƒˆ(Permission Set) ãƒ¢ãƒ‡ãƒ«ã‚»ãƒƒãƒˆ(Model Set) ãƒãƒ¼ãƒ«ãƒ»ãƒ‘ãƒ¼ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚»ãƒƒãƒˆãƒ»ãƒ¢ãƒ‡ãƒ«ã‚»ãƒƒãƒˆã®é–¢é€£æ€§ã«ã¤ã„ã¦ ã¾ã¨ã‚ ã€Œãƒ¦ãƒ¼ã‚¶ãƒ¼ä½œæˆã€åŸºæœ¬æ“ä½œå®Ÿè·µ ã¾ãšã¯ã–ã£ãã‚Šãªæµã‚Œã§ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒã©ã®æ§˜ã«ä½œæˆã•ã‚Œã‚‹ã‹ã€ä½œæˆã—ãŸãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ã©ã®æ§˜ã«
stibbar 2019/08/14
looker

classmethod
ãƒªãƒ³ã‚¯
BIãƒ„ãƒ¼ãƒ«ã€ŒLookerã€ã®åˆ†æžç”»é¢ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ | ãƒ¡ãƒ«ã‚«ãƒªã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°
ã“ã‚“ã«ã¡ã¯ã€‚ãƒ¡ãƒ«ãƒšã‚¤ãƒ‡ãƒ¼ã‚¿ã‚¢ãƒŠãƒªã‚¹ãƒˆã®hase-ryoã§ã™ã€‚ æ¿€å‹•ã®2018å¹´ãŒçµ‚ã‚ã‚Š2019å¹´ã¨ãªã‚Šã¾ã—ãŸã€‚ ãƒ¡ãƒ«ãƒšã‚¤ã¯å¼•ãç¶šããƒªãƒªãƒ¼ã‚¹ã«å‘ã‘ã¦é–‹ç™ºã‚’é ‘å¼µã£ã¦ãŠã‚Šã¾ã™ã€‚ ä»¥å‰æ–°ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã€ŒLookerã€ã®å°Žå…¥ã«ã¤ã„ã¦æœ¬Blogã§ã”ç´¹ä»‹ã„ãŸã—ã¾ã—ãŸã€‚å‰å›žï¼ˆ18å¹´8æœˆï¼‰ã¯ãƒ¡ãƒ«ã‚«ãƒªJPã€ãƒ¡ãƒ«ãƒšã‚¤ã¨ã‚‚ã«å°Žå…¥æ®µéšŽã§ã—ãŸãŒã€ãã‚Œã‹ã‚‰4ãƒ¶æœˆãŒçµŒéŽã—ã€ä»Šã§ã¯çµŒå–¶ä¼šè°ã§ã‚‚æ¯Žå›žè¦‹ã‚‰ã‚Œã‚‹ãã‚‰ã„ã«æµ¸é€ã—ãŸBIãƒ„ãƒ¼ãƒ«ã¨ãªã‚Šã¾ã—ãŸã€‚ ã“ã‚Œã«ã¯Lookerã®ã‚‚ã¤ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç®¡ç†ã¨ã„ã†ç¨€æœ‰ãªç‰¹å¾´ã«ã‚ˆã‚Šé–‹ç™ºãŒç´ æ—©ãé€²ã‚“ã ã“ã¨ã®ä»–ã€ç°¡å˜ã«åˆ†æžã§ãã‚‹UIã«ã‚ˆã‚Šã€PMãªã©ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ãŸã„äººã«ä½¿ã£ã¦ã‚‚ã‚‰ãˆãŸã“ã¨ãŒå¤§ããè²¢çŒ®ã—ã¦ã„ã¾ã™ã€‚ ä»Šå›žã¯ãã‚“ãªSQLã‚’æ›¸ã„ãŸã“ã¨ãŒãªã„äººã§ã‚‚ç°¡å˜ã«ãƒ‡ãƒ¼ã‚¿åˆ†æžãŒå‡ºæ¥ã‚‹ã€ŒExploreã€æ©Ÿèƒ½ã«ã¤ã„ã¦ã€ãã®è©³ç´°ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ Lookerã‚’ä½¿ã£ãŸåˆ†æžã®ã‚¤ãƒ¡ãƒ¼ã‚¸ã«å½¹ç«‹ã¦ã¦ã„ãŸã ã‘ã‚Œ
stibbar 2019/01/18
mercari

mercan

looker

BI
ãƒªãƒ³ã‚¯
OSSã®ãƒ‡ãƒ¼ã‚¿å¯è¦–åŒ–ãƒ„ãƒ¼ãƒ«ã€ŒMetabaseã€ãŒè¶…ä½¿ã„ã‚„ã™ã„ - Qiita
Metabaseã€ã¾ã˜ã§ã‚¤ã‚±ã¦ã‚‹ã€‚ 1æ—¥ã§ã€Re:Dashã‹ã‚‰ä¹—ã‚Šæ›ãˆã¾ã—ãŸã€‚ Metabaseã¨ã¯ OSSã®ãƒ‡ãƒ¼ã‚¿å¯è¦–åŒ–ãƒ„ãƒ¼ãƒ«ã€‚Re:Dashã¨ã‹ã¨åŒã˜é¡žã€‚ AWSã¨ã‹ã«ä¹—ã›ã¦ã€èª°ã‚‚ãŒè¦‹ã‚Œã‚‹ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã‚’ä½œã£ãŸã‚Šã™ã‚‹æ™‚ã«ä½¿ã†ã¨ã€ä¿ºã‹ã£ã‘ãƒ¼ã£ã¦ãªã‚Šã¾ã™ã€‚ ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚·ãƒ§ãƒƒãƒˆ å®Ÿéš›ã«ç¤¾å†…ã§é‹ç”¨ã—ã¦ã„ã‚‹æ§˜åã‚’ãƒ¢ã‚¶ã‚¤ã‚¯ä»˜ãã§ãŠè¦‹ã›ã—ã¾ã™ã€‚ æ¯Žæ—¥ã¿ã¦ã„ã‚‹ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã€‚ã“ã‚Œã®4å€ãã‚‰ã„ã®æ•°å€¤è¦‹ã¦ã‚‹ã€‚ ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã®ç·¨é›†ã€‚ãƒžã‚¦ã‚¹ã§ç°¡å˜ã«ä½ç½®ã‚„å¤§ãã•ã®å¤‰æ›´ãŒã§ãã‚‹ã€‚ ã‚¯ã‚¨ãƒªãƒ“ãƒ«ãƒ€ãƒ¼çš„ãªã‚„ã¤ãŒã‚ã‚Šã€ã‚°ãƒ«ãƒ¼ãƒ”ãƒ³ã‚°ã¨ã‹è¶…çµ¶ä¾¿åˆ©ã€‚SQLæ›¸ã‘ãªã„äººã§ã‚‚ã€å˜ä¸€ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã‹ã ã£ãŸã‚‰ä½™è£•ã‹ã¨ã€‚ ã‚°ãƒ©ãƒ•åŒ–ã‚‚ç°¡å˜ã€‚ SQLã§ã®ã‚¯ã‚¨ãƒªç·¨é›†ç”»é¢ã€‚ã¡ã‚ƒã‚“ã¨è£œå®Œã—ã¦ãã‚Œã‚‹ã€‚ Metabaseã®è‰¯ã„æ‰€ è¦‹ãŸç›®ãŒæ ¼å¥½ã„ã„ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒç°¡å˜ã€‚ openjdk-8-jdkå…¥ã‚Œã¦ã€jarãƒ•ã‚¡ã‚¤ãƒ«ç½®ãã ã‘ã€‚ è±Šå¯Œãªãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã«å¯¾å¿œ
stibbar 2018/12/10
https://quipper.hatenablog.com/entry/2018/06/04/080000

BI

qiita

looker

metabase
ãƒªãƒ³ã‚¯
1