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:
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]