Skip to main content

Building Data Analytics Solutions Using Amazon Redshift

Written by wamrhein on . Posted in AWS Training, Training.

Building Data Analytics Solutions Using Amazon Redshift

current course dates can be found at the bottom of this page … company training available on request!

Course description

In this course, you will build a data analytics solution using Amazon Redshift, a cloud data warehouse service. The course focuses on the data collection, ingestion, cataloging, storage, and processing components of the analytics pipeline. You will learn to integrate Amazon Redshift with a data lake to support both analytics and machine learning workloads. You will also learn to apply security, performance, and cost management best practices to the operation of Amazon Redshift.

Course objectives

In this course, you will learn to:

  • Compare the features and benefits of data warehouses, data lakes, and modern data architectures
  • Design and implement a data warehouse analytics solution
  • Identify and apply appropriate techniques, including compression, to optimize data storage
  • Select and deploy appropriate options to ingest, transform, and store data
  • Choose the appropriate instance and node types, clusters, auto scaling, and network topology for a particular business use case
  • Understand how data storage and processing affect the analysis and visualization mechanisms needed to gain actionable business insights
  • Secure data at rest and in transit
  • Monitor analytics workloads to identify and remediate problems
  • Apply cost management best practices

Intended audience

This course is intended for:

  • Data Warehouse Engineers
  • Data Platform Engineers
  • Architects and Operators who build and manage data analytics pipelines

Prerequisites

We recommend that attendees of this course have:

Activities

This course includes:

  • Training with instructor
  • Practical exercises

Course duration / Price

  • 1 day / € 750.00 (excl. tax) per person (DE)

Course outline

Module A: Overview of Data Analytics and the Data Pipeline

  • Data analytics use cases
  • Using the data pipeline for analytics

Module 1: Using Amazon Redshift in the Data Analytics Pipeline

  •  Why Amazon Redshift for data warehousing?
  • Overview of Amazon Redshift

Module 2: Introduction to Amazon Redshift

  • Amazon Redshift architecture
  • Interactive Demo 1: Touring the Amazon Redshift console
  • Amazon Redshift features
  • Practice Lab 1: Load and query data in an Amazon Redshift cluster

Module 3: Ingestion and Storage

  • Ingestion
  • Interactive Demo 2: Connecting your Amazon Redshift cluster using a Jupyter notebook with Data API
  • Data distribution and storage Interactive Demo 3: Analyzing semi-structured data using the SUPER data type
  • Querying data in Amazon Redshift
  • Practice Lab 2: Data analytics using Amazon Redshift Spectrum

Module 4: Processing and Optimizing Data

  • Data transformation
  • Advanced querying Practice Lab 3: Data transformation and querying in Amazon Redshift
  • Resource management
  • Interactive Demo 4: Applying mixed workload management on Amazon Redshift
  • Automation and optimization
  • Interactive demo 5: Amazon Redshift cluster resizing from the dc2.large to ra3.xlplus cluster

Module 5: Security and Monitoring of Amazon Redshift Clusters

  • Securing the Amazon Redshift cluster
  • Monitoring and troubleshooting Amazon Redshift clusters

Module 6: Designing Data Warehouse Analytics Solutions

  • Data warehouse use case review
  • Activity: Designing a data warehouse analytics workflow

Module B: Developing Modern Data Architectures on AWS

  • Modern data architectures

IMPORTANT: Please bring your notebook (Windows, Linux or Mac) to our trainings. If this is not possible, please contact us in advance.

Course materials are in English, on request also in German (if available).
Course language is German, on request also in English.

AWS Cloud Essentials for Business Leaders

Written by wamrhein on . Posted in AWS Training, Training.

AWS Cloud Essentials for Business Leaders

current course dates can be found at the bottom of this page … company training available on request!

Course description

This course is for business leaders who seek an overall understanding of the fundamental concepts of cloud computing. Learn how a cloud strategy can help you meet business objectives. The course dives into the business value of the cloud through customer examples, exploring industry trends, and the Cloud Value Framework, which helps you understand the business value of building on AWS by assessing cost and value impact.

Course objectives

In this course, you will learn to:

  • Explain the role of information technology (IT) in an organization for business transformation
  • Explain the customer value proposition for using the cloud across industries
  • Define key characteristics of cloud computing
  • Explain the cloud business model
  • Identify key security practices of cloud computing
  • Frame the cloud business value using the Cloud Value Framework

Intended audience

