PT Metrodata Electronics Tbk won the trust from one of the customers engaged on commercial vehicle Sales & Distribution to implement the first Serverless Data Warehouse using Amazon Web Service (AWS) S3 and Redshift as well as Data Visualization’s implementation using Tableau, which is a pioneer of the company’s Big Data project.

Business Challenges

1. The Company want to get better insights into the data they have, which can help in making company decisions later in Dealer Analysis, Unit Analysis in Operations, Telematics Data Analysis captured from sensors on vehicles.
2. Currently the data is spread over several different systems on different platforms, so that the company need “single point of truth” that accommodates all data needs as information.

Project Objectives

1. Build a data warehouse using AWS S3 & Redshift.
2. Build an ETL process using AWS Glue to pull data from any required source.
3. Build Data visualization using Tableau.
4. The decision to use PaaS model can provide faster time to get value from the company’s data, so that the company can focus on analyzing, enriching, and transforming company’s data into useful information insight for company decision making.

Solution

1. Implement a Data Warehouse on Amazon Web Services (AWS).
2. Implement Data Visualization using Tableau.

The Results & Benefits

1. Data Warehouse on Amazon Web Services
2. Data Virtualization on Tableau
3. Development of 65 use cases
4. Development of 5 dashboards

Customer Highlight

1. It is an Agile Project using Kanban methodology, following the 4 values of the Agile Manifesto:
   1. Individuals and Interactions over process and tools.
   2. Working software over comprehensive documentation.
   3. Customer collaboration over contract negotiation.
   4. Responding to change over following a plan.
       
2. Project management tools using Microsoft Teams for Agile Collaboration, and Microsoft Planner for Kanban Dashboard.
    
3. Virtual Daily Standup Meetings are held every day for a maximum 15 minutes to discuss 3 main agendas:
   1. What you did to change the world yesterday?
   2. How are you going to crush it today?
   3. How are you going to blast through any obstacles unfortunate enough to be standing in your way?
       
4. Project will continue to next phases:
   1. Phase 2 in Q3 2021
   2. Phase 3 in Q1 2022
       
5. The first company’s Data Warehouse, a pioneer of Big Data used in all branch offices of the company in Indonesia.

The project last for 5 months after Kick Off Meeting in October 2020 and Go Live in March 2021.