æ¡çšåã Data Analytics in Google Cloud Platform (GCP) ãã¹ã
Google Cloud ã®ããŒã¿ã¯ãŒã¯ãããŒå šäœã§ãåè£è ãå®è·µçãªå€æãã©ãè¡ããã確èªã§ããŸãã
- 10å
- 15å
- äžçŽ
- éžæåŒ
- è±èªã®åé¡
- ã¹ããŒããã©ã³ã»ãã¹ã¯ããã
ç°¡åã«èšããš
Data Analytics in Google Cloud Platform ãã¹ãã¯ãGoogle Cloud ã§ããŒã¿ã®ã¯ãšãªãåã蟌ã¿ãã¢ããªã³ã°ãè¡ã人åãã®äžçŽã¬ãã«ã®æ¡çšãã¹ãã§ããéžæåŒã®ã·ããªãªåé¡ãéããŠãããŒã¿ã®åã蟌ã¿ãšä¿åãBigQuery ã¯ãšãªããã€ãã©ã€ã³åŠçã®è§£éãLooker Studio ã§ã®ã¬ããŒãäœæãé床ãšã³ã¹ããèæ ®ãã調æŽã«é¢ããå®è·µçãªå€æåãæž¬å®ããŸãã
枬å®ããå 容
Google Cloud ã§ã®ããŒã¿ã®åã蟌ã¿ãå å·¥ãã¬ããŒãäœæã調æŽã«é¢ããå®è·µçãªå€æåã
ããŒã¿ã®åã蟌ã¿ãšä¿å
åè£è ã¯ãGoogle Cloud ã§ã®ããŒã¿ã®åãèŸŒã¿æ¹æ³ãšä¿åæ¹æ³ãéžã³ãŸãã
倿ãšåŠç
åè£è ã¯ãBigQuery ã¯ãšãªããã€ãã©ã€ã³ã®ååŠçã§äœãçæãããããèªã¿åããŸãã
åæãšå¯èŠå
åè£è ã¯ãLooker Studio ã§ã®çµæã®ã¬ããŒãæ¹æ³ãéžã³ãŸãã
ããã©ãŒãã³ã¹ãšã³ã¹ã
åè£è ã¯ãã¯ãšãªã®è©³çްããžã§ãçµ±èšãããšã«ãåææ¥åãããéããäœã³ã¹ãã«ããæ¹æ³ãèããŸãã
åé¡åœ¢åŒ
éžæåŒ
åè£è ïŒ çãç¶æ³èª¬æã衚ããŸãã¯æãèªã¿ãæ£è§£ãŸãã¯ãã¹ãŠã®æ£è§£ãéžã³ãŸãã
確èªã§ããå å®¹ïŒ åè£è ãå 容ãèªèããã ãã§ãªããå®éã«æŽ»çšã§ããã»ã©çè§£ããŠããããæž¬å®ããŸãã
10åã§åé¡15åã1åãã€åºé¡
ãã®ãã¹ãã«é©ããè·çš®
Google Cloud ã§ããŒã¿ã®ã¯ãšãªãåã蟌ã¿ãã¢ããªã³ã°ãè¡ã人ã察象ã§ããã¬ããŒãæ åœè ãããŒã¿ã¢ããªã¹ããã¢ããªãã£ã¯ã¹ãšã³ãžãã¢ãããŒã¿ãšã³ãžãã¢ãããžãã¹ã€ã³ããªãžã§ã³ã¹éçºè ãèªãããŒã¿ãæºåããããŒã¿ãµã€ãšã³ã¹å®åè ãã¯ã©ãŠãããŒã¿ãã©ãããã©ãŒã ãèšèšããã¢ãŒããã¯ããå«ãŸããŸãã
å®åçãªããŒã¿å€æã瀺ã蚌æ
ããŒã«åã ãã§ã¯åãããªã倿åã確èª
å°ããªè¡šãSQL ã¯ãšãªããžã§ãçµ±èšãªã©ãåè£è ãèªã¿åããå ·äœçãªæ å ±ãæç€ºãããããGoogle Cloud ã®æ¥åã«ã€ããŠã©ã®ããã«èãããã確èªã§ããŸãã
ã¬ããŒãæ¹æ³ã確èª
Looker Studio ã®ã·ããªãªåé¡ã§ã¯ãåè£è ãçµæã®ã¬ããŒãæ¹æ³ãã©ãéžã¶ããåãããŸããå±¥æŽæžã«èšèŒãããåæããŒã«ã®äžèЧã ãã§ã¯åãããªãæ å ±ãåŸãããŸãã
ã³ã¹ããšããã©ãŒãã³ã¹ã®ãã©ã³ã¹ãè©äŸ¡
åé¡ã§ã¯ãç¹å®ã®ã³ã³ãœãŒã«ç»é¢ã®ç¥èã«é Œãããæç€ºãããæ å ±ã䜿ã£ãŠã¯ãšãªãããéããäœã³ã¹ãã«ããæ¹æ³ãèããŸãã
åè£è ããšã«åŸãããå 容
- ãã¹ãäžããã¹ãã®ã¿ããé¢ããã«åéš
- åçã®è²Œãä»ããªã
- äžå®ã®ããŒã¹ã§åç
ã¹ã³ã¢ããããã£ãŒã«ãIntegrity Scoreã®ã·ã°ãã«ã¯ã颿¥ãšããããŠç¢ºèªããããã®æ å ±ã§ããèªåçãªå€æã«ã¯äœ¿ãããŸããã
ãã®ãã¹ããç¡æã§å©çš
ãã¹ãã®å¶åŸ¡ãšç¢ºèªçšã·ã°ãã«
åè£è ããšã«ãå€§èŠæš¡ãªåé¡ããŒã«ããç°ãªãåé¡ãç°ãªãé åºã§åºé¡ãããéžæè¢ã®é åºãå ¥ãæ¿ãããŸãããã©ãŠã¶ãŒã«ã¯äžåºŠã«1åãã€è¡šç€ºãããæ£çããŒã¿ã¯ HireValid ã®ãµãŒããŒã«ä¿åãããŸãã10åã®å¶éæéã¯ãµãŒããŒäžã§èšæž¬ãããŸããããŒãžãåèªã¿èŸŒã¿ãããšãæ®ãæéãšãšãã«åãåé¡ã衚瀺ãããŸããåè£è ã¯åã®åé¡ã«æ»ããŸãããå顿ã®ã³ããŒãéžæã¯ã§ãããã³ããŒããããã¯ãããå Žåã¯ãã®è©Šè¡ãã¿ã€ã ã©ã€ã³ã«èšé²ãããŸããHireValid ã¯ããã¹ãç»é¢ããé¢ããŠããæéãåçæ¬ãžã®è²Œãä»ããåé¡ãèªãã«ã¯éãããåçãªã©ã®ã·ã°ãã«ãèšé²ããŸããIntegrity Score ãšèšŒæ ã®ã¿ã€ã ã©ã€ã³ã¯ãéçšäž»ã確èªããããã®ãã®ã§ããã©ã¡ããåç¬ã§å€æãäžããã®ã§ã¯ãããŸãããåè£è ã®åæãããå Žåã¯ãã©ã³ãã ãªã¿ã€ãã³ã°ã§ãŠã§ãã«ã¡ã©ã®åçã远å ã§ããŸãã
AIã«ããäžæ£ãé²ãæ¹æ³ · èª å®æ§ã«é¢ããã·ã°ãã«
ã¹ã³ã¢ã倿ææã®äžã€ãšããŠæŽ»çš
å°èŠæš¡ãªããŒã¿ã»ããã®åã蟌ã¿ãã¯ãšãªçµæã®èª¬æãªã©ãè·åãåæ ããå®åãµã³ãã«ãšããããŠã¹ã³ã¢ã確èªããŠãã ãããæ§é å颿¥ã§åè£è ã®å€æã«ã€ããŠæãäžããŸããããã¹ã³ã¢ã¯äººã確èªããããã®æ å ±ã§ãããåæ Œåºæºãæ¡çšå€æã§ã¯ãããŸãããé¢é£ãããã¹ããšããŠãSnowflakeãTableauãPower BI ãã芧ãã ããã
æ§é å颿¥ã®è³ªå
æ°ãããŠã§ãã€ãã³ãããŒã¿ã Google Cloud ã®ã©ãã«åã蟌ã¿ãä¿åããããã©ã®ããã«æ±ºãããæããŠãã ããã
ããŒã¿ã®çšéãã©ã確èªããå®è¡å¯èœãªåãèŸŒã¿æ¹æ³ãšä¿åæ¹æ³ã説æãããã«æ³šç®ããŸãã
BigQuery ã¯ãšãªããã€ãã©ã€ã³ã®ååŠçã§äœãçæãããããã©ã®ããã«ç¢ºèªããã説æããŠãã ããã
ã¯ãšãªãåºåãæç¢ºã«èªã¿åããçµæãã©ãæ€èšŒãããã説æã§ããã確èªããŸãã
åŠçãé ãã³ã¹ãã®ãããã¯ãšãªã®ãžã§ãçµ±èšã確èªããããã§ãæ€èšãã倿Žã説æããŠãã ããã
çµ±èšæ å ±ãšåæã®ç®çã«åºã¥ããæ ¹æ ã®ããèª¿æŽæ¹æ³ãéžã¹ãã確èªããŸãã
ã¹ã³ã¢ãšãã³ãããŒã¯ãçè§£ãã
å ¬å¹³æ§ãšé æ ®æªçœ®
ã·ããªãªã§ã¯ã泚æãã»ã³ãµãŒã®æž¬å®å€ããŠã§ãã€ãã³ãããµããŒããã±ãããªã©ãå°åã«é¢ããç¥èãäžèŠãªäžè¬çãªããžãã¹ããŒã¿ã䜿çšããŸããé貚èšå·ã¯äœ¿ããŸãããåé¡ã¯ãæéã®å ·äœçãªæ°å€ããã¬ãã¥ãŒæ®µéã®æ©èœã§ã¯ãªããå®å®ããŠããŠææžåãããŠããåäœã«ã€ããŠåããŸããå¿ èŠãªè¡šãã¯ãšãªãçµ±èšæ å ±ã¯ãã¹ãŠå顿ã«ç€ºããããããç¹å®ã®ã³ã³ãœãŒã«ç»é¢ãèŠããŠããå¿ èŠã¯ãããŸããã
é æ ®æªçœ®ãšããŠãåè£è ã«è¿œå ã®æéãäžããããšãã§ããŸããçµæã¯äººã確èªããããã®æ å ±ã§ãããèªåçã«å€æãäžããã®ã§ã¯ãããŸããã
æ«å®å€ïŒåæ€è ã200人ã«éããæç¹ã§ä¿¡é Œæ§ãå ±åããŸãã
ãã¹ãã®è©³çް
Google Cloud ã§ã®äžçŽã¬ãã«ã®åææ¥åã«é¢ããã·ããªãªåé¡ã§ããåè£è ã¯ãããŒã¿ã®åãèŸŒã¿æ¹æ³ãšä¿åæ¹æ³ãéžã³ãBigQuery ã¯ãšãªããã€ãã©ã€ã³ã®ååŠçã§çæããããã®ãèªã¿åããLooker Studio ã§çµæãã¬ããŒãããé©åãªæ¹æ³ãéžã³ãã¯ãšãªãããéãäœã³ã¹ãã«ããæ¹æ³ãèããŸããå€ãã®åé¡ã§ã¯ãå°ããªè¡šãçã SQL ã¯ãšãªããŸãã¯ãžã§ãçµ±èšãæç€ºãããŸãã
- åé¡ã¯è±èªã§ãã
- è£å©ããŒã«ã¯äžèŠã§ãã
- å質åã«é çªã«äžåºŠãã€åçããŸããåã®è³ªåã«æ»ãããšã¯ã§ããŸããã
- æéå¶éä»ããã¹ãã®åã«ãç·Žç¿åé¡4åïŒ4åïŒ
Google Cloud Platform, Google Cloud, BigQuery, Cloud Storage, Pub/Sub, Dataflow, Dataproc, Dataform, Cloud Composer, Looker Studioã¯åææè ã®åæšã§ããHireValidã¯åææè ãšææºããŠããããæšèŠãåããŠããŸããã
ãããã質å
Google Cloud Platformã®ããŒã¿åæãã¹ãã¯ãã©ã®ãããªæ¹ã«é©ããŠããŸããïŒ+
ã¬ããŒãæ åœè ãããŒã¿ã¢ããªã¹ããã¢ããªãã£ã¯ã¹ãšã³ãžãã¢ãããŒã¿ãšã³ãžãã¢ãããžãã¹ã€ã³ããªãžã§ã³ã¹éçºè ãèªãããŒã¿ãæºåããããŒã¿ãµã€ãšã³ã¹å®åè ãã¯ã©ãŠãããŒã¿ãã©ãããã©ãŒã ãèšèšããã¢ãŒããã¯ãåãã®äžçŽã¬ãã«ã®ãã¹ãã§ããGoogle Cloud ã§ããŒã¿ã®ã¯ãšãªãåã蟌ã¿ãã¢ããªã³ã°ãè¡ãè·çš®ã«é©ããŠããŸãã
Google Cloud Platformã®ããŒã¿åæãã¹ãã®ã·ããªãªãå ¬å¹³ã§ããçç±ã¯äœã§ããïŒ+
ã·ããªãªã§ã¯ã泚æãã»ã³ãµãŒã®æž¬å®å€ããŠã§ãã€ãã³ãããµããŒããã±ãããªã©ãäžè¬çãªããžãã¹ããŒã¿ã䜿çšããŸããå°åã«é¢ããç¥èã¯äžèŠã§ããåé¡ã«å¿ èŠãªè¡šãã¯ãšãªãçµ±èšæ å ±ã¯å顿ã«ç€ºããããããã³ã³ãœãŒã«ç»é¢ãèŠããŠããå¿ èŠã¯ãããŸããã
Data Analytics in Google Cloud Platform (GCP) ãã¹ãã§ã¯ãæéããã¬ãã¥ãŒæ©èœã«ã€ããŠåºé¡ãããŸããïŒ+
ããããåºé¡ããã®ã¯ãå®å®ããŠããŠææžåãããŠããåäœã«é¢ããå 容ã§ããæéã®å ·äœçãªæ°å€ãããŸã ãã¬ãã¥ãŒæ®µéã®æ©èœã«ã€ããŠã¯åããŸããããã®ãããBigQuery ããã€ãã©ã€ã³ãµãŒãã¹ã®åäœãçè§£ããŠããåè£è ããæè¿ã®æé倿Žã«ãã£ãŠäžå©ã«ãªãããšã¯ãããŸãããè£å©è³æã¯äœ¿çšã§ãããåè£è ã¯åã®åé¡ã«æ»ããŸããã
åè£è ã¯äºåã« Data Analytics in Google Cloud Platform ãã¹ãã詊ããŸããïŒ+
ã¯ããç·Žç¿åé¡ã¯4åã§ãæèŠæéã¯4åã§ããæ¡ç¹å¯Ÿè±¡ã®ãã¹ããåããåã«ãéžæåŒåé¡ã®åœ¢åŒã確èªã§ããŸããããŒã¿æ¥åã«é¢ããå¥ã®ãã¹ããšæ¯èŒããã«ã¯ã[ããŒã¿æœåºã»å€æã»ããŒãïŒETLïŒ](/tests/role-specific-skills/data-extraction-transformation-and-loading-etl)ãã芧ãã ããã
é¢é£ãã¹ã
Amazon Web Services (AWS)ã§ã®ããŒã¿åæ
10åããœãããŠã§ã¢ã¹ãã«
詳ããèŠãSnowflake
10åããœãããŠã§ã¢ã¹ãã«
詳ããèŠãExcelã§ã®ããŒã¿åæ
10åããœãããŠã§ã¢ã¹ãã«
詳ããèŠãTableau
10åããœãããŠã§ã¢ã¹ãã«
詳ããèŠãPower BI
10åããœãããŠã§ã¢ã¹ãã«
詳ããèŠãããŒã¿ãšã³ãžãã¢åãApache Spark
10åãããã°ã©ãã³ã°ã¹ãã«
詳ããèŠã次åã®æ¡çšã§Google Cloud Platform (GCP)ã§ã®ããŒã¿åæãã¹ããæŽ»çšããŸããã
Freeãã©ã³ã«ã¯å¿ é ãã¹ã5çš®ãå«ãŸããææãã©ã³ã«ã¯ãã¹ãŠã®ãã¹ãã©ã€ãã©ãªãå«ãŸããŸãã