Hello - I am creating a reporting/BI portal for my restaurants using Dundas BI. I have an Azure VM where I want to host the data. The new data polls every morning to an SFTP site that we would have to extract to whatever database we create. The main features will be:
- creating data cubes
- 10 - 15 dashboards: sales, ops, financials, top/bottom 5 KPI
- Multiple reports: capturing data from multiple sites and data mashing
- mobile/tablet accessible: HTML 5
- data in the cloud using Azure VM
The data polls in the format attached. Please let me know if you have any questions. This project would require ongoing development as we add/adjust features.
Make sure you answer the following questions:
What experience do you have with the Dundas BI Platform?
What experience do you have with ETL?