VBA to Excel Services - Business Intelligence in Sharepoint

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.

Skills: .NET, Data Entry, Excel, Sharepoint, SQL

See more: excel xls, excel vba sharepoint web form, vba excel services sharepoint, sharepoint excel services vba, works need excel, Works in spanish, where to get data entry job, what is system ui, what is mdb file, what is job portal system, what is data structure in c, what is data in data structure, what is an mdb file, what is a mdb file, what is a data structure in c, what is a data entry form in a database, what are data entry forms, we need spanish data entry, vba with, vba load, uses of data structure, ui status, to get a job in spanish, system one services, sharepoint job

About the Employer:
( 0 reviews ) Santiago, Chile

Project ID: #1107301

21 freelancers are bidding on average $870 for this job


100% client satisfaction, we are top sharepoint team here.

$7200 USD in 35 days
(51 Reviews)

We are eager to develop this project. We have a lot of experience in this [login to view URL] more details please check pmb.

$700 USD in 30 days
(20 Reviews)

Please check your PM.

$250 USD in 2 days
(17 Reviews)

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.

$600 USD in 20 days
(4 Reviews)

Porfavor lea el mensaje privado

$500 USD in 15 days
(3 Reviews)

Please check PM, Thanks

$500 USD in 30 days
(2 Reviews)

bidding on behalf of ossak infotech

$500 USD in 15 days
(0 Reviews)

Sir, I am understandof this project. My skill for his work is so high. I have some experiaence to this work. The quality of my work is ery high.

$500 USD in 5 days
(0 Reviews)

Please check PMB for more details about project.

$750 USD in 10 days
(0 Reviews)

Please see Private Message

$1200 USD in 15 days
(0 Reviews)

Hi, We are working on Cognos BI tool and we can provide you solution but we require more information before starting the project and i sent request to you on skype so we share information.. Thanks & Regards, Atu More

$300 USD in 20 days
(0 Reviews)

Proficient .NET ( C#,VB.NET ), SQL Server-2005, SharePoint Developer, Web Services, InfoPath eager to contribute technical expertise and development skills towards actively supporting the employer in optimizing perform More

$725 USD in 20 days
(0 Reviews)

Hola, Tengo mucha experiencia en procesos ETL y de inteligencia de negocios

$600 USD in 21 days
(0 Reviews)

Work with development sharepoint, lotus notes, portal 3 years, very familiar in working with vba macro.

$1100 USD in 15 days
(0 Reviews)

Hi, I'm very much familiar with SSIS SSAS SSRS and also during last two years I involved many project in ETL, data warehousing, BI reporting and 3 years of application development experience. I would highly appreci More

$300 USD in 5 days
(1 Review)

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

$500 USD in 15 days
(0 Reviews)

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.

$350 USD in 10 days
(0 Reviews)

My extensive financial experience in the Microsoft suite of products such as Excel, Access, Outlook, PowerPoint and Word in front ends GUI, back-end VBA code and SQL calls, and work-flow Client-Server connectivity is u More

$444 USD in 7 days
(0 Reviews)

.net/php experienced

$500 USD in 5 days
(0 Reviews)

Dear SiR, I'm interested to your job. Can I do this job from my Ubuntu(linux based OS), sir? hope you understand me.

$250 USD in 30 days
(0 Reviews)