Systems and methods for improved efficiency
Systems and methods for improving efficiency are described herein. The systems and methods described herein can also comprise systems and methods for reducing waste. Systems and methods described herein can comprise a date warehouse, data marts, and visualizations.
1. A method comprising:
determining, using one or more processors, that a first set of load dependencies associated with a first source mart is satisfied; and
responsive to determining that the first set of load dependencies associated with the first source mart is satisfied, gathering, using the one or more processors, data from a set of source database systems associated with the first source mart and storing the data in the first source mart, wherein the first source mart includes a common linkable identifier, the common linkable identifier linked to a first identifier in a first source database system and a second identifier in a second source database system.
2. The method of claim 1 , wherein the first set of load dependencies associated with the first source mart includes a first subset of tables being up-to-date, wherein the first subset of tables is included in the set of source database systems associated with the first source mart.
3. The method of claim 2 further comprising:
determining that a second set of load dependencies associated with the first source mart is satisfied; and
responsive to determining that the second set of load dependencies associated with the first source mart is satisfied, gathering data from the set of source database systems associated with the first source mart and storing the data in the first source mart.
4. The method of claim 3 , wherein the second set of load dependencies associated with the first source mart includes a second subset of tables being up-to-date, wherein the second subset of tables is included in the set of source database systems associated with the first source mart.
5. The method of claim 4 , wherein the first set of tables and the second subset of tables include one or more tables in common.
6. The method of claim 1 , wherein determining that that the first set of load dependencies associated with the first source mart is satisfied includes determining that a first subset of tables is up-to-date, wherein the first subset of tables is included in the set of source database systems associated with the first source mart.
7. The method of claim 1 further comprising:
extracting data from the first source mart based on one or more selected criteria;
manipulating the data extracted from the first source mart; and
storing the manipulated data in a subject area mart.
8. The method of claim 7 , wherein the one or more selected criteria include one or more of a treatment ordering criteria, a delivery treatment criteria, and a patient safety treatment criteria.
9. The method of claim 7 , wherein the subject area mart includes:
a pre-cohort table, wherein a pre-cohort is defined from a population;
a cohort table, wherein the cohort is a subset of the pre-cohort; and
a metric table.
10. A system comprising:
one or more processors; and
a memory storing instructions that, when executed by the one or more processors, cause the system to:
determine that a first set of load dependencies associated with a first source mart is satisfied; and
responsive to determining that the first set of load dependencies associated with the first source mart is satisfied, gather data from a set of source database systems associated with the first source mart and storing the data in the first source mart, wherein the first source mart includes a common linkable identifier, the common linkable identifier linked to a first identifier in a first source database system and a second identifier in a second source database system.
11. The system of claim 10 , wherein the first set of load dependencies associated with the first source mart includes a first subset of tables being up-to-date, wherein the first subset of tables is included in the set of source database systems associated with the first source mart.
12. The system of claim 11 further comprising:
determining that a second set of load dependencies associated with the first source mart is satisfied; and
responsive to determining that the second set of load dependencies associated with the first source mart is satisfied, gathering data from the set of source database systems associated with the first source mart and storing the data in the first source mart.
13. The system of claim 12 , wherein the second set of load dependencies associated with the first source mart includes a second subset of tables being up-to-date, wherein the second subset of tables is included in the set of source database systems associated with the first source mart.
14. The system of claim 13 , wherein the first set of tables and the second subset of tables include one or more tables in common.
15. The system of claim 10 , wherein determining that that the first set of load dependencies associated with the first source mart is satisfied includes determining that a first subset of tables is up-to-date, wherein the first subset of tables is included in the set of source database systems associated with the first source mart.
16. The system of claim 10 , wherein the instructions, when executed by the one or more processors further cause the system to:
extract data from the first source mart based on one or more selected criteria;
manipulate the data extracted from the first source mart; and
store the manipulated data in a subject area mart.
17. The system of claim 16 , wherein the one or more selected criteria include one or more of a treatment ordering criteria, a delivery treatment criteria, and a patient safety treatment criteria.
18. The system of claim 16 , wherein the subject area mart includes:
a pre-cohort table, wherein a pre-cohort is defined from a population;
a cohort table, wherein the cohort is a subset of the pre-cohort; and
a metric table.