Time Travel with Snowflake

A couple years ago, as I was trying to teach myself programming, I managed to wipe out my computer. It was a silly mistake—all I was trying to do was learn how to work in command line and set a directory for R. Through some degree of frustration, I deleted the folders that kept ending […]
Questions from Alteryx Training

This blog post focuses on different aspects of the Alteryx platform that I’ve received questions on while delivering training. Hopefully, this will help answer some questions you may encounter in your analytics work. Transpose and Crosstab You can use the Crosstab tool and the Transpose tool to rearrange your rows, columns and cell values in […]
InterWorks Now and Then: A Photo Challenge

As years end and begin, we like to think back fondly (or not so fondly) on the last twelve months and look ahead with expectancy to those upcoming. As 2018 transitioned into 2019, popular culture decided (for some reason) to look back … way back … to 10 years ago. This manifested in a variety […]
Tableau Class Notes: Filtering with a Date Slider

This question comes from my student Christie. She wanted a quick way to create a date slider that started after a certain point in her data. The issue is, if you set your Range of dates or Starting Date filter to begin at a certain date, your user can still adjust it to go back […]
Celebrating the Women of InterWorks

As you may have heard, InterWorks’ best asset is by far our people. It’s the thing I’m thankful for day in and day out and one of the first answers I give when asked why I enjoy working here. Today is International Women’s Day, and here at InterWorks, while we celebrate the amazing women that […]
Capturing the InterWorks Culture on Camera

Note: This post was written collaboratively by Ricki Thompson, Marketing Generalist, and Carter Link, Graphic Designer. The post represents their collective experience at their first InterWorks Summit and Holiday Party. Find more accounts of first-time Summit attendees here. The InterWorks Summit is an annual event when we come together as a company to realign big-picture […]
Makeover Monday: Attendance at NHL Games

New Year, New Year’s Resolution. I’m not a huge believer in resolutions, but I do have a list of to-dos on my desk, and now seems as good a time as any to get things going. One of those things I’ve been meaning to do more of is Makeover Monday. I’ve tinkered around with it […]
Advance with Assist: Creating a Distribution of Sales in Tableau

Question: How would I go about calculating how many states generate a specific percentage range of sales? Like > 10% of total sales as an example? I want to know where to target more marketing efforts. Can you help me get started? As with most things Tableau, there are a variety of ways someone could […]
Going the Distance in Tableau: Fixed Point Comparisons

Calculated fields are awesome. They can be used to discover incredible insights in your data by using fields from your original data source. And if some of those fields are latitude and longitude, they can be used for more than just plotting. You truly can use calculated fields to go the distance. Distance Calculations in […]
Webinar Replay: Tales from the Portals Crypt

Oftentimes, when you run into issues within your data practice, a simple solution can be found. You just have to know where to look and who to ask. In this webinar, some of our InterWorks experts talk about how embedded analytics can be the right solution for your needs. Mark Bingham and Derrick Austin share […]