How surviveplus/evm-report works
Project type and purpose
• This is an open‐source asset/tool rather than a monolithic application.
• Purpose: Provide Excel templates and a Power BI template (.pbit) so that traditional Earned Value Management (EVM) metrics (CPI, SPI, PV, EV, BAC) can be reported using data from VSTS/TFS.
File structure
• Root:
• README.md and LICENSE – general project metadata
• .gitignore – version control settings
• Asset/
• DataSource TFS-EVM.xltx – Excel template to extract and store TFS history
• Export For EVM.wiq – (optional) query definitions
• Report TFS-EVM.pbit – Power BI report template
• Other .xltx variants – alternate management modes
• HowToUse/
• HowToUse.md – step‐by‐step instructions
• images/ – visual walkthroughs
README for additional insights
• Data flow is manual today:
1. Run queries against TFS/VSTS
2. Populate the Excel history template
3. Load that Excel into Power BI Desktop using the .pbit
4. Generate interactive EVM dashboards
• Future vision: replace manual Excel step with a VSTS extension for automation.
Main components
a. External System
• VSTS/TFS REST API or direct database – the source of work‐item and historical data
b. Manual Extraction/Transformation
• Excel templates (Asset/DataSource TFS-EVM.xltx and related .wiq)
c. Data Store
• The generated Excel workbook holding historical snapshots
d. Reporting Engine
• Power BI Desktop using Report TFS-EVM.pbit
e. End User
• Project manager or analyst who reviews dashboards
f. (Future) Automation Layer
• Planned VSTS extension to automate data pull
Architectural patterns and design principles
• ETL pipeline (Extract → Transform → Load)
• Clear separation of concerns:
• Data extraction & storage (Excel)
• Presentation layer (Power BI)
• Documentation and instructions (HowToUse)
• Extensibility point: the VSTS extension sits between Extraction and Storage.
Relevant technologies and frameworks
• Microsoft Excel (templates in .xltx)
• Power BI Desktop (.pbit files)
• VSTS/TFS (REST API or WIQ queries)
• Markdown for docs
Diagramming conventions
• Rounded rectangles for external systems (TFS/VSTS REST API)
• Rectangles for processing steps (Excel template, Power BI engine)
• Blue for external systems
• Green for data stores
• Orange for processing steps