The AWS Solutions Library offers a variety of solutions developed by AWS and its partners to cater to different industrial and technological needs. Check the details below!

About AWS Solutions Library

Numerous companies require prompt and dependable solutions, along with proficient guidance, to tackle business predicaments. The AWS Solutions Library provides a plethora of solutions, which are pre-built and can be customized, and designed by AWS and AWS Partners to suit diverse industries and technology prerequisites.

Automated Data Analytics on AWS

Automated Data Analytics on AWS enables you to derive meaningful insights from data in a matter of minutes through a simple and intuitive user interface.

This solution helps to easily consolidate data distributed across siloes, apply fine-grained governance controls, and query data through a tailored user experience that is abstracted from underlying AWS services. The solution is quickly deployed to an AWS account through a single click, removing the need for deep technical expertise.

Benefits

  • Faster time to value
    • Ready to use out of the box, no need to build your own platform. If you are early in your data journey, get started quickly with the solution, and expand your capabilities over time.
  • Reduced operational overhead
    • Removes the heavy lifting of joining and managing disparate datasets.
  • Self-service analytics
    • Anyone with SQL skills can quickly and easily derive insights from their data.
  • Organization-wide collaboration and controls
    • Users can share datasets and queries across teams with flexible controls to enforce access protection.

Technical Details

  • The diagram below presents the architecture that will be automatically deployed following the steps in the solution’s Implementation Guide and accompanying AWS CloudFormation template.
  • Once deployed, users will access the application through a standalone user interface that abstracts away the underlying AWS services used.
  • Learn how to use this AWS Solution, ingest data from a range of data sources and more in the implementation guide.

Steps to Follow

  • Step 1: The AWS CloudFormation template provisions the following infrastructure and services provided by the solution.
  • Step 2: Amazon CloudFront and AWS WAF for static website hosting distribution and protection. An Amazon DynamoDB table is used to manage and provide persistent notifications in the user interface.
  • Step 3: Federated Identity: An Amazon Cognito user pool manages to federate and store users from external identity providers (IDPs).
  • Step 4: An Amazon DynamoDB table to store group policy statements, and an Amazon Cognito user pool for managing federated user authentication.
  • Step 5: Amazon EventBridge for event-driven application messaging between micro-services and notifications for users
  • Step 6: AWS Lambda functions for handling API requests (NodeJS & Java), and deploying dynamic infrastructure for each data product (NodeJS).
    • AWS Step Functions for managing the lifecycle of data products, and asynchronous life-cycle of query execution.
    • Amazon S3 buckets for storing processed data, user-defined scripts, and file uploads.
    • AWS Glue tables and resources for handling the data extract, transform, and load (ETL) processing.
    • Amazon Athena for performing federated queries which stores results in Amazon S3 buckets.
    • Amazon DynamoDB data stores saved queries, query history, query caching, and governance metadata.
  • Step 7: AWS Lambda functions for handling source import.
    • AWS CloudFormation stack to manage resources.
    • AWS Step Function for orchestrating lifecycle management.
    • AWS Glue crawlers, data catalogues, and jobs for ETL.
    • AWS Secrets Manager to store external credentials.
    • Amazon ECS tasks for processing large data ingestion jobs.
    • Amazon Athena and Amazon Comprehend for detecting PII entities.
  • Step 8: Ingress (Data Connectors): Automated Data Analytics on AWS supports multiple source data connectors out-of-the-box including file upload, AWS S3, Amazon Kinesis, Amazon CloudWatch, Google BigQuery, Google Cloud Storage, and Google Analytics, and databases such as MySql5, Postgres, Oracle, and MS SQL.
  • Step 9: Egress (Clients): Automated Data Analytics on AWS support both JDBC and ODBC standards for consuming data from common clients.

Click here to visit official page of the AWS Solutions Library