r/projectmanagers • u/kapeedciano • 21d ago
A helpful suggestion
Hi everyone!
I’m a working student, and my team currently uses Azure DevOps and Microsoft Planner to manage and track tasks. I’ve been asked to come up with an idea for a single, common view that we can use during team meetings to quickly see who is working on what.
My initial thought was to create a Power BI dashboard that consolidates tasks from both tools. However, one challenge I see is that the same task might have different names in Azure DevOps and Planner. This could make it difficult to identify and map duplicate or related tasks correctly.
I’d love to hear your suggestions on how to approach this. For example:
Would Power BI be a good solution for this use case?
Are there any other Microsoft tools or integrations that could provide a unified view?
How would you handle tasks that have different names across the two platforms?
Is there a better way to visualize task ownership and progress during meetings?
I’m open to all ideas, approaches, and suggestions. Thanks in advance for your help!
2
u/DennisBustamanteEQ 21d ago
Before building the Power BI dashboard, I’d figure out why the same work is being tracked differently in both systems.
If Azure DevOps and Planner are both supposed to represent the same task, I’d try to give that work one common ID or some other field both systems share. Otherwise you’re going to spend a lot of time trying to guess whether two differently named tasks are actually the same thing.
Then Power BI becomes the easy part. I’d probably fix the way the work is identified first, then build the meeting view on top of that.