Application Note: Video - ANV071
Using Power BI for Data Visualization of Video Search Metadata
2024-07-26 Revision 1.0
This document is intended for use by an end user’s data analyst with an understanding of, and experience using, Python and Power BI who wishes to extract business insights from video analytics metadata. It’s ideal for retail customers, but the concepts also apply across industries.
Organizations have multiple data sources, such as POS terminals, environmental sensors, and enterprise resource planning (ERP) systems. Organizations may already be using a data visualization tool, such as Power BI or a similar one, to perform data analysis. They can get valuable insights by combining this with metadata extracted from video surveillance cameras. Brivo Eagle Eye Video can convert nearly any industry-standard ONVIF-compliant camera into an AI camera by leveraging AI capabilities in the Cloud. The metadata extracted from AI is available via Eagle Eye's open APIs and can be viewed and manipulated with data visualization tools.
The suggested process outlined below describes how a Python script can be used to pull data from the Brivo Eagle Eye API and inject it into Power BI.
Create an app in Eagle Eye Networks developer portal. Get an application ClientID and client secret. Obtain account access token and base URL.
Using the Python code provided, make the edits specified below. Once complete, run the script. The script will create a JSON text file in the local directory with metadata from Eagle Eye Network’s API.
Import the JSON file into Power BI to be used for data visualization.
Navigate to the Eagle Eye Networks developer portal using the following URL: https://developer.eagleeyenetworks.com/
Select “My Application/Login” in the top right-hand corner.
Log in to the account using your Brivo Eagle Eye Video credentials.
Select “List applications” on the Manage Applications tile.
Select “Add Application.”
Complete the required fields and select “Save Changes.”
The application will now show in the application list. Select “See client credentials.”
Select “Add credential.”
Complete the required fields as shown below.
Select “Add credential.”
Now that an application has been created, the Client ID and client secret can be viewed.
Record your Client ID and Client Secret. Please note these are specific to your application.
Navigate back to the “My Application" Login page and select the “Test it” button on the Quick API testing tile.
Record the contents of both “Your access token” and “Your base URL.”
Use the script below with your Client ID, client secret, access token, and base URL to pull metadata from Eagle Eye Networks’ API.
This script will create a JSON text file in your local directory titled “responsedata.json.”
Using Power BI desktop, import the data from the “Get Data” tab.
Select “More…” from the drop-down menu.
Select JSON, then click the Connect button.
Navigate to the directory where the file titled “responsedata.json” was saved, and select Open.
The data is now loaded into Power BI, where it can be transformed and manipulated for data visualization.