Complete AWS Big Data and Analytics Certification

Create filters and excluded lists to refine datasets, including exclude fields, country and date range filters, and time granularity, then apply and visualize for actionable insights.

Create map charts using area maps, apply conditional formatting to color countries by profit, and adjust tooltips. Tune filters and themes to achieve color harmony across the dashboard.

Apply conditional formatting and pivot tables to highlight top performing states in a data visualization dashboard, using color-coded ranges to tell a clear data story.

Create and configure an Amazon S3 bucket to store datasets, selecting a region, managing public access and encryption, and uploading files as objects.

Create and manage batch processing using Amazon Batch on Amazon EC2, configuring compute environments, job queues, and definitions, and monitor job status under a pay as you go model.

Create a new database in Amazon Athena named population, and import data from an S3 bucket by selecting a dataset and defining the table columns.

Explore Athena queries using select statements, create and drop tables, and manage table properties, location, and performance—for practical data analysis in AWS big data workflows.

Write a query to compute total population and total female population by time and location, filtering years 1980 to 2000 using a group by statement in Athena.

The lecture demonstrates using the create statement to create a database and tables, select the database, handle errors, and rename or recreate tables.

Explore Amazon CloudSearch, a fully managed, scalable search service with auto-complete, highlighting, geospatial search, and range and boolean full-text search.

Kinesis Video Streams provides fully managed, secure video streaming from connected devices for analytics and machine learning, with encrypted data, durable storage in S3, and accessible APIs.

Explore creating and configuring Amazon Kinesis Data Streams and Amazon Kinesis Data Firehose, set throughput and destinations, enable enhanced fan out, and monitor stream status in real time.

Learn to set up AWS Kinesis streams with Python boto3, including creating streams, describing them, listing streams, and putting records with partition keys, while managing permissions and basic encryption options.