What can we do for you?
Using transactional data to generate operational insights and improve the retail experience.
More Case Studies
The customerStartselect is Europe’s largest reseller of mobile and game credit, gift cards, subscriptions and digital games. All their products are digital and delivered instantly. Customers can purchase and redeem their product within just a few minutes.
The challengeStartselect generates a trove of transactional data from its web store. Management needed to generate quantitative insights based on such data for performance dashboards, customer behaviour modeling, customer segmentation, and other numerical needs within the organization.
Cambrian used AWS Glue, Amazon Redshift, AWS Lambda and Amazon S3 to build the Startselect data & analytics solution. Many business rules were built into AWS Glue in order to validate data and reject invalid information.
As the Startselect store keeps evolving, changes in the data model of the store translate into an evolving structure of stored data in Amazon Redshift. Redshift’s data model was designed in a way that allowed users to use dashboards that present all the available historical data across various historical periods of the store.
The resultsRedshift views were built to allow business users to visualise data in easily accessible and understandable PowerBI dashboards. Additionally, Redshift is used to answer custom data requests throughout the company.
Business users have gained a better understanding of Startselect’s performance and are therefore better able to make the right (data-driven) decisions.