Achieving massive parallel calculation with Google Cloud Platform™️
avgidea, Inc. (Teppei Yagihashi, Founder CEO) has newly developed high speed Cross-tabulation system based on Google Cloud™️ for Paasons Advisory, a strategic boutique at Hakuhodo Inc. Data analysts has experimentally started using the system since March 2020.
avgidea brings various business ideas into practice and offers them to users as form of services or applications using IT technologies. We offer system development and maintenance using cloud technologies such as G Suite™️ and Google Cloud Platform™️ (GCP™️).
Paasons Advisory is a boutique dedicated to strategic planning within Hakuhodo. By fully utilizing cloud platform, Paasons Advisory offers highly agile planning service while constructing always-connected community at strategic layer with clients.
Passons Advisory utilizes Google Cloud G Suite for day-to-day work, therefore, instantaneously starts building cross tabulation application using Google Sheets™️. However, they have realized the boundary of this approach when data volume and a number of analysis axises grows, and performance degradation and spikes of CPU usage at client PCs are noticeable, which start affecting data analysts essential analysis work.
For above issues faced by Paasons Advisory, avgidea has newly designed and built a system, which distributes heavy workloads to cloud. In the past, workloads of “Store”, “Process” and “View” are only beard by Google Sheets. We distribute “Store” and “Process” to GCP and let Google Sheets to focus on “View” and successfully reduce load of client PCs. Further, we achieve parallel execution which is common in high performance computing area and lead to shortening total execution time.
The application built by avgidea for Passons Advisory can be utilized as a general parallel execution platform including cross tabulation so we plan building this as service and provide it to other companies.