How to create a Power BI Dashboard with CSP data
How-to-Create-a-PowerBI-Database-for-CSP-AnalyticsAuthor: Matt Miller
FM VBA Course by FTC
How to guide to new CAC
DEAMS Sandbox Info
Username and Password are located near the bottom of this page
Data Universal Numbering System (DUNS) to Unique Entity Identifier (UEI) Transition Effective 4 Apr 2022
DEAMS Users will be impacted by the transition from Data Universal Numbering System (DUNS) to Unique Entity Identifier (UEI) codes, which is currently expected to occur on 4 April 2022. Those with DEAMS Supplier Maintenance and Creation Responsibility will be most impacted.
In DEAMS, the DUNS number has been a nine-digit non-indicative numbering sequence used to identify specific vendors, assigned and managed by Dun & Bradstreet since 1962. In October 2020, the Office of Management and Budget (OMB) directed a Government-wide transition from DUNS to UEI codes to be completed by April 2022. This transition impacts Government Information Systems that use or collect Supplier information, and streamlines how an entity (anyone who does business with the government) receives their ID. UEI codes are scheduled to be activated in DEAMS on 4 April 2022.
Entities already registered in the System for Award Management (SAM) were automatically transitioned from DUNS to UEIs. Information on creating a new UEI is available on the General Services Administration website at https://www.gsa.gov/about-us/organization/federal-acquisition-service/office-of-systems-management/integrated-award-environment-iae/iae-systems-information-kit/unique-entity-identifier-update.
“If your entity is registered in SAM.gov today, your Unique Entity ID (SAM) has already been assigned and is viewable in SAM.gov. This includes inactive registrations. The Unique Entity ID is currently located below the DUNS Number on your entity registration record.”
For DEAMS Users, the biggest difference will be the number of characters in the field (9 DUNS/12 UEI). To assist Users in selecting the correct UEI site number for a vendor, DEAMS Job Aid “Supplier Record Research_SPD.docx” provides an overview of the process and references other job aids, depending on which responsibilities are being used for the actions. To help ease the transition from DUNS to UEI, a crosswalk will be made available at “go live” on the DEAMS Outreach Portal to help users identify correct vendor records in DEAMS. This crosswalk will only contain existing vendors; it will not capture new entities following the transition.
Our DFAS partners are responsible for creating and maintaining the UEI list in DEAMS, and in the event of interface errors, they may need to validate UEI codes in SAMs. The SAMs site lists the UEI for a supplier right below the corresponding DUNS, simplifying the validation process.
Questions should be addressed to users’ respective MAJCOM/CCMD SMEs, or the DEAMS Help Desk.
For any further messaging, access the DEAMS Users Group on milBook.
DAR-Q Notes
- AFAFO-A DAR-Q SharePoint page
- DAR-Q Instruction
- DoD FMR Vol. 3 Ch. 8
- To assist in researching the “IE” document numbers with RCCCs , watch video walkthrough here (use Chrome)
DEAMS Top 10 List Archive
The monthly DEAMS Top 10 list is an invaluable resource for staying on top of the latest DEAMS updates. It typically has information relevant to the current budget cycle and has tons of helpful links. It (like almost everything else) is behind the .mil domain, so I’m going to house them here so you can learn when your not connected or after hours.
DEAMS Top 10 Library (CAC required)
03_March_2022_Top_Ten_List 02_February_2022_Top_Ten_ListMy Favorite Power BI Resources
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
YouTube
- Guy in a Cube
- Curbal
- Microsoft Power BI
- SQL BI TV
- The BIccountant
- Avi Singh
- Contextures (more Excel focused)
PBASweb Information
- PBASweb
- Training Documents
- PBASweb User Guide
- Help Desk Email
- POCs
- Rosetta Brown
- Toni Hanes
PBASweb manages the Reserve Personnel Appropriation (RPA) by offering automated allocation of funding authority and funds management control for HQ AFRC/FM and providing a real-time status of funds, as well as the mileage obligations and expenditures for Military Personnel Appropriations (MPA). Its customer base is HQ AFRC, NAFs, Wings, Commanders, Base Level FM Personnel
AFAOC Analytics Power BI Introduction to the Open Document Listing (ODL)
Great video by Josh Johnson on how to analyze the STH within DEAMS via Power BI.
CFO Academy Leadership Certificate
Advance your career and the DoD mission – take advantage of the extended application deadline to August 13 for the Fall 2021 term
Don’t miss out! The CFO Academy is seeking applicants for its Fall 2021 CFO Leadership Graduate Certificate program. This program will help prepare you to lead within and across organizational boundaries by leveraging knowledge of federal budgeting, financial accounting and reporting, data management and analytics, risk, internal controls, and audit for strategic advantage.
A component of the College of Information and Cyberspace at the National Defense University (www.ndu.edu), CFO Academy courses align with the competencies specified in DoD Financial Management Certification Program and provide accredited, graduate-level education in the leadership of resource management – critical learning that directly supports the DoD mission to make efficient and effective use of financial and other resources.
Application Instructions: https://cic.ndu.edu/Admissions/Application-Instructions/
Why you should pursue this opportunity
Students earn this certificate by successfully completing these five robust courses:
- White House, Congress, and the Budget
- Data Management Strategies and Technologies
- The Future of Federal Financial Information Sharing
- Risk Management, Internal Controls and Auditing for Leaders
- Strategic Performance and Budget Management
For more information, please visit: https://cic.ndu.edu or email CICOSS@ndu.edu
To apply online: https://cic.ndu.edu/Admissions/Apply-Online/
Superintendent/Senior Enlisted Leader (SEL) Duty Title Update
TLDR: Required to change Superintendent duty title to Senior Enlisted Leader (SEL)
Defense Travel Dispatch – Volume XIV – Issue 2 – Summer 2021
The Defense Travel Management Office is pleased to publish the newly redesigned Summer 2021 edition of our quarterly newsletter, Defense Travel Dispatch. Recognizing the need for better communication between the Defense Travel Management Office and the travel community, the Dispatch provides timely travel-related news, best practices, and updates.
- The Rapidly Changing COVID-19 Travel Environment
- What Can You Expect During Your Next Hotel Stay?
- What’s New with Defense Travel Modernization
- Rental Car Shortage Felt by Defense Travelers
- Mark Your Calendars for GovTravels 2022
- Dining Traveler Rewards – Too Good to Be True?
FICS Faves
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)
FY21 Fiscal Year End Guidance
- 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