A few years ago, the dominant architecture for data and analytics was based around an enterprise data warehouse (EDW). The intention was to replace separate departmental data silos with a central hub that would allow data to be shared much more easily throughout the organisation. Early...
Welcome back, welcome back, readers! This is, as you can tell from the title, the InterWorks Blog Roundup for March of 2024. Yes, I just read the title back to you for word count purposes. No, I will not apologize. Anywho, we're listing out here all...
While visualizations provide a valuable snapshot of data, they often fall short in accommodating the diverse analytical needs of decision-makers. For example, imagine a visualisation shows total sales by year. This is useful. But what if we want to compare this with the average spend...
In this blog we will show how to write case statements in Power BI, and how they differ from writing case statements in Tableau. How do you write a CASE statement in Tableau? Since the syntax in Tableau (VizQL) is very similar to SQL syntax writing a...
For anyone interested in learning multiple BI tools, it's always a rough start in the beginning: we're sure we know the basics, but we also need to understand how some concepts translate or don't even compare. Like a Mac user trying to use a PC, switching...
With more than 150 virtual sessions, talks and live Q&A events, the Power BI and Fabric Summit 2024 conference had something for everyone. The keynote session kicked off with an overview of the Microsoft Fabric ecosystem. Getting a chance to hear from Kim Manis, who is...
Welcome to our journey into the world of AWS automation! In this blog post, we'll be exploring how to automate the start and stop times of Amazon EC2 instances using a combination of AWS services: Lambda, EventBridge and Simple Notification Service (SNS). Managing EC2 instances...
The term "Medallion Data Architecture" was first coined by Databricks where they describe data at different stages of processing as being "bronze," "silver" or "gold" level data. The term has since been used by Microsoft to describe stages of processing within Microsoft Fabric. It can...
It was the end of April 2023 when I got a phone call from Diego, a former and very dear colleague with great experience working with Tableau (and with data in general) from whom I personally have learned tons. He told me that he recently...
In this episode, Content Manager Garret Sauls sits down with Analytics Architect Jack Hulbert, Analytics Lead Brooks Barth and Solutions Architect Director, Americas Mat Hughes to discuss the upcoming Data Council Austin 2024, what they’re looking forward to and much more. Dive on in!...
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...
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...
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...
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...
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...
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...
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...
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...
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,...
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?...
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