Question: I am looking for a data integration tools to do some schools data analytics. One of the role I expect the tool to do is

I am looking for a data integration tools to do some schools data analytics. One of the role I expect the tool to do is to do data transformation, mapping, calculate data quality, data missing, clean data, having different rules of transformation by state, deleting duplicate data ad leave one of the duplicate data, doing some dashboard reports, calculate outlier, convert the data into CSV file, allowing dropping down to allow analytics into school, county, state. All states provide the data in different format. The data has 65 columns and 4000 rows. Now, you will have to develop an interface that would run these data through automation, run selected transformations in the backend and provide users an output with 64 standard fields. No coding is need in the tools to do the automation. The tool should also be free. Kindly explain each of the tools below including advantage and disadvantage. Also evaluate each of those tools in terms the goal of the project.

1. Custom Tool development evaluation

2. Trifacta

3. Alteryx

4. Funnel

5. Hevo

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!