Author Archives: Ron Keler

Using dbt macros to centralize key model parameters

Posted on October 1, 2021 by Ron Keler

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

Posted on June 2, 2020 by Ron Keler

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

Posted on November 8, 2015 by Ron Keler

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

Posted on July 6, 2015 by Ron Keler

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

Posted on May 12, 2015 by Ron Keler

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

Posted on March 29, 2015 by Ron Keler

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

Posted on January 1, 2015 by Ron Keler

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

Posted on September 29, 2014 by Ron Keler

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

Posted on September 1, 2014 by Ron Keler

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

Posted on August 4, 2014 by Ron Keler

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