My interest in large non-proprietary healthcare databases exceeded anything Excel could hope for and I was amazed at the automation attainable in understanding a few open source languages--R and Python. I believe this is what I needed under the hood of the dashboards and insights clients were requesting. You may or may not know about TabPy--API Tableau Python Server--allowing remote execution of Python Code within a Tableau workbook. Also in Tableau Prep but let's not get ahead of ourselves. The limiting reagent for me was getting everything updated, dowloaded, and connected.
A lot of what is discoverable at the moment is somewhat out of date and might cause you to sip a scotch a little earlier in the day than what is socially acceptable--allegedly.
So my point here is to update Toward Data Science or GitHub (although the Github link I am providing is the updated version shared with me by Nathan Mannheimer a product manager at Tableau).
I activated my Anaconda environment and downloaded the required files. It is pretty easy. Hit the create button and name your environment--I opted for TabPy. The files I installed into this new env included Numpy, Matplotlib, Pandas, Conda, scikit-learn, ipython, and Spyder (so I could have a testing environment for calculations in Tableau). I updated Python, TabPy, and Anaconda--I had a bit of a circling the drain day when I didn't realize that links were using older versions...live it and learn it!
Once you have your environment created you can click and open your preferred coding window...