Author Archives: Ron Keler

Using dbt macros to centralize key model parameters

Leveraging dbt to manage modularized sql for analytics is a game changer and an important pillar of the modern data stack. But not only the ability to re-use sql components on your cloud data warehouse, clearly understand data lineage and … Continue reading

Posted in Uncategorized | Comments Off on Using dbt macros to centralize key model parameters

AWS Lightsail windows instance snapshot automation

If you are using AWS Lightsail to host analytics related applications, or any other applications for that matter, and you happen to be using windows OS on your Lightsail instances, you may have noticed the message indicating that “Automatic snapshots … Continue reading

Posted in AWS, Lightsail, PowerShell | Tagged , , | Comments Off on AWS Lightsail windows instance snapshot automation

Audit Tableau Filters Application With the JS API

While Tableau Server provides good auditing capabilities in terms of logins and dashboard views, in some cases, you need very detailed and granular auditing of certain dashboards. Like other websites, you may need to understand exactly which features of a … Continue reading

Posted in Tableau | Tagged , , , , | 3 Comments

Tableau Infographic dashboard – it’s not the tool which makes a dashboard cool

Ever since Josh Tapley published the infographic style dashboard, I have been working to reproduce this design in various tools. I used SAP webi and crystal reports to create similar versions in the past and recently produced another version in … Continue reading

Posted in Data visualization, HTML5, Tableau | Tagged , | Comments Off on Tableau Infographic dashboard – it’s not the tool which makes a dashboard cool

Change the order of execution of connections in Tableau

I recently ran into a situation where I had to change the order of refresh execution in a tableau dashboard that had multiple connections (extracts) that support multiple worksheets/dashboards. The original order of execution of the connections is determined by … Continue reading

Posted in Tableau | Tagged | Comments Off on Change the order of execution of connections in Tableau

Custom tabbed navigation in tableau

This example illustrates how a combination of images used as tableau shapes, with some careful positioning and action filters, can be used to create custom navigation effects that will feel natural and intuitive to most users. Here is a description … Continue reading

Posted in Data visualization, Tableau | Tagged , , | 7 Comments

Tableau recalls dashboard using Extract API

In this recalls dashboard, I used custom shapes/symbols to represent each hazard and reflected the number of recalls through the size of the symbols. I also used the manufacturing country to create a map of the recalls, were the size … Continue reading

Posted in Data visualization, Tableau, Uncategorized | Tagged , , , | 1 Comment

Don’t let the software migration cycle cripple your BI project

Software developers have been taught for decades that they must follow the Development/Integration/Staging/Production practice. This practice was instituted to minimize the number of “bugs” in the software and allow for rigorous testing of code changes without “interfering with production”. This … Continue reading

Posted in BI At Large | Tagged | Comments Off on Don’t let the software migration cycle cripple your BI project

Embedding Tableau Dashboards

I delivered a webcast about embedding tableau dashboard in external facing apps, and embedded BI in general. You can view the webcast recording at the following address, or checkout the slides that accompanied the webcast here.

Posted in BI At Large, Data visualization, Tableau | Tagged , , | Comments Off on Embedding Tableau Dashboards

Embedded Tableau Oscars Dashboard

A few months ago I published my Oscars dashboard (http://bihappyblog.com/2014/03/10/oscars-dashboard/). Recently, I decided to produce a new version of it, leveraging Tableau, and extending it with some additional features possible with some html5 integration. Embedding Tableau in an external web … Continue reading

Posted in Data visualization, HTML5, Tableau | Tagged | Comments Off on Embedded Tableau Oscars Dashboard