Welcome back to our mini-series on Snowflake External Functions with AWS Lambda. Before we proceed, please read the previous post on how to set up these functions and how Snowflake interacts with AWS Lambda. API Knowledge Disclaimer If you are unfamiliar with APIs and how they work,...
A regular expression, also commonly known as RegEx (pronounced as /reh-JEKS/), is a powerful text-processing framework that uses a sequence of characters to define a search pattern. It is a widely used method to identify if a pattern exists in a chunk of text, and...
Data lake is one of the terms in our field that has changed a lot over the years. When I think about data lake as a workload that organizations run, my first thought goes back to the Hadoop days. Hadoop promised that processing true big...
In this post, we’ll be looking at how we can use a tooltip and worksheet actions to highlight, rather than filter, a data point in our target viz. Here, the primary viz shows the sales by Sub-Category, and the tooltip shows where that Sub-Category sits...
Since Tableau released 2020.3 on the 11th of August, it is high time to highlight some of the new or improved features. In this blog, I'll highlight the following: Improvements to the New Data Model Improvements to set controls, both introduced in 2020.2 The IN...
This week's show is all about Tableau User Groups! Join our host, Ben Bausili, as he speaks with TUG leaders from across the globe. We hear from seasoned TUG leaders like Dan Murray who shares about his European TUG adventures and Eugenia Kis who speaks...
Question: I’m needing to split Sales out for each member of a dimension to have separate measures. What’s the best way to go about that? This question comes up from time to time when someone has a dimension that separates out a single measure, but the...
You are probably already aware of sheet swapping within a dashboard in Tableau, whereby a parameter is provided for the user to select the visualisation they want to see ...
Recently, Snowflake implemented a new feature that allows its standard functionality to be extended through the use of external functions. Among several other capabilities is the ability to create AWS Lambda functions and call them within Snowflake. This has unlocked a whole new realm of...
When talking about the “doing” part of data engineering, folks usually want to say something about ETL like, “How are your ETLs running today?” This is a horrible term and even worse in plural form. The new hotness is to flip the “T” and the...
As the world remains in quasi-quarantine, we’ve been staying connected and learning in our home offices thanks to InterWorks’ virtual Lunch & Learn series hosted by our APAC team. This month’s event covered five essential tips on table calculations. Table calculations are a special feature inside...
In this new blog series, we’ll be looking at a few advanced techniques for tooltips. To get to grips with the basics, why we use tooltips and how they can add to your views, refer to this blog from my colleague Brooks Barth. You can...
Have you ever been working on a project and wanted to pull in some data that you didn’t have access to? This has happened to me on far too many occasions. My next step is to figure out where I am going to get that data from then...
Politics are … tricky. I firmly believe that data has its place in every part of the world. However, I also know that data can be biased, especially in its presentation. So, when designing for data, how does one navigate these biases? I’m not sure...
Question: After restarting our Tableau Services due to the gateway going down, the system came back up. However, we now see that the Interactive Microservice Container is degraded. Restarts aren’t fixing the issue. Anything else we can try? In this post, we’ll talk through the troubleshooting...
The Drawing Tool has been incorporated into CBI Studio by InterWorks. Explore CBI Studio to see what’s new. As a result of the widespread measures taken by various governments around the world to mitigate the spread of COVID-19, a lot of business industries have been adversely...
When you think of data science (for the purposes of this blog, this will encompass all machine learning and AI activities), you may think of specific aspects. I would make a wager that most people think specifically about model building. The Data Science Process Data science is...
Question: We just upgraded to 2020.2 and when I view the data source screen, I no longer see my joins that were in my data source before. Where’d they go? Do I have to rebuild? With the release of 2020.2, Tableau has unveiled many new features,...
Geocoding addresses in a scalable and sustainable way has always been surprisingly difficult in the BI world, let alone in Tableau. You either need expensive datasets/services, overkill GIS tools, or you must rely on very legally dubious usage of seemingly free (but not really free)...
Tableau Prep has improved considerably since it was launched. It offers a lot of tools to pre-process and transform your data. But sometimes, you need to apply a function that has no equivalent in Prep, want to extract some data using an API interface or...
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