It’s the most wonderful time of the data year. Here’s looking at you, Tableau Conference 2021. As we prepare for the week, join InterWorks Communications Manager Garrett Sauls as he speaks with InterWorks Global Experience Practice Lead and long-time Tableau Conference attendee Ben Bausili. Together,...
When following this content, I would recommend first reading through the following two posts: How to Access a Linux Virtual Machine (e.g. Matillion Server) via SSH from Windows How to Configure Remote Git Integration for Matillion Leveraging SSH Keys These two posts have been written to...
There are pivotal projects in our careers that help set our paths towards doing cool work. For me, as someone in marketing, the Tableau Conference has been that catalyst. I started at InterWorks over 10 years ago with no marketing or trade show experience. At...
Great dashboards start with great stories, but how much do we think about that story before we open up Tableau or PowerPoint? Many of us are guilty of dashboarding without purpose, which can limit the impact of what we produce. So, in this webinar, we...
There are several ways to set permissions on folders in a Linux machine. Many Linux experts with far more knowledge than myself have already created tons of online resources to discuss this topic, so this is just a quick overview of configuring privileges to directories...
The summer update of the Tableau platform has given us a few new features for Tableau Server, as well as for Tableau Desktop. Let’s have a look at what was released: Notification Integration with Slack: Notifications for alerts, @mentions and sharing; visit our blog post...
When using Matillion to load data into Snowflake, temporary stages are often created in Snowflake to store the data before it lands in the destination table. Often, this is not an issue as Matillion provides a handy load option called "Clean Staged Files," which cleans...
Daten sind selten perfekt. Und wie wir wissen, kommt es auf die Vorbereitung an – mit schlecht aufbereiteten Daten riskieren wir langsame oder ungenaue Ergebnisse. In einer idealen Welt würden wir unsere Datenvorbereitung in der Datenquelle selbst oder in etwas wie Tableau Data Prep erstellen,...
After you’ve finished setting up your dbt environment and begun working in dbt, you may find that you’ll need more than just the basics. As mentioned in The Transformational Power of dbt in Analytics, dbt allows data teams to leverage the capabilities of software engineering teams. Here,...
In the previous post, we discussed the benefits of supplementing traditional to-date reporting periods with rolling periods. In this post, we will dive into the optimal practices (and not-so-optimal practices) for creating the logic for effective Date Selection calculations in Tableau Desktop. Common Date Functions Before we...
We have all seen this problem in data transformation: names automatically becoming CAPITALISED NAMES or all lowercase names. If we have a list of cities consisting of only one word, it is quite straightforward to capitalise the first one using the following code: UPPER(left([Data],1)) + LOWER(right([data],LEN([data])-1)) However,...
InterWorks recently joined Dremio’s Global Partner Network, so naturally we’re here to give you a rundown of what Dremio is and when you’d look to use it. Check out our post announcing this new partnership. Dremio is a SQL Lakehouse Platform that features a shared semantic...
Tableau is committed to helping people see and understand data. This translates into many things: building products with intuitive platforms, making AI available in a no-code/low-code environment and investing in data literacy and governance, just to name a few. Ultimately, it’s about removing barriers between...
Remote git integration is a way of backing up a local git repository to an online git management provider, such as GitHub, GitLab or Azure DevOps. If a customer has multiple Matillion instances for any reason, this also allows them to make changes on one...
This is a walkthrough for adding a task that automatically starts the Matillion instance at a certain time and another task that shuts down (deallocates) the resources of the Matillion instance via an API endpoint. These two tasks are intended to be deployed in Azure...
Does any of this feel familiar? Our end users struggle to find the dashboards they’re looking for in my Tableau Server / Tableau Cloud environment. Stakeholders are confused as to which dashboard(s) should be the source of the truth for reporting. Stakeholders aren’t sure what...
Often when working with Matillion Support or investigating other Matillion issues, you will need to retrieve the logs from the Matillion virtual machine. This could be for several reasons, including: The logs available through the UI may be trimmed whilst the virtual machine itself stores...
Key pair authentication is a method of authenticating with a system using a pair of keys that meet specific security requirements. The pair consists of a private key that is leveraged by the system trying to authenticate and a related public key that the authenticator...
There are various reasons you may wish to access the backend of a Linux virtual machine. In regards to a Matillion server, which is hosted on a Linux operating system, this could be for a variety of reasons, including but not limited to: Retrieving historic...
SSH-Agent and OpenSSH are tools in Windows that can be used to authenticate to remote Git repositories, such as GitLab, GitHub, Azure DevOps, etc. Once set up as a service that stores your various SSH keys, this can facilitate authentication without entering a password each...
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
