Floweraura Leverages Searce Expertise to Ensure Scalable, Cost-effective and Secure Deployment for Business Intelligence Tool on AWS
Challenges
Floweraura wants their real-time Clickstream data into Redshift after performing multiple transformations and filtering. The Floweraura team did not have real-time replication and analytics. Google Analytics data shows ad-cost analysis on day basis, capturing hourly ad-cost data and Inability to get insights from the data that was being captured through various sources.
Searce Solution
Searce conducted a Well-Architected Review of their Overall architecture that ensures that the overall architecture follows the Best Practices of the Industry which are also recommended by AWS. The Searce solution involved:
- Building AWS Kinesis Firehose to get data from DynamoDB into Redshift so that the data can be merged with other data sources and generate actionable insights
- Implemented AWS DMS for CDC replication for near real-time reporting
- To understand the ad cost to acquire a customer, developed python scripts to capture hourly ad cost data and insert into Redshift
- Data models and 10 dashboards in Quicksight to enable near real-time data and analytics
Business Impact
The Searce solution enabled the organization to resolve their existing issues and boost their business with:
- Better decision making and real-time insights based on the reports in QuickSight
- Centralized data warehouse and reporting framework in Redshift where various data sources were merged
- Redshift clusters offer flexibility and scalability as required depending on the peak and slack business periods
About Floweraura
FlowerAura is an online flower store that delivers flowers all over India. FlowerAura delivers the best quality – fresh cut flowers in more than 229+ cities across India with the help of our strong affiliate network and channel stores. The Online flower delivery platform comprises a team with strong technological and operations experience which enables us to deliver fresh flowers and gifts at the cheapest prices available in India. In addition to delivering flowers, they strive to make the special occasion even more special by delivering surprise gifts like cakes, chocolates, teddy bears and sweets.
Industry: Retail
Location: India
more case studies
Driving Logistics Innovation with Searce & Google Cloud
Yaantra partners with Searce & Google Cloud to help consumers with a single window stopover for smart gadgets in India
