SoftwareOne case study
Popular Book Company Proves the Value of Modern Retail Analytics with a Generative BI Platform on AWS
Popular Book Company needed to modernize its data infrastructure to turn massive volumes of retail data into actionable insights, moving from a slow, legacy system to a dynamic, AI-enabled cloud platform.
As a leading retailer, Popular Book Company recognized that its existing reporting infrastructure, running on SAP Business Warehouse (BW), was creating challenges. The system struggled with an ~ 11TB data volume, leading to slow performance, while the process for generating new reports was manual and time-consuming. This made it difficult for management, merchandising, and operations teams to access timely insights for strategic decision-making .
Popular wanted to understand the benefits of a modern, scalable solution that could introduce next-generation analytics and Generative BI capabilities. The objective was to demonstrate how a centralized data repository could automate workflows and provide stakeholders with interactive, visually rich dashboards.
Partnering with SoftwareOne, Popular Book Company successfully implemented a new data analytics platform on AWS. The solution uses a powerful data lakehouse architecture to process data from sources like LSBC retail data and SAP ERP and use Amazon Q in QuickSight to answer business critical questions using natural language. This successful implementation proves the efficiency of the new system and lays the foundation for a future driven by data.
- Client
- Popular Book Company
- Industry
- Retail
- Platform
- AWS Cloud
- Services
- Application Services: Data Analytics
- Country
- Singapore
SoftwareOne delivered more than what they promised. The speed and flexibility of the new AWS platform are remarkable. Our teams are more empowered than ever, and with Generative BI, we are asking questions of our data that we never thought possible. This is the foundation for our next phase of growth.
Popular Book
Retail General Manager
A modern data lakehouse on AWS with Gen-BI
SoftwareOne partnered with Popular to design and implement a Data Analytics Platform built on AWS. The project was structured the engagement to demonstrate the powerful capabilities of a modern cloud data architecture.
The core of the solution involved replacing the on-premise SAP BW system with a scalable data lakehouse on AWS. The architecture leverages.
- Amazon S3: To store 13 months of historical and incremental raw data from sources including SAP ERP and LSBC retail systems.
- AWS Glue: To perform ETL (Extract, Transform, Load) processes, automating the cleaning and structuring of data as it moves from the raw data lake (Bronze layer).
- Amazon Redshift: As the central, high-performance cloud data warehouse, serving as the single source of truth for all structured data for transformed (Silver) and aggregated (Gold) layers.
- Amazon QuickSight: For creating intuitive and interactive dashboards to visualize key KPIs.
- Amazon Q in QuickSight: To showcase Generative BI capabilities, allowing users to ask questions in natural language and receive instant visualizations and answers.
More case studies
Connect with our experts
Share a few details about your business challenge, and we’ll get right back to you.
Connect with our experts
Share a few details about your business challenge, and we’ll get right back to you.