Zero to Snowflake: Multi-Threaded Bulk Loading with Python
Earlier in this series we have discussed how to load data into Snowflake using several different methods: Snowflake’s user interface, the SnowSQL command line tool and Python. These three methods all perform the same task of loading data into Snowflake; however, they increase in complexity and functionality as we progress down the list. This post […]
InterWorks Blog Roundup – February 2020
And just like that, another month has gone by. It felt like February came and went in the blink of an eye, but the good news is that we’ve got loads of resources on the blog that are here to stay. With 25 posts and over 40 distinct contributors (!!), last month’s offering boasts tons […]
Portals for Tableau 101: Page Power Improvements
Do you like tools that are difficult to use? We don’t either. A big focus our team has for Portals moving forward is making them easier and easier to use. We want to avoid users having to think about where the menu is for changing the navigation background color and instead develop a tool that […]
Setting up Tableau Prep with R Integration, Part 2
This post builds on my previous blog that laid out the basics of using the new Tableau Prep integration with R. Here, we’ll go a little bit deeper with a more complicated example and another dimension to this new capability. Using Tableau Prep and R to Add Rank to Your Data Do you need to […]
Zero to Snowflake: Reporting in Tableau
If there has been a lot of hype around how Tableau and Snowflake work so well together, it’s simply because they do! Tableau is a modern BI platform that enables powerful, self-service analytics in a continuously visual process to uncover rapid business insights. Snowflake is a true SaaS multi-cluster modern cloud data platform that enables […]
The Sound of InterWorks: Covers
I’m a sucker for a great song cover. It’s true. I love covers so much the channel topic for our #hobby-music Slack channel is: Kirsten does covers. As an undergraduate, I was known to be found lurking on Napster and Limewire at all hours of the day seeking out new and rare versions of celebrated […]
How to Improve Your Tableau Work with Documentation
When I first started out as a Tableau developer, I was just trying to make sure my calculations didn’t result in errors and the dashboard rendered properly on Server. But as time went on, the caliber of dashboards became more complex and the number of developers on a project increased; I soon realized I needed […]
How to Wrangle Date Logic in Tableau
TL;DR Build as much date logic into your calculations as possible, as opposed to using the Filters Shelf. Put your reference date (e.g. TODAY() ) into its own calculation so it can be easily changed in the future if needed. Centralize your date logic into Boolean calculations, then reference these in your fields like YTD […]
Three Barriers to Tech Change and How to Overcome Them
When you work at a consultancy, you’re in the business of change. When a client reaches out for the first time, they’re showing a desire for change. When you suggest a new technology to improve their work, you are actively advocating change. And once that technology is in place, you and your client must navigate […]
Portals for Tableau New Feature Spotlight: Report Builder Overhaul
It’s rare, but sometimes the sequels are better than the original. In parts one, two and three, the report builder just kept getting better and better. Just when you thought there was no way we could top the original, we not only did, but we did so much so that the previous iterations will soon […]