How to denormalise a dataset using Talend’s tUnpivotRow
In both my previous 'Eurovision Song Contest Voting' and 'History of Refugee Movement' blogs, I have needed to denormalise datasets in order to properly use them within Tableau. If you want to replicate a similar action on a large data set, here's how I did it... For...
An overview of Talend Data Preparation
Some time ago we wrote about the new Talend Open Studio, version 6.0, back when it was still in Beta. Well now we would like to share a new product created by Talend. It's called Talend Data Preparation and it might be an amazing offering for a particular audience....
A visual history of the refugee movement
This blog refers to this set of visual dashboards available for free, public viewing on Tableau public. If this link does not work, please visit the Tableau Public website and search for ‘Refugee Movement History’. Rather than writing about the enormity of the...
Managing your Azure Active directory from different instances
Challenge Here is a quick fix to a simple but bothersome challenge: there are users in your production active directory that are required to collaborate on an application that is currently under development or at least being tested in a non-production environment. How...
Validating address data in Talend Studio
This article will present you with a crash course in validating address data using the tGoogleAddressRow component in Talend Studio. Incorrect or incomplete address information is a common problem in customer databases but thankfully, Talend offers an out-of-the-box...
Creating a Blog Scoreboard using Google Analytics and Tableau
Overview One of the marketing challenges we initially faced after merging to become Datalytyx was how to increase our visibility online. Our friend, Ian Cleary of razorsocial.com, kept telling us that we needed to create valuable content. That would increase our SEO...
Talend Studio: Tips and Tricks (Part 2)
You may have seen a blog published by me a few weeks ago called "Talend Studio: Tips and Tricks (Part 1)". In this blog, I touched upon a few nifty ideas to help kickstart your use of Talend Studio 6.0. So, in the spirit of keeping things short and simple, here's part...
Talend Studio: Tips and Tricks (Part 1)
As you may or may not know, my blog articles often revolve around solving issues and challenges that has arisen while using Talend Studio on client projects. Here are a few of the smaller, but no less valued tips and tricks I've picked up since working with Talend...
Using Validation Rules
Introduction In this blog entry, I will discuss a feature of Talend that is almost never talked about - and it's right there in front of you. Each time you open the Repository tab and go to Metadata you will see "Validation Rules". Well, OK, you might not see it if...
Fixing the CMIS component issue in Talend 6
Synopsis Talend 6.0.1 brings a lot of new features and technology upgrades, which is always welcome. Unfortunately that also means that there might be compatability issues with previous projects, generated with older versions of Java, or the potential for custom...