The Problem: I work for a company that has on-call rotations for emergencies after hours. The most common emergencies come in the form of alarms physically placed in a specific location (e.g. alarm no. 2208 was set off at housing unit at the corner of Elm St. & Pine Blvd). We often need to use multiple programs on my company’s network and open excel spreadsheets (often all at the same time) to find the relevant information to determine the necessary information to address emergencies. This is time consuming, which is not good for time-sensitive issues.
The Idea: I want to create a program that takes information from excel spreadsheets and my company’s alarm software (accessed via url on the internet in a secure network) and displays everything in one screen. That is, I only need to input the alarm number, and all the relevant programs and information is displayed on a single, interactive dashboard.
The Challenge: My main hurdle is to ensure security (no hacking or communication with an outside network) and whether a ‘free’ data visualization tool exists to embed URLs to stream live data and import excel spreadsheet data. I know PowerBI supports embed URLs, but as far as I know it costs money that my superiors might not be willing to spend.
Can anyone offer insight on how to tackle this project? Further, does anyone know of any data visualization tools exist that meet my needs (free, no communication with outside network, and embed web-apps and import excel data)?