Data analysis using Talend Data Prep
In this dataset we will be analyzing Chicago Data Crime.
After importing the sample data in the tool , this is how it looks like
Some analysis on the file, extracted from the statistics that Data prep offers.
With one click on each column we will answer a real analysis question.
What are the most dangerous streets in Chicago ?
By clicking on the block volumn which represent the Address , we will get the following image on the bottom right :
We can clearly identify the most dangerous Street in Chicago with only one click. Great.
What are the most frequent Crimes ?
Just one click on the Crime type will give us the picture below
Which community area has high level of Crimes reported ?
This new type of data preparation solution must be based on an Excel-type shared interface and must offer a broad spectrum of data qualityfunctions. In addition, it must offer viewing and, it goes without saying, transformation functions, easier to use than Excel macros and specialized for the most commonly used domains in order to ensure appropriation by the business user.