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 Nov 11, 2022 Niranjan Panda
from Az Zawiyah, Libya