ã¯ããã«
ã¡ãªãŒã¯ãªã¹ãã¹ïŒ
æ¬èšäºã¯ NRI OpenStandia Advent Calendar 2023 ã® 24 æ¥ã®èšäºã§ãã
æ¯èŒçµæã¯å人çãªèŠè§£ã«åºã¥ããã®ã§ãã®ã§ããããŸã§ãåè ãšããŠæããŠããã ãããšå¹žãã§ãã
èšäºã®æ§æãšããŠã俯ç°ããããã¬ã³ãã«ããæ¯èŒããåãã§ãŒãºããµãŒãã¹ä»æ§ã«çç®ãããå芳ç¹ã«ããæ¯èŒãã®äºæ¬ç«ãŠã§èšèŒããŸãã
æ³å®èªè
- ãŸã BI ããŒã«ãå°å ¥ããŠããããã©ã®ããŒã«ãè¯ããããã£ãŠããªãã
- å°å ¥äºå®ã¯ãªãã BI ããŒã«ãæ°ã«ãªã£ãŠãããã©ããããã®ããããã¶ãã¯ãªç¥ãããã
è©äŸ¡ã»æ¯èŒ
ãã¬ã³ãã«ããæ¯èŒ
ãŸãã¯å®¢èгçã«å BI ããŒã«ãã©ã®çšåºŠæ€çŽ¢ãããŠããã®ãããç°¡åã«èŠãŠã¿ãŸãããã
以äžã¯å
šãŠã®åœã察象ã«ããã10幎ã®å BI ããŒã«ã®æ€çŽ¢æ°ã Google Trends ã§èª¿ã¹ãã°ã©ãã«ãªããŸãã
ãããŸã§æ€çŽ¢ãªã®ã§ãæ¬çªç°å¢ãšããŠäœ¿ãããŠããããšããè©äŸ¡ãããã«ã¯è³ããŸããããTableauãé·ãã«ããã£ãŠäººæ°ãPower BIã远ãäžããŠãã ãšããããšãããããŸãã
ç¶ããŠåãæéãåãå¯Ÿè±¡ã§æ¥æ¬åœå
ã®ç¶æ³ãèŠãŠã¿ãŸãããã
以äžã¯æ¥æ¬ã®ã¿ã«ãã£ã«ã¿ããã°ã©ãã«ãªããŸãã
2014幎é ãŸã§ã¯æŠãã©ã®BIããŒã«ãåãããã«çç®ãããŠããããã§ãããçŸåšã§ã¯ TableauãPower BIãæ³šç®ãããŠãã ããšãããããŸãã
ãã®ããšãã TableauãPower BI ãäžçã»æ¥æ¬ã©ã¡ãã§ã泚ç®ãããŠããããšãããããŸãã
泚ç®ãããŠããåãããã¥ã¡ã³ãããµããŒããæŽåãããããã³ãã¥ããã£ã掻æ§åããããåŸåãããããæ³šç®åºŠãé«ããšããã®ã¯1ã€ã®äŸ¡å€ïŒéžå®çç±ã«ãªããšèããŠããŸãã
å芳ç¹ã«ããæ¯èŒ
ããããã¯ããã€ãã®èгç¹ããšã«å BI ããŒã«ãæ¯èŒããŸãã
ïŒïŒïŒããŒã¿å å·¥ã»å¯èŠåãããŒã«ãããæ©èœæ§
DB ã«æ¥ç¶ããŠããã·ã¥ããŒãã§å¯èŠåãããŸã§ãäžèšâ ïœâ£ãšããŠè©äŸ¡ããããšæããŸãã

