Centralising GCP Projects and Infrastructure

Truworths’ scattered GCP projects and infrastructure presented a significant challenge, with multiple accounts and no centralised management structure. This lack of centralisation led to inefficiencies, security risks, and a complex billing process that relied on a credit card for payments. CloudSmiths swiftly developed a comprehensive plan to centralise Truworths’ GCP environment and streamline their operations.

The first step involved establishing a single GCP organisation specifically for Truworths and linking it to a centralised billing account. This strategic move consolidated their projects under one roof, enabling more efficient management and oversight. By migrating their projects to the newly created organisation and connecting them to the centralised billing account, Truworths transitioned to a more streamlined payment process, which eliminated the reliance on a credit card and provided better financial control.

Enhancing Security and Governance

Security and governance were also top priorities for Truworths. The scattered nature of their previous GCP setup posed significant risks, so CloudSmiths conducted a thorough review of their Identity and Access Management (IAM) policies. We standardised their naming conventions, ensuring consistency and clarity across the organisation, and implemented granular IAM policies to enhance security and governance. These measures enabled Truworths to manage user access more effectively, reducing the risk of unauthorised access and ensuring that their cloud infrastructure was secure and compliant with industry best practices.

Optimising Data Processing with BigQuery Integration

In addition to centralising their GCP environment, Truworths sought to optimise their data processing capabilities. To achieve this, CloudSmiths seamlessly integrated their existing SAS system with Google’s powerful BigQuery data warehouse. This integration facilitated an efficient extraction, transformation, and loading (ETL) pipeline from BigQuery to their on-premise environment, significantly enhancing their data analysis and decision-making processes.

The BigQuery integration allowed Truworths to process large volumes of data more quickly and accurately, providing valuable insights that drive better business decisions. This optimisation has empowered Truworths to leverage data more effectively, ensuring that they remain competitive in the fast-paced retail industry.

Strengthening Security with Google Workspace

Recognising the importance of robust security practices, CloudSmiths also provided expert guidance on Google Workspace. We set up control panels and implemented granular IAM policies within Google Workspace, enabling Truworths to manage user access more effectively and strengthen their overall security posture. This holistic approach to security ensured that Truworths' digital environment was protected across all fronts, from cloud infrastructure to user management.