Get up and running in 5 minutes.
- Python 3.7+
- Azure DevOps organization access
- Personal Access Token (PAT) with
Work Items: Readpermission
pip install -r requirements.txtCreate a .env file in the project root:
AZURE_DEVOPS_ORG=YourOrganizationName
AZURE_DEVOPS_PAT=your_personal_access_token
To create a PAT:
- Go to Azure DevOps > User Settings > Personal Access Tokens
- Click "New Token"
- Set scope to
Work Items: Read - Copy token to
.envfile
python run.py --list-projectsIf you see your projects, you're ready.
python run.py --query-work-items \
--assigned-to "Developer Name" \
--start-date "2025-01-01" \
--end-date "2025-01-31" \
--export-csv "january_report.csv"Creates two files:
january_report.csv- Detailed work item datajanuary_report_developer_summary.csv- Developer KPI summary
python run.py --query-work-items \
--assigned-to "Dev1,Dev2,Dev3" \
--start-date "2025-01-01" \
--end-date "2025-01-31" \
--export-csv "team_report.csv"python run.py --list-projectsThe developer summary CSV includes:
| Metric | Description |
|---|---|
| Overall Developer Score | Weighted combination of all metrics |
| Average Efficiency % | Productivity vs estimated time |
| Average Delivery Score | On-time performance (60-130) |
| Completion Rate % | Tasks completed vs assigned |
| On-Time Delivery % | Completed by target date |
The tool includes workflows for automated reporting:
- Daily Snapshot - Runs at 9:00 AM Mexico City time
- Monthly Report - Runs on the 30th of each month
Trigger manually from GitHub Actions tab.
python run.py --explain- Customize scoring: See documentation/SCORING_PARAMETERS.md
- Full documentation: See documentation/