Hi all,

I'm looking for some guidance on a path forward for us to use all this data we're pushing in to Sage. 

Long story short, we run a contract manufacturing operation and we'd like some dashboards to use on the floor for production scheduling, some financial data such as how much we're making per job that management would like to see, etc.

Right now, we have a pretty primitive, manual process for extracting data, too many Excel spreadsheets, etc. I'd like to try to spearhead an initiative for some useful dashboards that will increase our visibility on a number of things.

As of today, here's our setup for shop floor operations:

• Sage 100 Advanced - we've considered Sage 100 Premium for the SQL back end
• Scanforce Manufacturing (new to us- previously used Scanco's solution)
• Production Management (new to us- previously used Operations Management)
• MRP (new to us after moving off IRP)
• DSD Multi-bin

We're really wanting to get a lot of this data in to Power BI as we have some experience with it already and have access to cheap licensing for it.

With that in mind:

• Is a move to Premium for the SQL back end most ideal for this?
• If it's only marginally better, could we achieve all of this by staying on Advanced, albeit with tradeoffs?

Ultimately looking for opinions on if we want to move our back end infrastructure to SQL for this and welcome any articles or content that can help in making a decision. Thank you all.