ã©ã®ãããªéžæè¢ããããŸããïŒ
å€ãã®å Žåãé«äŸ¡ã§è€éãªBIã·ã¹ãã ã®äœ¿çšã¯ãåçŽã§æ¯èŒçå®äŸ¡ã§ãããéåžžã«å¹æçãªåæããŒã«ã«çœ®ãæããããšãã§ããŸãããã®èšäºãèªãã åŸãããžãã¹ã€ã³ããªãžã§ã³ã¹ã®ããŒãºãè©äŸ¡ããããžãã¹ã«æé©ãªãªãã·ã§ã³ãç解ã§ããŸãã
ãã¡ããããã¹ãŠã®BIã·ã¹ãã ã¯éåžžã«è€éãªã¢ãŒããã¯ãã£ãåããŠãããäŒæ¥ã§ã®å®è£ ã¯ããœãªã¥ãŒã·ã§ã³ãšé«åºŠãªè³æ Œãæã€ã€ã³ãã°ã¬ãŒã¿ã«å€é¡ã®è²»çšãå¿ èŠãšããç°¡åãªäœæ¥ã§ã¯ãããŸããããã¹ãŠãå®è£ ãšè©Šé転ã§çµããããã§ã¯ãªããããç¹°ãè¿ããµãŒãã¹ã«é Œãå¿ èŠããããŸããå°æ¥çã«ã¯ãæ©èœãæ¹è¯ããæ°ããã¬ããŒããšã€ã³ãžã±ãŒã¿ãŒãéçºããå¿ èŠããããŸããã·ã¹ãã ãæåããå Žåãããå€ãã®åŸæ¥å¡ãã·ã¹ãã ã§äœæ¥ããããã«ãªãããšã«æ³šæããå¿ èŠããããŸããã€ãŸããè¿œå ã®ãŠãŒã¶ãŒã©ã€ã»ã³ã¹ãè³Œå ¥ããå¿ èŠããããŸãã
é«åºŠãªããžãã¹ã€ã³ããªãžã§ã³ã¹ã·ã¹ãã ã®ãã1ã€ã®åºæã®æ©èœã¯ãéåžžã«å€ãã®æ©èœã»ããã§ãããããã®æ©èœã®å€ãã¯äœ¿çšããããšã¯ãããŸããããã©ã€ã»ã³ã¹ãæŽæ°ãããã³ã«æéãæ¯æãç¶ããŸãã
BIã·ã¹ãã ã®äžèšã®æ©èœã«ããã代æ¿æ¡ã®éžæã«ã€ããŠèããããšãã§ããŸãã次ã«ãPower BIãšExcelã䜿çšããŠã¬ããŒããäœæãããšãã«ããœãªã¥ãŒã·ã§ã³ãæšæºã®äžé£ã®ã¿ã¹ã¯ãšæ¯èŒããããšãææ¡ããŸãã
Power BIãŸãã¯ExcelïŒ
ååãšããŠãååæããšã®å£²äžã¬ããŒããäœæããããã«ãã¢ããªã¹ãã¯äŒèšã·ã¹ãã ããããŒã¿ãã¢ã³ããŒããããããããªãã¡ã¬ã³ã¹ããã¯ãšæ¯èŒããVLOOKUPé¢æ°ã䜿çšããŠ1ã€ã®ããŒãã«ã«åéããããã«åºã¥ããŠã¬ããŒããäœæããŸãã
Power BIã¯ãã®åé¡ãã©ã®ããã«è§£æ±ºããŸããïŒ
ãœãŒã¹ããã®ããŒã¿ã¯ã·ã¹ãã ã«ããŒããããåæã®ããã«æºåãããŸããããŒãã«ã«åå²ãããã¯ãªãŒã³ã¢ãããããŠæ¯èŒãããŸãããã®åŸãããžãã¹ã¢ãã«ãæ§ç¯ãããŸããããŒãã«ãçžäºã«ãªã³ã¯ãããããŒæ°å€ãå®çŸ©ãããã«ã¹ã¿ã éå±€ãäœæãããŸãã次ã®æ®µéã¯èŠèŠåã§ããããã§ã¯ãã³ã³ãããŒã«ãšãŠã£ãžã§ããããã©ãã°ã¢ã³ãããããããã ãã§ãã€ã³ã¿ã©ã¯ãã£ããªããã·ã¥ããŒãã圢æãããŸãããã¹ãŠã®èŠçŽ ã¯ãããŒã¿ã¢ãã«ãä»ããŠãªã³ã¯ãããŠããŸããåæãããšããããã«ãããå¿ èŠãªæ å ±ã«çŠç¹ãåãããããã·ã¥ããŒãèŠçŽ ã1åã¯ãªãã¯ããã ãã§ãã¹ãŠã®ãã¥ãŒã§ãã®æ å ±ãé€å€ã§ããŸãã
ãã®äŸã®åŸæ¥ã®ã¢ãããŒããããPowerBIã䜿çšããå©ç¹ãã©ã®ããã«ç¢ºèªã§ããŸããïŒ
1-ããŒã¿ãååŸããŠåæçšã«æºåããæé ã®èªååã
2-ããžãã¹ã¢ãã«ã®æ§ç¯ã
3-ä¿¡ããããªãã»ã©ã®èŠèŠåã
4-ã¬ããŒããžã®ã¢ã¯ã»ã¹ãå¶éãããŠããŸãã
ããã§ã¯ãåã¢ã€ãã ãåå¥ã«èŠãŠãããŸãããã
1-ã¬ããŒããäœæããããã®ããŒã¿ãæºåããã«ã¯ãããŒã¿ã«æ¥ç¶ããŠããŒã¿ã1ååŠçããããã·ãŒãžã£ãå®çŸ©ããå¿ èŠããããŸããç°ãªãæéã®ã¬ããŒããååŸããå¿ èŠããããã³ã«ãPowerBIã¯äœæãããããã·ãŒãžã£ãä»ããŠããŒã¿ãæž¡ããŸãããããã£ãŠãåæçšã®ããŒã¿ã®æºåã«é¢ããäœæ¥ã®ã»ãšãã©ã¯èªååãããŠããŸããããããå®éã«ã¯ãPower BIã¯ãåŸæ¥ã®ããŒãžã§ã³ã®Excelã§äœ¿çšå¯èœãªããŒã«ã䜿çšããŠããŒã¿ãæºåããæé ãå®è¡ããŸããããã¯PowerQueryãšåŒã°ããŸããããã«ãããExcelã§ãŸã£ããåãæ¹æ³ã§ã¿ã¹ã¯ãå®äºããããšãã§ããŸãã
2-ããã¯åãç¶æ³ã§ããããžãã¹ã¢ãã«ãæ§ç¯ããããã®PowerBIããŒã«ã¯Excelã§ãå©çšã§ããŸã-ããã¯PowerPivotã§ãã
3 -ããªãã¯ããããæ¢ã«æšæž¬ãšããŠãç¶æ³ãå¯èŠåãšäŒŒãŠããŸãïŒExcelã®æ¡åŒµæ©èœ-é»æºè¡šç€ºããã¿ã³ãšããã®ã¿ã¹ã¯ã«ã察å¿ããŸãã
4-ã¬ããŒããžã®ã¢ã¯ã»ã¹ãåŠçããå¿ èŠããããŸããããã§ã¯ãã¹ãŠããã©è²ã§ã¯ãããŸãããå®éãPower BIã¯ãå人ã¢ã«ãŠã³ããä»ããŠã¢ã¯ã»ã¹ãããã¯ã©ãŠããµãŒãã¹ã§ãããµãŒãã¹ç®¡çè ã¯ããŠãŒã¶ãŒãã°ã«ãŒãã«åæ£ãããããã®ã°ã«ãŒãã®ã¬ããŒãã«ããŸããŸãªã¬ãã«ã®ã¢ã¯ã»ã¹ãå²ãåœãŠãŸããããã«ãããäŒç€Ÿã®åŸæ¥å¡éã®ã¢ã¯ã»ã¹æš©ã®å·®å¥åãå®çŸããŸãããããã£ãŠãåãããŒãžã«ã¢ã¯ã»ã¹ããã¢ããªã¹ãããããŒãžã£ãŒãããã³ãã£ã¬ã¯ã¿ãŒã¯ãã¢ã¯ã»ã¹å¯èœãªãã¥ãŒã§ã¬ããŒãã衚瀺ããŸããç¹å®ã®ããŒã¿ã»ãããŸãã¯ã¬ããŒãå šäœãžã®ã¢ã¯ã»ã¹ãå¶éã§ããŸãããã ããã¬ããŒããExcelãã¡ã€ã«ã«ããå Žåãã·ã¹ãã 管çè ã®åªåã§ã¢ã¯ã»ã¹ã®åé¡ã解決ããããšããããšãã§ããŸãããããã¯åãã§ã¯ãããŸãããåŸã§äŒæ¥ããŒã¿ã«ã®æ©èœã«ã€ããŠèª¬æãããšãã«ããã®åé¡ã«æ»ããŸãã
ååãšããŠãè€éã§çŸããããã·ã¥ããŒãã«å¯ŸããäŒç€Ÿã®ããŒãºã¯å€§ãããªããExcelã§ã®ããŒã¿åæã§ã¯ãããžãã¹ã¢ãã«ãæ§ç¯ããåŸãPower Viewæ©èœã«é ŒãããããããããŒãã«ã䜿çšããããšããããããŸãããããã¯ãã»ãšãã©ã®ããžãã¹ã€ã³ããªãžã§ã³ã¹ã®åé¡ã解決ããã®ã«ååãªOLAPæ©èœãæäŸããŸãã
ãããã£ãŠãExcelã§ããžãã¹åæãè¡ããªãã·ã§ã³ã¯ãã¬ããŒããå¿ èŠãšããåŸæ¥å¡æ°ãå°ãªãå¹³åçãªäŒæ¥ã®ããŒãºãååã«æºããå¯èœæ§ããããŸããããã§ããäŒç€Ÿã®èŠæ±ãããéå¿çãªãã®ã§ããå Žåã¯ããã¹ãŠãäžåºŠã«è§£æ±ºããããŒã«ã«æ¥ãã§é Œããªãã§ãã ããã
ããå°éçãªã¢ãããŒãã«æ³šç®ããããšæããŸããããã䜿çšãããšãå®å šã«å¶åŸ¡ãããç¬èªã®èªååãããã·ã¹ãã ã䜿çšããŠãã¢ã¯ã»ã¹ãå¶éãããããžãã¹åæã¬ããŒããäœæã§ããŸãã
ETLãšDWH
ããžãã¹ã¬ããŒããäœæããããã®åè¿°ã®ã¢ãããŒãã§ã¯ãåæçšã®ããŒã¿ã®ããŒããšæºåã¯ãPowerQueryãã¯ãããžã䜿çšããŠå®è¡ãããŸããããã®æ¹æ³ã¯ã1ã€ã®ã¢ã«ãŠã³ãã£ã³ã°ã·ã¹ãã ãšExcelããŒãã«ã®ãªãã¡ã¬ã³ã¹ããã¯ãšããå€ãã®ããŒã¿ãœãŒã¹ããªãéããéåžžã«æ£åœåãããå¹æçã§ãããã ããã¢ã«ãŠã³ãã£ã³ã°ã·ã¹ãã ã®æ°ãå¢ãããšãPower Queryã䜿çšããŠãã®åé¡ã解決ããããšã¯éåžžã«é¢åã«ãªããä¿å®ãšéçºãå°é£ã«ãªããŸãããã®ãããªå ŽåãETLããŒã«ã圹ã«ç«ã¡ãŸãã
ãããã¯ããœãŒã¹ããããŒã¿ãã¢ã³ããŒããïŒExtractïŒãå€æãïŒTransformïŒãã¯ãªãŒãã³ã°ãšãããã³ã°ãè¡ããããŒã¿ãŠã§ã¢ããŠã¹ã«ããŒãããïŒLoadïŒããã«äœ¿çšãããŸããããŒã¿ãŠã§ã¢ããŠã¹ïŒDWH-ããŒã¿ãŠã§ã¢ããŠã¹ïŒã¯éåžžããµãŒããŒäžã«ãããªã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ã§ãããã®ããŒã¿ããŒã¹ã«ã¯ãåæã«é©ããããŒã¿ãå«ãŸããŠããŸãã ETLããã»ã¹ã¯ã¹ã±ãžã¥ãŒã«ã«åŸã£ãŠèµ·åããããŠã§ã¢ããŠã¹ããŒã¿ãçŸåšã®ããŒã¿ã«æŽæ°ããŸããã¡ãªã¿ã«ããã®ãããã³å šäœã¯ãMS SQLServerã«å«ãŸããŠããIntegrationServicesã«ãã£ãŠå®å šã«æäŸãããŸãã
ããã«ã以åãšåæ§ã«ãExcelãPower BIããŸãã¯TableauãQlik Senseãªã©ã®ä»ã®åæããŒã«ã䜿çšããŠãããŒã¿ããžãã¹ã¢ãã«ãšèŠèŠåãæ§ç¯ã§ããŸããããããæåã«ãé·ãéå©çšå¯èœã§ãã£ãã«ãããããããããªããç¥ããªããããããªããã1ã€ã®æ©äŒã«æ³šæãåããããšæããŸããåæãµãŒãã¹MSSQL Serverãã€ãŸãåæãµãŒãã¹ã䜿çšããŠããžãã¹ã¢ãã«ãæ§ç¯ããããšã«ã€ããŠè©±ããŠããŸãã
MSåæãµãŒãã¹ã®ããŒã¿ã¢ãã«
èšäºã®ãã®ã»ã¯ã·ã§ã³ã¯ã瀟å ã§ãã§ã«MS SQLServerã䜿çšããŠãããŠãŒã¶ãŒã«ãšã£ãŠããèå³æ·±ããã®ã«ãªããŸãã
Analysis Servicesã¯çŸåšãå€æ¬¡å ãšè¡šåœ¢åŒã®2çš®é¡ã®ããŒã¿ã¢ãã«ãæäŸããŠããŸãããããã®ã¢ãã«ã®ããŒã¿ãé¢é£ããŠãããšããäºå®ã«å ããŠãã¢ãã«ã¡ãžã£ãŒã®å€ã¯äºåã«éèšãããMDXãŸãã¯DAXã¯ãšãªã«ãã£ãŠã¢ã¯ã»ã¹ãããOLAPãã¥ãŒãã®ã»ã«ã«æ ŒçŽãããŸãããã®ã¹ãã¬ãŒãžã¢ãŒããã¯ãã£ã§ã¯ãæ°çŸäžã®ã¬ã³ãŒãã«ãŸãããã¯ãšãªãæ°ç§ã§è¿ãããŸãããã®ããŒã¿ãžã®ã¢ã¯ã»ã¹æ¹æ³ã¯ããã©ã³ã¶ã¯ã·ã§ã³ããŒãã«ã«å°ãªããšã100äžã¬ã³ãŒããå«ãŸããŠããäŒæ¥ã«å¿ èŠã§ãïŒäžéã¯å¶éãããŠããŸããïŒã
ExcelãPower BIãããã³ãã®ä»ã®å€ãã®ãå ç¢ãªãããŒã«ã¯ããã®ãããªã¢ãã«ã«æ¥ç¶ããŠããããã®æ§é ã®ããŒã¿ãèŠèŠåããããšãã§ããŸãã
ãé«åºŠãªãæ¹æ³ãã€ãŸãETLããã»ã¹ãèªååããMS SQL ServerãµãŒãã¹ã䜿çšããŠããžãã¹ã¢ãã«ãæ§ç¯ããå Žåã¯ãç¬èªã®äŒæ¥ããŒã¿ã«ãæã€äŸ¡å€ããããŸãã
ã³ãŒãã¬ãŒãããŒã¿ã«
ããã«ããã管çè ã¯ã¬ããŒãäœæããã»ã¹ãç£èŠããã³å¶åŸ¡ããŸããããŒã¿ã«ã®ååšã«ãããäŒç€Ÿã®ãã£ã¬ã¯ããªãçµ±åããããšãã§ããŸãã顧客ã補åããããŒãžã£ãŒããµãã©ã€ã€ãŒã«é¢ããæ å ±ããããŒã¿ã«ã䜿çšãããã¹ãŠã®äººã1ãæã§æ¯èŒãç·šéãããŠã³ããŒãã§ããããã«ãªããŸããããŒã¿ã«ã§ã¯ãããŒã¿è€è£œã®ç®¡çãªã©ãäŒèšã·ã¹ãã ã®ããŒã¿ãå€æŽããããã®ããŸããŸãªæ©èœãå®è£ ã§ããŸãããããŠæãéèŠãªããšã¯ãããŒã¿ã«ã®å©ããåããŠãã¬ããŒããžã®å¶éãããã¢ã¯ã»ã¹ãæŽçããåé¡ãæ£åžžã«è§£æ±ºãããããšã§ããåŸæ¥å¡ã¯ãèªåã®éšéã®ããã«èªåçšã«äœæãããã¬ããŒãã®ã¿ã衚瀺ããŸãã
ãã ããããŒã¿ã«ããŒãžã§ã®ã¬ããŒãã®è¡šç€ºãã©ã®ããã«ç·šæããããã¯ãŸã æ確ã§ã¯ãããŸããããã®è³ªåã«çããã«ã¯ãæåã«ãããŒã¿ã«ãæ§ç¯ããããã®åºç€ãšãªããã¯ãããžãŒã決å®ããå¿ èŠããããŸããASP.NET MVC / Web Forms / CoreããŸãã¯MicrosoftSharePointã®ããããã®ãã¬ãŒã ã¯ãŒã¯ãããŒã¹ã«ããããšããå§ãããŸããäŒç€Ÿã«å°ãªããšã1人ã®.NETéçºè ãããå Žåãéžæã¯é£ãããããŸãããããã§ãAnalysisServicesã®å€æ¬¡å ã¢ãã«ãŸãã¯è¡šåœ¢åŒã¢ãã«ã«æ¥ç¶ã§ãããã©ã°ã€ã³OLAPã¯ã©ã€ã¢ã³ããæ¢ãããšãã§ããŸãã
ã¬ã³ããªã³ã°çšã®OLAPã¯ã©ã€ã¢ã³ãã®éžæ
åã蟌ã¿ã®è€éããæ©èœãäŸ¡æ Œã®èŠ³ç¹ãããPower BIãASP.NETMVCã³ã³ããŒãã³ãçšã®TelerikUIãRadarCube ASP.NETMVCã³ã³ããŒãã³ããªã©ã®ããã€ãã®ããŒã«ãæ¯èŒããŠã¿ãŸãããã
Power BI
äŒç€Ÿã®åŸæ¥å¡ãããŒã¿ã«ããŒãžã®PowerBIã¬ããŒãã«ã¢ã¯ã»ã¹ã§ããããã«ããã«ã¯ãPower BIEmbeddedæ©èœã䜿çšããå¿ èŠããããŸãã
ããã«ãPower BIPremiumã©ã€ã»ã³ã¹ãšè¿œå ã®å°çšå®¹éãå¿ èŠã«ãªããŸããå°çšå®¹éã䜿çšãããšãã©ã€ã»ã³ã¹ãè³Œå ¥ããªããŠããçµç¹å ã®ãŠãŒã¶ãŒåãã«ããã·ã¥ããŒããšã¬ããŒããå ¬éã§ããŸãã
ãŸããPower BIDesktopã§çæãããã¬ããŒããPowerBIããŒã¿ã«ã«å ¬éããã次ã«ãããªãããŒãªã«ã¹ã¿ãã€ãºã䜿çšããŠãWebã¢ããªã±ãŒã·ã§ã³ããŒãžã«åã蟌ãŸããŸãã
ã¢ããªã¹ãã¯ãç°¡åãªã¬ããŒããçæããæé ãšãã®å ¬éã«ããŸã察åŠã§ããŸãããåã蟌ã¿ã§æ·±å»ãªåé¡ãçºçããå¯èœæ§ããããŸãããŸãããã®ããŒã«ãã©ã®ããã«æ©èœããããç解ããããšã¯éåžžã«å°é£ã§ããå€æ°ã®ã¯ã©ãŠããµãŒãã¹èšå®ãå€ãã®ãµãã¹ã¯ãªãã·ã§ã³ãã©ã€ã»ã³ã¹ã容éã«ãããã¹ãã·ã£ãªã¹ããã¬ãŒãã³ã°ã®ã¬ãã«ã®èŠä»¶ãå€§å¹ ã«å¢å ããŸãããããã£ãŠããã®ã¿ã¹ã¯ã¯ITã¹ãã·ã£ãªã¹ãã«ä»»ããããšããå§ãããŸãã
Telerikããã³RadarCubeã³ã³ããŒãã³ã
Telerikã³ã³ããŒãã³ããšRadarCubeã³ã³ããŒãã³ããçµ±åããã«ã¯ããœãããŠã§ã¢ãã¯ãããžã®åºæ¬çãªç¥èãããã°ååã§ãããããã£ãŠãITéšéã®1人ã®ããã°ã©ããŒã®å°éçãªã¹ãã«ã§ååã§ããã³ã³ããŒãã³ããWebããŒãžã«é 眮ããããŒãºã«åãããŠã«ã¹ã¿ãã€ãºããã ãã§ããTelerik UI for ASP.NET MVCã¹ã€ãŒã
ã®PivotGridã³ã³ããŒãã³ãã¯ãæ°ã®å©ããRazoræ¹åŒã§ããŒãžã«åã蟌ãŸããåºæ¬çãªOLAPæ©èœãæäŸããŸãããã ããããæè»ãªã€ã³ã¿ãŒãã§ã€ã¹èšå®ãšé«åºŠãªæ©èœãå¿ èŠãªå Žåã¯ãRadarCube ASP.NETMVCã³ã³ããŒãã³ãã䜿çšããããšããå§ãããŸããå€æ°ã®èšå®ãåå®çŸ©ããã³æ¡åŒµæ©èœãåããè±å¯ãªæ©èœã«ãããè€éãªOLAPã¬ããŒããäœæã§ããŸãã
以äžã¯ãæ€èšå¯Ÿè±¡ã®æ©åšã®ç¹æ§ãäœ-äž-é«ã¹ã±ãŒã«ã§æ¯èŒããè¡šã§ãã
Power BI | ASP.NETMVCçšã®TelerikUI | RadarCube ASP.NET MVC | |
---|---|---|---|
èŠèŠå | èãé«ã | äœ | äžé |
OLAPé¢æ°ã»ãã | èãé«ã | äœ | èãé«ã |
ã«ã¹ã¿ãã€ãºã®æè»æ§ | èãé«ã | èãé«ã | èãé«ã |
æ©èœããªãŒããŒã©ã€ãããæ©èœ | - | - | + |
ãœãããŠã§ã¢ã®ã«ã¹ã¿ãã€ãº | - | - | + |
åã蟌ã¿ãšã«ã¹ã¿ãã€ãºã®è€éãã®ã¬ãã« | èãé«ã | äœ | äžé |
æå°ã³ã¹ã | Power BI Premium EM319
äžã«ãŒãã«/æ |
1人ã®éçºè
ã®ã©ã€ã»ã³ã¹
90,000ã«ãŒãã«ã |
1人ã®éçºè
ã®ã©ã€ã»ã³ã¹
|
ããã§ãåæããŒã«ãéžæããããã®åºæºã®å®çŸ©ã«é²ãããšãã§ããŸãã
PowerBIã®éžæåºæº
- ããŸããŸãªææšãããŒã¿é¢é£ã®èŠçŽ ãè±å¯ãªã¬ããŒãã«é¢å¿ããããŸãã
- , , , - .
- IT-, BI-.
- -.
Telerik
- OLAP- Ad hock .
- .NET .
- 20%.
RadarCube
- OLAP- , .
- å瀟ã¯äžå ã®.NETéçºè ãæ¡çšããŠããŸããããã§ãªãå Žåã¯ãã³ã³ããŒãã³ãã®éçºè ã芪åã«ãµãŒãã¹ãæäŸããŸããããã«ã¿ã€ã ã®ããã°ã©ããŒã®çµŠäžãè¶ ããªãè¿œå æéãããããŸãã
- 1åéãã®ã©ã€ã»ã³ã¹è³Œå ¥ãš60ïŒ å²åŒã§ã®ãããªãæŽæ°ã®ããã®å°é¡ã®äºç®ã
çµè«
ããžãã¹ã€ã³ããªãžã§ã³ã¹ã«é©ããããŒã«ãéžæãããšãExcelã§ã®ã¬ããŒãã®äœæãå®å šã«æŸæ£ã§ããŸããããªãã®äŒç€Ÿã¯ãBIã®åéã§é«åºŠãªãã¯ãããžãŒã®äœ¿çšã«åŸã ã«ãããŠçã¿ã䌎ããã«åãæ¿ãããã¹ãŠã®éšéã®ã¢ããªã¹ãã®äœæ¥ãèªååããããšãã§ããŸãã