We were able to build an app that allowed users to view a pricing comparison table with filters for store, unit size, unit type and more. Each result also had a link out to the store’s website and how far away the competitor was from their store.
A map was also built that had the locations of each store, their competitors and the locations of their current customers. Using this would help determine which competitors they should be comparing against most.
We also added in additional data from their CRM to help encompass everything that goes into pricing a unit into one report.
And then to help identify when actions needed to be taken, we built a dashboard of where each store ranked in average price and set up alerts that would notify the pricing manager each time a ranking moved up or down.
Overall, this project saved our client quite a bit of money. The only costs were the $9.99 per Power BI Pro license, $500 for Power Update (plus a $100 Power Update yearly license), and our consulting fee.
Using this tool the Pricing Manager is now able to more easily set the pricing at the best value for the area, creating a large advantage in the market.
Think this might be something you’d be interested in doing? Contact us today. We can help you build it or just provide the roadmap. Our team is here to help in any way possible.