I am new to Microsoft Dataverse and the common data model.
I want to build a model-driven app that would help us manage all of our project management needs. We manage software development projects and other non-development projects. At a minimum, I have the need to track user stories, their associated tasks, the time spent on a task by day, the accomplishments of the resource for the work they did that day for a given task, capture status updates at the story and project level, prioritize user stories with various stakeholders, etc.
At first, I was just going to create separate tables for how I envisioned each entity (Program, Project, Epic, Story, Task, Task Timesheet, etc.), but then thought perhaps some of the standard tables that come with Dataverse may work for my needs.
QUESTION 1: One of the reasons I am posting is because I wanted to know if anyone had some example model-driven apps for project management, requirements management, agile development management, support (helpdesk tickets/incident) management, etc.
I am sure there are a lot of great already-built applications out there, but it doesn't appear that my work company has subscriptions/licenses for those products. So, I think I will need to build something myself to help our team manage our projects better. But I don't want to reinvent the wheel, especially if there are free or at least example apps out there.
QUESTION 2: Would you consider a user story to be a type of task, and then the tasks for the user story to be sub-tasks? I was thinking it might make sense to use the Task table to capture my user stories, but I would want to extend the table I think for user story specific fields. I was going to make it its own table, but then I was thinking about the future - and what if I want to show nested tasks in something like a MS Project file. I thought having Stories and Tasks in separate lists might make it messy. Any thoughts?
Thanks for any responses. I feel pretty dumb for trying to build out functionality that I am sure already exists much better in other tools - but if our company doesn't have those tools, what else can I do? Or maybe we do have tools that we are actually underutilizing.