Industry
QSR
Challenges
Build a Data warehouse to support the data needs for their CRM and other marketing tools and functions
Solution
Data warehouse should serve as a single source of true data. Discovery of existing data sources and building automated pipelines to bring the data into the data platform.
Challenge
QSR Company wanted to build a Data warehouse to support the data needs for their CRM and other marketing tools and functions. Manual compiling of the data is also a pain area for the business. The PII data was not encrypted and stored with third party.
Solution
- Data warehouse should serve as a single source of true data.
- Discovery of existing data sources and building automated pipelines to bring the data into the data platform.
- Securing and storing the PII information separately.
- Distribution of data to CRM and other Marketing tools.
Business value delivered
Improved Operational Efficiency & Productivity
Technology deployed
- AWS - Lambda
- Kineses
- Firehose
- Glue
- Athena
- S3
- PowerBi
- SNS
- Cloudwatch
- EC2