When I first started building Sigma apps, I kept hitting the same performance wall. Sigma Workbook transformations and their repeated SQL queries sent to the warehouse can feel slow. The techniques that make traditional BI fast (like pushing transformations upstream, materializing aggregated views and precomputing...
Tableau is a robust tool that allows you to build dashboards in a multitude of ways, which is part of what makes it great. The flip side is that it can be easy to let little inefficiencies pile up and affect the ultimate performance of...
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...
In a previous installment, we kicked off this blog series by materializing our policy and entitlement table and removing all physical joins in our data source. We are now left with a large volume of records due to combining users with what they’re entitled to....
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...
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...
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...
Relationships in Tableau have grown older – it's been almost two years now when they started seeing the light of day. And still, even after all that time, there are many questions around this data model, be it within the Tableau Community, be it in...
A video replay for this webinar is available at the bottom of the blog. In this webinar, our analytics team covers what data prep looks like in a modern analytics stack and makes suggestions for a solid data prep environment. The Data Preparation Process When you’re going through...
Do you ever feel like Tableau Server is crawling rather than running? Do your workbooks seem to be on the sluggish side? There are all kinds of factors that can affect performance. InterWorks analytics consultant and Training Lead Katie Wagner will show you a few...
Question: "I added a calculation that uses a parameter input and my dashboard is a lot slower now. How can I make it faster?" Example Calculation Some common reasons to include user-selected values (parameters) inside of calculations are: Change the measure displayed Set a date for comparison to...
This post continues from Building Filters in Alteryx for Tableau, Part 1. In this, the foundation filter calculations were built. I advise going through Part 1 before looking at this section. If you would like to follow on with the workflow, it is possible to...
Recently, I was required to prepare data in Alteryx and output it into a .Hyper file to create a Tableau workbook. The data that was being utilised looked at past sales and potential future sales. The dataset was a very large dataset, over 20 million...
Is your Tableau Server bogged down with endless extracts? Is your VizQL Server struggling to render your complex visualizations? A slow dashboard is a useless dashboard. Performance is critical. Researchers from the Forensic Optimization & Obfuscation Lab have pinpointed the secret to smoothing out Tableau Server...
Magic is what happens when our panel gets together. Magic and gold. This week’s show is a lot of both as Brad, Ben, Kate and Mat talk about Gartner’s Magic Quadrant for Business Intelligence Tools, self-service analytics as a concept and the different infrastructure options...
HAPPY BIRTHDAY TO US! We’re officially two years old. Thank you for being a part of our community for the past two years. We have some exciting updates to the show that we’ll implement in upcoming episodes, the first being our new panel format. Brad Fair...
As the first post in a series about Tableau Server on Linux, I wanted to share a quick note and some promising results of performance testing in the upcoming release. The TL;DR Tableau Server on Linux = Joy. Median dashboard load times were cut 40-60% compared to...
Even with the best planning, we occasionally end up with less than speedy dashboards. Tableau is great at crunching large amounts of data – but when you are looking at many different slices of millions of records, anything would be slow. There are many ways to improve the...
Just a few days ago, I had the privilege of attending and presenting at the latest Baton Rouge TUG meeting. As an LSU alumnus (Geaux Tigers!), I was thrilled at the opportunity. It was also great to see how much the Tableau community has grown...
Ask Tableau users what they love most about Tableau, and they’ll likely say it’s the ability to create stunning data visualizations quickly and easily. Tableau was designed with usability in mind, apparent in its approachable interface, yet behind that interface lies a powerful collection of...
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