data analysis/comparison from 2 excel files generated with similar data from 2 different dates
Budget: $10 – $30 USD
I get an excel file (approx. 80000 rows) everyday with current date, I need a program or a tool which can analyze this data over time (compare data in excel to previous days excel). I want to track how item prices and item quantities are changing over time. Excel files will have columns or price/quantity etc.
From those approx 80000 rows i only need approx 8000 rows compared/analyzed and will provide text criteria from 1 column to filter data
You can use python/java/tableau/qlikview/power bi or any other tool, I do not have any preference but I should be able to run on my own to analyze/compare data in future. Input will be 2 excel files and output dashboard will compare all values in both files and should be able to sort
Attached sample excel files. In past i had exactly similar power bi work done by another freelancer for similar data and will provide that after project is awarded
Thanks
From those approx 80000 rows i only need approx 8000 rows compared/analyzed and will provide text criteria from 1 column to filter data
You can use python/java/tableau/qlikview/power bi or any other tool, I do not have any preference but I should be able to run on my own to analyze/compare data in future. Input will be 2 excel files and output dashboard will compare all values in both files and should be able to sort
Attached sample excel files. In past i had exactly similar power bi work done by another freelancer for similar data and will provide that after project is awarded
Thanks