A security & surveillance company Implements Power BI to have effective monitoring and improve operations

Overview


VNB assisted a security company to ease the monitoring of security events by creating automated reports thus reducing both labor and clerical errors 

Customer Profile

Customer is a full-service security firm that provides digital intelligence to proactively predict and prevent security threats using various types such as video surveillance monitoring integration, remote guarding, cyber intelligence, security system integration, security consulting, executive protection, and canine services.  

Customer Situation


security-surveillance-customer-power-bi

Customer had an elaborate and complicated DW solution using various AWS services. The reports that were custom developed using these services were error prone due to the complexity and changing environment. It was also very difficult for them to keep finding resources to fix the issues, hence they ended up going back to weekly manual reporting. The cost prohibitive error prone solution forced customer to rethink platform and reporting needs. The customer reached out to VNB Team to help them move to a more flexible reporting architecture using Microsoft Power BI.

VNB Solution


security-surveillance-customer-power-bi

After a few initial discovery sessions and analysis, Customer and VNB team decided together it was necessary to reverse engineer existing reporting platform including reports and data sources as subject matter experts were not available to provide insights into data and process flow. VNB team did detailed analysis of code base of all aspects of the existing AWS services framework. VNB team proposed a new solution with Power BI as reporting tool along with SQL server and SharePoint as data sources. VNB team also provided industry standard best practices that govern key disciplines of design and development of Power BI reports to help client in future implementations.

Customer Benefits 

  • Huge cost savings by eliminating multiple AWS Services
  • Standardization of report architecture and move to self-service BI mode
  • Elimination of unnecessary hours spent by business users weekly on 100s of manual reports
  • Focus on assisting clients with insights into their security data rather than creation of reports

Related Case Studies


womans-healthcare-powerbi-case-study-vnb

Womans Healthcare Provider Transform Data Consolidation and Visualizations to Improve Patient Care

VNB assisted a womans healthcare provider build data warehouse for Meditech EMR data and creates visualizations using PowerBI to improve patient care

VIEW DETAILS
vnb-custom-powerbi-visual

A pharmaceutical company implements Custom PowerBI Visual for deeper insights into drugs launch milestones

VNB developed a custom PowerBI visual for a pharmaceutical company to aid seamless reporting of program/product launch milestones across their products, regions, sub-regions, and countries 

VIEW DETAILS