Sunray Group
AWS-QuickSight-Service
Industry Vertical – Hospitality
The Client
Sunray Group is a family-owned, multifaceted corporation specializing in hospitality and development. Sunray believes in the strength of brand equity. The group is successfully building an ever-increasing portfolio of award-winning brands, which include Marriott, Starwood, Hilton, Radisson, Best Western, IHG, Wyndham and Choice Hotels. They have also developed prominent brands such as Tim Horton's, McDonald's, Fionn McCool’s, Shell and Petro Canada.
The Challenge
Relied on static monthly billing exports with limited detail. No granular visibility into per-account, per-instance, and per-service usage. Reports took weeks to prepare, delaying financial decisions. No forecasting capability for future cost planning.
The Solution
- Integrated AWS Cost & Usage Report (CUR) stored in Amazon S3.
- Queried CUR data with Amazon Athena.
- Connected Athena datasets to Amazon QuickSight (SPICE) for high-performance queries.
- Built interactive dashboards for finance, cloud operations, and leadership.
- Enabled ML Insights for anomaly detection and predictive cost forecasting.
Outcome
- Reporting cycle reduced from 2 weeks → real-time dashboards
- Discovered $30K annual savings by identifying unused EC2 and storage resources.
- Finance leaders gained self-service cost analytics.
- Proactive budgeting and cloud governance across business units.
