So my company is using a Microsoft NAV erp (sql based system). I am responsible for carrying out analysis; mainly in excel.
I currently use power pivot models and DAX queries to aggregate and explore my data further.
However I would like my models to link automatically to the table data in sql so that my models update automatically when the sql database is updated.
My questions are as follows?
How do I link a NAV table to powerpivot
Do I have to load all the tables from sql into powerpivot or can I create a connections?
How do I link the models to the sql tables so that the update automatically? I've heard something about using Sharepoint
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.