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.