Archiving Paste Equipment Data
Hi all, I'm thinking of archiving all past equipment and just wondering if anybody have any better suggestions as to what i'm thinking. 1. Creating a duplicate App, then setting up automation to...
Forum Discussion
Samuel,
Just another idea to add the many great suggestions already listed:
Data Warehousing
You may want to try archiving your data in the form of a data warehouse. You can think of a data warehouse as a big Excel pivot table for a chunk of similar operations data. The summary values in this pivot table are saved in a non-linked format for historic reporting instead of keeping track of years' worth of operations data and performing calculations on the data each time a report is generated. In addition to reporting speed, this is particularly handy when you want to use a new field to track a metric or update the way it's calculated. You wouldn't have to wrangle legacy data or look through archived .csv files because the value you want is already calculated and saved in your data warehouse. Data warehousing also gives you an opportunity to remove any bad data from metric calculations.
Example:
You would need to identify the business metric needs for the data being archived and relevant summary time frames. For you, these relevant business metrics seem to be total operation hours and usage frequency for a piece of equipment. Many companies data warehouse based on month or week. With your data warehouse, if the CEO asked, "what are the trends for total operations hours on equipment by month for the past 10 years filterable by individual piece of equipment," you could answer the question even though you might only have the last 6 months of data stored in your operations tables! If you want to continue a running total of operations hours in your operations tables, you could related the "data warehouse" table to the operations table and keep using the summary field.
------------------------------
Evan Westbrook
PRIME Developer
Harder Mechanical Contractors Inc.
Portland OR
------------------------------
Just another idea to add the many great suggestions already listed:
Data Warehousing
You may want to try archiving your data in the form of a data warehouse. You can think of a data warehouse as a big Excel pivot table for a chunk of similar operations data. The summary values in this pivot table are saved in a non-linked format for historic reporting instead of keeping track of years' worth of operations data and performing calculations on the data each time a report is generated. In addition to reporting speed, this is particularly handy when you want to use a new field to track a metric or update the way it's calculated. You wouldn't have to wrangle legacy data or look through archived .csv files because the value you want is already calculated and saved in your data warehouse. Data warehousing also gives you an opportunity to remove any bad data from metric calculations.
Example:
You would need to identify the business metric needs for the data being archived and relevant summary time frames. For you, these relevant business metrics seem to be total operation hours and usage frequency for a piece of equipment. Many companies data warehouse based on month or week. With your data warehouse, if the CEO asked, "what are the trends for total operations hours on equipment by month for the past 10 years filterable by individual piece of equipment," you could answer the question even though you might only have the last 6 months of data stored in your operations tables! If you want to continue a running total of operations hours in your operations tables, you could related the "data warehouse" table to the operations table and keep using the summary field.
------------------------------
Evan Westbrook
PRIME Developer
Harder Mechanical Contractors Inc.
Portland OR
------------------------------