IMV data dữ liệu

IMV’s Business Intelligence Empowered by AWS Data Management Solution

Established in 1996, International Minh Viet Joint Stock Company (IMV) is a prominent Vietnamese distribution company which specializes in Photo Imaging & Printing, Baby Care, Cosmetics, and Medical Imaging Systems. IMV has offices in all major cities with an expansive distribution network covering traditional, modern, and e-commerce channels. This allows IMV to broaden its presence and provide services to all 63 provinces in Vietnam. IMV’s ambition is to reshape Vietnam’s consumer landscape by providing top-quality products to end consumers, ultimately enhancing their modern, convenient lifestyle.

imv logo

Industry:

Manufacturing, Trading and Distributing

Technology:

AWS (Amazon Web Services) Cloud

CUSTOMER CHALLENGE

IMV used to grapple with a complex data landscape, in which data spread across diverse sources such as Oracle Database on AWS and numerous spreadsheets. This data fragmentation posed a significant challenge as it hindered the company’s ability to consolidate and access a unified view of the company’s data. Another pressing challenge for IMV was the heavy reliance on manual reporting processes, which not only consumed valuable resources but also introduced the risk of errors in reporting, posing serious implications for decision-making. 

Furthermore, the former infrastructure of IMV lacked the scalability required to accommodate the growing volumes of data and the increasing demand for business intelligence and analytics. 

Timeliness of insights was another critical challenge: its old setup could not provide the agility required for swift decision-making, potentially impacting IMV’s competitiveness in the market. As IMV continues its growth trajectory, such limitations of the existing current systems made it imperative for IMV to acquire a scalable, cost-effective infrastructure that could adapt to their evolving data needs without incurring excessive operational overhead.

SOLUTION - RENOVA CLOUD APPROACH

The focus of the IMV project was to build data lakes for processing data and transform them into comprehensive, insightful PowerBI reports, based on which IMV can make informed decisions that contribute to growth objectives. After careful consideration of IMV’s requirement and its existing IT infrastructure, Renova Cloud proposed a data management solution that relied on AWS Glue for Extraction – Transformation – Load (ETL); Amazon S3 for storing data; and Amazon Athena for querying necessary data needed by BI tools. Furthermore, Renova also employed AWS Glue Data Catalog for catalog management in order to achieve better integration between the selected AWS services.

IMV data dữ liệu
Figure 1: Overall architecture of IMV solution

The IMV solution was implemented in three phases with clearly defined tasks and deliverables. First, Renova Cloud set up a data lake for the client to store raw data ingested from their existing Oracle database hosted on Amazon EC2. Second, we aggregated this raw data to create a data source for Power BI, where raw data were duplicated and transformed into data types required by its destination processing tools. Finally, Renova used AWS Glue Crawler to determine schema, create tables, and write metadata in the AWS Glue Data Catalog. Based on this central metadata store, Amazon Athena would subsequently query processed data in S3 to create different views. As a result, Power BI would use the outputs from these views as a data source to build insightful data reports such as Marketing Reports, Sales MT Reports & Sales GT Reports, or Inventory reports. 

As the region’s leading AWS partner, compliance with AWS best practices is always one of Renova Cloud’s top priorities when delivering solutions and the IMV project was not an exception. The overall architecture and operation of the IMV solution were fashioned and deployed in adherence with AWS Account Governance best practices such as informing the client’s team on when to use and not to use the root user for workload-related activities or activating MFA on the root account. 

Client’s employee empowerment was also an important aspect of the IMV project thanks to the real-near-time alert mechanism based on pre-built workflows configured within AWS Step Functions. Specifically, In the event of any workflow step failure, a notification will be sent to the responsible administrator for immediate remediation. Thanks to this near real-time alert mechanism, the IMV team could proactively prevent unwanted interruptions when one or more elements could not make it to their intended destination.

BENEFITS

  • Thanks to the AWS Data Management solution, IMV could now gain valuable insights from existing raw data, enabling the company to stimulate growth and streamline operations
  • The IMV solution operates on a serverless service, which allows IMV to minimize operational expense as they would only have to pay for what they actually used
  • The sizing for AWS Glue and AWS Lambda was carefully studied and selected based on IMV’s estimated usage requirements to maximize ROI

RELATED STORIES

6 1 7
Cloud Reselling White 1

Ngân hàng Thương mại Cổ phần

Joint Stock Commercial Bank successfully accelerated growth by migrating to AWS

The competitive digital race among banks is increasingly fierce, focusing on attracting technology-savvy customers. The commercial bank wanted to stay ahead of the competition and required scalable, reliable and cost-effective back-end infrastructure for rapid growth.Read more>
IMV web 610x400 1
Cloud Reselling White 1

IMV

IMV’s Business Intelligence Empowered by AWS Data Management Solution

The former infrastructure of IMV lacked the scalability required to accommodate the growing volumes of data and the increasing demand for business intelligence and analytics. Read more>
web 610x400 5
Cloud Reselling White 1

E-wallet

Vietnam’s Prominent E-wallet Migrated Its Two Most Critical Workloads to AWS

