A system for collecting, aggregating, and analyzing data, the system comprising one or more processors for executing instructions stored in non-transitory computer readable storage medium, the instructions comprising:
- ingesting an unstructured file comprising text;
- mapping the unstructured file to a primary aggregated data form, wherein the primary aggregated data form is mapped to a tenant on a cloud-based database;
- creating a unique user pool for the primary aggregated data form to provide data isolation security to the primary aggregated data form, wherein users within the unique user pool have permissions to access the primary aggregated data form;
- translating the unstructured file to a computer-readable file by causing a file analysis machine learning algorithm to execute optical character recognition processing on the unstructured file to identify textual characters in the unstructured file;
- classifying content of a plurality of words or phrases within the computer-readable file by cross-referencing the plurality of words or phrases against known vocabulary, wherein the plurality of words or phrases comprises a name of a device;
- scraping web data from a webpage by communicating directly with the webpage and executing a web script to render the webpage as a simulated user interaction, wherein the scraped web data pertains to the device;
- comparing the scraped web data to applicable stored data to determine whether a discrepancy exists between the scraped web data and the applicable stored data, wherein the applicable stored data pertains to the device;
- in response to identifying the discrepancy between the scraped web data and the applicable stored data, resolving the discrepancy by updating the applicable stored data to comprise the scraped web data;
- assigning the plurality of words or phrases from the computer-readable file to one or more data buckets associated with the primary aggregated data form based on the content classification, wherein the primary aggregated data form is stored on the cloud-based database, and wherein the primary aggregated data form comprises at least one device data bucket assigned to receive the name of the device;
- replicating the primary aggregated data form to generate one or more facility aggregated data forms, wherein each of the one or more facility aggregated data forms is customizable relative to the primary aggregated data form, and wherein each of the one or more facility aggregated data forms is stored on the database;
- generating a summary file comprising information from the primary aggregated data form, wherein the summary file comprises structured data and unstructured data;
- identifying a facility where the summary file will be utilized;
- retrieving the name of the device from the device data bucket for the aggregated data form;
- cross-referencing the name of the device against the applicable stored data pertaining to the device to identify one or more products associated with the device;
- electronically communicating with an inventory management solution associated with the facility to determine whether any of the one or more products is available at the facility;
- and
- electronically communicating with an invoicing system associated with the facility to determine an itemized cost of at least a portion of the one or more products when utilized at the facility.