Case Study

A leading supply chain management specialist provider in Malaysia successfully achieved 15 minutes refresh with real- time data. 

Download the Case Study
Industry

Supply chain

Expertise

AWS DMS, Amazon S3, Amazon Quicksight, AWS VPC, AWS EC2

Offerings/Solutions

To import data from the production AWS account to the BI AWS account.

About the Client

Incorporated in 2015, Line Clear Express & Logistics is a fully integrated supply chain management specialist providing seamless, reliable, and efficient delivery services across Malaysia.

Highlights

15 minutes refresh on QuickSight Dashboard

Reports are generated in Real-time

Interactive dashboards

The Challenge

The client required a centralized data repository (Data Lake) to hold data collected at various delivery phases and from multiple applications. 

Solutions

  •  Setting up infrastructure in a different AWS account, and import data from the production AWS account to the BI AWS account. 
  •  Using Amazon QuickSight (Enterprise Edition) which is a cloud-scale fast business analytics service to build visualizations and quickly get business insights on the data. 
  •  Processing data in Databricks Workspace to create a separate VPC with private and public subnets for its cluster. 

The Results

Replication of Real-Time data changes on Aurora RDS cluster tables on Databricks Hive meta-store tables is set up. And successfully achieved 15 minutes refresh with Real-Time data on QuickSight Dashboard.

Download the Case Study

Get The Most Out Of Us

Our support doesn't end here. We have monthly newsletters, study guides, practice questions, and more to assist you in upgrading your cloud career. Subscribe to get them all!