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...
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...
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...
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...
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...
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...
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...
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...
As of version 2019.3, Tableau Prep introduced a new and exciting feature: integration with R and Python. This is an incredible way to expand and customize the capabilities of your workflow. As someone coming from an R background, I was excited to brush up on...
One question we often get when a customer is considering moving to Snowflake from another platform, like Microsoft SQL Server for instance, is what they can do about migrating their SQL stored procedures to Snowflake. If you’ve read Snowflake’s documentation on the subject, you’ll know that Snowflake’s stored...
I’m going to let you in on a little known fact: Scientists have very recently discovered that a picture is worth a thousand words. When it comes to tutorials, you can either use your thousand words to describe each part of a dashboard, or you...
Tableau is the #1 visual analytics platform in the world. In part, it has accomplished this by providing its user base with a tremendous amount of flexibility when it comes to data sources. By my last count, Tableau has over 80 native connectors to a...
Gartner has recently released the Magic BI Quadrant for 2020. As a refresher, this quadrant ranks the top platforms in BI according to factors like execution and scope of vision. Per tradition, I've decided to take their report and visualize them in Tableau. The overall...
One of the first things you’ll do when setting up your Snowflake environment is to establish your virtual warehouses. What this boils down to, essentially, is how much compute you want to use and how segregated that compute will be. What Is a Virtual Warehouse? Warehouses are...
What does it look like to go from zero to hero with Snowflake? In this PYD episode, host Ben Du talks with Geoff Soon, the company’s managing director for South Asia, about the value of Snowflake, what we can expect in its future and some...
Two weeks ago, my fellow content connoisseur Andrea Avey sat down with InterWorks IT gurus Scott Matlock and Tim Rhymer to talk about the impact of the cloud on IT over the past ten years. That’s some serious ground to cover, and they did a...
We know what dates Halloween, Christmas, and US Independence Day are on. But what about National Dogs in Politics Day or National Raisin Day? This Alteryx Weekly Challenge starts with a list of unofficial holidays, and the goal is to put them in order from January...
In the entire history of the world, sharing information has never been easier. This becomes obvious just by looking at social media platforms. Their technological innovations have enabled billions of users worldwide to share Instagram stories, TikTok videos, World War 3 memes, baby/yoga/kitten videos and...
Data visualization, like any other tool, can serve whatever purpose we desire. Most of the time, it is a business-related purpose. However, there are thousands of cases where pointing out a gain or loss in a specific aspect can bring us—as a society—increased life expectancy,...
If you’ve never heard of Typeform, don’t worry. A lot of people haven’t. However, allow me to introduce you. Typeform is a great tool that can stand in place of programs like SurveyMonkey or Qualtrics. As users take a survey, it can provide an awesome...
Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson
Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301
Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072