I would like for you to create a 3-way forecast model and financials reporting tool that I can manipulate in Power Bi. It is essential that it connects to Xero seamlessly so I can do daily reporting, on a number of clients. I have heard API and ODBC connections are the best.
It is also important that I can have a number of variables that can be changed. eg customer numbers, sales volume, gross profit margin, etc.
If it can be similar to what Spotlight, Futrli and Castaway can do that would be great.