Latest Enterprise DNA Initiatives

Power BI as a Dynamic Pricing Tool?

Hi Forum,

I’m exploring the feasibility of creating a basic pricing tool using a Power BI dashboard.

Sales teams in my organisation work from their own excel creations where discount calculators and pricing sheets are generated manually and data is moved back and forth. Needless to say there is a lot of time wasted and errors made.

So I have been tasked with trying to come up with a consolidated pricing tool which can be represented in dashboard format and I am not quite sure if 1.) It’s even possible and 2.) if it is, what method is the best way forward.

Here are the basics:

  • All our products can be found in one static spreadsheet which is manually updated once per year by our operations and procurement departments. This process is unavoidable, but if I can reduce manual input to just this step we will have moved light years from where we currently are.

  • I have already played around a bit using the scenario methods learned here on E-DNA (see attached screen shot)

The challenge:

  • This tool must be able to quote different amounts depending on the product type as well as represent varying percentage mark-ups/discounts for different products. For example: a customer may want to order 5 routers which we quote at 7% below list price, 7 LCDs at 13% below list price and so on.

I haven’t played around with buttons in Power BI yet, but what I require is essentially some form of “save quote to visual” function as the user goes through the list of items they want to add and use slicers to change amount and percentage accordingly. Is this possible in Power BI?

I hope the above description makes sense and thank you for any help you can provide.

It sounds like you want something that will effectively ‘write back’ to the dataset - even if that is only an excel spreadsheet. This is not something I have explored myself, but it is possible

This link will take you to some custom visuals with that capability (all are tagged as ‘may require additional purchase’): https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&search=write%20back&page=1

This link will take you to a list of videos on YouTube discussing write-back capabilities and options with PowerBi (some include using PowerApps): https://www.youtube.com/results?search_query=power+Bi+writeback

If I’m headed off in a completely different direction than your understanding, please let me know.

2 Likes

Hi @oscar_wandel, we’ve noticed that no response has been received from you since the 25th of November. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!

A response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!