This course is intended for:

  • Line of Business (LoB) owners and executives

Prerequisites

We recommend that attendees of this course have:

  • No prior IT experience or cloud experience is required.

Activities

This course includes:

  • Training with instructor
    Practical exercises

Course duration / Price

  • 4 hours / € 750.00 (excl. tax) per person (DE)

Course outline

Module 1: Course Introduction

Module 2: Information Technology for Business Transformation

  • Role of IT in an organization for business transformation
  • Brief history of IT
  • Legacy approach to IT
  • What drives customers to move from traditional infrastructure to the cloud

Module 3: Cloud Computing

  • Define cloud computing
  • Key characteristics of cloud technology
  • The cloud business model
  • Key security practices within the cloud

Module 4: Business Value of the Cloud

  • The customer value proposition
  • Identify who is using cloud computing
  • Industry trends
  • Customer examples

Module 5: The Cloud Value Framework

  • Introduction to the Cloud Value Framework
  • Cost Savings
  • Staff Productivity
  • Operational Resilience
  • Business Agility

Module 6: Business Value Activity

  • Using a fictional customer case study, we review and apply lessons learned from the course

IMPORTANT: Please bring your notebook (Windows, Linux or Mac) to our trainings. If this is not possible, please contact us in advance.

Course materials are in English, on request also in German (if available).
Course language is German, on request also in English.

AWS Cloud Essentials for Business Leaders – Financial Services

Written by wamrhein on . Posted in AWS Training, Training.

AWS Cloud Essentials for Business Leaders – Financial Services

current course dates can be found at the bottom of this page … company training available on request!

Course description

This course is for business leaders who seek an overall understanding of the fundamental concepts of cloud computing. Learn how a cloud strategy can help you meet business objectives. In this half-day, instructor-led course, you’ll explore the possibilities of cloud computing in banking, insurance, capital markets, payments, and financial technology. The course dives into the business value of the cloud through customer examples, exploring industry trends, and the Cloud Value Framework, which helps you understand the business value of building on AWS by assessing cost and value impact.

 

Course objectives

In this course, you will learn to:

  • Explain the role of information technology (IT) in an organization for business transformation
  • Explain the customer value proposition for using the cloud in the financial services industry (FSI)
  • Define key characteristics of cloud computing
  • Explain the cloud business model
  • Identify key Financial Services Industry (FSI) security practices of cloud computing
  • Frame the cloud business value using the Cloud Value Framework

Intended audience

This course is intended for:

  • Line of business (LOB) owners and executives

Prerequisites

We recommend that attendees of this course have:

  • No prior IT experience or cloud experience is required

Activities

This course includes:

  • Training with instructor
  • Practical exercises

Kursdauer / Preis

  • 4 hours / € 750.00 (excl. tax) per person (DE)

Course outline

Module 1: Course Introduction

Module 2: Information Technology for Business Transformation

  • Role of IT in an organization for business transformation
  • Brief history of IT
  • Legacy approach to IT
  • What drives customers to move from traditional infrastructure to the cloud

Module 3: Cloud Computing

  • Define cloud computing
  • Key characteristics of cloud technology
  • The cloud business model
  • Key FIS security practices within the cloud

Module 4: Business Value of the Cloud

  • The customer value proposition
  • Identify who is using cloud computing
  • Industry trends
  • Customer examples

Module 5: The Cloud Value Framework

  • Introduction to the Cloud Value Framework
  • Cost Savings
  • Staff Productivity
  • Operational Resilience
  • Business Agility

Module 6: Business Value Activity

  • Using a fictional customer case study, we review and apply lessons learned from the course

IMPORTANT: Please bring your notebook (Windows, Linux or Mac) to our trainings. If this is not possible, please contact us in advance.

Course materials are in English, on request also in German (if available).
Course language is German, on request also in English.

AWS Well-Architected Best Practices

Written by wamrhein on . Posted in AWS Training, Training.

AWS Well-Architected Best Practices

current course dates can be found at the bottom of this page … company training available on request!

Course description

The AWS Well-Architected Best Practices course will help you learn a consistent approach to evaluate architectures and implement designs from a live instructor. You’ll learn how to use the Well-Architected Review process and the AWS Well-Architected Tool to conduct reviews to identify high risk issues (HRIs). In this 1-day, classroom training course, you’ll learn to apply the five pillars of the AWS Well-Architected Framework—operational excellence, security, reliability, performance efficiency, and cost optimization—to understand the impact of design decisions. You’ll apply what you’ve learned during the course to each pillar of the Well-Architected Framework through tutorials, hands-on labs, discussions, demonstrations, presentations, and group exercises.