(å³ã¯ s-shimabukuro ç¬èªã§äœæ)
â Connect
DBæ¥ç¶ã®èгç¹ã§ã¯ã©ã®çšåºŠã®ããŒã¿ãœãŒã¹ïŒDBãµãŒãã¹æ°ãã«ããŒããŠããããšããç¹ã§æ¯èŒããŸãããæ¯èŒè¡šã¯ä»¥äžã®éãã§ãã
| Tableau | Power BI | Domo | Qlik | |
|---|---|---|---|---|
| ã³ãã¯ã¿æ° | çŽ90çš®é¡ | çŽ90çš®é¡ | çŽ1,000çš®é¡ | çŽ100çš®é¡ |
BI ããŒã«æ¯èŒã«ãããŠãããDomo ã¯ã³ãã¯ã¿ãå
å®ããŠããããšãé
åããšèšãããããã«ã³ãã¯ã¿æ°ã§ã¯ Domo ãæçŸ€ã«åªããŠãããšãããŸãã
äœããæ°ãå€ããã°è¯ããšããããã§ã¯ãªãã®ã§åæå¯Ÿè±¡ã®ç€Ÿå
å©çšDBãµãŒãã¹ãã«ããŒã§ããŠããã° Connect ã®èгç¹ã§ã¯ã©ã® BI ããŒã«ã§ãåé¡ãªãããšèããŸãã
ãŸããBI ããŒã«ãèªç€Ÿå
å©çšã® DB ãµãŒãã¹ã«å¯Ÿå¿ããŠããªãå Žåã§ããDB ãµãŒãã¹ãš BI ããŒã«ã®éã«äžéãµãŒããèšããçã®å¯Ÿå¿ã§ Connect éšåãè£å®ããããšãå¯èœã§ãã
â¡Store
ããŒã¿ã®æ ŒçŽã»æŽçã«ã€ããŠã¯åçš®ãµãŒãã¹ã«ãããŠå€§ããªå·®ã¯ãªããã岿ããããšæããŸãã
â¢Data Prep
ååŸããããŒã¿ãã¯ã¬ã³ãžã³ã°ã»æ£èŠåã»å å·¥ãããã§ãŒãºã§ã¯ETLæ©èœã«çç®ããããšæããŸãã
| Tableau | Power BI | Domo | Qlik | |
|---|---|---|---|---|
| ETLæ©èœ | Tableau PrepãšããããŒã«ãæããŠãããå å·¥ã®ã¯ãŒã¯ãããŒäœæã»èªååãè¡ããã | Power Query ã䜿ã£ãŠããŒã¿ã®éèšã»å å·¥ãã§ããã | Magic ETL/Beast Modeããããèªåçã«ç¹å®åãåèšç®ããçã®æ©èœãããã | ããŒã¿ãããŒãžã£ãŒãšããæ©èœã䜿ã£ãŠæ¢åã«ã©ã ã®å€ããæ°ããé ç®ãããŒãã«ã®äœæãã§ããã |
åºæ¬çã«ã¯ã©ã® BI ããŒã«ãã¯ãŒã¯ãããŒã§ETLåŠçãäœãããšãã§ããéšåçã«ã³ãŒã(SQL/Pythonãªã©)ãå
¥ããŠã«ã¹ã¿ã å å·¥ãã§ãããããªä»çµã¿ã«ãªã£ãŠããŸãã
ãŸããMagic ETLã®ããã«ç¹å®åã«é¢æ°ãé©çšããããããæ°ããå€ãç®åºããæ°ããé
ç®ãããŒãã«ãäœããšãã£ãæ©èœãæããŠããŸãã
ETLã®ç¹ã«ã€ããŠã¯ã©ã® BI ããŒã«ã倧ããå·®ã¯ãªããšèããããŸãã
(UI/UXé¢ã§ã®æ±ããããã®å·®ã¯ãããŸãããä»åã¯å²æããŸã)
â£Visualize
Visualize ã®èгç¹ã§ã¯è¡šçŸåãšããŠã°ã©ãã衚ãªã©ã®ç»é¢éšåæ°ãã©ã®çšåºŠå€ãããæ¯èŒããŸãã
| Tableau | Power BI | Domo | Qlik | |
|---|---|---|---|---|
| ç»é¢éšåæ° | 21 | 23 | 92 | 32 |
äžèšã®éããå¯èŠåããäžã§ã¯ Domo ãå§åçã«ç»é¢éšåãå€ã ãšããããšãããããŸãã
ã©ã®ãããªããã·ã¥ããŒãïŒã¬ã€ã¢ãŠãã«ãããããšãã£ãããšãæ€èšããéã«ç»é¢éšåã®æ°ãæ€èšã®å¹
ãå·Šå³ããããéèŠãªææšã®1ã€ã§ãããšèããŸãã
ïŒïŒïŒå©çšæé
ç¶ããŠå©çšæéã®æ¯èŒã§ãã
æéãã©ã³ã¯åãµãŒãã¹ã§æäŸããŠããæ©èœã®ç¯å²ãç°ãªããããåçŽã«æšªäžŠã³ã§ãé«ãã»å®ãããæ¯èŒããããšã¯ã§ããŸããããBI ããŒã«ãæåå¥çŽãããšã©ã®çšåºŠè²»çšãçºçããã®ãã®ç®åŠãã確èªããã ããããšæããŸãã
ãŸããä»åã¯ãµãŒãã¹ããšã«ããã€ããã©ã³ãããããšããå©çšæéãã¬ã³ãžã§æŽçããŠããŸãã
| Tableau | Power BI | Domo | Qlik | |
|---|---|---|---|---|
| å©çšæé(å/ãŠãŒã¶ã»æ) | 1,800ïœ9,000 | 1,250ïœ2,500 | äžæ(*1) | 2,800 |
(*1) å£ã³ããµã€ãããŒã¹ã§ã¯2,000å/ãŠãŒã¶ã»æ
â» 2023幎12ææç¹ã®åHPäžã§èšèŒãããå©çšæéã§ãã詳现ã¯åãµãŒãã¹HPã§ã®ç¢ºèªãæšå¥šããŸãã
â» æ¬å®¶HPã§åã§ã®èšèŒããªããµãŒãã¹ã¯140å/ãã«ã§æç®ããŠããŸãã
äžèšã®éããæŠããŠãŒã¶èª²éãæ¡çšããŠãã1ãŠãŒã¶ããã2,000-3,000å/æã§ããããšãããããŸãããŠãŒã¶èª²é以å€ã«ãå©çšããŒã¿åŸé課éãªã©ã®èª²éæ¹åŒãããããã詳现ã«ã€ããŠã¯åãµãŒãã¹ã® Pricing ããŒãžã«ãŠã確èªãã ããã
å
ã«è¿°ã¹ãéããåãµãŒãã¹ããšã«ãã©ã³ãããããã©ã³ããšã«æäŸããŠããæ©èœãç°ãªãããšããåçŽãªæšªäžŠã³æ¯èŒã¯ã§ããªãããå©çšæéã®é«äœã«ã€ããŠã¯èšåããŸããã
ãããã«
ç°¡æœã«å BI ããŒã«ãæ¯èŒããŸããã
- äžçã»æ¥æ¬ã®ã©ã¡ãã®èгç¹ã§ã Tableau ã人æ°ã§ããäžæ¹ã§ Power BI ãæ³šç®ã济ã³ãŠããããšãããããŸããã
- æ©èœã®èгç¹ã§ã¯ Domo ãé åçã§ããããšãããããŸããã
ç§èªèº«ã®å¥œã¿ãšããŠã¯ Power BI ãè¯ããªãšæããŠããŸãã
çç±ã¯ä»¥äžã®éãã§ãã
Power BI ãæšãçç±
- UIããããããã
- å©çšæéãæ¯èŒçå®ã
- ä»ã®MS補åãšã®é£æº(Azure AD ã Power Automate ãªã©)ã匷ã
- Microsoft Fabric (*3) ã®ç»å Žã«ããæŽ»çšãé²ããšäºæ³ããã
(*3) AIÃããŒã¿åæã®åºç€ãšã㊠Synapse ã Power BIãå«ã,
2023幎11æã«GA ããããµãŒãã¹
æ¯é BI ããŒã«å°å ¥ããæ€èšããŠã¿ãŠã¯ãããã§ããããã

