Custom report for Open Cart or Magento

For professional & serious Open Cart or Magento freelancers. I am planning to have an online store to gather all my vendors with their products in one place. However, in order to have a good reporting system for future analysis, I want a custom report. The custom report must be displayed in a single page and can be exported to Excel format. It must have a filter function to display report for each vendors separately. The time frame of the report will be daily, weekly, and monthly. Below is the data (as for now) that I want the report page to display: 1. Number of transaction 2. Number of successful transaction 3. Number of cancelled transaction 4. Number of failed transaction 5. Number of product sold by category 6. Number of subscription 7. Number of purchase via web 8. Number of purchase via Android app 9. Number of purchase via iOS app 10. Value of purchase via web 11. Value of purchase via Android app 12. Value of purchase via iOS app 13. Total revenue / sales from method of payment 1 14. Total revenue / sales from method of payment 2 15. Total revenue / sales from method of payment 3 16. Total revenue / sales from method of payment 4 17. Total revenue / sales 18. Number of registered 19. Number of web visitor 20. Number of web unique visitor 21. Number of web page view 22. Number of app visitor (by session) 23. Number of app unique visitor (active user) 24. Number of app page view (screen views) 25. Total visitor 26. Total unique visitor 27. Total page view This is the only information that I can provide for now.