B.I. Joe

Usage / Implementation of Custom Themes  While Tableau features several very nice themes that help to accentuate your data, the standard themes don't really differentiate your dashboard from others. You can create your own theme to match your company / desired theme for your dashboards. This guide will show you clearly how to create your own theme either using Adobe Illustrator or a free-to-use online tools I found the other day. STEP 1: Gather Hex Codes  Tableau determines colors based off of Hex Codes, which are unique alphanumeric identifiers for specific colors. While these can be daunting to look at, their usage is quite simple. Here's steps to find some using both Illustrator and a web source.  A. Online Web Source  If you navigate to  https://www.color-hex.com , you are given the ability to create custom color palettes relatively simply online for free. While it doesn't give the user as much guidance on good color pairings for color pale...

iOS 12 – Siri Shortcuts and Tableau Intro One of the cool new features implemented in iOS 12 was Siri Shortcuts, which is an amalgamation of an app called Workflow and Apple's own software. It's a tool that's integrated directly into iPhones, iPads, and Apple Watches. With this cool new software comes a slew of tricks. Today, I'm going to show you how to integrate health data into excel and eventually into Tableau using your iPhone.  Initial Setup You will need to start with this workflow, provided to me by a  @vulkman  on reddit. Open  this link  on your iPhone and save the workflow. It's pretty easy setup. Additionally, you will need to be able to export the data, so I would just use  this workflow  I made to streamline the process. The second workflow allows you to export data from your iPhone to Dropbox or iCloud Drive.  Prep Your Data I love using this method for showing active calories. It allows me to visualize how active ...

INTRO One of the most recent trends within Tableau and the visualization world is the utilization of geographic data and heat maps. While entering ZIP codes and City names are useful, it would be significantly more interesting to see specific locations as individual pins within those areas. That's where using Google maps has its benefit. Using the below method, you can easily source geographic data using Latitudes and Longitudes and export the table into excel. There are really only two pieces of software that you need: Microsoft Excel (ON PC) A web browser capable of accessing Google Maps  A google account **Unfortunately, I have not yet been able to recreate my success with this process on Mac. The XML conversion is a bit difficult to navigate there** STEP 1: Create a Custom Google Map with the Locations For the sake of this example, I will plot all of the Chik-Fil-A locations in the Philadelphia area. First, we must plot the area of the map. For this, navigate to...