Azure DevOps PM Intelli Dashboard

What you're getting

This is a digital download — not a live call. After purchase you receive:

1. Illustrated PDF setup guide — step-by-step install, demo mode, Azure DevOps connection, PAT creation, .env configuration, dashboard walkthrough, and troubleshooting (with screenshots).
2. Link to the public GitHub repository — full source code to clone, customize, and run on your machine.

The problem this solves

Most Azure DevOps reporting shows data. It doesn’t tell PMs and engineering leaders what to do about it.

Power BI and native charts are fine for metrics — but Monday morning you still need to figure out: What’s overdue? Is velocity on track? Who’s blocked? What should we escalate in standup?

This tool closes that gap.

The killer feature: PM Recommendations (no AI)

The standout capability is a rule-based recommendation engine built into query_analyzer.py. It analyzes your shared queries and work items and surfaces actionable guidance, such as:

• Overdue items to escalate in standup
• Velocity / milestone risk based on current close rate
• Assignee blockers (stale work, no recent updates)
• Triage gaps and customer-reported item patterns

All of this runs locally in Python — no ChatGPT, no Copilot, no LLM APIs, no extra subscription cost.

What the dashboard includes

• PM Recommendations — prioritized actions for project managers
• Executive Summary — completion %, KPIs, priority & severity charts
• Shared Queries sidebar — red / amber / green health on every saved query
• Detailed View — filterable table (type, due date, created date, age, assignee)
• Area Path reporting — team-scoped health and trends

Output is a single HTML file in reports/ — open in any browser, email to leadership, or host on SharePoint/Teams. No server required.

How it works

Azure DevOps (REST API) → Python pipeline → Self-contained HTML report

• Demo mode — main_demo.py runs with fictional data (no Azure credentials)
• Live mode — main.py connects to your org with a Personal Access Token (Work Items Read only)
• 3 Python packages — requests, python-dotenv, jinja2
• Python 3.9+ on macOS, Windows, or Linux

Who this is for

• Engineering managers and PMs who want a daily leadership snapshot without building a BI dashboard
• Scrum masters preparing for standup or sprint review
• Anyone tired of reporting on progress instead of driving it

What this is NOT

• Not a hosted SaaS — you run it locally
• Not an AI product — recommendations are deterministic rules, not LLM output
• Not Power BI — simpler, faster, PM-focused
• Not a consultation — digital guide + repo access only

Requirements

• Python 3.9 or newer
• Azure DevOps organization (for live mode; demo works without it)
• Personal Access Token with Work Items (Read) scope
• At least one Shared Query in your Azure DevOps project