Working with Dates in Tableau: To-Date vs. Rolling Periods
A common question we field is how to create current period and prior period selections in Tableau to show % changes in periods. Popular periods include the To–Date family of Month to Date (MTD), Quarter to Date (QTD) and Year to Date (YTD). To-Date periods have a fixed starting point and provide a hindsight view […]
Upgrading Your Legacy Tableau Server
Tableau recently sent out an email to all customers letting them know that a version of Postgres that’s embedded within their Tableau Server product will no longer be actively maintained as of November 11, 2021. This means that if your Tableau Server is running any version prior to 2020.4, you will need to upgrade to […]
InterWorks Blog Roundup – July 2021
We made it another month and are excited to present the July roundup! Last month on the blog, we featured 20 different InterWorkers – including TWO new posts from our fearless leader, Behfar – and published 17 new content pieces aimed at empowering and equipping you in your journey with data and tech. We took […]
Webinar Replay: Interactive Dashboard Tips & Tricks
Interactive dashboards are where Tableau really comes into its own. As a Creator, you can build something that lets your users explore and answer questions you didn’t even think to design for. But while we know that interactive dashboards are valuable, many users will find themselves using only a tiny fraction of the options available […]
Advance with Assist: Highlighting Points of Interest
Question: I want to allow my user to easily see a custom value that is connected to a highlighted point on my time series chart. How can I do this in a way that can also interact with a dashboard action to give these values more prominence and context for the user? Client Scenario You […]
Snowflake, Matillion and InterWorks Accelerating Success in Asia-Pacific
Call it kismet or just plain-old great collaboration, but the relationship between Snowflake, Matillion and InterWorks continues to produce some real data magic. We’ve worked together for a few years now, but 2020 was a particularly notable year (in a good way) in terms of helping others streamline the way they work with their data, […]
How to Stage Email Attachment Data with Matillion
Transferring datasets via email is definitely not ideal, and while we try to avoid it as much as we can, there are occasions where our data providers do not have the resources to provide their datasets any other way. Maybe they are able to implement better, more elegant ways of providing their data such as […]
Exploring dbt Cloud vs. Core
In our previous post, we briefly introduced dbt and an emerging role on modern data teams called an analytics engineer. If you’ve had a chance to dig into dbt, you’ve likely asked the questions, “What is dbt Core?” and “What is dbt Cloud?”. In this post, we hope to add some clarity to these questions and give […]
A Data Viz of U.S. Lumber Prices in 2021
My wife and I moved into our downsized home three years ago. Our timing was good. There was some available inventory, and we were able to purchase a very nice home for a reasonable price. This weekend we received a letter from a realtor who is representing a buyer that wants to purchase a house […]
Getting Started with Python Scripts in Tableau Prep
In the last few years, we have seen an ever-growing number of codeless data-prep solutions made available to analysts and developers. At InterWorks, we are constantly vetting these technologies, especially those that are extensible with powerful integrations with scripting languages like Python. Tableau Prep is among the tools we like, as it brings custom scripting, […]
