As a leading French agricultural cooperative, Groupe Dauphinoise places collaboration at the heart of its philosophy. Working with farmers in the Rhone-Alpes region, Groupe Dauphinoise takes on a diverse range of activities from agricultural production to research and development to running retail outlets.

As its operations expanded and strained its existing infrastructure, Groupe Dauphinoise saw the opportunity to upgrade its technology solutions and adopted G Suite, Chrome devices and ultimately Google Cloud Platform (GCP).

“We transitioned to G Suite to improve our staff’s collaboration. We quickly realized that as the company grew, we needed a new infrastructure. Based on our satisfaction with G Suite, we chose GCP. With Google, ‘any device, anytime, anywhere’ is not just a dream,” says Sylvain Claudel, Head of IT at Groupe Dauphinoise.

“We transitioned to G Suite to improve our staff’s collaboration. We quickly realized that as the company grew, we needed a new infrastructure. Based on our satisfaction with G Suite, we chose GCP. With Google, ‘any device, anytime, anywhere’ is not just a dream.”

—Sylvain Claudel, Head of IT, Groupe Dauphinoise

Flexible workforce, stable infrastructure

Many of Groupe Dauphinoise’s 1,500 employees spend their days out of the office. Five years ago, with the help of Google partner GoWizYou, the company transitioned to G Suite to improve the flexibility and collaboration of its staff.

As Groupe Dauphinoise began to expand and collect more data, the company reached the limits of its on-premise infrastructure. Adding new storage was not a simple matter. Acquiring, configuring and synchronising new servers costs Groupe Dauphinoise time as well as money. In addition, with all its servers stored in a single room, security was a concern. Groupe Dauphinoise needed a new infrastructure.

Google Cloud Platform was the only solution in mind after Groupe Dauphinoise’s experience with G Suite and Chromebooks. Disruption was kept to a minimum thanks to Google’s licensing agreements with Microsoft products, allowing the company to migrate without affecting its operations.

After migrating its infrastructure to Compute Engine, Groupe Dauphinoise can let Google look after the security and maintenance. Cloud IAM makes it easy for Groupe Dauphinoise to hand out permissions to sensitive resources across a number of sites with maximum security and minimum fuss. The company placed its archives in Cloud Storage, while Cloud SQL allows it to continue to make use of its MySQL databases without disrupting the day to day business. Meanwhile, BigQuery provides Groupe Dauphinoise with the raw power to analyse large datasets quickly.

“Our company is growing and we have more and more data to collect and analyze like sales data, weather patterns or production numbers. With GCP, we have more than a single on-premise data store, so our disaster recovery plan is much more flexible. Compute Engine allows us to add more storage quickly and easily, without having to spend days synchronizing data and installing new servers. We have improved security and maintained the stability of our infrastructure while keeping costs down,” says Sylvain.

Safeguarding the present, looking to the future

With Google Cloud Platform, Groupe Dauphinoise has expanded and secured its infrastructure without sinking costs into on-premise servers or DevOps staff. Its investment in Chrome devices and adoption of G Suite mean that its mobile workforce can fully reap the benefits of a cloud-based infrastructure while dramatically cutting the cost of hardware. Meanwhile, working with a 200 million line table of sales data in Google BigQuery, the cooperative found that queries ran ten times faster than with its previous database provider. Groupe Dauphinoise is experimenting with Google BigQuery to expand its BI capabilities. Products like Google BigQuery help Groupe Dauphinoise grow its business, safe in the knowledge that its infrastructure is stable and secure.

“The amount of data we collect is growing very quickly. We need to break our rules and evolve from the mindset that we had with on-premise infrastructure and our old databases. We can now look at collecting more customer fidelity data, or big data for our farmers. With our data and infrastructure in Google’s care, we can concentrate on growing our customer base instead of our IT department!” says Sylvain.

For consulting companies such as EDI Environmental Dynamics Inc. (EDI), interactions among employees and customers are the direct drivers of value, and helping them collaborate has a tangible impact on the bottom line. However, connecting people from the field to work-from-home spaces to the office is no easy task.

