data&donuts
  • Data & Donuts (thinky thoughts)
  • COLLABORATor
  • Data talks, people mumble
  • Cancer: The Brand
  • Time to make the donuts...
  • donuts (quick nibbles)
  • Tools for writers and soon-to-be writers
  • datamonger.health
  • The "How" of Data Fluency

data & donuts

"Maybe stories are just data with a soul." -- Brene Brown

Ready to integrate Python with Tableau?

8/2/2019

 
As soon as I completed the Columbia School of Engineering Executive Education program in Applied Data Science I became responsible for translating successful weekly assignments and assessments into an effective and scalable work flow. It is one thing to complete a high-level course at a prestigious university--it is quite another to know how to gain actionable insights outside of a classroom.

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).
Picture
Download the Github repository and follow instructions in the README.md file. I use juptyer lab so had specific steps to get everything up and running.

​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...
Picture
Picture

I am a loyal MacOS person so your mileage may vary--navigate to Terminal enter "Conda create --name TabPy python=3.7"
Picture
Making sure you are in the right directory "cd TabPy-0.7" in my case and now run the "source startup.sh"
Picture
Once you have everything properly installed head over to Tableau. Under the Help menu scroll down to Settings and Performance >> Manage External Service Connection.
Picture
These are the settings you want to select. Click "OK", close the window and open again to Test Connection.
Picture
If you have everything installed correctly--you will receive the blessed notification below. Once I sorted out the old links, outdated software, and steps for MacOs--it all came together but I am hoping to prevent you from the aggravation.

​
Picture
Any questions find me on twitter @datamongerbonny or at the next Healthcare TUG on August 14th...
Picture
Picture

Comments are closed.

    Telling stories...

    Finding, curating, tidying, analyzing, and communicating your data creates many opportunities for discussion and collaboration...

    Take a look around...
    Follow @datamongerbonny

    Categories

    All

    twitter...

    Tweets by datamongerbonny
Proudly powered by Weebly
  • Data & Donuts (thinky thoughts)
  • COLLABORATor
  • Data talks, people mumble
  • Cancer: The Brand
  • Time to make the donuts...
  • donuts (quick nibbles)
  • Tools for writers and soon-to-be writers
  • datamonger.health
  • The "How" of Data Fluency