A critical part of any data warehouse is how new data is brought in and prepared for consumption. Depending on the order of events, this process is known either as ETL or ELT. So, what do these acronyms mean? ETL is the process of extracting data...
Business Information (BI) technology is a collection of hardware, protocols, toolsets and methods that is ever-changing. A common refrain has been “Buy IBM, or Microsoft, or Oracle, or SAP” because these vendors are perceived as safe investments—ways you couldn’t go wrong. The market has evolved...
Tableau Prep Builder and Conductor are Tableau’s tools for enabling repeatable, documented and scheduled workflows to transform raw data into user-friendly datasets. Tableau Prep Builder’s first live release came in April 2018 in Desktop 2018.1, and since then, we’ve had four major releases and eight...
Snowflake and Tableau are tech powerhouses that facilitate the management of ever-increasing volumes of varying data, and we at InterWorks are thrilled to partner with them in creating unique and tailormade data solutions for clients. Want to know how combining these two technologies can help you...
After last week’s Airtable post, I’m sure all of our readers have been anxiously sitting on the edge of their seats. By now, I hope some of you have had the opportunity to explore Airtable and begin building bases. While I touched on the Airtable’s...
Holt Calder wrote an excellent blog post a couple months ago about why Matillion is so great and why you should be using it. As he writes, “We have been using Matillion for Snowflake with as many of our clients as possible. Here’s why: when...
Happy New Year to all the readers of the InterWorks blog; 2018 has been a whirlwind of a year! In 2018, InterWorks steadily provided value to our clients in the data space, and as we kick off 2019, it seemed appropriate to prep you guys...
There are things in this world that data engineers love and hate. For example, they love green and hate red. Green is good, but when you see red, the ETL job is dead! Data engineers also love seeing the word “success” because it subconsciously triggers...
It all started when I wanted to make a dashboard on the correlation between the brightness of the moon and crime activity. It’s one of those things everyone has heard in their life whenever crime or hospitalizations spike (or at least I have): “It must...
Matillion – cool name, cool tech. Before I get into the actual tech, I’ve just got to comment: Who comes up with all these company names? It seems like in the entire tech industry, the Coolest Names Award is going to big data. Okay back...
Big data has been the rage for a couple of years. There have been many posts written on the explosion of digital data. It’s no longer surprising to learn that we are creating more digital data through machine-generated sources than humans. What’s more surprising to me...
I haven't had a ton of time to really dig into the new features of Tableau 9, but I did want to start playing with the new Level of Detail (LOD) calculations to see what they could do. The result is simple yet entertaining. The...
What the world needs now is a ubiquitous schema that is without form and can capture everything. That sounds like Hadoop or some NoSQL capture/archive systems. We want these data sources to be more performant so that they can also support analytical analysis with tools like Tableau. Spark will help that along. What the...
So, you’ve finally worked out your ETL process using Alteryx and have it exporting a shiny new TDE file. Now what? Using the Run Command tool in Alteryx Designer you can automate the publishing of that TDE to Tableau Server, and here’s how you do...
So, you’ve finally worked out your ETL process using Syncsort DMExpress and have it exporting a shiny new TDE file. Now what? Using the Custom Task in DMExpress, you can automate the publishing of that TDE to Tableau Server, and here’s how you do it: Step...
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