Channel

Data

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

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

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

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

×

Love our blog? You should see our emails. Sign up for our newsletter!