Data Base Updates via MySQL Queries


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

Skills: MySQL, PHP

See more: hierarchical data queries mysql, mysql script retrieving data web, mysql import tab data, mysql import large data xml, mysql load large data files, freelancing sites home base data encoding, php mysql insert user data, worker ssl data entry 3000 words, php mysql real estate data, mysql display show data starting letter, write queries mysql, mysql php plot data timeline, google base data feed xml format, mysql dump import data, create mysql table form data, joomla mysql php enter data, mysql import delimited data, simple mysql php show data dropdown, php mysql sort form data

About the Employer:
( 35 reviews ) OXFORD, United Kingdom

Project ID: #13103006

34 freelancers are bidding on average $135 for this job


To run the mysql queries and fill the data into the data fields with correct data. To find the missing data in both datasets. To run update queries to populate the the correct data. To test the correctness of the da More

$89 USD in 2 days
(522 Reviews)

Hello sir, Greetings !! I have 6+ YEARS of experience in Wordpress, Core PHP, Magento,iPhone, Android, Joomla & eCommerce. development. I have reviewed and analyzed your requirement . It would be nice if we h More

$100 USD in 5 days
(477 Reviews)

Hi, I can do your job but need to make a short chat discussion with you. let me know if possible for you. please let me know. You can check my profile and feedbacks of clients which itself I got from them . Hope the More

$277 USD in 7 days
(72 Reviews)

First, I am sunsoftpro, I from VietNam. Nice to meet you! I have read your description and been interested in your project. I'm ready to discuss and do hard working so that complete great job. Please discuss requi More

$220 USD in 3 days
(116 Reviews)

Hello, I have expertise in mysql. I can handle your work. I have read your requirements. Can we have more discussion. I have 5 years of experience in php,mysql,codeigniter,wordpress,payment gateway,API integra More

$80 USD in 2 days
(123 Reviews)

Hi Yes we can Run MySQL queries Coding Standards: We Use all guidelines and ethics of MVC Pattern, follow all rules as needed. Even with Plugin development for any opensource CMS we give a very strong and secure p More

$277 USD in 15 days
(33 Reviews)

on what parameter need to verify that data is correct and update . and what data is incorrect need to update it .

$100 USD in 3 days
(32 Reviews)

Hello, We Believe in Quality and Delivering a Quality Product Thanks for your post on freelancer! Ecove Solutions is a trusted, global provider of digital marketing Services and IT Services; our clients rely us due to More

$111 USD in 3 days
(56 Reviews)

I would like to discuss with you about project scope in details before we confirm budget and other things. Hope you ok with that. Hello, We have reviewed your proposal and We have more then 7+ year of experien More

$155 USD in 3 days
(20 Reviews)

Hi there, I am java developer. I have read the details and it looks very easy for me. I can develop a desktop tool for automating such tasks like identifying incorrect data, inserting data, updating data into databa More

$200 USD in 3 days
(31 Reviews)

Hi, Hope you doing good? I am experienced PHP developer having expertise in e-commerce domain using Zen Cart, Wordpress, Codeigniter, OsCommerce, CreLoaded, MVC framework, Prestashop, Opencart, HTML5, Bootstrap, More

$111 USD in 5 days
(51 Reviews)

Hello Hiring Manager, i will use the client queries to fill the columns in database tables.i will also identify the missing columns data as well. I will also run the update query provided by the data values by the cli More

$100 USD in 3 days
(71 Reviews)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$100 USD in 3 days
(26 Reviews)

Hello I have specialized programmers for various php frame works. So we are comfortably accommodating wide range of programming systems. With our 6 year experience, we understand clients and their Business needs b More

$116 USD in 5 days
(47 Reviews)

Hi, Your job posting has caught my attention and I am keenly considering your job post. I have excellent experience in Mentioned skills. *******NO UPFRONT REQUIRED ,PAY ME WHEN YOU SATISFY WITH MY WORK********** More

$133 USD in 3 days
(12 Reviews)

Hello, I have 4+year of experience in MySql and codeigniter so, i can do this job. I read project description and i am ready to start this work as soon as. Please share more information with me. Looking fo More

$83 USD in 3 days
(15 Reviews)

Hi,Can i talk to you..? i have checked your requirements regarding data Base Updates via MySQL Queries I'm ready to do it,because i have 7 + years exp. in Codeigniter with all php frameworks and also expert in Ja More

$100 USD in 2 days
(38 Reviews)

Hello, I'm interested to work on this. I'm good in my sql and can do the job effectively. Thanks,. Sheik

$80 USD in 4 days
(23 Reviews)
$111 USD in 3 days
(43 Reviews)

Hi I am Anu, Having Good experience in Hybrid and Native Mobile Development & website develooment. I Read your Requirement and happy to inform you we are able to fulfill all your Need according to you, so can we discus More

$155 USD in 3 days
(8 Reviews)