Closed

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

qitsol

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

$7200 USD in 35 days
(51 Reviews)
6.0
PrasadSolutions

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

$700 USD in 30 days
(20 Reviews)
5.8
Rahul2012

Please check your PM.

$250 USD in 2 days
(17 Reviews)
5.2
profisoftit

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)
4.7
Hmontes

Porfavor lea el mensaje privado

$500 USD in 15 days
(3 Reviews)
4.2
yogeshmalathi

Please check PM, Thanks

$500 USD in 30 days
(2 Reviews)
1.8
persushil

bidding on behalf of ossak infotech

$500 USD in 15 days
(0 Reviews)
0.0
Akash003

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)
0.0
darianmartin

Please check PMB for more details about project.

$750 USD in 10 days
(0 Reviews)
0.0
dazmond

Please see Private Message

$1200 USD in 15 days
(0 Reviews)
0.0
atulkm651984

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)
0.0
kamrul11

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)
0.0
alexcarbor

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

$600 USD in 21 days
(0 Reviews)
0.0
plsilvapereira

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

$1100 USD in 15 days
(0 Reviews)
0.0
jineshm

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)
0.0
skizziks

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)
0.0
AhmedEj

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)
0.0
henrybarlatier

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)
0.0
tech2yash

.net/php experienced

$500 USD in 5 days
(0 Reviews)
0.0
sabbir2world

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)
0.0