Transforming into a data-driven business
With the move to Google Workspace providing an immediate productivity boost, Camper wanted to become more data-driven but needed to modernise its existing data architecture. The local database server, which served as the data warehouse, was limited in terms of scalability, accessibility and integration of different data sources and did not provide a comprehensive overview of the information needed for informed decision-making.
To overcome these challenges, SoftwareOne supported Camper in developing a customised solution in the Google Cloud. The key approach was to democratise all data and create a scalable structure that provides centralised and combined access to all relevant information, while creating the basis for developing predictive models to anticipate the market.
Camper's data journey began with the creation of a data lake, feeding data from various systems such as enterprise resource planning (ERP), analytics, customer relationship management (CRM), marketing automation, eCommerce, logistics and email marketing tools. Using the Google ecosystem, the data was migrated and stored in BigQuery and Google Cloud Storage, giving Camper a centralised and scalable data solution.
With BigQuery as its unified data repository, Camper gains valuable insights into its retail strategies to attract customers to shop in-store and online. Consolidating data sources has eliminated information silos, allowing Camper to analyse information from all applications at once, rather than having to analyse data from each separately. SoftwareOne helped Camper create workflows to upload data into BigQuery in a timely manner and replicate it as needed to ensure system accuracy across systems.