EDI, an environmental consulting company that helps organizations assess environmental impacts and meet government regulations, has eight offices across Western and Northern Canada. Frontline workers account for 80% of its total employees, ranging from biologists and scientists to safety inspectors and project managers. EDI’s success is directly linked to its remote workforce’s ability to work effectively in the field and to collaborate with coworkers and clients across Western Canada. With the help of Google Workspace and AppSheet, EDI is enabling its mobile workforce to function more efficiently and collaboratively than ever before.

Bringing efficiency to its frontline workers

Just four years ago, much of EDI’s fieldwork was still being tracked with pen and paper, resulting in frequent challenges, from error-prone data retention to inefficient collaboration. Luckily, EDI was able to address this using AppSheet, Google Cloud’s no-code application development platform. 

With AppSheet, EDI has replaced the majority of its pen-and-paper processes with tailored apps. As EDI’s Director of IT, Dennis Thideman explains, “AppSheet allows us to be much more responsive to our field needs. Using it, we can spin up a basic industrial application, share it with our field workers, and have them adjust their workflows—all in just a few hours. Doing that from scratch might take weeks or months.”

For EDI, there are a couple of features that make AppSheet shine. First, AppSheet is platform-agnostic, meaning it works on most devices and most operating systems, so any employee can access their AppSheet apps. Secondly, because 90% of EDI’s projects involve working in remote areas, they can leverage AppSheet’s Offline Mode, allowing workers to collect data on their mobile devices in the field and have it automatically download when they reconnect to the internet. 

Eliminating the challenges associated with pen and paper has resulted in even more benefits than EDI leaders originally anticipated: namely, employees work faster across an unexpectedly wide range of use cases. For example, governmental regulations require EDI to complete a pre-trip safety evaluation before heading into the field. Before using AppSheet, this evaluation would take upwards of four hours to complete. By streamlining the process with an AppSheet app, EDI employees have reduced that time down to one hour. EDI averages over 850 evaluations every year, and they’ve realized over 2,550 hours in annual savings—savings that can be passed on to clients and allow staff to focus more time on other tasks. This is just one of more than 35 mission-critical applications that EDI has built with AppSheet.

Time savings is a huge benefit, but as Logan Thideman, an IT manager at EDI, explains “At the end of the day, we realized that the biggest benefits of AppSheet aren’t about time savings as much as they are about high-quality data.” Collecting and analyzing good data is critical to EDI’s operations, as most data collected in the field can never be replicated. For example, if a water quality sample for a certain day is lost (which can happen easily when using pen and paper), that information can never be retrieved again. AppSheet makes data collection easy. Employees are much less likely to lose a smart device than they are a paper form, and any data entered would be immediately uploaded to a Google Sheet or SQL database when they return from the field, meaning data is always backed up in the cloud. From there, information can quickly be analyzed by coworkers, passed on to the client, or shared with government agencies to ensure proper compliance.

Overall, EDI found that the more they could enable their field workers with AppSheet apps, the more those employees could focus on providing quality research and recommendations to their clients and gain a stronger competitive advantage in the market.

Enhancing collaboration everywhere

Enabling collaboration in remote environments can be difficult, but Google Workspace has made this easy for EDI. Google Workspace lets employees effortlessly share documents and work together in real time. Given its ease of use for mobile workers, Google Meet has become all-important and is used as EDI’s tool of choice for face-to-face collaboration. It became even more essential when COVID-19 arrived. As Dennis Thideman explains, “Google Meet allowed us to adapt to the COVID-19 environment quickly as we were already conversant with it. In just two days, we were able to transition our employees from office to home because of it.” By leveraging Google Meet and the rest of the Google Workspace platform, EDI employees are able to remain productive, regardless of where they’re working.

Google Workspace also makes it easy to collaborate with customers. Because many of EDI’s customers leverage Microsoft Office tools such as Word, Excel, and PowerPoint, EDI still needs to use them. Google Workspace makes it easy to continue using Microsoft products in its environment, allowing employees to store Microsoft Office files on Google Drive and open, edit and save them using Google Docs, Sheets, and Slides. 

AppSheet and Google Workspace’s deep integrations also make collaboration easy. Employees can update data in Google Sheets, save images and reports to Drive, and update Calendar events all from AppSheet apps. Together, the two platforms simplify many of the activities that consumed so much time in the past.

An empowered workforce

