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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started