We are a Spanish outsourcing enterprise that currently works with many companies that sell products in the Retail industry, in a few words we manage their sales force. Each Retail has a B2B portal where we can get a file containing all the sales/stock of the company in each point of sale. The sales file comes in different formats (txt,csv or xls) and have a different structure.
To create reports we use a VBA Macros in Excel that loads and transform this file so that all the information is consolidated in one Database (currently in an mdb file). We also have an Access form where users load new SKU to the DataBase when new products are detected by the VBA Tool.
Once we have all this data in one place (an ETL process), we can create reports. We use PowerPivot to create the Dashboards and visualize them in SharePoint.
What do we want?
We need this VBA tool to be on the Web. So it can transform and load the sales file in the SharePoint server. An UI that receives a file as an input and transform the structure so it can be loaded correctly to the database (we think that excel services should do the job).
The SharePoint tool must detect new products in this sales file and with a form manually assign the correct SKU to the code that the company uses.
Additionally to that, Sales people should use forms to add data like Price, Stock in system, Exhibition status, etc…
The first image shows a general idea of the project and the second one the reports that we want, which we are currently obtaining with the VBA Tool and PowerPivot.
21 freelancers are bidding on average $870 for this job
I am interested in doing your project. I have also, a great experience with Data Warehousing, BusinessObjects XI and ETL (Informatica Power Center) Please view my PMB.
Gentlemen, we automate business processes. We think you could be better of using Google apps working on their cloud infrastructure. Please see private message for details
Dear, i am interested for providing the simplest solution i-e; ETL (data transformation servces). if you are interested then please contact in this regard. my skype is ahmedej.