Empowering employees has been at the core of EDI’s success, and Google Workspace and AppSheet have given EDI a clear advantage. Collaboration has become easier and more agile using Google Workspace. Robust AppSheet apps have been built to streamline mission-critical processes. For unique project requirements, simple AppSheet apps are built in a matter of hours. As Dennis Thideman summarizes, Google Workspace and AppSheet “make managing a distributed, deskless workforce much simpler, giving EDI better growth opportunities and a competitive edge in the marketplace.”

PIK Group is the leading developer of large-scale residential housing projects in Russia. Founded in 1994, PIK Group has built more than 300,000 apartments – 19 million square meters of residential real estate in Moscow and other cities.

To achieve and maintain its position at the top of the real estate industry, PIK Group has made innovation central to its business model, whether creating new building techniques or embracing automation. New technology, in particular, enables the company to achieve efficiencies at scale and streamline processes, such as with PIK Group’s app, developed in-house, through which engineers can send photographs as evidence of the quality of building work.

PIK Group looked for a reliable, fast way for teams to collaborate across multiple offices, on the road, and at construction sites. Because the company handles large volumes of sensitive customer data, security was a key concern. To create a collaboration platform ready to pull the company together, PIK Group looked for a cloud solution to streamline processes and improve productivity.

“The construction industry is progressing,” says Ilya Tikhomirov, CIO at PIK Group. “There are new ways of working, new construction processes, and new materials. PIK wants to lead change in that external context with an internal transformation.”

Automating collaborative processes for greater efficiency

“One team has information about the layout and condition of our buildings and can count the areas that need work, but then needs to match prices and the required work to that information. Previously, we would spend two to three weeks matching all the lists. Now, using Google Apps Script and Sheets, we can run calculations for a building in one hour.”

– Sergey Fuksman, Deputy CIO, PIK Group

Real estate companies of any size have to communicate between office-based staff and teams on the move. For PIK Group, with more than 7,000 employees and 70 offices in the Moscow region alone, communication has to operate at scale. Because each project involves multiple participants and numerous stages, the right collaboration tools can generate major efficiencies.

“Take costing and scheduling work in an apartment. What might sound simple is a complex process with numerous stages, says Ilya. “We need to define each and every step, and the materials required. One group of employees says what the task requires, then another group of employees cost the materials and labor, and yet another group matches the costs to the plan. That process alone requires a lot of communication and collaboration, and it’s just one of many in a single project.” To enhance collaboration, PIK Group looked to give staff instant access to a central, highly secure file repository from anywhere at anytime.

“It’s so much easier to work with our 2,000 suppliers when we share Docs and Sheets instead of emailing back and forth. The speed and convenience of this new way of working is immediately clear. A number of our third-party contractors have been so impressed that they’ve implemented G Suite at their own firms.”

– Ilya Tikhomirov, CIO, PIK Group

To do that, PIK Group implemented the full range of G Suite collaborative tools across more than 7,000 employees. “G Suite has helped change the way employees think about the work they do,” says Ilya. “It has helped them to foster the culture of a small start-up, with all of the agility associated with that.” Now staff at more than 70 offices in the Moscow region managing the construction and sale of apartment blocks, meet and communicate using Google Hangouts and collaborate over distance on Google Sheets and Google Docs, reducing the need to travel and increasing their efficiency by approximately 20%.

In order to reduce the complex, laborious work of prototyping projects, PIK Group automates aspects of the process using Google Apps Script to match lists in different Sheets and generate documents, as Sergey Fuksman, Deputy CIO at PIK Group explains: “One team has information about the layout and condition of our buildings and can count the areas that need work, but then need to match prices and the required work to that information. Previously, we would spend two to three weeks matching all the lists. Now, using Apps Script and Sheets, we can run calculations for a building in one hour.”

Migrating to the cloud for machine learning at scale

With over 7,000 G Suite accounts implemented, PIK Group has set its sights on migrating local infrastructure to Google Cloud Platform. “We have a big IT department with many developers, and we want to redirect them to important projects instead of IT maintenance,” says Ilya. “With machine learning and TensorFlow, we plan to use data from over 50 systems to inform business decisions.”

PIK Group’s internal change is already yielding external results. “It’s so much easier to work with our 2,000 suppliers when we share Docs and Sheets instead of emailing back and forth,” says Ilya. “The speed and convenience of this new way of working is immediately clear. A number of our third-party contractors have been so impressed that they’ve implemented G Suite at their own firms.”