I Need Help Creating a PBI visual using Python - Forecast Model

Power BI
1

I am starting a project to create a prediction model of work hours. The goal of this project is to use documented work hours needed to complete a major project throughout the year. There might be 3 projects in a year that take 4 months each to complete and there are 4 teams tracking their hours. The point of this is to predict future hours needed to complete the next project, and this will help determine if the project end date is correct or if the hours put in will not be enough. I also wanted to add a modifying tool, if the managers of the teams feel there will be more work for a certain project, they can increase the projected hours by percentage. So there can be a percentage modifying tool, and if a manager things there will be 25% more work involved, they can click 25% and it would adjust the linear regression line to be more accurate.

Here is recording explaining with the data and sketch of what I hope to accomplish: https://www.loom.com/share/cb8c3db461d941e6a88eab65fe936026

Resource Prediction Tools.xlsx (22.7 KB)

2

Bumping this post for more visibility from our experts and users.

3

Hi @jtalhait

We have noticed that your inquiry has remained unresolved for an extended period of time, indicating that it may have been outside the capabilities of our experts and users.

If you believe that you have provided all the necessary context for your concerns and have familiarized yourself with effective forum usage by referring to this guide, we recommend exploring the additional resources included with your subscription. These resources can provide valuable assistance with your Power BI education, and we encourage you to utilize them.

While our users and experts strive to assist with inquiries to the best of their abilities, it is important to acknowledge that not all concerns can be addressed, particularly when there are valuable learning opportunities involved. Thank you for your understanding.

We sincerely hope that you find the solution you are seeking and achieve your desired outcome.