Executive Summary
About the Customer
Customer Challenge
Customer’s use case was to create insightful dashboards on a Managed Services platform which used embedded analytics in the HR portal for their clients which should be able to track critical management program and surveys by enabling them to move from static spreadsheets email reports and ad-hoc analysis to always-available dashboards.
Serverless Architecture
A serverless architecture is a way to build and run applications and services without having to manage infrastructure. The Customer no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Since, the size of the data is not defined and the data will be growing in future, the serverless architecture from AWS services has been chooses. For the data migration, AWS database migration services (DMS) is used, for storage Amazon Simple Storage Service(S3) is used. For the data transformation and data cleaning AWS Glue has been used and for building data marts AWS Athena has been used.
Partner Solution
- In the subsequent sequence, the overall data flow from extraction in SQL to the final dashboard is carried out.
- AWS Database Migration Service is used to migrate the RDS source(MySQL database) to transfer full data load and then delta data only.
- For data engineering, AWS Glue was set up, and data quality checkpoints were performed on the data lake using AWS Lambda.
- For all the data that passed the data quality check, a separate database was created, Athena was configured to query the data and ingest the data to QuickSight.
- The data validation and transformation were done, and visualization were created as per the Qualee Technology requirements, and then these dashboards were embedded in the client domain.
AWS Services Used
As part of the solution architecture, the following AWS Services were used in the development of the QuickSight dashboard embedding project:
- AWS DMS
- AWS Glue
- AWS S3
- AWS Lambda
- AWS Athena
- AWS QuickSight
Results and Benefits
- A high-level view of aggregated survey & quiz responses from employees across different surveys to recognize and analyze the perception for the surveys answered.
- The HR interaction with the portal is improved, encouraging the customer to make a thoughtful decision.
- Open-ended responses were able to analyze as a Word Cloud.
- Client engagement in collecting benchmark results which leads to increase employee efficiency is increased by 50%.
- With excellent enterprise-grade dashboards, visibility and control over data have increased by 30%.
- The outcome was to get reliable data from the target audience, create and publish the dashboard on the client web portal utilizing web embedding.