FOR ANALYSTS FOR BI PROS FOR EVERYONE LEARN Tableau
Tableau Performance: Why Embedded Data Source is Faster than Published
April 16, 2017
4
, , , , , , ,

Optimize ExtractIt started with one of my colleague who managed a Tableau case from our end. His client was constantly dissatisfied: her workbooks were significantly faster with embedded data sources compared to published ones. Even if we told her that this is normal, this is the way how life works, so better accept it and let it go. But no, she wanted an explanation. Well, here it is.

Spoiler: this post is about Optimize Extract feature in Tableau and how it works internally. (more…)

FOR ANALYSTS FOR BI PROS FOR EVERYONE LEARN Tableau
Auto refresh a Tableau Dashboard without Embedding
March 21, 2017
4
, , , , ,

counterI was casually sitting at my desk writing my first ever blog entry here when Tamás Földi walked past my desk. He asked me how much I know about Tableau and JavaScript, because he has a cool idea which he didn’t really manage to find the time to implement yet. He quickly briefed me into what he had in mind and off I went to start coding it. The idea is to place a little spinner or counter into a Tableau Dashboard and as often as the counter ticks call the refresh JavaScript API function to reload the data. All this without embedding the dashboard into an another page. And what if I tell you that this little gem can be reused without any changes in any Dashboards on any Server? I bet you want to see it action first, right? I knew that, so click here to see a live working demo. If you like what you see I’m sure you’ll also enjoy reading the rest of the post where I share how it’s all put together. (more…)

FOR BI PROS LEARN Spotfire
Spotfire’s hidden Developer Tools menu
March 13, 2017
0
, , ,

 Starting from version 7.5 Spotfire is using Chromium Embedded Framework as a display engine which comes with the well-known Chrome-style Developer Tools. Why is this so great you might ask? There are a couple of good tricks you can do with this one.

Guest blog post by Norbert Ledenyi (more…)

FOR ANALYSTS FOR EVERYONE LEARN Tableau
Tableau Save as Previous Version feature
February 20, 2017
18
, , , , ,

Save for previous versionTableau Software is an R&D heavy company, they’re just continuously throwing new features and releasing new versions. But what if some of our colleagues or clients are still not upgraded to the latest Tableau Desktop version? How can we share our superb new workbook? XML Hacking? Jeff’s converter tool?

Forget all. Tableau Desktop can do it out of the box.

UPDATE: Two months after publishing this post from version 10.2.1 Tableau Software removed the DebugMenu command line option. So from here this is history.

(more…)

FOR BI PROS Tableau
Inside Tableau Desktop – DebugMenu, Override, GammaRay
December 6, 2016
5
, , , , , , , ,

screen-shot-2016-12-06-at-09-49-53One thing that I realised in Austin: I’m not a Tableau Desktop guy. I’m struggling sometimes even with the easiest densification calcs and my dashboards generally suck. What can I do? Learn Desktop, deep dive and share my findings. Well, I did and the results are below.

Going back to Austin. I spend two hours in the Hackatlon with a Tableau employee called Paul Howie. While he wrote a clever password manager (LastPass) integration to Tableau Desktop I spent most of my time to understand Desktop’s architecture especially the Qt GUI layer (but at the end of the day I did integrate Sever with LastPass as well). We were both pissed off that we did not make into the top three? Honestly, how many people struggle with copying pass database password to Desktop (a lot) vs integration Amazon Alexa with a 3rd party commercial product (a few). And there is no better motivation than resentment (hear me, Ben Lower?) so I started to plan my ultimate solution to open up Tableau Desktop as platform for the masses.

So this is the first part of my journey to write a web REST API for Tableau Desktop (yes, in Tableau Desktop, yes a Tableau REST API) starting with the basics. At the end of this series you will able to inject a web server into Desktop and call tabdoc commands from a nice web UI. Let’s get started.

(more…)

Editorial FOR BI PROS FOR EVERYONE Tableau
Building Faster Dashboards by Understanding Tableau Server
October 25, 2016
2
, , , , , , ,

small-netflixTwo weeks ago I was lucky enough to visit some of my new and old customers in the sunny Bay Area. To make it more interesting I opted for a short presentation at Netflix to talk about Tableau Server Architecture, Abstract Query Caching and Fusion plus dashboard optimisation. I was super jetlagged but still I enjoyed a lot.

Slides? Here they are: (more…)

FOR BI PROS FOR EVERYONE Tableau
Tableau JavaScript API without Embedding
August 29, 2016
18
, , , , , , , ,

Using D3.js or Chart.js without EmbeddingOne of the biggest myths of Tableau Javascript API is that you cannot use it inside Tableau Server. Some says that you need to embed your workbooks into external sites to leverage Javascript API. Well, don’t believe them since Tableau JS API works flawlessly in Tableau Server Vizportal with any workbook without any with some minor hacks.

Do you need D3.js in your workbook that interacts with the other sheets in the workbook? No issues. Want to re-define some part of the portal like what should happen when users want to export or see underlying data? It’s easy. Add excel export directly to the exporting options? It’s an hour of work. But how? (more…)

Clojure FOR BI PROS Tableau
getData() function in the new Tableau 10 JavaScript API
August 16, 2016
0
, , , , ,

Tableau getData() functionTableau’s Javascript API evolves fast. In just a few versions we have arrived from the basic embedding to an event based, fully asynchronous API. Maybe the last, missing piece was accessing the summary and underlying data (however most of us used the vud  vizql controller to get the underlying data as featured in our excel downloader for tableau). With Tableau 10 this is also possible in a standard way: you can use two new Sheet level getData functions: getSummaryData() and getUnderlyingData() .

But why is this such a great deal?

(more…)

FOR EVERYONE Tableau
My Tableau Zen Master Nominees for 2016-2017
July 27, 2016
0
, , ,

This year is passing so fast we are already around that time when we nominate those who made exceptional contribution to the Tableau community. Just like last year, when all of my favorites were honoured to be Zen Masters, I’ll introduce you my current nominees.

This year the two guys who I learned the most from, are from Tableau Software, but fortunately there is enough contribution in the scene.

If you’re not familiar with the Zen Master concept you can read more about the zen mastership and nomination process here: https://www.tableau.com/about/blog/ZenMasterNomination.

And now my nominees in alphabetical order:

(more…)

FOR ANALYSTS FOR BI PROS FOR EVERYONE LEARN Tableau
Tableau JavaScript API in Practice: My Chess Game Tutorial
July 25, 2016
0
, , , , , , , ,

yo-grunt-bowerIn this short tutorial I will go thru the basic steps of creating a project that uses Tableau JavaScript API. My intent is to show non-developers how the typical implementation workflow looks like. Obviously, there are multiple ways to achieve the same goals but the way of implementing new web applications is pretty much the same. Let me share my flow and show how I usually setup a development environment, embed a view and capture parameter and event changes. I will use my chess game as an example. (more…)