Data Quality: An Introduction to Data Profiling
Overview Data quality plays a vital role in data driven organisations; the ever-growing reliance on data to make critical decisions based on predictive analysis and trends relies heavily on trusted data. Most organisations want to capitalise on the data they have...
Talend Open Studio 6.0 Preview
Overview Talend recently announced the Beta of Talend Open Studio 6.0. The new version has been in development for quite a while now and we have seen 5 milestone releases so far. The release of Beta means that the final release is getting closer. This is an important...
How to Connect Tableau to a SharePoint List
Introduction Company and organisational information is often locked up inside SharePoint and is not always easy to manipulate or visualise as Business Information. This is where Tableau comes in. SharePoint data can be manipulated or accumulated with other information...
Microsoft SharePoint: What are Event Receivers?
Overview An event receiver in Microsoft SharePoint is a method that is triggered when action occurs on a specified SharePoint object. Triggering events include actions such as adding, updating, deleting, moving, checking in, and checking out. The SharePoint object...
Making best use of Talend’s tSystem component
Overview The tSystem is sometimes an overlooked component in Talend, and rarely used. So in this blog post, we are going to look at how we can inject external application functionality into Talend, such as PuTTY, by using the tSystem component. Main As you may know...
How to Extract List Items from SharePoint On-Premise into Talend
Many businesses and organisations use Microsoft SharePoint in one guise or another to store company-centric information. Most of this information is locked in and it can be difficult to extract, and yet much of it could be used to report on the health of the business,...
How to create a Talend MDM trigger to standardise telephone numbers
A fundamental principle of Talend Master Data Management (MDM) is data quality and data governance and the specific trigger functionality is a great way to automatically execute events on record creates and updates. However, getting started with trigger functionality...
The 4 Big Questions at SSOW 2015
Big data is like teenage sex: everyone talks about it, nobody really knows how to do it, everyone thinks everyone else is doing it, so everyone claims they are doing it. If you have ever read a blog about big data then you have probably come across this joke before. ...
Eurovision Song Contest: Regression analysis highlights the voting patterns
Although the first Eurovision Song Contest (ESC) took place in 1956, one could argue that its modern era – in terms of both musical arrangements and spectacle – arrived with ABBA’s victory in Brighton in 1974. The following ESC in Sweden, 1975, was the first one to...
Add a profile to a workflow state in Execview
This is a quick tip I discovered while creating a workflow in Execview. In your workflow state, you might want to add a profile to the respective form which will consequently allow you to add more information. The image below shows a workflow for a project. Each stage...
Base Point Business Centre
377-399 London Rd
Camberley
GU15 3HL
+44 (0)2036 379155
info@datalytyx.com