Breakeven point with Alteryx and Tableau

Hello -

I want to present a report on Tableau with a feasiblity study for a new building.

I want the ultimate result to be an interface on Tableau where the client can make changes to the assumptions and get the results straight away.

Given that some calculations would require some heavy calcs (e.g. the occupancy rate at which the developer is able to pay a 10 year loan + interest), I need to have the assumptions feed back into Alteryx, a way to trigger an Alteryx macro from Tableau, and then have the results displayed on the same workbook.

To summarise > Assumptions details on Tableau > Modified by user > macro triggered on Alteryx > results displayed on Tableau.

Do you know the most efficient way to do this?

Thanks!

Macros

Tableau

Accepted answers

jdrummey

A couple of notes:

- Without seeing the algorithms for your scenarios I can't say directly, in any case there is a lot that can be done inside Tableau using Tableau's calculations, and then there are the R & Python integrations in Tableau that can do more complex computation than we can get in Tableau alone.

- That said, there are definitely cases where it's easier to build more complex calculations in Alteryx than in Tableau, and pre-computing millions of records for various scenarios is something that I've done previously so I can just use Quick Filters instead of parameters.

Jonathan

All comments

JoBen

Hi @jasatt, I not sure that Alteryx and Tableau will interface exactly the way that you want. I would recommend using an Alteryx app and Tableau in conjunction. You can make the app available to the end user, and then end user can select the variables that they want, run the app, and see the changes in Tableau.

jasatt

Thanks! It seems like that would be the only solution for this. We don't have Alteryx server currently, so will have to apply a workaround. I think i will solve it by working out a number of different scenarios and load them on Tableau. The options will be limited, but it can still provide a good level of visibility.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703