Redshift (Cloud)


Retail business

Project Scope

Conduct analysis of several dozen gigabytes of transaction data using Amazon Web Services (AWS).

Project Goal and Objectives

Keep costs to a minimum by using the transparent AWS cost structures and flexibility of increasing or reducing server capacity. Secure data transfer to the Redshift Cloud. Carry out an effective and qualitative data analysis.

Requirements, Constraints and Framework

Similar to all data intensive projects, data cleansing proved to be the most time consuming part of the project. With large data volumes each phase took anything between a few minutes and a couple of hours. A structured approach was necessary.

Key Implementation Steps

  1. Transfer using a direct dedicated connection to the AWS backbone

  2. Concept and setup of DWH (Data Warehouse) cluster

  3. Data cleansing

  4. Data analysis using standard SQL-Clients (Tableau, Alteryx)

  5. Presentation of the analysis. Archive the data. Shut down of the Redshift cluster

Resources Allocated

For data preparation, the setup of the Redshift cluster and transfer to the cloud:
AWS Solution Architect: 2 Weeks (50-100%)

For performing the analysis, creating the visualizations and documentation:
IT Analyst: 8 Weeks (100%)

Interested in our portfolio? Project Inquiry? Questions related to an upcoming project?
We will find the best course of action and suitable solution to transform your business.