I have an existing Codeigniter/Fusion Charts based website which displays charts of sales performance data to users. The users review the charts and use this and other data to prepare sales improvement plans. The charts are in two broad categories: Sales Charts and AMG Charts, each served by its own data base
Data Base Updates: There are five data fields with incomplete or inaccurate data for each of the two data bases. These data fields hold 3-digit numerical information in the form, for example, 25.5 or 0.22. The data fields hold actual year on year growth rates for the same period in the previous year for month, quarter and year. In other words Quarter 2 2016 would be compared with Quarter 2 2015. The data fields hold benchmark growth rates for quarter and year for the same period.
The task is to:
a. Run MySQL queries provided by the client and, using data supplied by the client, fill the empty data fields with correct data.
This is a task for a freelancer or small team with MySQL knowledge who can:
Identify the missing or incorrect data in the database for all countries, years, quarters and months in both data sets
Run MySql update queries for each country in each data set for each month, quarter and year so that all of the five fields are populated with the correct data. The correct values for each month, quarter and year will be provided by the client
To test a sample of each country and data set to ensure that the data has been uploaded and is correct
The project has a guideline budget not exceeding $75 - $100