Creating a Business Value VS Feasibility Matrix in Power Apps for Project Management!

This is only Part 1! The video was over 40 minutes so we will break it into 2 videos, one per week!
It's time to be able to put our own projects into a business value vs feasibility matrix in power apps so we can visualize which initiatives we should take forward. This is a great app for any project or portfolio manager!
Submit Button:
Collect(colCircles,{ID:varID+1, Feasibility:Slider1.Value,BusValue:Slider1_1.Value});
UpdateContext({varID:varID+1})
Vertical Gallery:
"Feasibility " & ThisItem.Feasibility & " Business Value: " & ThisItem.BusValue;
OnVisible Screen:
UpdateContext({varID:0})
Clear Button:
Clear(colCircles);
UpdateContext({varID:0})
X of the Circles:
LookUp(colCircles,ID=1,BusValue*57.5)
LookUp(colCircles,ID=2,BusValue*57.5)
LookUp(colCircles,ID=3,BusValue*57.5)
Y of a Circle:
LookUp(colCircles,ID=1,Feasibility*57.5)
LookUp(colCircles,ID=2,Feasibility*57.5)
LookUp(colCircles,ID=3,Feasibility*57.5)
Creating a business value vs feasibility matrix is a strategic tool used by entrepreneurs and business leaders to evaluate and prioritize potential projects or initiatives. This matrix helps in visualizing where each idea or project stands in terms of its potential to generate value for the business against how feasible it is to implement, considering factors like cost, time, resources, and technical complexity. By plotting ideas on this matrix, decision-makers can identify high-value, high-feasibility opportunities that are worth pursuing, while also recognizing those that, despite their potential value, may be too challenging or resource-intensive at the current time. This process fosters a more disciplined and rational approach to resource allocation, ensuring that investments are directed towards projects that are not only valuable but also achievable. Ultimately, the business value vs feasibility matrix serves as a critical decision-making framework, guiding businesses in maximizing their growth and innovation efforts efficiently.
Chapters:
0:00 Introduction
0:42 Some examples first
1:26 The grid in Power Apps
3:42 Inserting inputs for data
6:38 Using a Container for our Grid
8:00 The formula for X and Y
10:03 Collecting our Data for multiple circles
11:15 Our Vertical Gallery
14:35 Using a LookUp for our X and Y
17:40 Until Next Week

[@rpaconsultant-ericparijs]

Awesome, looking forward to next week!

[@andrewhess123]

Thanks Eric! Super excited to create this one, was just a ton a fun!

[@AustinWarnstrom]

That was great!

[@fcnc3024]

I’m not an app developer Andrew but your explanation really makes me feel like I can do this and bring value to my department. Thank Andrew. Will look for next video

[@andrewhess123]

If you have the tools to do it! You can do it!

[@andrewhess123]

If not reach out to me on CZcams 😉

[@rpaconsultant-ericparijs]

recently I worked with a client who made their feasability studies by kind off winging it.... this will show them how it should be done 🙂

[@andrewhess123]

And then we can improve on my take 😄

[@andrewhess123]

This is a great app, honestly I think it should be embedded into Teams! Hope you all like the app as much as I do 🤣