The OutFit understands that analytics is a powerful process that ultimately can be an effective tool to assist General Officers and other Leadership with informed decision making during a project. Each program initiative is managed using the following life cycle approach – identify data source(s), determine report/deliverable format(s), transform data and document process, finalize, and implement quality control checks. Throughout this approach, team coordination and feedback are essential.
Through careful review of static, readily obtainable data, and metric analysis, we were able to determine a sustainable, mutually beneficial process which resulted in a recurring monthly project update that provides a high-level program overview that can easily be drilled down to the individual project level. Reporting is done via Excel and a Power BI dashboard. Metrics that are produced include overall project status, average percentage billed and dollar amount over budget, total number of modifications, and number of projects by fiscal year and by contractor. Through continued data evaluation, a risk status (black, red, amber, green) has been implemented based on specific time and cost.