If you embed your Tableau analytics dashboards through either a straight embedded i-frame or with the JavaScript API, upgrading your Tableau Server to 9.1 will cause some unexpected grief. But it’s fixable. After upgrading Tableau Server to 9.1, I was getting this error: Refused to display 'https://path/to/my/tableau/dashboard?:embed=y&:showVizHome=n&:tabs=n&:to...
Tableau does a great job of connecting to a variety of databases, but it sometimes needs help on the database end to get the results we need to make hot visualizations. One such example showed itself when connecting to Google BigQuery. The issue? Count distincts. BigQuery doesn't handle count distincts like one...
I've had the pleasure of working with a large number of Tableau Server users and administrators, and by far the most common phrase I hear is "What the [expletive redacted] is up with permissions?!" Permissions in Tableau Server are very simple, given two conditions: Forget everything you...
Tableau Driver's Ed is a new blog series in which we explain InterWorks' unique take on Tableau Drive, a new methodology for enabling self-serve BI in the enterprise. For the full list of posts, check out the Tableau Driver's Ed channel. “The trouble with programmers is that you can...
Next up on the list of ways to make your dashboards be the best they can be, we take a closer look at blended calculations: "Limit blended calculations. They require sequentially querying multiple data sources and can be time-consuming. Where possible, create a view on the...
Let’s examine the following item on the checklist: "Use calculated fields carefully. Think about the data type as you code the calculation. Number and Boolean > date > string calculations when it comes to performance." This is another item that can quickly get you into performance trouble...
Quantified self visualizations predominantly focus on daytime activity, not sleep habits. Perhaps this is because it’s one of the most difficult things to accurately measure, or maybe it doesn’t seem like an interesting data set. But, anyone with a newborn in the house knows how...
Today we’re examining the following guideline: "Watch for useless clauses, e.g. ORDER BY. Tableau is going to re-sort the data once loaded anyway." Let’s get started! SQL Overview SQL, or Structured Query Language, is designed for managing data within a relational database. It is essentially composed of two parts: Data...
Currently, we’re going through the best ways to employ custom SQL and what to avoid. Here’s what we’ll cover today: "Avoid parameters in custom SQL in Tableau. Tableau wraps the custom SQL in a subquery that many databases don’t handle well. Consider building a view in the...
The annual Tableau Conference (formerly known as TCC) is one of my favorite parts about working at InterWorks and being a part of the Tableau Community. I get to meet all sorts of new Tableau users and attend fascinating sessions and keynotes. Some of last...
Fantasy Football has become an incredible phenomenon in the United States. According to FSTA, over 56 million people will participate in some form of fantasy sports in 2015 with 73% playing fantasy football. I first started in 2007 as a means to socialize with coworkers at...
There’s been a lot of coverage of wildfires in the United States this year, particularly in the Pacific Northwest, where some of the largest fires are consuming hundreds of thousands of acres. To bring some context, I scraped data from the US Forest Service’s website...
Approximately 8.2 million people live within the five boroughs that make up New York City. Every year, thousands of accidents occur due to a multitude of contributing factors. NYPD collects information about each of those accidents and provides it for public use on nycopendata.socrata.com. We...
The rule that we’ll cover today is: "Limit custom SQL in live connections as they can be inefficient. Where possible, create a view on the database server to implement your custom SQL and connect Tableau to your view." In other environments and in other tools, using your...
Over the last twenty years, video games have become a cultural force in America. From movie spin-offs to t-shirts at Target, it's almost impossible not to be touched by the gaming industry every day, even if you don't consider yourself a "gamer." In this period...
Tableau Driver's Ed is a new blog series in which we explain InterWorks' unique take on Tableau Drive, a new methodology for enabling self-serve BI in the enterprise. For the full list of posts, check out the Tableau Driver's Ed channel. “Data, I think, is one of the most...
It’s entirely possible that one must be a country music fan (Kenny Chesney, generally, and his song “No Shirt, No Shoes, No Problem,” specifically) to understand the reference in the title. I’ll grant that up front! But whether you are or aren’t a fan, when you...
The final topic in Filtering addresses when and when not to use user filters and how it can slow down your visualization: "Don’t be lazy with user filters. Security by user filters can impact performance on Tableau Server as the server cannot share connections and query...
.syntaxhighlighter code{font-size:0.9em!important;} The Problem During a recent engagement a client asked a question I hear occasionally regarding Tableau which basically boiled down to: "How do I show marks for the percentile ranks of my customers by Sales?" The client wanted to aggregate their measure, we're using Superstore Sales here,...
Keeping track of the growing number and types of database products is a full-time chore. This week I spent a few days in Vail, Colorado at the Pacific Crest Global Technology Forum. This is the 17th year that Pacific Crest Securities has sponsored the event—bringing...
Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson
Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301
Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072