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...
And just like that, another month gone! September on the blog saw 13 new posts and 18 contributors, and a lot of this month's focus was on security, convenience and recognition of individual contributions to the data community and beyond. It was a fun month,...
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...
Thinking back, 2013 was an interesting year for many reasons. During the “International Year of Quinoa”, the world welcomed Prince George and Pope Francis. Meanwhile, the culture added words such as “twerk”, “selfie” and “bingeable” to the dictionary. In other, lesser-known news, 2013 was also...
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...
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