1. Program Overview
The opening page gives the boss the monthly state in one minute: current lifecycle status, immediate movement, active requirements, and command focus.
Command assessment
Overall: Program execution is steady. Two students transition from language training to course execution within 45 days. Fiscal execution stands at $928K obligated year-to-date against the $1.48M annual submitted budget.
Next 60 days
| Date | Expected movement | Immediate action |
|---|---|---|
| 14 Sep | Student 04 begins language training | Confirm travel and reporting instructions |
| 03 Oct | Student 11 begins course execution | Complete two open requirements |
| 21 Oct | Student 07 begins course execution | Resolve clearance verification |
Command focus
Decision Confirm alternate report date for Student 07.
Coordination Gain host-school response for Student 15.
Awareness Three students change locations next month.
FITREP Two reports are due within 30 days; the earliest is due 15 Sep.
Fiscal $552K remains available; $120K in expected obligations supports the forecast.
Lifecycle used across every page
SelectedLanguage TrainingCourse ExecutionCancelledAlumniEach person carries one current lifecycle status. Alumni data enters the report during the future-expansion phase.
2. Current Population
WHO and WHERE form one operating picture. The roster shows selected and current students, their lifecycle status, their current location, and their next expected transition.
Current roster
| Person | Program | Current status | Current location | Next transition | Requirements |
|---|---|---|---|---|---|
| Example Fellowship A | Selected | Parent Command | Language Training · 14 Sep | 2 open | |
| Example Program B | Language Training | Arlington, VA | Course Execution · 21 Oct | 1 blocked | |
| Example Program C | Language Training | Monterey, CA | Course Execution · 03 Oct | 2 open | |
| Example Program D | Course Execution | London, UK | Completion · 15 Jun | On track | |
| Example Program E | Cancelled | Parent Command | Record closeout | Closed |
Person detail
Power BI drill-through opens the selected person’s complete record here: current place, dates, assigned program, requirements, and active issues.
Current locations
Status distribution
Selected 12
Language Training 7
Course Execution 18
Cancelled 2
Upcoming FITREP Due Dates
Person-linked reporting dates are sorted by due date. Near-term reports receive the strongest visual priority.
| Marine | Reporting occasion | Due date | Days remaining | Current status |
|---|---|---|---|---|
| Example Marine 01 | Annual | 15 Sep 2026 | 13 | RO Action |
| Example Marine 02 | Transfer | 30 Sep 2026 | 28 | Draft Review |
| Example Marine 03 | Annual | 15 Oct 2026 | 43 | Input Received |
| Example Marine 04 | Change of Reporting Senior | 31 Oct 2026 | 59 | Drafting |
| Example Marine 05 | Annual | 30 Nov 2026 | 89 | Scheduled |
| Example Marine 06 | End of Service | 15 Dec 2026 | 104 | Future |
Due-within counts are cumulative and use the report date of 02 September 2026.
3. Upcoming Movement
This page looks forward across a selected date horizon. It shows expected arrivals, departures, location changes, and movement between lifecycle statuses.
| Date | Person | Movement | From | To | Staff focus | |
|---|---|---|---|---|---|---|
| 14 Sep | Student 04 | Arrival / status change | Parent Command · Selected | → | Monterey · Language Training | Travel and reporting |
| 03 Oct | Student 11 | Location / status change | Monterey · Language Training | → | Overseas School · Course Execution | Close two requirements |
| 21 Oct | Student 07 | Location / status change | Arlington · Language Training | → | Overseas School · Course Execution | Clearance verification |
| 18 Nov | Student 03 | Departure / status change | Monterey · Language Training | → | Overseas School · Course Execution | Finalize reporting package |
4. Fiscal
The office coordinates funding for designated course tuition, training tuition, TDY, and housing. The budget is submitted annually, and obligations are tracked monthly across the fiscal year from 01 October through 30 September.
Monthly Budgeted vs Spent · Oct–Sep
Each month pairs the approved budget plan with recorded spending. Labels show Budgeted / Spent. Monthly budget values total $1.48M; monthly spending values total $928K fiscal-year-to-date.
Forecast
September Budgeted vs Spent by category
September category budgets total $285K, and September spending totals $102K.
Course tuition applicability
Course tuition applies to designated programs. Each funding record carries a clear indicator.
| Program | Indicator | Fiscal treatment |
|---|---|---|
| Example Fellowship A | Tuition Applies | Program office coordinates payment |
| Example Program B | Tuition Covered | Partner agreement covers course tuition |
| Example Program C | Tuition Applies | Program office coordinates payment |
Funding records tied to execution
| Record | Person / program | Category | Course tuition | Expected | Spent | Planned month | Status |
|---|---|---|---|---|---|---|---|
| FND-104 | Student 04 · Fellowship A | Training Tuition | Applies to course | $18K | $18K | Sep | Spent |
| FND-107 | Student 07 · Program B | TDY | Course covered | $24K | $16K | Sep–Oct | Partial |
| FND-111 | Student 11 · Program C | Course Tuition | Applies | $72K | $72K | Aug | Spent |
| FND-115 | Student 15 · Program D | Housing | Course covered | $36K | $27K | Jul–Sep | Executing |
One person or program may carry several funding records across tuition, TDY, and housing.
5. Issues & Decisions
This page translates considerations into leadership relevance: what needs awareness, coordination, or a command decision.
Alternate report date
Student 07’s clearance timing affects the planned report date.
Host-school response
Country Team coordination remains active for Student 15.
October movement
Three students change locations and two enter Course Execution.
Attention summary
6. Program Record
The program record holds the person and program detail behind the monthly picture. The annual Quota Plan and TEEP provide seat-selection and execution context.
Person record
| Field | Example |
|---|---|
| Person ID | STU-011 |
| Program | Example Program C |
| Current status | Language Training |
| Current location | Monterey, CA |
| Course dates | 03 Oct – 15 Jun |
| Parent command | Example Command |
Program record
| Field | Example |
|---|---|
| Program ID | PRG-C |
| School / country | Example School / Partner Nation |
| Education level | Intermediate |
| Annual seat context | FY27 seat selected |
| Execution window | Oct – Jun |
| Program owner | FPME Office |
Funding record
| Funding ID | Person | Program | Category | Course tuition indicator | Expected amount | Obligated amount | Fiscal month |
|---|---|---|---|---|---|---|---|
| FND-111 | STU-011 | PRG-C | Course Tuition | Applies | $72K | $72K | Aug |
Funding IDs connect obligations to the relevant person, course, program, and fiscal category.
Annual TEEP context
The TEEP supports annual seat planning, transition forecasting, and program continuity. Requirements remain independent and may be completed in any order.
7. How the Data Works
Think of the architecture as labeled filing cabinets that feed a monthly briefing. Staff maintain familiar lists; Power BI cleans, connects, counts, and displays them.
From staff update to command report
Core tables
- Person ID
- Program ID
- Current lifecycle status
- Current location ID
- Next transition date
- Program ID
- School and country
- Annual seat selection
- Course dates
- Location ID
- Place name
- Country and region
- Location type
- Funding ID
- Person and Program IDs
- Fiscal category
- Expected and obligated amounts
- Fiscal month
- Course tuition indicator
- Issue ID
- Person or program link
- Attention type
- Command ask
- Snapshot month
- Person ID
- Status and location then
- Monthly and FYTD obligations then
- FITREP record ID
- Person ID
- Reporting occasion
- Due date
- Current status
Simple relationships
One Person or Program → many Funding Records
One Person → many FITREP Records
One Location → many People
One Program → many People
One Person or Program → many Issues
Monthly refresh workflow
Staff update the source lists.
Staff validate statuses, dates, IDs, FITREP reporting occasions, funding categories, expected amounts, and obligations.
Power BI refreshes the model and report pages.
The program office adds the command assessment.
A month-end snapshot preserves the historical picture.
8. Future Expansion
The current report includes the operational picture and Fiscal. Two deliberate additions extend the program view: Training and Alumni.
Preparation and readiness
- Preparatory training requirements
- Completion status and dates
- Owners, suspenses, and blockers
- Readiness for the next transition
Command value: shows preparation for successful execution and identifies actions that support the next transition.
Long-term program record
- Completion history
- Follow-on utilization
- Contact and assignment history
- Program outcomes over time
Command value: shows enduring return from the program and supports future selection decisions.
9. Review & Refine
This prototype is ready for leadership review. Your comments will help Taylor refine the report’s priorities, level of detail, and monthly command value.
How to review
Move through each report tab, then capture concise feedback below. Notes stay in this browser session. Copy your review notes and send them to Taylor.