“I have a lot of data and want my users to be able filter the dashboard. However, there are a few options in the filter that I don’t want them to be able to select. How can I remove these from the dropdown but not...
This post covers how to automate the fetching and pushing of a Matillion project's local git repository with its remote counterpart and uses the Bash Script component to do so. If you would prefer, I have also written a similar post which leverages the Python Script...
At InterWorks, we want to help users create insightful, intuitive data experiences and empower them with the tools and best practices to navigate those data experiences in the most natural way possible. At this year’s Tableau Conference, we hosted a session that took a closer...
This post covers how to automate the fetching and pushing of a Matillion project's local git repository with its remote counterpart using the Python Script component. If you would prefer, I also have a similar post that leverages the Bash Script component. Requirements Your Matillion project...
By now, we’ve all seen the blazing speed of Matillion workflows, but we always want more, right? Let’s talk about how to get even more speed from your already-lightning-fast workflows, and – while we’re at it – let’s talk about how to save a few...
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...
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