BIããŒã«ãšExcelã®éããšã¯ïŒã§ããããšãåªããŠãããã€ã³ã

BIããŒã«ãå°å
¥ããããšæã£ãŠããçš®é¡ããããããã£ãŠã©ããã£ãŠéžã¹ã°ããã®ïŒãšè¿·ããŸãããããããªå£°ã«ãå¿ãããŠãSaaSå°å
¥æšé²è
ãéžã¶ãµã€ã第1äœâ»ãã®BOXILãããããBIããŒã«ãå³éžããã§ãã¯ããããµãŒãã¹ã®çŽ¹ä»è³æããŸãšããŠããŠã³ããŒãã§ããŸãã
âãç¹å
žæ¯èŒè¡šã€ããBIããŒã«ã®è³æããŠã³ããŒãã¯ãã¡ãïŒç¡æïŒ
â»2020幎9æå®æœ æ ªåŒäŒç€Ÿã·ã§ãããŒãºã¢ã€ãSaaSæ¯èŒã¡ãã£ã¢ã«é¢ããã€ã¡ãŒãžèª¿æ»ããã
ç®æ¬¡ãéãã
BIããŒã«ãšExcelã®éã
BIããŒã«ãšExcelã®éãã¯ãæ±ãããŒã¿éãäž»ãªæ©èœãå°å ¥ã®é£æ床ãªã©ã«ãããŸããBIããŒã«ã¯ãããŒã¿ã®æ ŒçŽå ããåã蟌ãã§åæãããã倧ããããŒã¿ã«å¯Ÿå¿ã§ããåé¢ãéçšã«ããããŸã§ã®å·¥æ°ã倧ãããªããã¡ã§ããå察ã«Excelã¯ãç°¡åãªé¢æ°ãã°ã©ãã§ããã°ããŠã³ããŒãããŠãã䜿ãã¯ãããããã¡ãªããã¯ãããã®ã®ãè€éãªåæã¯èŠæãšããŠããŸãã
BIããŒã« | Excel | |
---|---|---|
æ±ããããŒã¿ã®å€§ãã | 倧ãã | å°ãã |
äž»ãªæ©èœ | å€æ¬¡å åæïŒOLAPïŒãã¬ããŒãã£ã³ã°ãããã·ã¥ããŒããããŒã¿ãã€ãã³ã° | ååæŒç®ãç°¡æçãªã°ã©ãåãããããããŒãã« |
å°å ¥ã®ããŒãã« | é«ã | äœã |
BIããŒã«ã§ã§ããããš
BIãšã¯Business Intelligenceã®ç¥ã§ãèšå€§ãªããŒã¿ãåæãææ決å®ãæ¯æŽããããšã§ãããBIããŒã«ã¯ãããå¯èœã«ããããŒã«ã®ããšã§ããBIããŒã«ã¯ãããã¯ããŒã¿ã掻çšã§ããããšã§æåã«ãªã£ãããŒã«ã§ãããŒã¿åæã«æ欲çãªäŒæ¥ã«å°å ¥ãããŠããŸãã
BIããŒã«ã§ãã䜿ãããæ©èœã«ã¯å€æ¬¡å åæïŒOLAPïŒãã¬ããŒãã£ã³ã°ãããã·ã¥ããŒããããŒã¿ãã€ãã³ã°ãªã©ããããããã¯ããŒã¿ãäž»ãªå¯Ÿè±¡ã§ããExcel以äžã«å€§èŠæš¡ã§è©³ããåæã§ããã®ãBIããŒã«ã®åŒ·ã¿ãšèšããã§ãããã

