AFAOC Shares Air Force Status of Funds Using Power BI

The AFAOC, in coordination with the DEAMS FMO, has created a BETA version of cloud reporting capability based on an Integrated Status of Funds (e.g. DEAMS and Legacy data).

  • This reporting tool will serve as a stopgap while the DEAMS System Integrator continues to work towards resolving issues with the Status of Funds reports in DEAMS Reports.
  • Please follow hyperlink to access this report and be sure to enter your “us.af.mil” email address if prompted

Instructions:

Once at the site:

  • Click on Data Download
  • Filter Required Data (OAC, OE, Main_Limit, etc)
    • Saves the filter criteria for future reports – YEAH!!!!)
  • Click the big downward arrow in the gray box
    • Click on More Options
    • Click Export Data (if you want to use Excel)

Note: Chad Kukorola and James Johnson are amongst some of the smartest data-wonks I know. I bounce and share ideas with Chad on a semi-regular basis. I am going to highlight some of the great tools he’s built as a Air National Guardsman. If you know other “dataheads”, please share in the comments. I’m trying to compile a list and create an email listserve to share ideas and coordinate our efforts.

There will be a lot of additional Power BI info coming in the near future.

Author: Matt Miller

Matt is the civilian comptroller for the 301st Fighter Wing in Fort Worth, Texas and a Reserve finance officer. He spent seven years on active duty before returning home to Texas and beginning the second chapter of his life. He is an avid maker that loves golf, reading, welding, carpentry and tinkering with electronics. An amateur at many things and master of none.