Real time data tracking, analytics data warehousing, and front end reporting system
An embodiment provides a method, including: receiving, from a plurality of devices, event data; storing, in electronic memory of one or more source devices, event data reported by the plurality of devices; routing, using a processor, the event data to a warehouse database; storing, in the warehouse database, the event data according to a plurality of storage dimensions associated with one or more of a plurality of selectable elements of a graphical user interface; and displaying, on a display device operatively coupled to the warehouse database, a front end program comprising the graphical user interface having the plurality of selectable elements; wherein, responsive to user interface with one of the plurality of selectable elements in the graphical user interface, the data warehouse communicates a subset of the event data by associating a storage dimension with the one of the selectable elements in the graphical user interface. Other embodiments are described and claimed.
1. A system, comprising:
a plurality of devices associated with a site within a hospital facility, each of the plurality of devices providing event data, wherein the event data comprise transactional data identifying information related to statistics of the site and generated utilizing a statistic tracking system;
one or more source devices that store, in electronic memory, the event data provided by the plurality of devices;
a processor that operates to route the event data to a warehouse database, wherein to route comprises routing the event data to a portion of the warehouse database associated with the site;
said warehouse database storing the event data according to a plurality of storage dimensions associated with one or more of a plurality of selectable elements of a graphical user interface, each of the plurality of storage dimensions comprising a different refinement of information associated with the selectable element; and
a front end program that displays the graphical user interface having the plurality of selectable elements, wherein the graphical user interface allows a user to generate one or more reports using at least a portion of the event data;
wherein, responsive to user interface with one of the plurality of selectable elements in the graphical user interface, the data warehouse communicates a subset of the event data by associating a storage dimension with the one of the selectable elements in the graphical user interface, wherein the subset of event data comprises a refinement of the event data corresponding to the refinement of the associated storage dimension.
2. The system of claim 1 , wherein the warehouse database communicates with the one or more source devices to obtain the event data according to a policy.
3. The system of claim 2 , wherein the policy is a timing policy that provides near real-time updates of event data to the warehouse database.
4. The system of claim 1 , wherein the plurality of storage dimensions are each associated with at least one of the plurality of selectable elements of the graphical user interface.
5. The system of claim 4 , wherein each of the plurality of selectable elements of the graphical user interface is provided in a set of predetermined categories provided by the front end program.
6. The system of claim 1 , wherein a subset of the plurality of selectable elements of the graphical user interface includes predetermined categories associated with a decomposition tree provided by the front end program.
7. The system of 1 , wherein the graphical user interface provides an option to retrieve the event data.
8. The system of claim 1 , wherein the front end program permits re-organization of the plurality of selectable elements to facilitate retrieval of different combinations of event data from the data warehouse.
9. The system of claim 1 , wherein the front end program automatically forms a predetermined graphic using the event data based on one or more selectable elements selected by a user within the graphical user interface.
10. The system of claim 1 , wherein:
the front end program determines a user permission; and
the front end program provides, based on the user permission, a predetermined view the event data associated with a predetermined subset of storage dimensions.
11. A method, comprising:
receiving, from a plurality of devices associated with a site within a hospital facility, event data, wherein the event data comprise transactional data identifying information related to statistics of the site and generated utilizing a statistic tracking system;
storing, in electronic memory of one or more source devices, event data reported by the plurality of devices;
routing, using a processor, the event data to a warehouse database, wherein the routing comprises routing the event data to a portion of the warehouse database associated with the site;
storing, in the warehouse database, the event data according to a plurality of storage dimensions associated with one or more of a plurality of selectable elements of a graphical user interface, each of the plurality of storage dimensions comprising a different refinement of information associated with the selectable element; and
displaying, on a display device operatively coupled to the warehouse database, a front end program comprising the graphical user interface having the plurality of selectable elements, wherein the graphical user interface allows a user to generate one or more reports using at least a portion of the event data;
wherein, responsive to user interface with one of the plurality of selectable elements in the graphical user interface, the data warehouse communicates a subset of the event data by associating a storage dimension with the one of the selectable elements in the graphical user interface, wherein the subset of event data comprises a refinement of the event data corresponding to the refinement of the associated storage dimension.
12. The method of claim 11 , wherein the warehouse database communicates with the one or more source devices to obtain the event data according to a policy.
13. The method of claim 12 , wherein the policy is a timing policy that provides near real-time updates of tracking data to the warehouse database.
14. The method of claim 11 , wherein the plurality of storage dimensions are each associated with at least one of the plurality of selectable elements of the graphical user interface.
15. The method of claim 14 , wherein each of the plurality of selectable elements of the graphical user interface is provided in a set of predetermined categories provided by the front end program.
16. The method of claim 11 , wherein a subset of the plurality of selectable elements of the graphical user interface includes predetermined categories associated with a decomposition tree provided by the front end program.
17. The method of 11 , wherein the graphical user interface provides an option to retrieve the event data.
18. The method of claim 11 , wherein the front end program permits re-organization of the plurality of selectable elements to facilitate retrieval of different combinations of event data from the data warehouse.
19. The method of claim 11 , wherein the front end program automatically forms a predetermined graphic using the event data based on one or more selectable elements selected by a user within the graphical user interface.
20. The method of claim 11 , further comprising:
determining a user permission;
wherein said front end program provides, based on the user permission, a predetermined view the event data associated with a predetermined subset of storage dimensions.