Excelã§ã§ããããš
Excelãšã¯ããã€ã¯ããœãããæäŸããè¡šèšç®ãœããã§ãWordãPowerPointãªã©ã®Officeã·ãªãŒãºã®1ã€ãšããŠç¥ãããŠããŸãã矩åæè²ã®ææ¥ã§åãæ±ãããã±ãŒã¹ãå€ããäžä»£ãç°å¢ãåããåºãå©çšãããŠããã®ãç¹åŸŽã§ãã
ãã¡ããããžãã¹ã§ãåºã䜿ãããŠãããããŒã¿ã®éèšãåæã調æ»ããã¬ãŒã³ããŒã·ã§ã³ãªã©å€ãã®å Žé¢ã§æŽ»çšãããŠããŸãã
Excelã®ãããªæ©èœã玹ä»ããŸãã
- ã¯ãã¹éèš
- é¢æ°
- ã°ã©ã
- äºæž¬ã·ãŒã
ã¯ãã¹éèšãšã¯ãããããããŒãã«ã䜿çšãã2ã€ã®ç°ãªãã«ããŽãªãŒïŒè»žïŒãçšããŠããŒã¿ãåæããæ©èœã§ããããŒã¿ãå ¥åããã ãã§ãè³Œå ¥åºèå¥ã䜿çšè å¥ãªã©ãããŸããŸãªè§åºŠããã®åæãè¡ããŸãã
é¢æ°ã¯ãç¹å®ã®æ°å€ãåãåããå®ããããæäœãå®è¡ããŠçµæãåºåããæ©èœã§ããããšãã°ãæå®ãããã»ã«ã®å€ãåç®ããSUMé¢æ°ãããç¥ãããŠããŸãããªããExcelã«ã¯SUMé¢æ°ä»¥å€ã«ããããŸããŸãªé¢æ°ãçšæãããŠãããããŸããŸãªèšç®ãããŒã¿åŠçãå¯èœã§ãã
ãŸããExcelã«ã¯å€æ§ãªã°ã©ãã®ãªãã·ã§ã³ãçšæãããŠãããExcel 2016ã§ã¯æ°ãã«ããŠã©ãŒã¿ãŒãã©ãŒã«ããããµã³ããŒã¹ããããããªãŒããããããç®±ã²ãå³ããããã¹ãã°ã©ã ããšãã£ã5ã€ã®ã°ã©ãã¿ã€ããå ãããŸãããããã«ãã©ã®ã°ã©ãã䜿çšãã¹ããã決ããã®ã«åœ¹ç«ã€ãããããã°ã©ããæ©èœãæäŸãããŠããŸããããã«ããããŠãŒã¶ãŒã¯ããå¹æçãªããŒã¿è¡šç€ºæ¹æ³ãç°¡åã«èŠã€ããããŸãã
äºæž¬ã·ãŒãæ©èœã¯ãæé売äžã®æšç§»ã®ãããªæç³»åããŒã¿ãããšã«ãå°æ¥ã®å€åãExcelãäºæž¬ãããã®ã§ããäºæž¬ã®çµæã¯ãªã¬ã³ãžè²ã®ç·ã§ç€ºãããäºæž¬å€ãšãã®äžéã»äžéã®3çš®é¡ã®ããŒã¿ã衚瀺ãããŸããåºæ¬ãšãªãããŒã¿ãå°ãªãå Žåã粟床ã«äžå®ããããšã®æèŠããããŸãããåæã®åèã«ã¯ãªãã§ãããã
ExcelããBIããŒã«ãåªããŠããæ©èœ
ããã§ã¯ãBIããŒã«ã«ç¹åŸŽçãªæ©èœãç¹åŸŽã«ã€ããŠãExcelãšæ¯èŒããªãã解説ããŸãã
è€æ°ããŒã¿ããŒã¹ã®åç §
BIããŒã«ã§ã¯ãè€æ°ã®ããŒã¿ããŒã¹ãåç §ããŠåæãã§ããŸãããªã³ãã¬ãã¹åBIããŒã«ã®å Žåã¯å£²äžæ å ±ãäŒèšæ å ±ãããšã«åæãã§ããã¯ã©ãŠãåBIããŒã«ã®å Žåã¯ããã«å ãããœãŒã·ã£ã«ã¡ãã£ã¢ãšãã£ããªã³ã©ã€ã³ã®æ å ±ã掻çšã§ããŸããExcelã®å Žåã¯ããŒã¿ãåã蟌ãæ段ã«ä¹ããã®ã«å¯ŸããBIããŒã«ãªãExcelåºåããããŒã¿ã¯ãã¡ãããããå€æ¹é¢ããããŒã¿ãåéããŠæŽ»çšå¯èœã§ãã
ãŸãBIããŒã«ã®APIã掻çšããã°ãèªåã§ããŒã¿åéãããŒã¿åŠçãè¡ããŸããAPIé£æºã¯ä»ç€Ÿã®CMSãMAãDMP/CDPãšBIããŒã«ãã€ãªãã§èªååã§ãããããããå¹çããããŒã¿æŽ»çšãã§ããã§ãããã
ããã°ããŒã¿ã®åŠç
BIããŒã«ã¯ããã°ããŒã¿ã«ãExcelã¯å°éããŒã¿ã«é©ããŠããŸããExcelã§ãå€å°ã®å€§ããã§ããã°ããŒã¿åŠçãã§ãããã®ã®ãããŸãã«å€§ããªå Žåã¯åŠçã«æéãããã£ãããåŠçéãéçãè¶ ããŠã¢ããªãèœã¡ããããŸãããšã¯ãããBIããŒã«ã®ãªãã§ãäžå°äŒæ¥åãã®ããŒã«ã§ã¯å€§ããããããŒã¿ã«å¯Ÿå¿ã§ããªãå¯èœæ§ããããããäºåã«äœ¿çšæã確ããããšããã§ãããã
ããã°ããŒã¿ã®åŠçé床
BIããŒã«ã¯éåžžã倧èŠæš¡ãªããŒã¿åŠçãæ³å®ããŠèšèšããããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ç®¡çã·ã¹ãã ïŒRDBMSïŒãæ¡çšããŠããã倧éã®ããŒã¿ã§ãè¿ éã«åŠçãè¡ããããããŠãŒã¶ãŒã®åŸ ã¡æéãæå°éã«æããŸãã
ããã«å¯ŸããŠãExcelã§ã¯ããŒã¿éãå€å°å¢ããã ãã§åŠçé床ãäœäžããæã«ã¯ããªãŒãºããããšããããŸãããã®ç¹ãèæ ®ãããšãBIããŒã«ãçšããããšã§ããå¹ççã«äœæ¥ã®é²è¡ãå¯èœã§ãã
ããŒã¿å ±æ
ã¯ã©ãŠãã®BIããŒã«ã§ããã°ãURLãéãããšã§ããŒã¿ã容æã«å ±æã§ããŸããExcelã¯ãäœæããã¬ããŒããã¡ãŒã«ã«æ·»ä»ããããå ±æã®ãã¡ã€ã«ãµãŒããŒã«ä¿åããŠé£çµ¡ããå¿ èŠãããã§ããããBIããŒã«ãã¯ã©ãŠãã§å©çšããŠããã°ã瀟å ã§ã®ãããšãã¯ãã¡ãããã·ã¹ãã ã«ãã£ãŠã¯ç€Ÿå€ãšã®ã³ãã¥ãã±ãŒã·ã§ã³ãã¹ã ãŒãºã«ãªããŸãã
è€æ°äººã§åæã«ç·šé
BIããŒã«ã¯ãè€æ°äººãåæã«äœ¿ãæ³å®ãããŠèšèšãããŠãããããåäžã®ããŒãžã§ãªããã°åãã¿ã€ãã³ã°ã§ç·šéå¯èœã§ããExcelã®å Žåã¯ããã¡ã€ã«ãç·šéããä»çµã¿äžã1人ãç·šéããŠããéã¯ä»ã®äººãåŸ æ©ããããåŸãŸããããããBIããŒã«ã§ããã°ãåæã«ããŒã¿ã®æœåºãåæãè¡ããããã¹ããŒãã£ãŒã«äœæ¥ãé²ããããŸãã
ããŒã¿ããŒã¹ã®æŽæ°ãåæ
BIããŒã«ã¯ãå€éšã®ããŒã¿ããŒã¹ãšé£æºããŠãããããªã¢ã«ã¿ã€ã ã§ããŒã¿ãæŽæ°ã§ããŸããExcelã§ãç°å¢ãæŽããã°åæ§ã®ç¶æ³ãåçŸã§ãããã®ã®ãæå°éã®èŠæš¡ã§éçšãé²ããå ŽåããŸãæ©æµã¯åããããªãã§ããããäžæ¹ãBIã¯ããŒã¿ããŒã¹ãæŽæ°ããããšãèªåçã«ææ°ã®æ å ±ãé©çšããããããéœåºŠæŽæ°ããã«ãã¿ãŸãã
å€åœ©ãªåæçµæãšã¬ããŒãã®äœæ
BIããŒã«ã§ã¯ãåæã®æ¹æ³ãããã衚瀺ããã°ã©ãã®çš®é¡ãè±å¯ã§ãããããããèŠãããã¬ããŒããäœæã§ããŸããExcelã§ãããŒã¿åæãã¬ããŒãäœæã¯ã§ããŸãããçš®é¡ãéãããŠããŠãããŒã¿ã«å€åããããã³ã«äœãçŽããããªããã°ãªããŸããã
äžæ¹ã§BIããŒã«ã¯ExcelãšéããããŠã¹ã®ãã©ãã°&ããããã ãã§å€åœ©ãªã°ã©ããäœæã§ããããŒã¿ãæŽæ°ãããã°ã°ã©ããèªåã§æŽæ°ãããŸãããŸãããŒã¿ãå€è§çã«çµã¿åãããã¬ããŒããäœæã§ããããã·ã¥ããŒãã«ãŸãšããã°äžç®ã§çµå¶ç¶æ³ãææ¡å¯èœã§ãã
æš©éãèšå®å¯èœ
Excelãã¡ã€ã«ã®ã»ãã¥ãªãã£ã確ä¿ããéã«ã¯ãäžè¬çã«ãŠãŒã¶ãŒããã¡ã€ã«ã«ãã¹ã¯ãŒããèšå®ããããæ å ±ã·ã¹ãã éšéã®ç®¡çè ããã¡ã€ã«ãµãŒããŒäžã§ã¢ã¯ã»ã¹æš©ã管çããæ¹æ³ãããçšããããŸããããããBIããŒã«ãå©çšããå Žåã¯ããŠãŒã¶ãŒèªèº«ããã©ã«ãããã¡ã€ã«ã¬ãã«ã§çŽæ¥æš©éãèšå®å¯èœã§ããããã«ãããããå¹ççã«ã·ã¹ãã ã®éçšãå¯èœã«ãªããŸãã
ExcelãšBIããŒã«ã®äœ¿ãããæ¹
åè¿°ããããã«ãããŒã¿åéãåæã®èœåã«åªããŠããã®ã¯BIããŒã«ã§ãããBIããŒã«ã¯å°å ¥è²»çšã®é«ããéçšã®é£ããããããã¹ãŠã®äŒæ¥ãæ¥åã«å§ããããããã§ã¯ãããŸããããã®ããã次ã«ã©ã®ãããªã·ãŒã³ã§ExcelãšBIããŒã«ã䜿ããããã¹ããã詳ãã解説ããŸãã
Excelã®å©çšã·ãŒã³
- ã·ã³ãã«ãªããŒã¿ã ãã§è¡šãã°ã©ããäœæããã
- äžäººã ãã§äœæ¥ãè¡ããæ å ±å ±æãå¿ èŠãªã
- ããŒã¿ã®éãå°ãªãäœæ¥è² æ ããªãåæ
- ããŒã¿ããŒã¹ã«ã¢ã¯ã»ã¹ã§ããªãå Žåã®éèšã»åæ
- å°æ¥çã«ããŒã¿ãæŽæ°ããå¿ èŠããªã
Excelã¯ãäžèšã®ããã«æ±ãããŒã¿ã®éãå°ãªããå ¥åãéèšã«ãããäœæ¥è² æ ãå°ãªãå Žåã«é©ããŠãããœããã§ããããšãã°æéã決ãããããã£ã³ããŒã³ããçæã§çµäºãããããžã§ã¯ãã§ããã°ãExcelã§ãåå察å¿ã§ããå¯èœæ§ããããŸãã
BIããŒã«ã®å©çšã·ãŒã³
- ããŒã¿ã®çš®é¡ãéãå€ãå Žåã®éèšãåæ
- ããŒã¿ãœãŒã¹ãç°ãªããã®ãçµ±åããŠè¡ãããŒã¿åæ
- èªå以å€ã®äººãšæ å ±å ±æãå¿ èŠãªããŒã¿åæ
- ããŸããŸãªè§åºŠããã®åæãå¿ èŠ
- ç¶ç¶çã«ããŒã¿ãæŽæ°ããå¿ èŠããã
- ããŒã¿ããŒã¹ã§ã®ç®¡çãå¿ èŠãªããŒã¿ã®åæ
- çµå¶å€æã«äœ¿ããããšãã£ããªã¢ã«ã¿ã€ã æ§ãéèŠãªããŒã¿åæ
BIããŒã«ã¯ããã°ããŒã¿ãéèšããå€è§çã«åæãããå Žåã«ããããã§ãããŸãè€æ°äººã§ã®ç·šéãæ å ±å ±æãå¿ èŠãªã©ãå€ãã®äººãé¢ããå Žåãå¹ççã«äœæ¥ãé²ããŠã¹ããŒãã£ãŒã«ããŒã¿æŽ»çšãè¡ãããã«ãBIããŒã«ãå°å ¥ããæ¹ãããã§ãããã
BIããŒã«ãæ°ãã«å°å ¥ããéã®ã³ã3ã€
BIããŒã«ã¯å°å ¥ãç®çã§ã¯ãªããããåæãäŒæ¥æŠç¥ã«æŽ»ãããªããã°ãªããŸããããã®ããã®å°å ¥ãã€ã³ãã«ã€ããŠããµããŠãããŸãããããã¡ãã§ã¯ããBIããŒã«ã®éžã³æ¹ãã詳ãããŸãšããŠããŸãã
åé¡ãšç®çã®æ確å
BIããŒã«ãå°å ¥ããã«ããã£ãŠã¯ãç®çãæ確åãå ±æããŸããããBIããŒã«ã®å°å ¥èªäœã¯ç¹ã«æå³ã¯ãããŸãããBIããŒã«ãå©çšããŠç¹å®ã®ç®çãæããããšãã«ã¯ãããŠãBIããŒã«ãå°å ¥ãã䟡å€ãçãŸããŸããçŸç¶ã©ã®ãããªèª²é¡ãããã®ããã©ã®ãããªè§£æ±ºã«å°ãããã®ãã管çåŽã¯ãã¡ããçŸå Žã®å£°ãå·»ã蟌ãã§æ確åããã®ã倧åã§ãã
Excelã§ã¯ã§ããªãçç±ãæŽç
æ¥å圢æ ãšBIããŒã«ãé©ããŠãããããéèŠãªãã€ã³ãã§ããããšãã°æ¬¡ã®ãããªç¹ã確èªããŸãããã
- BIããŒã«ãå¿ èŠãªã»ã©ããŒã¿éã倧ããã®ã
- BIããŒã«ã䜿ãããªããåŸæ¥å¡ãããã®ã
- BIããŒã«ã§ãªããšã§ããªãããšã¯ããã®ã
ããããããã®æ¡ä»¶ãæºãããªãå Žåã¯ãExcelã§ååãªã±ãŒã¹ãèããããŸããBIããŒã«ãå°å ¥ããªããšããããããšãå®çŸã§ããªãã®ããããããŠèãçŽããŸãããã
éšçœ²ãè¶ ããããŒã¿é£æº
BIããŒã«ãå°å ¥ããã«ããã£ãŠã¯åœè©²éšçœ²ã¯ãã¡ãããé¢é£ããä»éšçœ²ã«ã説æããŸãããªãå°å ¥ãå¿ èŠãªã®ããã©ã®ãããªããŒã¿ãå¿ èŠã«ãªãã®ããã©ã®ãããªæ¹åãæåŸ ã§ããã®ããªã©ãäŒããŸããããæ ã·ã¹ãçµå¶è ããã®ç解ãããŠãããšãå°å ¥ããã³éçšã«é¢ããŠã¹ã ãŒãºã«ããšãé²ããããŸãã
BIããŒã«å°å ¥æã¯æ éã«éžå®ããŸããã
BIããŒã«ãšExcelã®éããBIããŒã«ãå°å ¥ããå¿ èŠæ§ãªã©ã«ã€ããŠè§£èª¬ããŸãããBIããŒã«ãšExcelãæ¯èŒãããšBIããŒã«ã®æ¹ãèœåã«åªããŠããŸãããç¶æ³ã«ãã£ãŠã¯Excelã§ååäºè¶³ããå ŽåããããŸãã
ãŸãã¯ã©ã®ãããªããŒã¿ãåéã»åæããããŒã¿æŽ»çšãè¡ãããããèããŠã¿ãŸãããããŸãBIããŒã«ã¯è²»çšã®é«ããéçšã®é£ãããããå°å ¥ã«å€±æãããããããããŒã«ã®éžå®ã¯æ éã«è¡ãããšã倧åã§ãã
BIã¯ãµãŒãã¹ã«ãã£ãŠãæ©èœãäŸ¡æ ŒãããŸããŸã§ããç®çã«æ²¿ã£ããµãŒãã¹ã®æ¯èŒã§å¹ççãªãµãŒãã¹æŽ»çšãå¯èœã§ãã
BOXILãšã¯
BOXILïŒãã¯ã·ã«ïŒã¯äŒæ¥ã®DXãæ¯æŽããæ³äººåããã©ãããã©ãŒã ã§ããSaaSæ¯èŒãµã€ããBOXIL SaaSããããžãã¹ã¡ãã£ã¢ãBOXIL MagazineããYouTubeãã£ã³ãã«ãBOXIL CHANNELããéããŠãããžãã¹ã«åœ¹ç«ã€æ å ±ãçºä¿¡ããŠããŸãã
BOXILäŒå¡ïŒç¡æïŒã«ãªããšæ¬¡ã®ç¹å žãåãåããŸãã
- BOXIL Magazineã®äŒå¡éå®èšäºãèªã¿æŸé¡ïŒ
- ãSaaSæ¥çã¬ããŒããããéžã³æ¹ã¬ã€ãããããŠã³ããŒãã§ããïŒ
- çŽ800çš®é¡ã®ããžãã¹ãã³ãã¬ãŒããèªç±ã«äœ¿ããïŒ
BOXIL SaaSã§ã¯ãSaaSãã¯ã©ãŠããµãŒãã¹ã®å£ã³ããåéããŠããŸããããªãã®äœéšãããµãŒãã¹å質åäžããããããå°å ¥æ€èšããäŒæ¥ã®åèæ å ±ãšããŠåœ¹ç«ã¡ãŸãã
BOXIL SaaSãžæ²èŒããŸãããïŒ
- ãªãŒãç²åŸã«åŒ·ãæ³äººåãSaaSæ¯èŒã»æ€çŽ¢ãµã€ãNo.1â»
- ãªãŒãã®åŸé課éã§ãå®å®çã«æ°èŠé¡§å®¢ãšã®æ¥ç¹ãæäŸ
- 环èš1,200瀟以äžã®æ²èŒå®çžŸããããåããŠã®æ¯èŒãµã€ãæ²èŒã§ãå®å¿
â» æ¥æ¬ããŒã±ãã£ã³ã°ãªãµãŒãæ©æ§èª¿ã¹ã調æ»æŠèŠ:2021幎5ææ ãã©ã³ãã®WEBæ¯èŒå°è±¡èª¿æ»