Lukket

Data Transformation - horizontal embedded tables into child tables

The attached file is a sample output of a database that needs to be transformed into a normalized table of data. Instead of the source being a table of data with children records, it was given to me with all child records pivoted horizontally. So it is a very wide table of data that must be broken into a narrower table with several related tables. A detailed explanation is provided below, as well as a sample of the transformation that needs to occur (second tab of the sample output).

In order for your proposal to be accepted, I require the following:

1. Timeline

2. Fixed cost

3. Description of the approach to how you will transform the data (i.e. what coding language)

4. Assumptions you are making regarding your approach

More specific project requirements are listed in the Google doc below in detail. I will fund 50% of the escrow upon rewarding the job. The remaining 50% will be released upon my satisfaction of the requirements below being met.

[url removed, login to view]

Færdigheder: Databehandling, Database Administration, Programmering af database, MySQL, Software Arkitektur

Se mere: software project proposal sample, sample proposal job, sample job proposal, horizontal architecture, google docs sharing, google docs cost, escrow fund, embedded coding, google docs mysql, embedded project coding, horizontal timeline, software architecture proposal, embedded coding project, mysql output table, mysql broken database, proposal doc, data transform, normalized database, mysql google doc, edit database output, embedded mysql, output satisfaction, coding embedded project, output data mysql, database google docs

Om arbejdsgiveren:
( 0 bedømmelser ) Nepal

Projekt-ID: #6027577

17 freelancere byder i gennemsnit $460 for dette job

mdakteruzzaman

Hi, I have been working as Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Check my works here h Mere

$333 USD in 7 dage
(25 bedømmelser)
5.0
MuradMurad

Hi, I have lots of experience with databases and can help you in short terms with this project. I checked the spreadsheet for information, but can you share the data which need to be changed so I can work on it and sho Mere

$555 USD in 7 dage
(8 bedømmelser)
4.5
BeautiCG

i can do what u want. i am a database designer and sql expert. i have many developing experience of various database projects during five years. thanks.

$526 USD in 5 dage
(3 bedømmelser)
3.5
efiguerc

Hi there! Listen, I have already done the program, just missing the SQL part, thats why I can have it ready in 1 day. I downloaded a csv version of the sheet you have in google documents and I worked with it. Fo Mere

$498 USD på 1 dag
(1 bedømmelse)
1.6
deb4t1

Hi, I am a database programmer and work with php and mysql. I found this project interesting and am researching it. What is not clear are the exact relationship between a property detail and the cell number (example A Mere

$275 USD in 10 dage
(1 bedømmelse)
1.4
jyotirmoy86

A proposal has not yet been provided

$555 USD in 10 dage
(0 bedømmelser)
0.0
vw6320803vw

A proposal has not yet been provided

$333 USD in 10 dage
(0 bedømmelser)
0.0
RyanSmithHE1

Hi, I do this for a living :) To be sure, here is an app I quickly made that uses your data from the link to normalize - of course it needs more testing and features, it was just a proof-of-concept and hopefully sho Mere

$291 USD in 10 dage
(0 bedømmelser)
0.0
ceinj

I currently extract non-normalized data from car dealers' DMS systems on a weekly basis and update a MySQL database. The major difference here is that I must assume that each new input file is a different format and I Mere

$833 USD in 10 dage
(0 bedømmelser)
0.0
microline53

Hi, Greetings for the day, we have gone through the data provided by you and would like o bid on this project , Time line will be 15 Days , Fixed cost is 555 USD , Approach , will try to create a macro in Ex Mere

$555 USD in 15 dage
(0 bedømmelser)
0.0
sapphpulgarinas

A proposal has not yet been provided

$555 USD in 10 dage
(0 bedømmelser)
0.0
rahulgupta555

Dear Sir : I was excited when I saw your job postings online for data entry person. I have three years of data entry experience, and I have performed all of the duties listed in your job description. I type 42 wpm w Mere

$388 USD in 10 dage
(0 bedømmelser)
0.0
mickeyboy16

Hello, I found your job advert and I like to apply for the job. I have professional experience in excel/table computing. I have worked for various organizations like provision stores, pharmacies, government organizati Mere

$555 USD in 3 dage
(0 bedømmelser)
0.0
shalala83eu

Hello sir. I have an expirience in data transformation, I can solve this task in Python language, and I'd like to work with you. Regards, Alexander

$277 USD in 4 dage
(0 bedømmelser)
0.0
cederlie

I am a Technologist, with emphasis in Databases. I have experience as an Architect, Administrator, and Developer. Therefore, I have the knowledge to build and support Enterprise Database Systems from the ground up. I h Mere

$750 USD in 14 dage
(0 bedømmelser)
0.0
ambreendabeer

I am here to deliver beyond your expectations. I am an experienced of Data Entry and Data Processing and so my other services that will provide useful benefits to your project. I have a distinguished career as a Copy T Mere

$283 USD in 10 dage
(0 bedømmelser)
0.0
haovo

I have read your requirement in spreadsheet shared and I believed that I can build this application for you in 1 day. I will C# to build this application and accept many type of excel file such as csv, xls, xlsx. feel Mere

$250 USD in 3 dage
(0 bedømmelser)
0.0