Data

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...

Does any of this feel familiar? Our end users struggle to find the dashboards they’re looking for in my Tableau Server/Online environment. Stakeholders are confused as to which dashboard(s) should be the source of the truth for reporting. Stakeholders aren’t sure what dashboard versions are...

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...

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...

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...

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

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