# Analytics **Topics** + [Analyze Amazon Redshift data in Microsoft SQL Server Analysis Services](analyze-amazon-redshift-data-in-microsoft-sql-server-analysis-services.md) + [Analyze and visualize nested JSON data with Amazon Athena and Amazon Quick Sight](analyze-and-visualize-nested-json-data-with-amazon-athena-and-amazon-quicksight.md) + [Automate data ingestion from AWS Data Exchange into Amazon S3](automate-data-ingestion-from-aws-data-exchange-into-amazon-s3.md) + [Automate encryption enforcement in AWS Glue using an AWS CloudFormation template](automate-encryption-enforcement-in-aws-glue-using-an-aws-cloudformation-template.md) + [Build a data pipeline to ingest, transform, and analyze Google Analytics data using the AWS DataOps Development Kit](build-a-data-pipeline-to-ingest-transform-and-analyze-google-analytics-data-using-the-aws-dataops-development-kit.md) + [Build a video processing pipeline by using Amazon Kinesis Video Streams and AWS Fargate](build-a-video-processing-pipeline-by-using-amazon-kinesis-video-streams-and-aws-fargate.md) + [Build an ETL service pipeline to load data incrementally from Amazon S3 to Amazon Redshift using AWS Glue](build-an-etl-service-pipeline-to-load-data-incrementally-from-amazon-s3-to-amazon-redshift-using-aws-glue.md) + [Build an enterprise data mesh with Amazon DataZone, AWS CDK, and AWS CloudFormation](build-enterprise-data-mesh-amazon-data-zone.md) + [Calculate value at risk (VaR) by using AWS services](calculate-value-at-risk-var-by-using-aws-services.md) + [Configure cross-account access to a shared AWS Glue Data Catalog using Amazon Athena](configure-cross-account-access-to-a-shared-aws-glue-data-catalog-using-amazon-athena.md) + [Convert the Teradata NORMALIZE temporal feature to Amazon Redshift SQL](convert-the-teradata-normalize-temporal-feature-to-amazon-redshift-sql.md) + [Convert the Teradata RESET WHEN feature to Amazon Redshift SQL](convert-the-teradata-reset-when-feature-to-amazon-redshift-sql.md) + [Deploy and manage a serverless data lake on the AWS Cloud by using infrastructure as code](deploy-and-manage-a-serverless-data-lake-on-the-aws-cloud-by-using-infrastructure-as-code.md) + [Enforce tagging of Amazon EMR clusters at launch](enforce-tagging-of-amazon-emr-clusters-at-launch.md) + [Ensure Amazon EMR logging to Amazon S3 is enabled at launch](ensure-amazon-emr-logging-to-amazon-s3-is-enabled-at-launch.md) + [Generate test data using an AWS Glue job and Python](generate-test-data-using-an-aws-glue-job-and-python.md) + [Cost-effectively ingest IoT data directly into Amazon S3 using AWS IoT Greengrass](cost-effectively-ingest-iot-data-directly-into-amazon-s3-using-aws-iot-greengrass.md) + [Launch a Spark job in a transient EMR cluster using a Lambda function](launch-a-spark-job-in-a-transient-emr-cluster-using-a-lambda-function.md) + [Migrate Apache Cassandra workloads to Amazon Keyspaces by using AWS Glue](migrate-apache-cassandra-workloads-to-amazon-keyspaces-by-using-aws-glue.md) + [Migrate Oracle Business Intelligence 12c to the AWS Cloud from on-premises servers](migrate-oracle-business-intelligence-12c-to-the-aws-cloud-from-on-premises-servers.md) + [Migrate an ELK Stack to Elastic Cloud on AWS](migrate-an-elk-stack-to-elastic-cloud-on-aws.md) + [Migrate data to the AWS Cloud by using Starburst](migrate-data-to-the-aws-cloud-by-using-starburst.md) + [Optimize the ETL ingestion of input file size on AWS](optimize-the-etl-ingestion-of-input-file-size-on-aws.md) + [Orchestrate an ETL pipeline with validation, transformation, and partitioning using AWS Step Functions](orchestrate-an-etl-pipeline-with-validation-transformation-and-partitioning-using-aws-step-functions.md) + [Perform advanced analytics using Amazon Redshift ML](perform-advanced-analytics-using-amazon-redshift-ml.md) + [Query Amazon DynamoDB tables with SQL by using Amazon Athena](query-amazon-dynamodb-tables-sql-amazon-athena.md) + [Access, query, and join Amazon DynamoDB tables using Athena](access-query-and-join-amazon-dynamodb-tables-using-athena.md) + [Set up language-specific sorting for Amazon Redshift query results using a scalar Python UDF](set-up-language-specific-sorting-for-amazon-redshift-query-results-using-a-scalar-python-udf.md) + [Subscribe a Lambda function to event notifications from S3 buckets in different AWS Regions](subscribe-a-lambda-function-to-event-notifications-from-s3-buckets-in-different-aws-regions.md) + [Three AWS Glue ETL job types for converting data to Apache Parquet](three-aws-glue-etl-job-types-for-converting-data-to-apache-parquet.md) + [Visualize Amazon Redshift audit logs using Amazon Athena and Amazon QuickSight](visualize-amazon-redshift-audit-logs-using-amazon-athena-and-amazon-quicksight.md) + [Visualize IAM credential reports for all AWS accounts using Amazon Quick Sight](visualize-iam-credential-reports-for-all-aws-accounts-using-amazon-quicksight.md) + [More patterns](analytics-more-patterns-pattern-list.md)