Samuel,
Just another idea to add the many great suggestions already listed:
Data WarehousingYou 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
------------------------------
Original Message:
Sent: 10-22-2019 22:57
From: Samuel Goh
Subject: 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 purge/transfer data from the current App to the copied App. (either via automation / 3rd party app like Zapier)
- what happens when there are field changes/new tabs in the future to the current App? do i then have to do extra work by editing both Apps?
- additionally, i'm afraid it might affect some of the data on the current App. etc. total operation hours, # of times used, because these numbers are based on a [Summary] field, is there a way to prevent that?
Would appreciate any feedback.
Thanks.
Regards,
Samuel
------------------------------
Samuel Goh
------------------------------