Koninklijke Ahold Delhaize & G-workplace

Ahold Delhaize was migrating nearly 260,000 users from G Suite to O365 and needed detailed information about their G Suite environment. They had to choose the best way to migrate their employees to O365 and remove G Suite licenses to save money.

G-workplace created a Google App Engine application in Python to extract data on users, groups, group members, user usage, and disk usage, among other things, and store it in BigQuery via Cloud Tasks. Based on the data in BigQuery, G-workplace created reports in Google Data Studio to gain better insight into the Google environment and the best ways to disable G Suite core services in a coordinated manner.

By using BigQuery and Google Data Studio, G-workplace was able to provide the necessary information to phase out the G Suite environment for the EU and the US separately, while G Suite services remained active for those who still needed them. The result was that only a small number of G Suite licenses are now needed, and over 90% could be decommissioned.