Course objectives

In this course, you will learn to:

  • Identify the Well-Architected Framework features, design principles, design pillars, and common uses
  • Apply the design principles, key services, and best practices for each pillar of the Well-Architected Framework
  • Use the Well-Architected Tool to conduct Well-Architected Reviews

Intended audience

This course is intended for:

  • Technical professionals involved in architecting, building, and operating AWS solutions.

Prerequisites

We recommend that attendees of this course have:

Activities

This course includes:

  • Training with instructor
  • Practical exercises

Course duration / Price

  • 1 day / € 750.00 (excl. tax) per person (DE)

Course outline

Module 1: Well-Architected Introduction

  • History of Well-Architected
  • Goals of Well-Architected
  • What is the AWS Well-Architected Framework?
  • The AWS Well-Architected Tool

Module 2: Design Principles

  • Operational Excellence
  • Lab 1: Operational Excellence
  • Reliability
  • Lab 2: Reliability
  • Security
  • Lab 3: Security
  • Performance Efficiency
  • Lab 4: Performance Efficiency
  • Cost Optimization
  • Lab 5: Cost Optimization

 

IMPORTANT: Please bring your notebook (Windows, Linux or Mac) to our trainings. If this is not possible, please contact us in advance.

Course materials are in English, on request also in German (if available).
Course language is German, on request also in English.

Building Data Lakes on AWS

Written by wamrhein on . Posted in AWS Training, Training.

Building Data Lakes on AWS

current course dates can be found at the bottom of this page … company training available on request!

Course description

In this course, you will learn how to build an operational data lake that supports analysis of both structured and unstructured data. You will learn the components and functionality of the services involved in creating a data lake. You will use AWS Lake Formation to build a data lake, AWS Glue to build a data catalog, and Amazon Athena to analyze data. The course lectures and labs further your learning with the exploration of several common data lake architectures.

Course objectives

In this course, you will learn to:

  • Apply data lake methodologies in planning and designing a data lake
  • Articulate the components and services required for building an AWS data lake
  • Secure a data lake with appropriate permission
  • Ingest, store, and transform data in a data lake
  • Query, analyze, and visualize data within a data lake

Intended audience

This course is intended for:

  • Data platform engineers
  • Solutions architects
  • IT professionals

Prerequisites

We recommend that attendees of this course have:

  • Completed thes AWS Technical Essentials training
  • One year of experience building data analytics pipelines or have completed the Data Analytics Fundamentals course

Activities

This course includes:

  •  presentations
  • lecture
  • hands-on labs,
  • group exercises

Course duration / Price

  • 1 day / € 750.00 (excl. tax) per person (DE)

Course outline

Module 1: Introduction to data lakes

  • Describe the value of data lakes
  • Compare data lakes and data warehouses
  • Describe the components of a data lake
  • Recognize common architectures built on data lakes

Module 2: Data ingestion, cataloging, and preparation

  • Describe the relationship between data lake storage and data ingestion
  • Describe AWS Glue crawlers and how they are used to create a data catalog
  • Identify data formatting, partitioning, and compression for efficient storage and query
  • Lab 1: Set up a simple data lake

Module 3: Data processing and analytics

  • Recognize how data processing applies to a data lake
  • Use AWS Glue to process data within a data lake
  • Describe how to use Amazon Athena to analyze data in a data lake

Module 4: Building a data lake with AWS Lake Formation

  • Describe the features and benefits of AWS Lake Formation
  • Use AWS Lake Formation to create a data lake
  • Understand the AWS Lake Formation security model
  • Lab 2: Build a data lake using AWS Lake Formation

Module 5: Additional Lake Formation configurations

  • Automate AWS Lake Formation using blueprints and workflows
  • Apply security and access controls to AWS Lake Formation
  • Match records with AWS Lake Formation FindMatches
  • Visualize data with Amazon QuickSight
  • Lab 3: Automate data lake creation using AWS Lake Formation blueprints
  • Lab 4: Data visualization using Amazon QuickSight

Module 6: Architecture and course review

  • Post course knowledge check
  • Architecture review
  • Course review

IMPORTANT: Please bring your notebook (Windows, Linux or Mac) to our trainings. If this is not possible, please contact us in advance.

Course materials are in English, on request also in German (if available).
Course language is German, on request also in English.