Webinar Replay: Redesign the Analytics Experience with Curator
A video replay for this webinar is available at the bottom of the blog. A lot of analytics tools are fantastic at visualizing data, but they don’t really have a good solution for presenting that data in a clean and effective way. That’s where Curator by InterWorks comes in. Why Curator? The common state of […]
InterWorks Blog Roundup — August 2022
Fun trivia fact about August you probably learned at school: the month was named after the Roman Emperor Augustus by, well, himself! Actually, all of the English language month names are carried over from Roman naming conventions. I’m a sucker for history, and month names are honestly just super neat. Oh, right, the blogs. Well, […]
2022 Tableau Fantasy Football Draft Kit
Last year’s Fantasy Football saw some wild rides, with early favorite Christian McCaffrey injured early and Cooper Kupp going absolutely HAM in PPR especially. COVID didn’t impact the season as much as it could have, fortunately and we’re not likely to see any further major impacts until variant 2389298b. With any luck, we’ll get another […]
Tableau Relationships: Performance – Joins and Referential Integrity
Now, let’s look into the second part of the Performance Options: Referential Integrity. What a daunting phrase! Sounds scary, but it’s actually simpler than the Cardinality. With this option, we tell Tableau whether it should expect values to have a match in the other table or not. Let’s have a look at our example from […]
Investigating Snowflake Connectivity Issues with SnowCD
Snowflake have developed a simple command line tool that can be used to investigate snowflake connectivity issues. This tool’s full name is the Snowflake Connectivity Diagnostic Tool, however it is more commonly referred to as SnowCD. If you are seeing connection issues with Snowflake, I would recommend using SnowCD as your first investigative action to […]
Soft Skills for Consultants
If you google, “skills every consultant should have,” you’ll get pages and pages of articles online listing out key skills for consultants. Communication! Leadership! Problem-solving! It’s a dizzying array of attributes and skills. As a hiring manager for InterWorks, I’ve talked to a lot of people who want to become consultants. Here’s my slightly different […]
Tableau Relationships: Performance – Speed and Cardinality
It may happen that we work with really big tables that are not just a few rows but millions or even billions of rows. Tableau’s VizQL’s SQL (what a beginning of a sentence!) has to query all these tables, and that takes time. When we are dealing with seconds of loading time (latency) or even […]
Tableau Relationships: Performance – A Few Introductions
From here on out (at least for a few posts), we will have a look into the Performance Options of Relationships that are shown when we design a relation between two tables. If you have no idea what I am talking about, chances are that you have never expanded the options. You’ll find them in […]
Upserting Data in Matillion
In my last blog, I showed you how to iterate through a variable to bring multiple tables into the raw layer of your data warehouse. Today, I’m going to build on that concept by creating a DIM table and performing an UPSERT. Now, to start, I won’t go over the process of building the DIM […]
Tableau Relationships: Extracts
The new data model brought us the Logical Layer, from which we can draw specific tables without being forced to load the data from all the related tables. Remember, with traditional joins, all sheets that worked with that join had to load the full data set from that joined table regardless if we were only […]