What we need is basically an integration of data flow into Power Bi for an automated process of data updates for visualization purposes.
We have 3 different sources of data coming in;
- Xero (open API),
- **** (closed API, we have the documentation on hand but can't share at the moment)
- **** (FTP server, CSV drops).
Basically we want the data from all 3 different sources to be cleaned and then fed into Power Bi so i can build dashboards.
NOTES:
- Preferably a Microsoft technology stack since we are using Power Bi.
- We need a 6 hour refresh rate on the data.
- Total monthly data is less than 20,000 rows across all 3 sources so this trinkles down to less than 200 rows per refresh so performance is not an issue.
About the recuiterMember since Mar 14, 2020 Deepak Shakya
from Ontario, Canada