IT Security Compliance Dashboard and Datawarehouse for Luxury Hotel Chain of Asia

suman verma Case Studies

The client was experiencing lack of IT compliance and security dashboard which would outline all KPIs related to its overall compliance across all the locations. IGT helped with developing IT compliance & security dashboard using PowerBI, SSIS, PowerShell & designed datawarehouse using SQL Server for the client which provided centralized view of their overall compliance at account, computer & security levels.

Share this Post

Benefits

  • 10 dashboards with real time insights
  • Direct consumption of security compliance data from various sources
  • 50 + compliance metrics with live business alerts on critical non-compliance data like Security threats and breaches
  • Accurate measurement of security compliance goals for multiple hotel properties worldwide
  • Comprehensive coverage around all major security compliance areas
  • Multiple views based on the user profiles at local, global & executive levels

Client
The client is a leading chain of luxury hotels based out of China with luxury properties in 10 major cities.

Problem Statement
The client was experiencing lack of IT compliance and security dashboard which would outline all KPIs related to its overall compliance across all the locations. Apart from this they were not able to gather the compliance statistics in order to generate various compliance because of data silos & segregated data systems with no integration in place.

Business Challenges
Compliance Reporting: Senior management, IT & security team needed to analyse the security compliance across hotel chain properties throughout the globe
Incomplete Compliance: Existing manual & highly error prone excel based security compliance reports with KPIs around multiple compliance areas
Lack of Integration: Overall security compliance information was difficult to generate due to data silos & segregated data systems with no integration in place
Huge Data Volume: Huge data needed to be extracted & transformed from multiple structured & semi-structured sources to measure overall compliance

IGT’s Approach/Solutions

Developed IT compliance & security dashboard using PowerBI, SSIS, PowerShell & designed datawarehouse using SQL Server for the client. It consolidates data from active directory, managed engines (various sites), SharePoint, HR data and derives the compliance for their users, computers, devices against various compliance needs.

Dashboard provides centralized view of their overall compliance at account, computer & security levels.

It facilities IT group to take necessary actions based on the non-compliances across completeness of inventory, windows patching, third party patching, blacklisted software’s, OS vendor Support, employees password compliance and Antivirus etc.