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

Overview


VNB Consulting 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 our team to help them move to a more flexible reporting architecture using Microsoft Power BI.

Our Solution Offering


security-surveillance-customer-power-bi

After a few initial discovery sessions and analysis, Customer and our 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. Our team did detailed analysis of code base of all aspects of the existing AWS services framework. We proposed a new solution with Power BI as reporting tool along with SQL server and SharePoint as data sources. Our 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


Electrical Diagnostics Innovator Accelerates Data Insights Through Microsoft Fabric

Century-old Electrical Diagnostics Innovator Accelerates Insights Using Microsoft Fabric for Business Central

VNB Consulting modernized analytics for a global electrical diagnostics firm using Microsoft Fabric for Business Central.

VIEW DETAILS
Payment Processing Company Case Study

Payment Processing Company Implements a Tool to Analyze Customer Activity and Better Retain Existing Customers

VNB Consulting helped a payment processing company develop a tool that enabled them to analyze customer behavior …

VIEW DETAILS