[text]
This Guidance helps consumer packaged goods (CPG) companies connect data from databases and ecommerce sites to create forecasts and increase visibility into inventory, sales, and marketing campaigns. In this Guidance, sales data with anomalous behaviors are sent to dashboards where alerts can be configured, so companies can take appropriate action. A time-series, machine learning forecasting service is also deployed in this Guidance, designed to analyze business metrics to help companies forecast easily and accurately.
Please note: [Disclaimer]
Architecture Diagram
![](https://d1.awsstatic.com/apac/events/2021/aws-innovate-aiml/2022/eng/innovate-aiml-22-UI_Gradient-Divider.082bb46e8d9654e48f62bf018e131dd8ec563c4e.jpg)
[text]
Step 1
AWS Database Migration Service (AWS DMS) will connect with your databases using change data capture (CDC). Data about sales, products, and marketing campaigns is collected and sent to Amazon Kinesis Data Streams. Optionally, you can send data from your e-commerce site to Kinesis Data Streams directly.
Well-Architected Pillars
![](https://d1.awsstatic.com/apac/events/2021/aws-innovate-aiml/2022/eng/innovate-aiml-22-UI_Gradient-Divider.082bb46e8d9654e48f62bf018e131dd8ec563c4e.jpg)
The AWS Well-Architected Framework helps you understand the pros and cons of the decisions you make when building systems in the cloud. The six pillars of the Framework allow you to learn architectural best practices for designing and operating reliable, secure, efficient, cost-effective, and sustainable systems. Using the AWS Well-Architected Tool, available at no charge in the AWS Management Console, you can review your workloads against these best practices by answering a set of questions for each pillar.
The architecture diagram above is an example of a Solution created with Well-Architected best practices in mind. To be fully Well-Architected, you should follow as many Well-Architected best practices as possible.
-
Operational Excellence
This Guidance is designed to provide you with the information necessary to help you understand your internal business state. For instance, each component sends logs and metrics to Amazon CloudWatch for monitoring. And DynamoDB is used to process information, such as last forecast completion time and number of items analyzed, providing transparency to your business users. You can also choose to deploy this Guidance with AWS CloudFormation that allows for small and frequent changes, and adapt it to fit within a continuous integration and continuous delivery (CI/CD) pipeline.
-
Security
This Guidance provides a selection of capabilities that helps ensure you have robust identity management in place. With Amazon S3, all buckets have encryption enabled and are configured to restrict access for only those services that should interact with it. The other services in this Guidance use AWS Identity and Access Management (IAM) policies with least-privilege access, allowing users to connect and complete only the necessary actions. QuickSight is provisioned with a login page for business users, and if you deploy the option of a webpage for forecasts with DynamoDB, you can use Amazon Cognito for authentication.
-
Reliability
This Guidance supports a reliable architecture for each application level. The components that process data, such as AWS Lambda, AWS Glue, Step Functions, and Athena are serverless, reducing concerns with scalability and scaling. In the data layer, this Guidance uses Amazon S3 that provides 11 9s of durability and DynamoDB that scales automatically to adapt to the application's load. And Forecast and QuickSight are fully managed services that provide automated recovery from failures and scalability.
-
Performance EfficiencyThe services selected for were purpose-built for this Guidance. The fully managed services, such as QuickSight, will adapt its capacity for the number of interactions, providing performance as it scales. DynamoDB auto-scales horizontally, allowing consistency in performance even with peak loads. You can experiment with this Guidance by adjusting Lambda and AWS Glue to process data faster and according to the needs of retraining the model. SageMaker Canvas will explore and process a series of adjustments based on the user’s data to achieve the best performance without the need for the user to understand machine learning extensively.
-
Cost Optimization
The components in this Guidance are serverless, providing a pay-as-you-go approach, avoiding oversized, provisioned resources to help you keep the costs related to the number of completions and the amount of data to be processed. From the data perspective, ETL is processed by a scheduled AWS Glue job, stored in Amazon S3, and read by Athena, avoiding spends with servers. SageMaker Canvas will be retrained only when scheduled, avoiding costs with this process as well. QuickSight provides cost per active user, allowing you to start with costs only for dedicated analysts.
-
Sustainability
This Guidance uses a serverless first approach, which means that there are no compute idle resources. The fully managed services in this Guidance scale as demand grows, reducing and optimizing the number of resources running. For example, AWS Glue will process on schedule, turn on its resources, process ETL, store it on Amazon S3, and turn the servers and the resources down. This directly reduces energy consumption and the impact of your carbon footprint.
Implementation Resources
![](https://d1.awsstatic.com/apac/events/2021/aws-innovate-aiml/2022/eng/innovate-aiml-22-UI_Gradient-Divider.082bb46e8d9654e48f62bf018e131dd8ec563c4e.jpg)
A detailed guide is provided to experiment and use within your AWS account. Each stage of building the Guidance, including deployment, usage, and cleanup, is examined to prepare it for deployment.
The sample code is a starting point. It is industry validated, prescriptive but not definitive, and a peek under the hood to help you begin.
Related Content
![](https://d1.awsstatic.com/apac/events/2021/aws-innovate-aiml/2022/eng/innovate-aiml-22-UI_Gradient-Divider.082bb46e8d9654e48f62bf018e131dd8ec563c4e.jpg)
[Title]
Disclaimer
The sample code; software libraries; command line tools; proofs of concept; templates; or other related technology (including any of the foregoing that are provided by our personnel) is provided to you as AWS Content under the AWS Customer Agreement, or the relevant written agreement between you and AWS (whichever applies). You should not use this AWS Content in your production accounts, or on production or other critical data. You are responsible for testing, securing, and optimizing the AWS Content, such as sample code, as appropriate for production grade use based on your specific quality control practices and standards. Deploying AWS Content may incur AWS charges for creating or using AWS chargeable resources, such as running Amazon EC2 instances or using Amazon S3 storage.
References to third-party services or organizations in this Guidance do not imply an endorsement, sponsorship, or affiliation between Amazon or AWS and the third party. Guidance from AWS is a technical starting point, and you can customize your integration with third-party services when you deploy the architecture.