cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
spardacus Frequent Visitor
Frequent Visitor

Migration of Excel Components to Marketable Web App

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.

 

CHALLENGE:

 

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.

 

Thank you.

1 REPLY 1
Super User
Super User

Re: Migration of Excel Components to Marketable Web App

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 197 members 1,961 guests
Please welcome our newest community members: