Category: Training

Creating a Decision Journal: Template And Example Included

decision-journal_draft3

Government Invoicing  –  A web-based application that efficiently manages government invoicing from the initial general terms and conditions (GT&C) all the way through Intra-Government Payment and Collection (IPAC) notification for reimbursable work between two federal agencies (AF to Army, AF to DLA, AF to GSA, etc.) 

• Department of Treasury system
• Centralized repository for agreements
• Automated handshake and agreement between buyer and seller

• G-Invoicing-IGT community on milBook
• https://usaf.dps.mil/sites/FMFC/SitePages/G-Invoicing.aspx
• https://www.fiscal.treasury.gov/g-invoice/

AFAFO G-Invoicing Team:

• Michael Smiley (Lead) – DSN 612-5604 – michael.w.smiley.civ@mail.mil
• Tony Gonzalez – DSN 612-5587 – antonio.gonzalez.civ@mail.mil
• TSgt Crystal Jones – DSN 612-5599 – crystal.m.jones58.mil@mail.mil

CSP Communication Page

How to create a Power BI Dashboard with CSP data

How-to-Create-a-PowerBI-Database-for-CSP-Analytics

FM VBA Course Block 1 Video

FM VBA Course Block 1 Power Point

FM VBA Course Block 2 Power Point

These are just a few of my favorite resources I’ve run across in my Power BI journey.

My #1 suggestion is to buy the books and work through the examples. Don’t just read the book; actually go through each example. Yes, it’s an insane amount of work, but it’s the best way to truly learn.

I’ve listed the books in the order that I recommend reading them. The first books provide a solid foundation and the latter books hone your DAX and Power Query skills.

Books

• Power Pivot and Power BI: The Excel User’s Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016
• Supercharge Power BI: Power BI is Better When You Learn To Write DAX
• M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query
• Collect, Combine, and Transform Data Using Power Query in Excel and Power BI
• The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition
• Master Your Data with Power Query in Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow

Websites

• SQL BI
  • Free tools
• DAX Formatter
• Guy in a Cube
• Power Pivot Pro
• HTML Color Codes

YouTube

• Guy in a Cube
• Curbal
• Microsoft Power BI
• SQL BI TV
• The BIccountant
• Avi Singh
• Contextures (more Excel focused)

UPDATE Several of the links below are broken, but you can still search FICS for the product via their new product search page.

• Money as a Weapons System (MAAWS)
• FMA Playbook 
• Retirement Separation Checklist for CONUS & OCONUS
• Death Gratuity Payment Process Checklist 
• DTS AO/ODTA Training Slides
• Use/Lose and SLA Base Reporting Tool
• Deployed Entitlements App
• Master DD114 Coding Tool – OHA and MIHA added
• New DS Computation tool for Meal Deduction Debts

Find these and more on the Financial Information Collaboration Space (FICS)

• AFAFO FYE SharePoint
• AFAFO FYE Mailbox
• AFAOC Help Desk (DEAMS)
• DFAS Command Post Org Box
• DFAS-LI Customer Care Box
• DFAS-CO Customer Care Box

FYE Calls Dates

• 4 August
• 18 August
• 1 September
• Daily 8 September through 6 October

Final Push Day is 27 Sep 2021

DFAS command post begins 13 Sep 2021

Misleading Budget Accounting In The Department Of Defense Needs Correction by Dave Deptula

DODAAC Management Tool

The Tool Suite provides a number of tools that can be used to manage DODAACs.

The Department Of Defense Activity Address Code (DODAAC) is a six position code that uniquely identifies a unit, activity, or organization that has the authority to requisition and / or receive materiel. Using the DODAAC Management system, you will be able to request a new DODAAC, change and existing DODAAC, or delete a cancelled DODAAC. The system also provides the ability to complete the annual validation of all Air Force DODAACs through an automated system.

FY DoDAACS ‐ Require that the requestor furnish the FB/FE/FG DoDAAC that will provide accountability for the FY DoDAAC being requested IAW AFMAN 23‐230 Table 2.1. Additionally, requester needs to provide the process that will be used for processing receipt transactions/accountability and a POC for the receiving locations on the ground at of the TAC1/TAC2 addresses. The FY DoDAAC is to be used in the supplementary address field of requisitions (positions 45‐50) from the accountable DoDAAC.

https://dodaac.wpafb.af.mil/about.aspx

DODAAC User Manual

DODAAC Technical Support

BPN Admin

DODAAC Site Admin

Quick Links

• MAPAC/MAPAD Information from DLAs Enterprise Business Standards Office
• MAPAC/MAPAD SAAR request from DLA Transaction Services
• Mapping Enterprise Business System (MEPS) Information from DLA Aviation
• DODAAC Information from DLAs Enterprise Business Standards Office
• DODAAC Single Look‐up from DLA Defense Automatic Addressing System (DAAS)
• Central Service Points for DODAAC/MAPAD ETC from DLAs Enterprise Business Standards Office
• EDASSINQ SAAR request from DLA Defense Automatic Addressing System (DAAS)
• TrackerLite ‐ DODAAC SAAR Request