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...
SSH (Secure Socket Shell) is a network protocol that can be used to securely access other machines across a network. From our perspective, using SSH can be valuable, especially if you're looking to interact with Linux virtual machines such as Matillion servers. For example, SSH...
When I do lead a Tableau Desktop training, the very first thing we do within the tool, is build a simple bar chart. It’s pretty straightforward; Drag a measure onto your Rows shelf, and there it is. As the margin for error is even lower than with placing the...
Recently, we hosted a webinar that focused on the anchoring question of, What is data prep and what tools can help me with it? “The goal is to turn data into information and information into insight” – Carly Fiorina, CEO of Hewlett Packard We feel like this...
Question: I would like my users to see the product names above the bars in my bar chart instead of having them on the left of the bar to make it more presentable. How do I achieve this? By having the field name sitting above each...
Dashboard Templates, also vorgefertigte Dashboards mit festgelegtem Platz für Arbeitsblätter und Steuerelemente wie beispielsweise Filter, können Zeit sparen und bessere Ergebnisse liefern. Allerdings ist es dabei entscheidend, wie Du diese Vorlagen erstellst und verwendest. In diesem Webinar lernst Du: 1. was Dashboard-Templates sind und was für oder...
In our last post, we talked about the differences between dbt Cloud and dbt Core. Once you’ve decided which environment works best for your team, it’s time to start development. In this post, we’ll walk through some of the basic setup of dbt and briefly...
The year 2020 produced a mass migration of business processes, enterprise software and internal workloads to AWS in a way that was previously unseen. In the world of data, organizations relied on the flexibility of the cloud to run infrastructure, authentication and analytic workloads at...
Welcome back to a 100% definitely nothing bad is going to happen year in professional football! Last year's uncertainty didn’t seem to slow the commitment to Fantasy Football that grips the U.S., and I’ve already heard from many of you eager to draft soon due...
Question: I have a need to determine my Current Opportunity amount and the change from whatever date was listed prior. It could be the previous week or several weeks ago. Any tips for figuring this out? The second requirement is that I need to aggregate...
Row-level security (RLS) is a data access control concept that pertains to dynamically restricting the rows of data that a certain user can access in a particular dataset. Over the course of my consulting career, I have encountered this business requirement on numerous occasions, such...
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