The E-wallet in question is one of Vietnam’s largest online payment platforms, developed and published by one of the most dominant technology players in the region. Read more>
web 610x400 8
Cloud Reselling White 1

F88

F88’s Journey to a Secure and Centralized Data Management with AWS Cloud Solutions

Established in 2013, F88 stands as the forerunner network of secure lending in Vietnam, focusing on serving micro & small enterprises as well as individual customers. Receiving substantial financial support from renowned global Read more>
web 610x400 12
Cloud Reselling White 1

Greenfeed

Greenfeed Data optimization solution with AWS

Greenfeed's mission is to provide consumers with a clean food chain from farm to table with the 3F Plus process - FARM FEED FOOD. Read more>
web 610x400 3
DevOps Transform White 1

Startup oi

RENOVA – STARTUP OI – SUCCESS STORY

Startup Oi is a new social media and tech talent platform. Startup Oi has an ambitious goal to focus on professional needs of tech engineers and developers, building a digital community and connecting with job opportunities and tech events. Read more>
web 610x400 5
Cloud Reselling White 1

Vietcetera

VIETCETERA – MIGRATION JOURNEY TO AWS

Founded in 2016, Vietcetera is a first-of-its-kind multimedia digital platform producing editorial content along with video series and podcasts in both Vietnamese and English.Read more>
imv photo
Cloud Reselling White 1

IMV

IMV – ON-PREMISE TO CLOUD JOURNEY

International Minh Viet Joint Stock Co. is a distribution company which entails general trade, modern trade, as well as an e-commerce channel. Read more>
smartpay illustration photo
Cloud Reselling White 1

Smartpay

SmartPay Rehost and Replatform Migration on AWS

SmartPay is an important contender in the Vietnamese payment apps landscape and experiencing growth with new vendors, partners, and users. Read more>
pepsico case study product scaled
Cloud Reselling White 1

Pepsi Co Myanmar

Accelerate SAP S/4HANA Transformation With AWS

Pepsi Co Myanmar was looking to modernize their existing systems and launch a new platform for their users and applications utilizing the up-to-date technology solutions and choose SAP S/4HANA on AWS. Read more>
engineers working photo
Cloud Reselling White 1

Nutifood Group

AWS Immersion Day with Nutifood Group

The goal of this educational workshop was to empower N Group's IT team and leadership to confidently use the AWS platform for their benefit, and unlock new business opportunitiesRead more>
photo 1571247865791 9d7ed2ddf033
Cloud Reselling White 1

Tadiran

Serverless application implementation on AWS for Tadiran Group

Tadiran is a leading technical and electrical appliances manufacturer company. Some of the company’s more famous product lines include batteries and air conditioners. Read more>
webinar blog banner
Cloud Reselling White 1

Scratchpay

Scratchpay Security best practices and well-built architecture on GCP

Evaluation and assessment of the existing GCP environment for best practices and well-built architecture methodologiesRead more>
UAB CLOUD NATIVE APPS 1
uab white 1

UAB - Connect. Create. Change.

UAB BANK CLOUD NATIVE APPS

As a part of the modernisation and digitalisation strategy, UAB is expanding its services to build mobile apps for payment and e-Wallet purposes to serve the growing Myanmar consumer banking marketRead more>
YOMA MIGRATION MANAGED SERVICES 1
yoma white 2

Yoma

Yoma Transformation to AWS Cloud

The increasing demand for Yoma’s applications and business across different verticals requires to have a digital transformation journey with an effective migration to the cloud.Read more>
AQUA AUTOMATION DEVOPS 1
aqua white 1

AQUA

AQUA – Migration & CI/CD

AQUA is able to improve operations as result of the migration and CI/CD on AWS as well as able to release new features faster with minimal time and disruption to the end users.Read more>
SOVIGAZ PROTECTS CRITICAL SYSTEMS ON AWS 1
sovigaz white 2

SOVIGAZ

Sovigaz – migrating to AWS

The agility of the new infrastructure help Sovigaz to relieve the burden of on premise infrastructure management and limitations as well as access to advanced services offered on AWS platform. Read more>
KAOPIZ AUTOMATION CI CD 1
kaopiz white 2

KAOPIZ

Kaopiz’s Infrastructure Automation

Automate the processes on AWS and create an environment to test new features to support the Development & QA team to deliver jobs faster, automated and without a deep level of experience and skills on AWS.Read more>
NAVIGOS MIGRATION BACKUP 1
navigos white 2

NAVIGOS

Navigos’ journey to the Cloud

As part of the company commitment to it’s customers, it is essential to secure a robust disaster recovery process. Navigos’ application requires to have a fast and effective reaction in the disaster recovery scenarios.Read more>
SABECO MIGRATION WELL ARCHITECTED 1
sabeco white 1

SABECO

Sabeco Case Study

Having migrated to AWS, Sabeco is capable of quickly responding to increased traffic and services’ usage when necessary, making running marketing campaigns and launching new features less risky.Read more>
Nkid case study image 1
Nkid white 1

NKID’S

Nkid’s journey to the Cloud

Nkid Group is running a number of Microsoft workloads in various environments including on-premises, local data center in Vietnam, Microsoft Azure and AWS.Read more>