FOR BI PROS Tableau
Tableau External Services API: Adding Haskell Expressions as Calculations
November 20, 2019
0
, , , ,

All of us have their own Tableau Conference habits; mine is to participate in the first-day hackathon, build something super cool that nobody understands, and finally win nothing. This conference was no exception. Earlier this year, our team won the NYC Tableau Hackathon (even if my tasks were limited to keep our squad hydrated, caffeinated), so I had really no pressure to go competitive. I was completely free, in a bit of an artsy mood, so I decided to build one of my old dream projects:

adding the Haskell programming language as a calculation engine to Tableau, by using External Services API.

If you have no clue what does this mean, then read on.

(more…)

FOR BI PROS Tableau
Scaling out Tableau Extracts – Building a distributed, multi-node MPP Hyper Cluster
August 11, 2019
0
, , , , , , , ,

Tableau Hyper Database (“Extract”) is a great engine; it’s one of the reasons people obsessed with Tableau analytics. However, being a single node database server, it has its limits (performance and data size) – that we are going to break in this blog post. With adding multi-node capacity, partitioning and distributed query processing Hyper will act like a real enterprise MPP data warehouse – running on modern infrastructure like kubernetes.

(more…)

FOR ANALYSTS FOR BI PROS Talend
Python Experiments in Tableau 1. – Add live currency conversion to Tableau Dashboards using TabPy
January 9, 2018
3
, , , ,

In a new series of blog posts, what I creatively named as “Python Experiments in Tableau”, I will share a few projects that we are doing in-house to play with Python and Tableau. In the first example we will do something special with the “External Services” functionality: add live data from web services to implement up to date currency conversion calculations in Tableau. All this with only a few lines of code using thanks to  TabPy and the Forex Python library.

 

(more…)

FOR BI PROS LEARN Tableau
HOWTO: Tableau Server Linux in Docker Container
November 2, 2017
24
, , , ,

We are all excited about the great news that Tableau will release its Server version on Linux. Even if I’ve been testing the linux build for a while now, since this feature is currently in Beta I can start sharing tips and tricks that will make others’ (yours perhaps) lives easier. The first is an easy howto, namely how to run a Tableau Server Linux in Docker container. Running the production Server in docker definitely makes no sense, however, for quick and dirty checks or automated testing pipelines (CD/CI) it has it’s own place. So let’s see.

(more…)

FOR BI PROS Tableau
Tableau Filestore Consistency Checker – How Repository Maps to Filestore
August 17, 2017
0
, , , , ,

Somewhere around the end of July I was invited to show some magic from our consultancy portfolio in the Server Admin User Group’s virtual meetup. I choose (no, actually Mark choose) two topics: the first was automated query banding (practically server side search and replace to programmatically fill initial sqls for workbooks and data sources) while the second was this consistency checker tool. Why should you care about your repository consistency? Read more, I’ll explain.

(more…)

FOR BI PROS Tableau
Pushing the Limits of Tableau Server – Practical Lessons from a Zen Master
June 6, 2017
3
, , , , , ,

 

Today I had the honour to present at the Tableau On Tour London conference. The main focus was the “web data connector trick” that allows one to implement reusable server plugins, explained here in details. You can find my slides and source codes below:

(more…)

Tableau
Embed Tableau Dashboards in SAP ERP and S4/HANA
June 1, 2017
0
, , , ,

SAP ERP systems are probably the best when it comes to robustness, flexibility and extensibility. However, two major issues almost always come up with SAP customers: the lack of operational analytics and the user interface which is… well… not the pinnacle of UI design. SAP constantly promises that they will replace the UI with something new but the reality is that 90% of SAP users still use the traditional SAP GUI. Operational analytics are mostly restricted to simple lists and so called “drilldown reports”.

(Guest blog post from Tamas Holics)

(more…)

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
50
, , , , ,

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…)