Watson Analytics: How to join datasets before loading into Watson Analytics

There are 2 things I like in this clip the first is at 2:35 Minutes, has a brilliant way of displaying left outer join. Then at 3:45 the automatic visualization of the data is great