Convert a database into analytics
Budget: $250 – $750 USD
I have a Zoho web-form collecting trading volumes (Sales , Purchases, Stock) and prices (Sales, Purchases) for x24 Shops split across x5 agents Mon-Fri since early November. So far collected c.5,000 lines of data.
The data is downloadable in .csv format from Zoho Forms. I have downloaded a sample file of the same. I want to create an auto-download API to avoid manual.
The data needs to be loaded into a database and split into a relevant table structure.
Once in the right structure, it then needs to be accessed by an analytics tool (trying out Metabase) and a variety of data queries need to be built into the tool that will analyse trading performances of each sku, each shop etc.
The data is downloadable in .csv format from Zoho Forms. I have downloaded a sample file of the same. I want to create an auto-download API to avoid manual.
The data needs to be loaded into a database and split into a relevant table structure.
Once in the right structure, it then needs to be accessed by an analytics tool (trying out Metabase) and a variety of data queries need to be built into the tool that will analyse trading performances of each sku, each shop etc.