Posts Tagged: etl

FOR BI PROS LEARN Talend
Vacuum Analyze with Talend Open Studio
March 23, 2015
0
, , , , , , , , , ,
The whole started with a requirement to vacuum analyze our production greenplum appliances. The problem was with the timing, we only had two hours to complete the activity. This means we would need to start with the table that was never vacuumed, then followup with the other tables ordered by vacuum date and stop process precisely after […]
FOR ANALYSTS FOR EVERYONE LEARN Tableau
Developing a simple dashboard in Tableau (part II.)
October 13, 2014
0
, , , , , , , ,
As I promised you in the Complaints blog post that I’m going to unfold the steps of creating the dashboard itself, so here it is! Draw? Draw! The above is a first prototype for the Complaints dashboard that served perfectly well when I had to create the dashboard itself. I highly recommend you to grab […]
FOR ANALYSTS FOR EVERYONE LEARN Tableau Talend
Creating a simple dashboard in Tableau with Talend and MySQL
September 15, 2014
0
, , , , , , , , ,
Tableau and some ETL In the following post I’m going to show you how to create a simple dashboard in Tableau from a MySQL database table which contains data from an .csv file loaded into the database via Talend. It’s also an easy to understand and hopefully working introduction to a basic ETL process, so […]
FOR BI PROS LEARN Tableau
Trigger Tableau Schedule from Java
September 9, 2014
1
, , , , , , ,
One of our customers asked me to help trigger Tableau Server extracts/schedules from their ETL application. The most easier way is to invoke tabcmd and call the runschedule command.  Well, I am not huge fan of the command line invocation from tools and applications, it’s fragile and platform dependent (our ETL is running on Linux […]