Tableau Deep Dive: Dates – Exact Dates
We’re continuing our Deep Dive into Dates with an examination of the Exact Date value. Remember to catch up on the previous three articles where I introduced dates (discrete vs. continuous) and some key date functions. Let’s get started! Exactly What is Exact Date? In our first article, we learned the difference between discrete and […]
Tableau Deep Dive: Dates – More Date Functions
We’re continuing our Deep Dive into Dates with further exploration into date specific functions. In this article, we’ll cover DATEADD, DATEDIFF and DATETRUNC. My goal is not only to show you how to use them but to give you some real world examples of when they’d be particularly useful. We’re going to start with our hypothetical Superstore […]
Tableau Deep Dive: Dates – Preparing Dates
In the first article on the Deep Dive on Dates, I introduced some of the basic concepts of dates. Specifically, we covered discrete vs. continuous dates, dart parts vs. date values and some basic date functions (DATEPART, YEAR, MONTH and DAY). In this article, we’ll cover more ways to work with dates. Most of the […]
Alteryx Tool Spotlight: Compare Values Across N Groups with Dynamic Replace
Imagine you are supplied financials from multiple vendors and have the wonderful task of comparing them to each other? With two vendors, you could easily write out formulas in Excel for each financial line item comparing one vendor to the other. But what if you had over 1,000 vendors to compare? You’d probably quit on the […]
PYD25 – Infrastructure & Security
We all love making new, beautiful visualizations, but what good are the vizzes if your data is unsecured and a mess? In this episdoe, InterWorks Data Engineer Matthew Brimer and Solutions Architect Jonathan Lundin talk about security, the Internet of Things and shoring up the wave of the future: mobile devices.
Tableau Deep Dive: Dates – Introduction to Dates
Dates are one of the most confusing topics that come out of Tableau training. What is the difference between a continuous date and a discrete date? What is the difference between those and normal continuous and discrete fields? Why isn’t my date field showing up in Tableau Desktop with the appropriate data type? What are […]
InterWorks Partners with the Data Integration Wizards at Keboola
We’re always looking for the latest and greatest things in data at InterWorks, and we think we found something really cool in our newest partner, Keboola. For those of you who don’t know, Keboola is an agile data integration and data preparation platform. That’s a fancy way of saying an awesome platform that lets you connect to, extract and […]
A Recap of the 2017 InterWorks IT Summit
Above: The InterWorks IT team gathers for the 2017 IT Summit. You may remember us mentioning our annual BI Summit back in December. Well, they’re not the only ones ascending metaphorical peaks. Just last Friday, the InterWorks IT team gathered at the OSU Alumni Center in Stillwater, Oklahoma, to discuss the events of 2016 and […]
Tableau Viz Showcase by Industry: K-12 Education
“Data-driving decision making” is a phrase heard in several industries, perhaps none more so than in education. In such a scrutinized field, the ability to back decisions up with data isn’t an optional luxury, it’s a necessity. The challenges that many educational organizations face are that they have a variety of data systems, a need […]
Outrage and Apathy: Presidential Election Voter Participation Visualized in Tableau
Emotions are running high right now as evidenced by the large number of people participating in the Women’s Protest Marches all over the world this past weekend. My oldest daughter is 24 years old. She wasn’t happy with the outcome of the election, but she didn’t vote. This and a Seth Godin post I read this morning got me interested […]