My Client runs a Saas based portal and uses freshbooks for all accounting needs. For some of the reports like Churn, the reports available in Freshbooks do not work well and we are looking at creating a Report Dashboard on a separate URL where we will pull data from Freshbooks using the api from Freshbooks, run some updates on data as per our needs and chart in the Reports Dashboard. To start with there will be only a single report, but later we would like to enhance the system with more reports.
We want to work with Microsoft stack i.e. sql server as the database to import the Freshbooks data.
I would like to know what dashboard solution you would propose, the cost of setting this up, integrating with Freshbooks and charting one report (Churn report i.e. how many clients we lost this month) with some minor tweaks that can be carried out by a simple stored procedure in Sql server. I am open to hosting it in cloud (AWS / Azure) and need to know cost for the same, even though we would be paying for hosting ourselves.
Please do not quote without understanding details above and ask questions if needed before submitting your quote. Please provide links / document/ information if you have done such work before, and propose how you would go about it.