Data Quality: Validating Data using Pattern Match Analysis
The introduction to Data Quality Profiling (part one of the Data Quality series) focused on data discovery by means of performing statistical data analysis. This blog - part two in the series - aims to perform pattern match analysis and validations using Talend Studio...
How to Split a File Based on a Date Value Using Talend – Part 2
In part 1, we looked at a simple example of how we can split a file into several smaller files based on the value of a date for a given field. In this part 2, we are going to expand on those ideas and improve the solution. Scenario So, unlike Part 1 where we had a...
Overview of Talend Metadata Bridge
What is Talend Metadata Bridge? As the name suggests, Talend Metadata Bridge is an add-on in 5.6.1 that will be a built-in as a full feature in 6.0.0 Enterprise or Platform products of Talend Studio. It allows the import of data from multiple data modelling tools...
How to Split a File Based on a Date Value Using Talend – Part 1
The following article is based on true events; only the client, data set and solution have been altered; all other details remain exactly the same. Scenario My client has a 16GB csv file that his team want to analyse. The problem is that their only analysis tool is...
How to Unlock your Data’s Value with Tableau
In my experience, I'm finding more and more often that customers are not leveraging the massive amount of data they have available to them. Let’s use the example of a department store chain: they want to generate a promotion that is bespoke to each individual store....
Automated Document Capture & Workflow for Accounts Payable
Automated Document Capture & Workflow Solution This article will showcase one of the many ways our digital transformation service can help reduce costs, boost efficiency and improve the governance. Research conducted by Gartner & IBM shows that 82% of CIOs...
Automating Salesforce routine tasks with Talend Open Studio
Scenario One of the great features of Talend is its vast quantity of different components. No other ETL (Extract, Transform and Load) tool gets close to Talend in this regard. In this blog post, we are going to take a look at how we can automate sales price updates in...
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...
Base Point Business Centre
377-399 London Rd
Camberley
GU15 3HL
+44 (0)2036 379155
info@datalytyx.com