The Tableau Performance Checklist: Custom SQL – Avoid Parameters
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 database or use a multi-table join with filters.“ Let’s […]
The Tableau Conference 2015 Session Planner
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 year’s highlights included Neil deGrasse Tyson, Hans Rosling, Dr. John […]
Performance Monitoring your Tableau Server Environment
Why do you need to monitor the performance of your environment? Your Tableau Server is a key element within your Tableau world, and for many people this is all they see of Tableau. They don’t get to play with Tableau Desktop, but they are the consumers of reports either through a web browser or mobile […]
Data Viz: 2015 Fantasy Football Draft Kit
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 a new job. At the time, I didn’t even much […]
Data Viz: Wildfires in the USA
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 for 2015. The site also includes links for historical fire […]
8 Years on the Inc. 5000: A Closer Look at What Keeps Us Growing
A week or two ago, we received notice from the folks over at Inc. that InterWorks would again be listed on the annual Inc. 5000 list of Fastest Growing Private Companies. For those counting, this will be our eighth year making the cut, and we came in at #2,600. That’s pretty significant and definitely worth sharing. […]
Exploring NYC Vehicle Crash Data in Tableau
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 decided to explore the crash data to see if there […]
The Tableau Performance Checklist: Custom SQL – Limit in Live Connections
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 own custom SQL connections would be a way […]
Analyzing Blizzard’s Video Game Trends in Tableau
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 of time, one developer has stood highest amongst the others. They […]
Tableau Driver’s Ed: Agile Development
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 powerful mechanisms for telling stories. I take a huge […]