ãã£ã¹ã«ãã·ã§ã³
-
æ€çŽ¢ããã¹ãããã¯ã¹ã«èšèŒãããããã¹ããèªç±ã«å€æŽããã
ã°ã©ãçš®å¥ãã¹ã©ã€ãµãŒããéžæããæ€çŽ¢ããã¯ã¹ã衚瀺ããŠããç¶æ ã«ã€ããŠã§ãã ããã©ã«ãã§ã¯è«çŒé¡ã®å³åŽã«ã次ã§ãã£ã«ã¿ãŒâŠããšèšèŒãããŠãããŸããã ãã¡ãã®ããã¹ããèªåã§ã倿Žã§ããããã«ããŠããã ãããšå€§å€å©ãããŸãã 瀟å ã«ãŠããæ¬¡ã§ãã£ã«ã¿ãŒâŠããšããæèšãåããã«ããã ã¢ã¯ã·ã§ã³ã«ç¹ãã«ãããšããè°é¡ãçããããèšèŒãããŠããã ããŸããããã ãããããé¡ãèŽããŸãã
-
ããã·ã¥ããŒãä¿åæã®éå±€ãéžã³ãã
çŸåšãããã·ã¥ããŒãã®ãååãã€ããŠä¿åããããéã«ã¯ãããã·ã¥ããŒããé 眮ãããŠããéå±€ãžèªåçã«ä¿åãããŠããŸããŸãã æ¯åãä¿ååŸã«é局倿Žãããå¿ èŠãããé¢åãªã®ã§ãæåããã©ã®éå±€ã«ä¿åããããéžã³ããã§ãã ããããããããããŸãã
-
Workbenchã®ãžã§ããã°ã«ãŒãã³ã°ããã
ã»ãã¥ãªãã£ã®éœåäžãWorkbenchãå©çšããæ©äŒãé »ç¹ã«ãããŸãã ãã®éãæ¡ä»¶ããšã«ããã€ãã®ãžã§ããäœæããŠããŸããããžã§ããå¢ããŠããŠããªãèŠã¥ãããªã£ãŠããŸããã ãžã§ããå¢ããŠããããšã«ãããçŸç¶æ€çŽ¢ã¯ã§ããŠããã±ã£ãšèŠãŠå€æããããšãã§ããå°ã£ãŠãããŸãã ïŒåœåèŠåã§æããŠã¯ããŸãããæ¡ä»¶ããšãªã©ã§ã°ã«ãŒãã³ã°ã§ãããšããã管çããããããªããŸãïŒ ãæ€èšããããããããããŸãã
-
ãããã·ã¥ããŒãããã£ã«ã¿ãŒå
容æ€çŽ¢åŸã®äžæ¬éžæããããã§ãã
ããã·ã¥ããŒãããŒãžã«ãŠããã£ã«ã¿ãŒæ©èœãå©çšããŠããã·ãŒã³ã®æ¹åæ¡ã§ãã ãã£ã«ã¿ãŒã®ã¹ã©ã€ãµãŒã°ã©ããçšããŠãã£ã«ã¿ãªã³ã°ããéã«ãæ€çŽ¢ãããçµæãäžæ¬ã§éžæãããã§ãã çŸç¶ãå å«ãããçµæãããã€ãåŒã£ããã£ãå Žåã«ã¯ãã¹ãŠæåã§éžæããå¿ èŠããããé ç®ãå€ãã»ã©äžäŸ¿ã§ãã æ€çŽ¢æ©èœã®ãªãªãŒã¹ããšãŠãæãé£ãæå¹æŽ»çšãããŠããã ããŠããã®ã§ããã²äžæ¬éžææ©èœããããããé¡ãããããŸãã ïŒãããã¯ããããã§ã«ã©ããã§èšå®ã§ããå Žåã¯æããŠããã ãããšå¹žãã§ãïŒ ãããããé¡ãããããŸãã
-
衚ã°ã©ãã®ããããè€æ°è¡äœæããã
衚ã°ã©ãã§ãè€æ°è¡ã®ããããäœæãããã§ãã ïŒãããããŸãšããããããã»ããã§ã ïŒäžèšå³ã®æ°Žè²ããããã®ã€ã¡ãŒãžã§ã åã®ã«ããŽã©ã€ãºããããå Žé¢ãå€ã ãããŸãããçŸç¶ã¯ãã®ããžã¥ã¢ã«ãå®çŸã§ããŸããã ExcelãDomoåããéã«ãããããïŒè¡ã«ãªãã®ã¯NGãšããããšã§ã Domoåãæå¿µ or SQLãAppã§ã«ã¹ã¿ãã€ãºããŠå®æœããããšããããããŸãã Sumoãå©çšããã°è€æ°è¡è¡šç€ºã§ããŸãããèŠãç®ã®ã«ã¹ã¿ãã€ãºãã§ããªãããã衚ã°ã©ãã®ä»£æ¿ãšããŠå®çšã§ããŸããã ãæ€èšããããããããããŸãã
-
ããŒã¿ã³ãã¯ã¿äžèЧã®äžŠã³é ã倿Žããã
æ¥ã ã³ãã¯ã¿ã远å ãããŠããŸãããæè¿è¿œå ãããã³ãã¯ã¿ãèŠã€ãã¥ããã§ãã çŸç¶ããªããšãªãã³ãã¯ã¿å¢ããæ°ããããªãŒãšæã£ããšãã«ãã²ãããã¹ã¯ããŒã«â詳现ããæŽæ°æ¥ãèŠãããããŠããç¶æ³ã§ãã ã³ãã¯ã¿äžèЧã®ããã©ã«ãã¯ååé ãããã§ããããã®ä»ã«ããã³ãã¯ã¿ã远å ãããé ããæŽæ°ãããé ã«ãœãŒãã§ãããšå©ãããŸãã ãããã¯ä»ã«ãªã«ãããæ¹æ³ãããã°ãæç€ºãã ããã ããããããããããŸãã
-
BeastModeã®é
ç®ã䜿ã£ãŠããªã«ããŠã³ããã
ãã°ããšæãDomoã«åãåããããšããã仿§ãšã®ããšã§ãã®ã§ãã²ãããã«æçš¿ããŸãã ããªã«ããŠã³ã§ããã«ãŒãã®ïŒéå±€ç®ãšïŒéå±€ç®ã§ç°ãªãããŒã¿ã»ãããå©çšããŠããå Žåã ïŒéå±€ç®ã§äœæããBeastModeã®ååãšã ïŒéå±€ç®ã«ååšããŠããååãåãã§ãã ããªã«ããŠã³ã§ãããšã©ãŒã«ãªã£ãŠããŸããŸãã BeastModeã§äœæããããã©ããã«é¢ããããååãåãå Žåã¯ã ããªã«ããŠã³ã§ããããã«ããŠããã ãããã§ãã BeastModeãäœæãããããŒã¿ãããŒã§äºåã«ååãå®çŸ©ããã°ããªã«ããŠã³ã¯å¯èœã§ãããäºåã®æéãå¿ èŠã«ãªãããã察å¿ããŠããã ãããã§ãã ãæ€èšããããããããããŸãã
-
ãããŒã¿è¡šãæ€çŽ¢çµæã®åã®ã¿éžæããã
ãã°ããšæããµããŒãã«é£çµ¡ãããšããã仿§ãšã®ããšã§ããã®ã§ããã¡ãã«æçš¿ããŸãã ã«ãŒãç·šéç»é¢ã®ããŒã¿è¡šã«ãŠãååãæ€çŽ¢åŸã«[å šãŠ]ãéžæãããšãæ¢åã®åå šãŠãéžæãããŠããŸããŸãã æ¢åã®åã50å以äžã®å Žåã¯æåãå€§å¹ ã«é ããªããããæ€çŽ¢çµæãšããŠè¡šç€ºãããŠããåã®ã¿ãéžæãããã§ãã â é·ç§» ã«ãŒãç·šéç»é¢ïŒããŒã¿è¡šïŒâåã衚瀺äžïŒååã§æ€çŽ¢ïŒ[å šãŠ]ãéžæ âãæ€çŽ¢çµæã®ååã®ã¿éžæãããŠã»ããããå šãŠã®åãéžæãããŠããŸãã ãæ€èšããããããããããŸãã
-
ããŒã¿ã»ããäœææã«ã¿ã°ä»ãããã
ããŒã¿ã»ãããããŒã¿ãããŒã®äœæåŸãã¿ã°ä»ãããããšã«ããããã£ã«ã¿ãŒãªã©ã§ç°¡åã«æ€çŽ¢ãã§ããããéå®ããŠããŸãã ãã ãçŸç¶ãäœæåŸã«ãã远å ã§ããªããããä»ãå¿ããïŒæ©èœèªäœãç¥ããªããŠãŒã¶ãŒãå€ãã§ãã æ€çŽ¢ç°¡æåã®ãããããŒã¿ã»ãããããŒã¿ãããŒãäœæããæµãã®äžã«ãã¿ã°ä»ãã®æäœãçµã¿èŸŒãã§ããã ãããã§ãã ïŒããŒã¿ã»ããã«ååã説æãã€ããäžãããã«ïŒ ããããããããããŸãã
-
BigQueryã³ãã¯ã¿ã§ããŒã¿ã»ããã2ã€å©çšããã
BigQueryã³ãã¯ã¿ã§StandardSQLãå©çšããéãããŒã¿ã»ããIDãæå®ããå¿ èŠããããŸãã ããããããŒã¿ã»ããIDãã²ãšã€ããæå®ã§ããªãããã BigQueryã®ã³ã³ãœãŒã«ã§ã¯å©ããã¯ãšãªããDomoã®ã³ãã¯ã¿ããã¯å©ããŸããããã (ïŒã€ä»¥äžã®ããŒã¿ã»ãããçšããŠã¯ãšãªãå©ããããšããé »ç¹ã«ãããŸã) Domoã®BigQueryã³ãã¯ã¿ã§ãè€æ°ããŒã¿ã»ããã䜿ããããæ¹ä¿®ããŠããã ãããã§ãã ãæ€èšããããããããããŸãã
-
ããŒã¿ã»ãããè€æ°è¡åé€ããã
çŸç¶ãããŒã¿ã»ããã®å±¥æŽããããŒã¿ã®åé€ãã§ããŸããã äžè¡ãã€éžæããåé€ããå¿ èŠããããŸãã è€æ°åã蟌ã¿ååé€ãããå Žåãå逿äœã®åŸããªããŒãåŸã«ãŸãã¹ã¯ããŒã«ããŠæäœããŠïœã®ç¹°ãè¿ãäœæ¥ã®å¿ èŠããããããšãŠãæéãæãã£ãŠããŸããŸãã ïŒç¹å®ã®ã¿ã€ãã³ã°ãŸã§æ»ããŠãããå ŽåããSQLã§åé€å¯èœãªå Žåã¯ããã®ã§ããã ããšãã°Workbenchã§åã蟌ãã§ãããšãããIDãç¡ããããSQLã§åé€ããã®ãé¢åã§ãïŒ ããŒã¿ã»ããã»ããŒã¿ãããŒäžèЧã®ããã«ãã§ãã¯ããã¯ã¹ãå©çšããŠè€æ°è¡äžæ¬åé€ãããã§ãããã ãæ€èšããããããããããŸãã
-
ããŒã¿ãããŒ(SQL)ã®å€æãã«ããŽãªããšã«ãŸãšããã
ããŒã¿ãããŒïŒSQLïŒã§å€æã远å ããŠããå Žåã è€éãªå€æãããã»ã©å€æã®åæ°ãå¢ããŠãã£ãŠããŸããŸãã 倿ã®äžæããŒãã«åã§ã«ããŽã©ã€ãºãããéæã³ã¡ã³ããã€ãããããŠããŸããã ãã¯ãã±ã£ãšèŠã§èŠã¥ããããã倿ã®ã«ããŽãªãäœæã§ãããšãšãŠãå©ãããŸãã ïŒïœïŒã®å€æã¯åŠçAãïŒïœïŒã®å€æã¯åŠçBããªã©ã®ã«ããŽãªåããã ã«ããŽã©ã€ãºãããåŠçããšã®æãç³ã¿ãã³ã¡ã³ãä»ãããããã§ãã èªåã®ã¡ã¢ã¯ãã¡ããã§ãããä»ã®äººãã±ã£ãšèŠããšãã«åŠçãããŒããããããã«ãªããšå©ãããŸãã ãæ€èšããããããããããŸãã
-
ãSharepointã³ãã¯ã¿ãååŸãã¡ã€ã«ã®ç¯å²æå®ãããã
Sharepoint onlineã³ãã¯ã¿ãé »ç¹ã«å©çšããŠããŸãã ExcelããŒã¿ãååŸããéã«ã¯ãA1ã»ã«ããèªåååŸãããŸãã ãã®ãããDomoãžã¢ããããŒãããéã¯ãæ¢åã®ã·ãŒãèªäœãæ¹ä¿®ãããã Domoçšã·ãŒããå¥éäœæããå¿ èŠããããŸãã éçšå€æŽãæ¹ä¿®ãªã©æ¯åºŠæéãæãã£ãŠããããã file upload ã³ãã¯ã¿ã®ããã«ãããç¯å²ãèšå®ããéèšå¯Ÿè±¡ç¯å²ãå®ãããã§ãã ãæ€èšããããããããããŸãã
