176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Data Analysis/ Database Development for FMCG business
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Sun, May 27, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Hourly Rate: Not Sure
  • Hrs/wk: Not Sure | Duration: 3-4 weeks
  • Work View™ Payment Protection
  • W9 Not Required
Sign in to view client's details

FMCG business seeks to analyse sales data from online Point of Sale system:

- the data is available for each day for the last year in .csv format
- it is complete but not set up very well for easy integration into Access . However could easily write VBA to re-format data in Excel before putting it into Access
- Probably too many entries for an Excel database (between 250 and 800 transactions per day, each with separate line items)
- Data would be updated COB daily (although, live updates would be better....see below)

The objective is to identify useful patterns and correlations in data to

a) improve inventory management (be able to respond quickly when stocks are low)
b) generate accurate sales predictions
c) analyse staff performance
d) identify good/bad selling products
e) identify causal factors affecting sales that are not being noticed.

Re updating the data. The easiest approach would be that the database is updated at the end of every day. But, it would be great if the ...

Sign in or Register to see more

Job ID: 30809332
Proposals
Hourly Rate: Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Australia  |  
Independent IT Consultant providing Solutions to small and medium business.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31128418  |  Submitted: Jun 10, 2012 07:37 ET 
Proposal SEALED

 Poland  |  
I'm an experienced Excel VBA developer as well as a business consultant. I create advanced Excel based tools for SMEs and large corporations. I...
10
  |  
 5.0   |  Private   |  61 Jobs
Bid ID: 31073084  |  Submitted: Jun 7, 2012 10:14 ET 
Proposal SEALED

 Australia  |  
I'm a Microsoft Certified IT Professional for Development & Administration, I'm also a Registered Member of Microsoft Partner Network. have over 10...
1
  |  
 0.0   |  Private   |  0 Jobs   |  1 verified credential(s)
Bid ID: 30977119  |  Submitted: Jun 3, 2012 23:12 ET 
Proposal SEALED

 Australia  |  
I do work on projects with wide range of technologies. If I bid on your project, it means I am on board with your ideas, and thus will put passion...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 30929592  |  Submitted: Jun 1, 2012 03:58 ET 
Proposal SEALED

 Pakistan  |  
I would like to introduce me as.Net/SharePoint/Office 365 - Developer/Architect. I have a very strong academic background in computer science...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30887675  |  Submitted: May 30, 2012 12:42 ET 
Proposal SEALED

 United States  |  
IDS has been developing focused, web based applications since 1994. Our forte is rapid application development. Timelines run days, not weeks or...
7
  |  
 5.0   |  $48,213 Earnings   |  5 Jobs
Bid ID: 30885321  |  Submitted: May 30, 2012 11:02 ET 
Proposal SEALED

Shenzhen XingShang is located in the Futian District E-Commerce Industrial Park in Shenzhen, Guangdong. It currently has 13 engineers that are...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 30876995  |  Submitted: May 30, 2012 04:13 ET 
Proposal SEALED

 India  |  
We are expert programmers and designers in .NET, C#, VB, Android, iOS & Business Intelligence - BI (SSAS , SSIS, SSRS). We are fast,...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 30853810  |  Submitted: May 29, 2012 08:39 ET 
Proposal SEALED

 Thailand  |  
Offering more than 20 years of experience designing, developing, and optimizing MS Access/VBA/SQL Server database applications and MS Office...
4
  |  
 4.7   |  $2,320 Earnings   |  0 Jobs   |  1 verified credential(s)
Bid ID: 30847975  |  Submitted: May 29, 2012 03:28 ET 
Proposal SEALED

 Costa Rica
Professional Data Base and Web Designer with over 21 years experience in creating work automation solutions, consulting and research services. C# ,...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 30836240  |  Submitted: May 28, 2012 13:40 ET 
Proposal SEALED

Mike Van Waas      
Mike Van Waas's identity has been verified.  Learn More
 United States  |  
In-depth expertise in the design and implementation of Office-based applications and associated analytic tools, including desktop, client-server...
7
  |  
 5.0   |  $7,853 Earnings   |  14 Jobs
Bid ID: 30833008  |  Submitted: May 28, 2012 11:08 ET 
Proposal SEALED

Our Team includes experts of Microsoft SharePoint 2013/10/07 Microsoft Office 365 BI(QlikView) Dynamics CRM and ERP Open source ERP specially...
4
  |  
 5.0   |  Private   |  27 Jobs
Bid ID: 30829916  |  Submitted: May 28, 2012 08:23 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »