Introduction to Semantic Layers
At InterWorks, most consultants would be able to tell you this story: “My client has asked me to help build a source of truth for all of their reporting and data analysis queries.” The ask is simple: analytics teams want a one-stop shop for their stakeholders to self-serve, consume a polished KPI dashboard or export […]
Data Products: Why Use Them and Why It Can Be Difficult to Get Started
Packaging data in the form of data products greatly increases the value and flexibility of your data assets. New business functionality can be delivered up to 90% faster and overall TCO of your data assets can be reduced by 30% (ref 1). Limiting data sharing to well-defined data products can make data governance processes more […]
How To Build the Best Metrics in Tableau Pulse
Tableau Pulse is here! The newest development of the Tableau world, launched and driven by artificial intelligence. If you haven’t seen much about what Tableau Pulse is and how it works, check out some of the blogs my colleagues and I have already published to get you onboarded. Here, I’ll give you detailed and practical […]
Tableau Hacks: Range-Based Labels and Axis
If the axis on your viz can change from anywhere between single numbers to millions depending on your filters, it might sometimes be a bit annoying that the number formatting on the axis and labels doesn’t change. However, as always, there are ways around this. Let’s have a look at making the labels and axis […]
InterWorks Wins Four 2024 Matillion Emerald Partner Network Awards
It’s officially award season, both in the film industry and for technology consulting partners like InterWorks. On Friday, March 8, our friends and partners at Matillion announced that the InterWorks team won four of their Emerald Partner Network Awards for 2024: Matillion APAC Partner of the Year Matillion Customer Obsessed Award Matillion Partner Champion: Paul […]
How Assist by InterWorks Supports Your Entire Data Stack
Assist by InterWorks has been helping hundreds of InterWorks clients for years now. Assist got its beginnings as an on-demand, Tableau assistance offering connecting users directly with our consultants. Tableau users could easily hop on a call, wherever they are in the world, and chat with Tableau experts who could help them through any issues […]
Comparing Query Performance of Star Schemas vs. Flat Tables
I was doing some performance tuning for a client recently, trying to improve their query performance from a SQL Server Parallel Data Warehouse. As part of the benchmarking process, I compared performance of a classic star schema (separate fact and dimension tables) with a single flat table holding everything. With a star schema, the database […]
InterWorks Blog Roundup — February 2024
Hey, howdy, hey readers! Welcome back to our monthly blog roundup, where we’re going to list out all of the blogs we published in February for your easy perusal. Scroll through, find a blog that tickles your fancy, and read on! Or, you just came here to see what music I recommend this month. I […]
How To Build a Colored Smooth Funnel in Tableau
As we’ve published before, a funnel is a great way to represent and track a flow or stages in a process. Whether in business, science or engineering, for instance, we can use funnels to easily see and analyze how large or small those stages are, or, in other words, how many elements are reaching each […]
Tableau Hacks: Mark Label Wrapping
A niche one today, but it does come up in some vizzes every now and then. Can you remember the forklift where we use placeholder values like “min(1)” or something similar just to draw a mark in a graph to than use for something else? Well, sometimes you might want to use a placeholder mark […]