Database implementation for software sales analysis

Completed Posted Sep 27, 2006 Paid on delivery
Completed Paid on delivery

Our company conducts research and analysis on the video games industry. Every month, we receive datasets in a defined Excel format that contain monthly sales figures for each title and available platform, including both units and dollar amounts. We have used an Excel PivotTable to manage this data, but the dataset has finally exceeded what can be directly managed in an Excel worksheet. We wish to convert to an Access-based database system. There are X mandatory features of this new system: 1. Automated data importing. The system must be able to take an Excel file, in a predefined format, and import the dataset with a minimum amount of manual involvement. There are challenges with the data each month, as new software titles are release each month and titles sometimes have minor spelling changes from one month to the next. 2. Software title management. For every software title in the database, we need to be able to 'tag' those titles with additional metadata (publisher, developer, game rating, etc.) The management of this information will require one or more forms to make it easier to maintain. 3. Publisher and developer management. Every software title should be associated with a software publisher and a software developer, each of which has a different set of metadata. 4. PivotTable export. We do a large amount of slice-and-dice analysis on the dataset, such as calculating sales totals for a particular title or publisher or developer. The data contained in the Access file must be structured in such a way that it can be used as a datasource for Excel PivotTable analysis. Additional details will be documented after selection of a coder, on in response to questions during the bidding process.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

* * *This broadcast message was sent to all bidders on Monday Oct 2, 2006 9:29:30 AM:

This is a quick update to all current bidders on our Excel/Access project. We're currently reviewing all of the various bids and will be making a decision within the next 2 days (by end-of-business Tuesday, October 3). Thank you all for your patience.

## Platform

Microsoft Access database with forms and/or reports as necessary

Engineering Microsoft Access MySQL PHP Software Architecture Software Testing

Project ID: #3824373

About the project

20 proposals Remote project Active Oct 5, 2006

Awarded to:

rbyteme

See private message.

$212.5 USD in 14 days
(67 Reviews)
5.9

20 freelancers are bidding on average $293 for this job

dominique1

See private message.

$153 USD in 14 days
(420 Reviews)
6.4
DeanMan

See private message.

$85 USD in 14 days
(68 Reviews)
5.2
Charu0306

See private message.

$629 USD in 14 days
(35 Reviews)
4.8
vw2244935vw

See private message.

$85 USD in 14 days
(39 Reviews)
4.5
emergingcoder1

See private message.

$127.5 USD in 14 days
(53 Reviews)
4.5
smc1

See private message.

$85 USD in 14 days
(14 Reviews)
3.6
itservbr

See private message.

$136 USD in 14 days
(4 Reviews)
2.8
astony

See private message.

$102 USD in 14 days
(19 Reviews)
2.5
pradeep211

See private message.

$127.5 USD in 14 days
(1 Review)
2.4
lakshmaiahv

See private message.

$85 USD in 14 days
(1 Review)
1.3
susanta

See private message.

$467.5 USD in 14 days
(6 Reviews)
0.0
gbalajii

See private message.

$102 USD in 14 days
(1 Review)
0.0
drmikewebb

See private message.

$2550 USD in 14 days
(0 Reviews)
0.0
jhcomp

See private message.

$85.85 USD in 14 days
(0 Reviews)
0.0
sumitkrbiswas

See private message.

$157 USD in 14 days
(1 Review)
0.0
gourabchatterjee

See private message.

$85 USD in 14 days
(0 Reviews)
0.0
lowfreq

See private message.

$425 USD in 14 days
(0 Reviews)
0.0
G4Genius

See private message.

$85 USD in 14 days
(0 Reviews)
0.0
blackrainsl

See private message.

$85 USD in 14 days
(0 Reviews)
0.0