Project Audit Use Cases
The following table details some common use cases for Microscope. Greater analysis is possible with the use of advanced statistical tools in spreadsheets such as the use of pivot tables.
| Migrating | Merging | Inheriting | Cost saving | Health checking | Step-by-step | Notes | |
|---|---|---|---|---|---|---|---|
| Identify most/least used projects | x | x | x | x | x | 1. Load your CSV up with your spreadsheet software of choice and enable filters. 2. Sort your data first by Number of issues, then by Issues created in the past 30 days. 3. You might choose to filter by Status so that you only look at Active projects. | The number of issues won't be a perfect indicator of how valuable the project is as it may leave out new relevant projects, this exercise will simply give you a broad view to get you started with assessing your usage and requirements. To get a better view of the usage in recent days you can add an extra column that calculates the value of Issues Created in the Past 30 days/Number of Issues. This will identify recently created projects compared to old established projects. |
| Identify totally unused projects | x | x | x | x | x | 1. Load your CSV up with your spreadsheet software of choice and enable filters. 2. Filter your data to show projects with a value of 0 in Issues created in the past 30 days. 4. You may also want to filter further to also only show projects with a value of 0 in Issues updated in the past 30 days. 3. You might choose to filter by Archived so that you only look at Active projects. | These projects might still be required, so be sure to look into each one fully before making your final decisions! |
| Identify archived projects | x | x | x | x | 1. Load your CSV up with your spreadsheet software of choice and enable filters. 2. Filter by the Archived column to reveal all projects in the Archived status. | ||
| Identify projects nearing their end-of-life | x | x | x | 1. Load your CSV up with your spreadsheet software of choice and enable filters. 2. Sort your data smallest to largest by Issues created in the past 30 days. 4. You may also want to sort by two columns including the Issues updated in the past 30 days. 3. Filter by Archived so that you only look at Active projects. | Run this scan periodically and compare the number for a project to see which are winding down towards end-of-life. You can use your spreadsheet to combine the created/edited entries to see the least active projects. |