Equivalent to Excel Solver in Domo MagicETL?

DataLawton

Hi everyone,

I'm working on a hotel lodging analysis and need to find something in Domo MagicETL with comparable capabilities to Excel’s Solver function.

In Excel, we’ve used Solver to optimize the number of daily hotel room blocks (reservations made in advance) to minimize last-minute (adhoc) room bookings, reducing extra costs.

Goal:
Look at historical scheduled rooms vs adhoc rooms to find the ideal number of scheduled room blocks that leads to the lowest overall cost (reduction of adhocs).

Has anyone tackled an optimization problem in Domo like this before?

Maybe some of the newer Data Science tiles will be good for this?

Any insights would be greatly appreciated! Thanks!

DavidChurchman

The closest thing I can think of out-of-the box is you could use variables to manually explore different combinations, and depending on how complex your situation is, that might be a good way to get an intuitive sense of why the optimal solution is what it is, or what some sub-optimal good-enough solutions would be.

Or if you have a range of discrete possible values (like from 0 to your maximum number of possible scheduled room blocks), you could do some joins to create every possible combination of values for your optimization and calculate across all of those combinations relatively quickly in MagicETL.

Or I'm sure there are libraries in Python/R you could leverage in a Jupyter Notebook or a data science tile, but Domo wouldn't have a lot of value add to those besides connecting it live to your data.