Houston Public Works have multitude of data sources they work with, for data analytics. Frequently, the problem arises where analysts have a hard time making sure that the data that they are working with is up-to-date or if its consistent with the data that their peers have. There was a need to develop a solution where HPW’s analysts can reliably pull data without the hassle of locating and verifying the data source each time. The solution should also provide a form of data governance to make it simple for the IT department to grant and remove access to the data as needed.

Enlyte has over 100 AWS accounts and more than 1000 servers across multiple AWS Regions. The servers are managed using AWS Systems Manager. Enlyte wanted to configure and execute scheduled patching for instances across multiple accounts and region. The challenge faced by the operations team was to be able to visualize the patching status, attributes, parameters, metrics etc. about the servers in one single pane using advanced visualizations. They needed a dashboard which would give them the ability to filter data and get a clear idea about the status of each server in each account and region across the organization.