Migration of Excel Components to Marketable Web App:
I REALLY need help to navigate a path forward relative to Web App Development and Dashboard reporting.
I have built a successful EXCEL-BASED business management system that connects several functional files for ingesting daily store revenue and operating expense data to feed an Excel "Power" Dashboard for the client’s Senior Leadership Team to monitor vital KPI across the business.
I would like to convert this Excel Desktop collection of connected files to a Web Environment that would facilitate data entry and outbound reporting dashboards in order to sell these business management functions to other similar businesses.
Researching an online or cloud based solutionled me to consider Access 2013 as a path to convert my Excel system to a Web-based Application. However, I am learning that the Access 2013 Web App does not really deliver visual reporting, and the Graphic Dashboards are very popular with the management teams.
What interactive dashboard alternatives work to add graphic-based reporting to an Access 2013 Web App? How can I migrate from an Excel Desktop / OneDrive Sharing system to a web-based environment that would protect system integrity while capturing data entry and delivering reporting dashboards?
Do I host the Excel modules or the "Excel for Web" elements in my Office 365 SharePoint Sites to connect to PowerBI? Can I and should I look at somehow connecting a PowerBI interface to the Access Web App module after converting the Excel componenets into Access 2013 Web Apps? Or, does this sound more like a Custom Visual Basic programming project, which I would have to outsource as I am NOT a programmer?
I need to clearly understand the proper MS Product Roadmap that will take me from a one-off desktop Excel application to a marketable Web-Based solution that will allow me to sell user accounts for additional client businesses.
One route to go would be to build out your data entry bits in a SharePoint Online list. You could then consume that via Power Query into your Excel spreadsheet, which you would have loaded into Power BI. You could build reports and dashboards off of that. You could then package it all up as a Content Pack and make it available to people that buy your service. Lots of details to hash out but one idea.