èªãã®ã«å¿ èŠãªæéã¯11å
ç§ãã¡ãš Gartner Square 2019 BI :)
ãã®èšäºã®ç®çã¯ãGartner ã¯ã¯ãã©ã³ãã®ãªãŒããŒã«äœçœ®ãã XNUMX ã€ã®äž»èŠãª BI ãã©ãããã©ãŒã ãæ¯èŒããããšã§ãã
- Power BI (ãã€ã¯ããœãã)
âã¿ãããŒ
âQlik
å³ 1. Gartner BI ããžã㯠ã¯ã¢ãã©ã³ã 2019
ç§ã®åå㯠Andrey Zhdanov ã§ããAnalytics Group ã®åæéšéã®è²¬ä»»è
ã§ã (
ç§ãšååã¯æ°å¹ŽéãããŸããŸãª BI ãã©ãããã©ãŒã ã«åãçµãã§ããŸããã åœç€Ÿã«ã¯éåžžã«åªãããããžã§ã¯ãçµéšããããéçºè ãã¢ããªã¹ããããžãã¹ ãŠãŒã¶ãŒãBI ã·ã¹ãã å®è£ è ã®èŠ³ç¹ãããã©ãããã©ãŒã ãæ¯èŒããããšãã§ããŸãã
ãããã® BI ã·ã¹ãã ã®äŸ¡æ Œãšããžã¥ã¢ã« ãã¶ã€ã³ã®æ¯èŒã«ã€ããŠã¯å¥ã®èšäºã§èª¬æããäºå®ãªã®ã§ãããã§ã¯ã¢ããªã¹ãããã³éçºè ã®èŠ³ç¹ãããããã®ã·ã¹ãã ãè©äŸ¡ããŠã¿ãŸãã
åæã®ããã«ããã€ãã®é åã匷調衚瀺ãã3 ç¹ã·ã¹ãã ã䜿çšããŠè©äŸ¡ããŠã¿ãŸãããã
â ã¢ããªã¹ãã®åå ¥åºæºãšèŠä»¶ã
â ããŒã¿ãœãŒã¹ã
â ããŒã¿ ã¯ãªãŒãã³ã°ãETL (æœåºãå€æãããŒã)
â èŠèŠåãšéçº
â äŒæ¥ç°å¢ â ãµãŒããŒãã¬ããŒã
â ã¢ãã€ã«ããã€ã¹ã®ãµããŒã
â ãµãŒãããŒãã£ã®ã¢ããªã±ãŒã·ã§ã³/ãµã€ãã«åã蟌ãŸãã (çµã¿èŸŒã¿ã®) åæ
1. ã¢ããªã¹ãã®åå ¥åºæºãšèŠä»¶
Power BI
IT ãããã§ãã·ã§ãã«ã§ã¯ãªãã«ãããããããããªãåªããã¬ããŒããäœæã§ãã Power BI ãŠãŒã¶ãŒãããããèŠãŠããŸããã Power BI ã¯ãExcel ãšåãã¯ãšãªèšèªãPower Query ããã³ DAX æ°åŒèšèªã䜿çšããŸãã å€ãã®ã¢ããªã¹ã㯠Excel ã«ç²ŸéããŠããããããã® BI ã·ã¹ãã ãžã®åãæ¿ãã¯éåžžã«ç°¡åã§ãã
ã»ãšãã©ã®ã¢ã¯ã·ã§ã³ã¯ã¯ãšãª ãšãã£ã¿ãŒã§éåžžã«ç°¡åã«å®è¡ã§ããŸãã ããã«ãå°é家åãã® M èšèªãåããé«åºŠãªãšãã£ã¿ãŒããããŸãã
å³ 2. Power BI ã¯ãšãª ãã«ããŒ
Qlik Sense
Qlik Sense ã¯éåžžã«ãã¬ã³ããªãŒã«èŠããŸããèšå®ã®æ°ãå°ãªããã¬ããŒããè¿ éã«äœæã§ããããŒã¿ ããŒã ãã¶ã€ããŒã䜿çšã§ããŸãã
æåã¯ãPower BI ã Tableau ãããç°¡åã«æããŸãã ããããçµéšããèšãã°ããã°ããããŠãã¢ããªã¹ããããã€ãã®åçŽãªã¬ããŒããäœæããããè€éãªã¬ããŒããå¿ èŠã«ãªã£ãå Žåãããã°ã©ãã³ã°ã®å¿ èŠæ§ã«çŽé¢ããããšã«ãªããŸãã
Qlik ã«ã¯ãããŒã¿ã®ããŒããšåŠçã®ããã®éåžžã«åŒ·åãªèšèªãåãã£ãŠããŸãã ç¬èªã®æ°åŒèšèªã§ãã Set Analysis ãåããŠããŸãã ãããã£ãŠãã¢ããªã¹ãã¯ã¯ãšãªãšæ¥ç¶ãäœæããä»®æ³ããŒãã«ã«ããŒã¿ãé 眮ããå€æ°ãç©æ¥µçã«äœ¿çšã§ããå¿ èŠããããŸãã ãã®èšèªã®æ©èœã¯éåžžã«å¹ åºãã§ãããåŠç¿ãå¿ èŠã§ãã ããããç§ãç¥ã£ãŠãã Qlik ã¢ããªã¹ãã¯å šå¡ãäœããã®æ¬æ Œç㪠IT ã®ããã¯ã°ã©ãŠã³ããæã£ãŠããŸãã
ç§ãã¡ã®ãã㪠Qlik ã€ã³ãã°ã¬ãŒã¿ã¯ãããŒã¿ãããŒããããšãã«ãã¹ãŠã RAM ã«é 眮ãããããŒã¿éã®æ¥ç¶ããã©ãããã©ãŒã ã®å éšã¡ã«ããºã ã«ãã£ãŠå®è¡ãããé£æ³ã¢ãã«ã«ã€ããŠãã話ããŸãã å€ãéžæãããšãã«ãåŸæ¥ã®ããŒã¿ããŒã¹ã®ããã«å éšãµãã¯ãšãªã¯å®è¡ãããŸããã äºåã«ã€ã³ããã¯ã¹ä»ããããå€ãšé¢ä¿ã«ãããããŒã¿ã¯ã»ãŒå³åº§ã«æäŸãããŸãã
確ãã«ãå®éã«ã¯ããã«ããããã£ãŒã«ãåãäžèŽãããšèªåããŒãã«çµåãäœæãããŸãã ããšãã°ãåããã£ãŒã«ããæã€ãªã¬ãŒã·ã§ã³ã·ããã®ãªãç°ãªãããŒãã«ãäœæããããšã¯ã§ããŸããã ããã«ã¯æ £ããªããã°ãªããŸããã åã®ååãå€æŽããŠååãäžèŽããªãããšã確èªãããããã¹ãŠã®ãã¡ã¯ã ããŒãã«ã XNUMX ã€ã«çµåããŠã¹ã¿ãŒ ã¿ã€ãã®ãã£ã¬ã¯ããªã§å²ãå¿ èŠããããŸãã ããããåå¿è ã«ãšã£ãŠã¯äŸ¿å©ã§ãããçµéšè±å¯ãªã¢ããªã¹ãã«ãšã£ãŠã¯åé¡ã§ã¯ãããŸããã
ã¢ããªã¹ããããŒã¿ãããŒãããŠåŠçããããã®äžè¬çãªã€ã³ã¿ãŒãã§ã€ã¹ã¯æ¬¡ã®ããã«ãªããŸãã
å³ 3. Qlik Sense ããŒã¿ ããŒã ãšãã£ã¿ãŒãã«ã¬ã³ã㌠ããŒãã«
泚: Power BI ã§ã¯éåžžãç¶æ³ãç°ãªããŸããç°ãªããã¡ã¯ã ããŒãã«ãšåç §ããŒãã«ãæ®ããåŸæ¥ã®æ¹æ³ã§ããŒãã«ãæåã§çµåã§ããŸãã æåã§åãçžäºã«æ¯èŒããŸãã
ã¿ãããŒ
éçºè
ã¯ãã¢ããªã¹ããç¬èªã«ããŒã¿ã調æ»ã§ãã䟿å©ã§ãã¬ã³ããªãŒãªã€ã³ã¿ãŒãã§ã€ã¹ãåãã BI ãšã㊠Tableau ãäœçœ®ä»ããŠããŸãã ã¯ããç§ãã¡ã®äŒç€Ÿã«ã¯ãIT ã®çµéšããªããŠãã¬ããŒããäœæã§ããã¢ããªã¹ããããŸããã ãã ããããã€ãã®çç±ãã Tableau ã®è©äŸ¡ãäžããŸãã
â ãã·ã¢èªã®ããŒã«ã©ã€ãŒãŒã·ã§ã³ã匱ã
â Tableau Online ãµãŒããŒã¯ãã·ã¢é£éŠã«ãããŸãã
â ããªãè€éãªããŒã¿ ã¢ãã«ãæ§ç¯ããå¿
èŠãããå Žåãéåžžã«åçŽãªããŒã ã³ã³ã¹ãã©ã¯ã¿ãŒã§ã¯åé¡ãçºçãå§ããŸãã
å³ 4. Tableau ããŒã¿ ããŒã ãã«ããŒ
Tableau ã¢ããªã¹ããžã®ã€ã³ã¿ãã¥ãŒäžã«ç§ãã¡ãå°ãã質åã® XNUMX ã€ã¯ãããã¹ãŠã XNUMX ã€ã®ããŒãã«ã«ãŸãšããã«ãåç §ããŒãã«ã䜿çšããŠãã¡ã¯ã ããŒãã«ã®ã¢ãã«ãæ§ç¯ããã«ã¯ã©ãããã°ããã§ãã?!ãã§ãã ããŒã¿ ãã¬ã³ãã£ã³ã°ã«ã¯æ éãªäœ¿çšãå¿ èŠã§ãã ãã®ãããªå䜵ã®åŸãç§ã¯ã¢ããªã¹ãã®éã§ããŒã¿ã®éè€ãšã©ãŒãäœåºŠãä¿®æ£ããŠããŸããã
ããã«ãTableau ã«ã¯ããªããŠããŒã¯ãªã·ã¹ãã ããããåã°ã©ããåå¥ã®ã·ãŒãã«äœæããŠããããã·ã¥ããŒããäœæããäœæããã·ãŒããé 眮ãå§ããŸãã 次ã«ãããŸããŸãªããã·ã¥ããŒããçµã¿åãããã¹ããŒãªãŒãäœæã§ããŸãã ãã®ç¹ã«é¢ããŠã¯ãQlik ããã³ Power BI ã§ã®éçºãããç°¡åã§ããããã«ã°ã©ã ãã³ãã¬ãŒããã·ãŒãã«æå ¥ããã¡ãžã£ãŒãšæž¬å®å€ãèšå®ãããšãããã·ã¥ããŒãã®æºåãæŽããŸãã ãã®ããã§Tableauã§ã®æºåã®äººä»¶è²»ãå¢ããŠãããããªæ°ãããŸãã
2. ããŒã¿ãœãŒã¹ãšããŠã³ããŒã
ãã®ã»ã¯ã·ã§ã³ã«ã¯æ確ãªåè
ã¯ãããŸããããããã€ãã®åªããæ©èœããããããQlik ã«çŠç¹ãåœãŠãŸãã
ç¡æçã® Tableau ã¯ãœãŒã¹ãéãããŠããŸãããèšäºã§ã¯ããžãã¹ã«éç¹ã眮ããŠãããäŒæ¥ã¯åçšè£œåãã¢ããªã¹ãã賌å
¥ããããšãã§ããŸãã ãããã£ãŠãTableau ã¯ãã®ãã©ã¡ãŒã¿ãŒã®è©äŸ¡ãäžããŸããã§ããã
å³ 5. 䜿çšå¯èœãª Tableau ãœãŒã¹ã®ãªã¹ã
ãã以å€ã®å ŽåããœãŒã¹ã®ãªã¹ãã¯ã©ãã§ãå°è±¡çã§ãããã¹ãŠã®ããŒãã« ãã¡ã€ã«ããã¹ãŠã®æšæºããŒã¿ããŒã¹ãWeb æ¥ç¶ãªã©ããã¹ãŠãã©ãã§ãæ©èœããŸãã éæšæºã®ããŒã¿ ã¹ãã¬ãŒãžã«ã¯ééããããšããããŸãããç¬èªã®ãã¥ã¢ã³ã¹ããããããããŸããããã»ãšãã©ã®å ŽåãããŒã¿ã®ããŒãã«åé¡ã¯ãããŸããã å¯äžã®äŸå€ã¯ 1C ã§ãã 1C ãžã®çŽæ¥ã³ãã¯ã¿ã¯ãããŸããã
ãã·ã¢ã® Qlik ããŒãããŒã¯ç¬èªã®ã³ãã¯ã¿ã 100 ïœ 000 ã«ãŒãã«ã§è²©å£²ããŠããŸãããã»ãšãã©ã®å Žåã200C ãã FTPãExcel ãŸã㯠SQL ããŒã¿ããŒã¹ã«ã¢ããããŒãããæ¹ãå®äŸ¡ã§ãã ãŸãã¯ã000C ããŒã¿ããŒã¹ã Web äžã«å ¬éããOdata ãããã³ã«ã䜿çšããŠããã«æ¥ç¶ããããšãã§ããŸãã
PowerBI ãš Tableau ã¯ãããæšæºã§è¡ãããšãã§ããŸãããQlik ã¯ææã®ã³ãã¯ã¿ãèŠæ±ãããããäžéããŒã¿ããŒã¹ã«ã¢ããããŒãããã®ãç°¡åã§ãã ãããã®å Žåã§ããæ¥ç¶ã®åé¡ã¯ãã¹ãŠè§£æ±ºã§ããŸãã
å³ 6. 䜿çšå¯èœãª Qlik Sense ãœãŒã¹ã®ãªã¹ã
ããã«ãQlik ã®ç¹åŸŽãšããŠãææã³ãã¯ã¿ãšç¡æã³ãã¯ã¿ã®äž¡æ¹ãå¥ã®è£œåãšããŠæäŸãããŠããããšã泚ç®ã«å€ããŸãã
å³ 7. è¿œå ã® Qlik Sense ã³ãã¯ã¿
çµéšããã倧éã®ããŒã¿ãå€æ°ã®ãœãŒã¹ã®å Žåãããã« BI ã·ã¹ãã ã«æ¥ç¶ããããšãåžžã«æšå¥šãããããã§ã¯ãªãããšãä»ãå ããŠãããŸãã æ¬æ Œçãªãããžã§ã¯ãã§ã¯ãéåžžãããŒã¿ ãŠã§ã¢ããŠã¹ãåæçšã«ãã§ã«æºåãããããŒã¿ãå«ãããŒã¿ããŒã¹ãªã©ã䜿çšãããŸãã ããšãã° 1 å件ã®ã¬ã³ãŒãã BI ã·ã¹ãã ã«åã蟌ãã§ã¢ããããŒãããããšã¯ã§ããŸããã ããã§ã¯ããœãªã¥ãŒã·ã§ã³ã®ã¢ãŒããã¯ãã£ããã§ã«æ€èšããå¿
èŠããããŸãã
å³ 8. Power BI ããŒã¿ ãœãŒã¹
ãããããªã Qlik ãéžã°ããã®ã§ãããã? ç§ã¯æ¬¡ã® 3 ã€ã®ããšãæ¬åœã«å¥œãã§ãã
- QVDãã¡ã€ã«
ç¬èªã®ããŒã¿ä¿å圢åŒã QVD ãã¡ã€ã«ã®ã¿ã§æ¬æ Œçãªåçšãããžã§ã¯ããæ§ç¯ã§ããå ŽåããããŸãã ããšãã°ãæåã®ã¬ãã«ã¯çããŒã¿ã§ãã XNUMX çªç®ã®ã¬ãã«ã¯åŠçããããã¡ã€ã«ã§ãã XNUMX çªç®ã®ã¬ãã«ã¯éèšããŒã¿ãªã©ã§ãã ãããã®ãã¡ã€ã«ã¯ããŸããŸãªã¢ããªã±ãŒã·ã§ã³ã§äœ¿çšã§ããããŸããŸãªåŸæ¥å¡ããµãŒãã¹ããããã®ãã¡ã€ã«ãæ
åœããå ŽåããããŸãã ãã®ãããªãã¡ã€ã«ããã®ããŠã³ããŒãé床ã¯ãåŸæ¥ã®ããŒã¿ ãœãŒã¹ããã®ããŠã³ããŒãé床㮠XNUMX åã§ãã ããã«ãããããŒã¿ããŒã¹ã®ã³ã¹ããç¯çŽããç°ãªã Qlik ã¢ããªã±ãŒã·ã§ã³éã§æ
å ±ãå
±æã§ããŸãã
â å¢åããŒã¿èªã¿èŸŒã¿
ã¯ããPower BI ãš Tableau ã§ããããè¡ãããšãã§ããŸãã ãã ããPower BI ã«ã¯é«äŸ¡ãª Premium ããŒãžã§ã³ãå¿
èŠã§ãããTableau ã«ã¯ Qlik ã®ãããªæè»æ§ããããŸããã Qlik ã§ã¯ãQVD ãã¡ã€ã«ã䜿çšããŠãããŸããŸãªæç¹ã§ã·ã¹ãã ã®ã¹ãããã·ã§ãããäœæãããã®ããŒã¿ãå¿
èŠã«å¿ããŠåŠçã§ããŸãã
â å€éšã¹ã¯ãªããã®æ¥ç¶
ããŒã¿ãä¿åããããã® QVD ãã¡ã€ã«ã«å ããŠãQlik ã§ã¯ã¹ã¯ãªãã ã³ãŒããã¢ããªã±ãŒã·ã§ã³ã®å€éšã«åãåºããInclude ã³ãã³ãã«çµã¿èŸŒãããšãã§ããŸãã ããã«ãããããŒã äœæ¥ã®çµç¹åãããŒãžã§ã³ç®¡çã·ã¹ãã ã®äœ¿çšãããŸããŸãªã¢ããªã±ãŒã·ã§ã³ã®åäžã³ãŒãã®ç®¡çããã§ã«å¯èœã«ãªããŸãã Power BI ã«ã¯é«åºŠãªã¯ãšãª ãšãã£ã¿ãŒããããŸãããQlik ã®ãããªããŒã äœæ¥ãã»ããã¢ããããããšã¯ã§ããŸããã§ããã äžè¬ã«ããã¹ãŠã® BI ã«ã¯ããã«é¢ããåé¡ãããããã¹ãŠã®ã¢ããªã±ãŒã·ã§ã³ã®ããŒã¿ãã³ãŒããããžã¥ã¢ã©ã€ãŒãŒã·ã§ã³ã XNUMX ãæããåæã«ç®¡çããããšã¯ãŸã£ããäžå¯èœã§ãã ç§ãã¡ãã§ããã®ã¯ãQVD ãã¡ã€ã«ãšã¹ã¯ãªãã ã³ãŒããæœåºããããšã ãã§ããã èŠèŠèŠçŽ ã¯ã¬ããŒãèªäœå
ã§ç·šéããå¿
èŠãããããããã¹ãŠã®ã¯ã©ã€ã¢ã³ãã®èŠèŠåãåæã«å€§èŠæš¡ã«å€æŽããããšã¯ã§ããŸããã
ããããã©ã€ãæ¥ç¶ã®ãããªä»çµã¿ã¯ã©ãã§ãããã? Tableau ãš Power BI ã¯ãQlik ãšã¯ç°ãªããããŸããŸãªãœãŒã¹ãžã® LIVE æ¥ç¶ããµããŒãããŠããŸãã ç§ãã¡ã¯ãã®æ©èœã«ã¯ã©ã¡ãããšãããšç¡é¢å¿ã§ãã å®éã«èŠãŠã¿ããšãããã° ããŒã¿ã«ãªããšãLIVE æ¥ç¶ã§ã®äœæ¥ã¯ãŸã£ããäžå¯èœã«ãªãããšãããããŸãã ãããŠãã»ãšãã©ã®å ŽåãBI ã¯ããã°ããŒã¿ã«å¿ èŠã§ãã
3. ããŒã¿ã¯ãªãŒãã³ã°ãETL (æœåºãå€æãããŒã)
ãã®ã»ã¯ã·ã§ã³ã«ã¯ãQlik Sense ãš Power Bi ãšãã 2 ã€ã®ãªãŒããŒããããŸãã
Qlik ã¯åŒ·åã§ããè€éã ãšã ãèšã£ãŠãããŸãããã SQL ã«äŒŒãèšèªãç解ãããšãä»®æ³ããŒãã«ãããŒãã«ã®çµåãšçµåãããŒãã«ã®ã«ãŒããšæ°ããããŒãã«ã®çæãè¡ãåŠçããããã®äžé£ã®ã³ãã³ããªã©ãã»ãšãã©ãã¹ãŠã®ããšãå®è¡ã§ããããã«ãªããŸãã ããšãã°ããIvanov 1 Belyãã®ãããªããŒã¿ããã®å Žã§å
¥åãã 851 ã€ã®ã»ã«å
ã®ãã£ãŒã«ãã¯ã(誰ã§ãã§ããããã«) 3 åã«å解ã§ããã ãã§ãªããäžåºŠã« 3 è¡ã«å解ããããšãã§ããŸãã 3 ã€ã®è¡ã 1 ã€ã«çµåããããšã§ãåãããšããã®å Žã§ç°¡åã«å®è¡ããããšãã§ããŸãã
å³ 9. Google ã¹ãã¬ããã·ãŒããã Qlik Sense ã«ããŒãã«ãããŒãããŠè»¢çœ®ããæ¹æ³
ãã®ç¹ã§ã¯ Power BI ã®æ¹ãã·ã³ãã«ã«èŠããŸãããã»ãšãã©ã®åé¡ã¯ã¯ãšãª ãã¶ã€ããŒãéããŠç°¡åã«è§£æ±ºã§ããŸãã å€æ°ã®ãã©ã¡ãŒã¿ãŒãèšå®ããããŒãã«ã転眮ããããŒã¿ãæäœããããããã¹ãŠã XNUMX è¡ã®ã³ãŒããè¡ããã«å®è¡ããŸããã
å³ 10. AmoCRM ããããŒãã«ã Power BI ã«èªã¿èŸŒãã§è»¢çœ®ããæ¹æ³
Tableau ã¯ç°ãªãã€ããªãã®ãŒãæã£ãŠããããã«ç§ã«ã¯æããŸãã ãããã¯çŸãããšãã¶ã€ã³ã«éç¹ã眮ããŠããŸãã å€æ°ã®ç°ãªããœãŒã¹ãæ¥ç¶ãããããããã¹ãŠçµã¿åãããŠãTableau å
ã§åŠçããã®ã¯éåžžã«é£ããããã§ãã åçšãããžã§ã¯ãã§ã¯ãã»ãšãã©ã®å ŽåãããŒã¿ã¯ãã§ã« Tableau çšã«æºåããããŠã§ã¢ããŠã¹ãããŒã¿ããŒã¹ã«èç©ãããŠããŸãã
å³ 11. Tableau ã§ããŒãã«ãããŒãããŠè»¢çœ®ããæ¹æ³
4. å¯èŠå
ãã®ã»ã¯ã·ã§ã³ã§ã¯ãªãŒããŒã«çŠç¹ãåœãŠãŸããã§ããã 3 ã€ã®ã±ãŒã¹ã®äŸã䜿çšããŠãXNUMX ã€ã®ã·ã¹ãã ãã¹ãŠã§åãã¬ããŒãã瀺ãå¥ã®èšäºãçšæããŸãã
ç§ã¯ Tableau ã®ã¹ã¿ã€ã«ã奜ãã§ããå³æ Œã§äŒæ¥çã ãšæããŸãã ããããTableau ã§æ¬åœã«çŸããç»åãååŸããã®ã¯å°é£ã§ãã æ¡åŒµæ©èœã®ã¿ã䜿çšãã Tableau ããžã¥ã¢ã©ã€ãŒãŒã·ã§ã³ã®åªããäŸã ãããç¹°ãè¿ãããšã¯ã§ããŸããããªããªã... ç§ã¯ãããã®æ¡åŒµæ©èœãæã£ãŠããŸããããèŠãç®ã¯è¯ãããã§ãã
å³ 12. æ¡åŒµæ©èœãåãã Tableau ã¬ããŒãã®å€èŠ³
Power BI ãé¢çœããã®ã«ããããšãã§ããŸãã
å³ 13. Power B c Extensions ã¬ããŒãã®å€èŠ³
Power BI ã«ã€ããŠç§ãç解ã§ããªãå¯äžã®ããšã¯ããªããã®ãããªå¥åŠãªæ¢å®è²ãããã®ãââãšããããšã§ãã ã©ã®ãã£ãŒãã§ããè²ãèªåã®ãã©ã³ãã®äŒæ¥çšã®è²ã«å€æŽããå¿ èŠãããããã®æšæºçãªè²ã«é©ããŸãã
Qlik Sense ã¯æ¡åŒµæ©èœã«ãäŸåããŸãã ã¢ããªã³ã䜿çšãããšãã¬ããŒããèªèãè¶
ããŠå€æŽãããå¯èœæ§ããããŸãã ç¬èªã®ããŒãããã¶ã€ã³ãè¿œå ããããšãã§ããŸãã
å³ 14. æ¡åŒµæ©èœã䜿çšãã Qlik Sense ã¬ããŒãã®å€èŠ³
éçºè ã®èŠ³ç¹ããèŠããšã代æ¿ãã£ã¡ã³ã·ã§ã³ãã¡ãžã£ãŒãªã©ã®æšæºãªãã·ã§ã³ããããããç§ã¯ Qlik Sense ã奜ã¿ãŸãã èŠèŠåèšå®ã§ããã€ãã®è»žãšã¡ãžã£ãŒãèšå®ã§ãããŠãŒã¶ãŒã¯ç¹å®ã®ãã£ãŒãã§äœãèŠãã¹ãããç°¡åã«èšå®ã§ããŸãã
Power Bi ãš Tableau ã§ã¯ããã©ã¡ãŒã¿ãŒããã¿ã³ãæ§æãããããã®ãã©ã¡ãŒã¿ãŒã«å¿ããŠã·ã¹ãã ã®åäœãããã°ã©ã ããå¿ èŠããããŸãã ãªããããªã«é£ããã®ãäžæè°ã§ãã æªåœ¹ã®çš®é¡ãå€æŽããæ©èœãåæ§ã§ãã
Qlik ã§ã¯ãXNUMX ã€ã®ãªããžã§ã¯ãå ã§ããŸããŸãªçš®é¡ã®ããžã¥ã¢ã©ã€ãŒãŒã·ã§ã³ãé衚瀺ã«ããããšãã§ããŸãããPower BI ãš Tableau ã§ã¯ãããããå°é£ã«ãªããŸãã ç¹°ãè¿ããŸãããããã¯æŒå¥è ã®ã¹ãã«ã«å€§ããäŸåããŸãã ã©ã®ãããªã·ã¹ãã ã§ãåäœãäœãããšã¯ã§ããŸãããçµéšããªããã°ãã©ãã«ããŠãè¡šçŸåã®ãªãã°ã©ãã£ãã¯ã¹ã«ãªã£ãŠããŸããŸãã
5. äŒæ¥ç°å¢ - ãµãŒããŒãã¬ããŒã
ãã¹ãŠã®è£œåã«ã¯æ³äººãµãŒã㌠ããŒãžã§ã³ããããŸãã ç§ã¯ãã¹ãŠã®ãšãã£ã·ã§ã³ã䜿çšããŠããŸããããã©ã®ãšãã£ã·ã§ã³ã«ãé·æãšçæããããšèšããŸãã 補åã®éžæã¯ããœãããŠã§ã¢èŠä»¶ã«åºã¥ããŠããã®ãã¥ã¢ã³ã¹ãèæ
®ããŠè¡ãå¿
èŠããããŸãã ãã¹ãŠã®ãã³ããŒã¯ãã¢ã«ãŠã³ã ã¬ãã«ãšã°ã«ãŒã ã¬ãã«ãããã³ããŒã¿è¡ã¬ãã«ã®ã»ãã¥ãªãã£ã®äž¡æ¹ã§æš©éãå²ãåœãŠãããšãã§ããŸãã ã¹ã±ãžã¥ãŒã«ã«åºã¥ããã¬ããŒãã®èªåæŽæ°ãå¯èœã§ãã
Qlik Sense Enterprise ã¯ãäžèŠæš¡äŒæ¥åãã«çµç¹å ã«åæãæ§ç¯ãã絶奜ã®æ©äŒã§ãã ãã㯠Power BI Pro ãããé«äŸ¡ã«èŠãããããããŸããããPower BI Pro ãµãŒããŒã¯ Microsoft é åã®ã¯ã©ãŠãã«é 眮ãããŠãããããã©ãŒãã³ã¹ã«åœ±é¿ãäžããããšã¯ã§ããŸããããŸãããµãŒããŒã«å±éã§ãã Power BI Premium ãå¿ èŠãªå Žåã«ã¯ããã®å Žåãæéã¯æé¡ 5000 ãã«ããå§ãŸããŸãã
Qlik Sense Enterprise ã®äŸ¡æ Œã¯ 230 ã«ãŒãã«ããã§ãã 000 ã©ã€ã»ã³ã¹ (幎é¡æéããã®åŸã¯ãã¯ãã«ã« ãµããŒãã®ã¿) ã§ãPower BI Premium ãããã¯ããã«æé ãªäŸ¡æ Œã§ãã ãŸããQlik Sense Enterprise ã䜿çšãããšãQlik ã®ãã¹ãŠã®æ©èœã䜿çšã§ããããã«ãªããŸãã ããããã5ã€ãé€ããŠã äœããã®çç±ã§ãQlik ã¯ãPDF ã¬ããŒããé»åã¡ãŒã«ã§éä¿¡ããæ©èœãªã©ã®æ©èœãå¥ã® NPrinting ãµãŒãã¹ãšããŠæäŸããå¿
èŠããããšæ±ºå®ããŸããã
ãã ããQlik Sense Enterprise 㯠Power BI Pro ããã匷åã§ããããã次ã®ãããªæ¯èŒãå¯èœã§ãã
Qlik Sense Enterprise = Power BI Premiumãåçã®æ©èœãåããå¹³åçãªå®è£ ã§ã¯ãã³ã¹ããå®ããªãããšãããããŸãã 倧èŠæš¡ãªå®è£ ã¯éåžžããã³ããŒåŽã§èšç®ãããäŒæ¥ã«åå¥ã®æ¡ä»¶ãæäŸã§ããŸãã
ãã®ç¹ã§ãç§ãã¡ã¯ Qlik Sense Enterprise ãåªå
ããŸããQlik Sense Enterprise ã«ã¯ã巚倧ãªããŒã¿ã«å¯ŸããŠæ¬æ Œçãªåæãæ§ç¯ããããããæ©äŒããããŸãã ç§ãã¡ã®æèŠã§ã¯ãQlik ã¯å€§èŠæš¡ãªã¢ã¬ã€ã§ã¯ Power BI ãããé«éã«åäœããŸããQlik ã«ã³ãã¡ã¬ã³ã¹ã§ã¯ãæåã«æ°ååã¬ã³ãŒãã®ããŒã¿ããã¹ãããã¯ã©ã€ã¢ã³ãã«ééããŸããããPower BI ã®æ¹ãæªãçµæã瀺ããŸããã
å³ 15. Qlik Sense Enterprise ãµãŒã㌠ã¬ããŒãã®å€èŠ³
Qlik Sense Cloud = Power BI Proã Qlik Sense Cloud 㯠1.5 åé«äŸ¡ã§ããããšãå€æ*ãããã®ãã©ãããã©ãŒã ã§ã¯èš±å¯ãããªãéåžžã«é倧ãªå¶éããããŸãã çµã¿èŸŒã¿ã®æ¡åŒµæ©èœã§ãã£ãŠããæ¡åŒµæ©èœã䜿çšããããšã¯ã§ããŸããã ãŸããæ¡åŒµæ©èœããªããšãQlik ã¯èŠãç®ã®çŸãããå€å°å€±ãããŸãã
å³ 16. Power BI Pro ã³ã³ãããŒã« ããã«ã®å€èŠ³
*代ããã«ãQlik Sense Enterprise ãµãã¹ã¯ãªãã·ã§ã³ã䜿çšããããšãã§ããŸãã ãã ãããã®èšäºãåºåãšããŠèªèãããªãããã«ãäŸ¡æ Œã«ã€ããŠã¯ã«ããŒããŸããã
ãããŠãTableau ã¯ç§ãã¡ã®ããã«å°ãèã«ç«ã£ãŠããŸãã éçºè ããã 70 ãã«ããã¥ãŒããã 15 ãã«ã®ã¯ã©ãŠã ãµãã¹ã¯ãªãã·ã§ã³ãšãé«äŸ¡ãªãµãŒã㌠ãœãªã¥ãŒã·ã§ã³ã®äž¡æ¹ãæäŸããŠããŸãã ããããTableau ã®äž»ãªã¢ã€ãã¢ã¯ãããã°ããŒã¿ã®å Žåã¯ããŒã¿ã®åŠçãšã¹ãã¬ãŒãžããµã€ãã§æŽçããå¿ èŠããããšããããšã§ãã 客芳çã«èŠãŠãæ©èœãå°ãªããšãTableau ã§æ¬æ ŒçãªããŒã¿åŠçãã§ããªããªããŸãã å¯èŠåãåæãã¯ãã ããããäžå°äŒæ¥ã®å Žåãå¥åã®ã¹ãã¬ãŒãžãäœæããããšã¯éåžžåé¡ã«ãªããŸãã ãããã£ãŠããã® 1 ã€ã®æ©èœããªããã°ãTableau ã®ã¹ã³ã¢ãäžããŠããã§ãããã Tableau Server ã¯ãCSV ãŸã㯠PDF ã®æ·»ä»ãã¡ã€ã«ãå«ãã¹ã±ãžã¥ãŒã«ãããé»åã¡ãŒã«ãã·ãŒã ã¬ã¹ã«éä¿¡ããŸãã ããã«ãæš©å©ããªãŒããã£ã«ã¿ãŒãªã©ãé åžããããšãã§ããŸãã äœããã®çç±ã§ Power BI ãš Qlik ã§ã¯ãããå®è¡ã§ããŸããããäžéšã®äººã«ãšã£ãŠã¯éèŠãªå ŽåããããŸãã ãã®ãããTableau ã¯ç§ãã¡ã®çŽäºã«ãããŠæå©ãªç«å Žãä¿ã£ãŠããŸãã
å³ 17. Tableau Server ã³ã³ãããŒã« ããã«ã®å€èŠ³
ãŸããäŒæ¥ç°å¢ã§ã¯ãå°å ¥ãšä¿å®ã®ã³ã¹ãã«ã€ããŠãèæ ®ããå¿ èŠããããŸãã ãã·ã¢ã§ã¯ãå°èŠæš¡äŒæ¥ã§ã¯ Power BI ãããäžè¬çã«ãªããšããæ £è¡ãçºå±ããŸããã ããã«ããã倧éã®æ¬ å¡ãå±¥æŽæžãçºçããå°èŠæš¡ãªã€ã³ãã°ã¬ãŒã¿ãŒãåºçŸããŸããã ããã«ãããå°èŠæš¡ãªãããžã§ã¯ãã®ã¹ãã·ã£ãªã¹ããèŠã€ããããšãã§ããŸãã ããããã»ãšãã©ã®å Žåã圌ãã¯å šå¡ã倧èŠæš¡ãªå®è£ ãããã°ããŒã¿ã®æäœã®çµéšããããŸããã Qlik ãš Tableau ã¯ãã®éã§ãã Qlik ããŒãããŒã¯ã»ãšãã©ãªããTableau ããŒãããŒã¯ããã«å°ãªãã§ãã ãããã®ããŒãããŒã¯ã倧èŠæš¡ãªå¹³åãã§ãã¯ã䌎ã倧èŠæš¡ãªå®è£ ãå°éãšããŠããŸãã åžå Žã«ã¯æ±äººæ å ±ãå±¥æŽæžãããã»ã©å€ããªãããããããã®è£œåã«åå ¥ããéå£ã¯ Power BI ãããå°é£ã§ãã ãããããã·ã¢ã§ã¯ãããã®è£œåãäœåãã®ãŠãŒã¶ãŒã«å°å ¥ããããšã«æåããŠããããããã®è£œåã¯ããã°ããŒã¿äžã§åªããããã©ãŒãã³ã¹ãçºæ®ããŸãã å¿ èŠãªã®ã¯ãèªç€Ÿã®ããžãã¹ã«ç¹ã«åœãŠã¯ãŸã補åã®é·æãšçæãç解ããããšã ãã§ãã
6. ã¢ãã€ã«ããã€ã¹ã®ãµããŒãã
ãã®ã»ã¯ã·ã§ã³ã§ã¯ãPower BI ãš Tableau ã«çŠç¹ãåœãŠãŸãã ã¢ãã€ã« ã¢ããªã±ãŒã·ã§ã³ãã€ã³ã¹ããŒã«ãããšãã¢ãã€ã« ããã€ã¹ã®ç»é¢äžã§é©åã«è¡šç€ºãããŸãã ãã ããã¢ãã€ã« ããã€ã¹ã§ã®åæ㯠PC ã§ã®åæãããå£ã£ãŠããããã«æããŸãã ãšã¯ããããã£ã«ã¿ãŒã䜿ãã«ãããåçãå°ãããæ°åãèŠã«ãããªã©ããããããããŸãã
å³ 18. iPhone ã§ã® Power BI ã¬ããŒãã®å€èŠ³
å³ 19. iPhone ã§ã® Tableau ã¬ããŒãã®è¡šç€º
å³ 20. iPhone ã§ã® Qlik Sense ã¬ããŒãã®è¡šç€º
Qlik ã¹ã³ã¢ãäœäžããã®ã¯ãªãã§ãã? çç±ã¯äžæã§ãããã¢ãã€ã« ã¯ã©ã€ã¢ã³ã㯠iPhone ã§ã®ã¿å©çšå¯èœã§ãããAndroid ã§ã¯éåžžã®ãã©ãŠã¶ã䜿çšããå¿ èŠããããŸãã ããã«ãQlik ã䜿çšããå Žåãå€ãã®æ¡åŒµæ©èœãããžã¥ã¢ã©ã€ãŒãŒã·ã§ã³ãåæžãããŠããªãããšããŸãã¯ã¢ãã€ã« ããã€ã¹å ã§è»äž¡ãæåŸ ã©ããã«é 眮ãããŠããªãããšãããã«ç解ããå¿ èŠããããŸãã PC ã§ã¯éåžžã«çŸããèŠããã¬ããŒãããå°ããªç»é¢ã§ã¯éåžžã«èŠèŠãããªããŸãã ã¢ãã€ã« ããã€ã¹çšã«å¥ã®ã¬ããŒããäœæããå¿ èŠããããŸãããã®ã¬ããŒãã§ã¯ããã£ã«ã¿ãŒãKPIããã®ä»ã®å€ãã®ãªããžã§ã¯ããåé€ã§ããŸãã ãã㯠Power BI ã Tableau ã«ãåœãŠã¯ãŸããŸãããQlik ã§ã¯ç¹ã«é¡èã§ãã Qlik ãä»åŸãã¢ãã€ã« ã¯ã©ã€ã¢ã³ãã«åãçµã¿ç¶ããããšãé¡ã£ãŠããŸãã
ã¢ãã€ã« ããã€ã¹ããã®åæã®å®æœã«å€ãã®æéãè²»ããäºå®ãããå Žåã¯ã3 ã€ã®ã¯ã©ã€ã¢ã³ãããã¹ãŠã€ã³ã¹ããŒã«ãããã¹ã ã¬ããŒãã§ã®è¡šç€ºã確èªããããšãåççã§ãã ã©ã®ãã³ããŒã§ããWeb ãµã€ãã«ãã¹ã ã¬ããŒãã®ã®ã£ã©ãªãŒããããã¬ãã¥ãŒã§ããŸãã
7. ãµãŒãããŒãã£ã®ã¢ããªã±ãŒã·ã§ã³/ãµã€ãã®åã蟌㿠(çµã¿èŸŒã¿) åæ
åæããµãŒãããŒã㣠ãµãŒãã¹ãšããŠäœ¿çšããããšã¯ãå¿
ããã䟿å©ã§ãããšã¯éããŸããã ãããããç¬èªã®è£œåãéçºããŠãããã®ã®ãèŠèŠåããã³åæãšã³ãžã³ãæåããéçºããæºåãã§ããŠããªãå¯èœæ§ããããŸãã ãããããã¯ã©ã€ã¢ã³ããèªåèªèº«ãç»é²ããããŒã¿ãã¢ããããŒãããå人ã¢ã«ãŠã³ãå
ã§åæãå®è¡ã§ããããã«ãWeb ãµã€ãã«åæãå°å
¥ããããšèããŠããŸãã ãããè¡ãã«ã¯ãçµã¿èŸŒã¿ã®åæ (çµã¿èŸŒã¿) ãå¿
èŠã§ãã
ãã¹ãŠã®è£œåã§ãããè¡ãããšãã§ããŸããããã®ã«ããŽãªã§ã¯ Qlik ã«çŠç¹ãåœãŠãŸãã
Power Bi ãš Tableau ã§ã¯ããã®ãããªç®çã®ããã«ã¯ãå¥ã® Tableau Embedded Analytics ãŸã㯠Power BI Embedded 補åãè³Œå ¥ããå¿ èŠããããšæ確ã«è¿°ã¹ãŠããŸãã ãããã¯æé¡æ°åãã«ãããå®äŸ¡ãªãœãªã¥ãŒã·ã§ã³ã§ã¯ãªããããããã«äœ¿çšãå¶éãããŸãã ã»ãšãã©ã®ãããžã§ã¯ãã¯ãããã«ã¯ã©ã€ã¢ã³ãã«ãšã£ãŠå©çãåŸãããªããªããŸãã ã€ãŸããã¬ããŒããã€ã³ã¿ãŒãããå šäœã«å ¬éããã ãã§ãªããããŒã¿ä¿è·ããŠãŒã¶ãŒèªèšŒãªã©ãåããç¹å®ã®ã¢ã¯ã»ã¹ã«åŸã£ãŠã¬ããŒããå ¬éãããããã«ããå¿ èŠããããŸãã
ãã㊠Qlik ã䜿ãã°ããããæãåºãããšãã§ããŸãã ãã¡ããããµãŒããŒããšã«ã©ã€ã»ã³ã¹ãä»äžãããç¡å¶éã®æ¥ç¶ãçµç¹ãã Qlik Analytics Platform ãåããŠããŸãã ãŸãã競åä»ç€Ÿã® Tableau ã Power Bi ãšåæ§ã«é«äŸ¡ã«ãªããŸãã ãŸããç¡å¶éã®æ¥ç¶ã®å Žåãéžæè¢ã¯ããã»ã©å€ããããŸããã
ããããQlik ã«ã¯ããã·ã¥ã¢ããã®ãããªãã®ããããŸãã Qlik Sense Enterprise ãš 10 åã®ã©ã€ã»ã³ã¹ããããšããŸãã æšæºçãªåæãå€èŠ³ããã¹ãŠããã§ã«éå±ã§ãã ç¬èªã® Web ãµã€ããŸãã¯ã¢ããªã±ãŒã·ã§ã³ãæ§ç¯ãããšãããã«ãã¹ãŠã®åæãå®è£ ã§ããŸãã ç°¡åã«èšããšãããã·ã¥ã¢ããã¯ããã°ã©ã ã³ãŒãã®èŠèŠåã§ãããšããããšãéèŠã§ãã API ã䜿çšãããšãã¢ããªã±ãŒã·ã§ã³ãŸã㯠Web ãµã€ãå ã§ããžã¥ã¢ã©ã€ãŒãŒã·ã§ã³ãããã°ã©ã ã§äœæã§ããŸãã ã©ã€ã»ã³ã¹ (ãµã€ãæ¥ç¶ã®ã©ã€ã»ã³ã¹ = BI ãžã®æ¥ç¶ã®ã©ã€ã»ã³ã¹) ãããŒã¿ã®ããŒããªã©ã«ã¯ Qlik Sense Enterprise ãåŒãç¶ãå¿ èŠã§ãããããžã¥ã¢ã©ã€ãŒãŒã·ã§ã³ã¯ãã®ãµãŒããŒã®åŽã«ã¯è¡šç€ºãããªããªãããµãŒããŒã«çµã¿èŸŒãŸããŸããã¢ããªã±ãŒã·ã§ã³ãŸãã¯ãŠã§ããµã€ãã CSS ã¹ã¿ã€ã«ã䜿çšããããæ°ãããã©ã³ããè²ãèšå®ãããã§ããŸãã 10 人ã®ãŠãŒã¶ãŒã¯åæãµãŒããŒã«ã¯ãã°ã€ã³ããªããªããŸãããäŒæ¥ããŒã¿ã«ãŸãã¯ã¢ããªã±ãŒã·ã§ã³ã䜿çšããããšã«ãªããŸãã åæã¯æ°ããªã¬ãã«ã«å°éããŸãã
å³ 21. Web ãµã€ãã«åã蟌ãŸãã Qlik Sense ã¬ããŒãã®å€èŠ³
ãµã€ãèŠçŽ ãã©ãã«ããã®ããã©ããã Qlik Sense ãå§ãŸãã®ããç解ããã®ã¯å°é£ã§ãã
ãã¡ãããããã°ã©ããŒã XNUMX 人ããããã¯ããã«è€æ°äººå¿
èŠã«ãªããŸãã XNUMX ã€ã¯ Web ããã°ã©ãã³ã°çšã§ããã XNUMX ã€ã¯ Qlik API ã®æäœçšã§ãã ããããçµæã«ã¯ããã ãã®äŸ¡å€ããããŸãã
çµè«ã èŠçŽããŸãããã
誰ãåªããŠããŠèª°ãå£ã£ãŠããããæ確ã«èšãããšã¯å°é£ã§ãã Power BI ãš Qlik ã¯ç«¶åä»ç€Ÿã§ã¯åçã§ãããTableau ã¯ãããã«å£ã£ãŠããŸãã ããããããããããªãã®ããžãã¹ã§ã¯çµæã¯ç°ãªãã§ãããã BI ãã©ãããã©ãŒã ã§ã¯ãããžã¥ã¢ã« ã³ã³ããŒãã³ããéåžžã«éèŠã§ãã ãã¹ãŠã® BI ã·ã¹ãã ã«ã€ããŠãã€ã³ã¿ãŒãããäžã§äœåãã®ã㢠ã¬ããŒããåçãèŠãŠãããããã®ãã©ãããã©ãŒã ã®èŠãç®ãæ°ã«å
¥ããªãå Žåã¯ãããšãäŸ¡æ Œãæè¡çã«æºè¶³ããŠããŠãããããããããå°å
¥ããªãã§ãããããµããŒãã ç¹åŸŽã
次ã«ãBI ãã©ãããã©ãŒã ã®ã©ã€ã»ã³ã¹ãå®è£ ãã¡ã³ããã³ã¹ã®ã³ã¹ããèšç®ããå¿ èŠããããŸãã ããããããªãã®å ŽåããªãŒããŒãç¹å®ãããã§ãããã è«è² æ¥è ããŸãã¯é©åãªå°é家ãéãèœåã¯éåžžã«éèŠã§ãã ã©ã®ãã©ãããã©ãŒã ã§ãå°é家ãããªããšãæ²æšãªçµæã«ãªããŸãã
BI ã®çµ±åãæåãããŸããããAnalytics ã°ã«ãŒãã® Andrey Zhdanov æ°ãš Vladimir Lazarev æ°
åºæïŒ habr.com