In Progress

Dashboard of PHP reporting (DB2 to PHP)

Skills that may be needed: DB2, PHP, SQL, AJAX, JAVASCRIPT

We have several reports similar to this so the winner will be considered for several future projects if this project is successful. We have an internal IT department who will support this long term but the initial development can take months at times due to large amount of work they are required to do so this is a test to see what the a few things; Can it be done using a freelancer, Will it meet our standards (design, look, and usability), what is the savings we can experience. Please keep this in mind when bidding for this project.

We have several reports (such as this) that we use SQL to write queries off our mainframe DB2 environment. Once we get the report ready we need to publish it so the field can use it and be able to get large amounts of data to them that are easy to understand and get to details.

This report is called Onsite Repairs (required to have final complete within one week of award)

The report tells us how much money is spent monthly by account within about 5 categories. It can help us show if an account is improving or not. It can show us one region vs. another region. It can show us one job vs. another job.

• The header logo files are attached

• The DB2 table name of the raw data that will be pulled in is PIDCW01.ONSITE_REPAIRS_13_MTH

o The example and structure of this table can be viewed in the excel spreadsheet (SQL Query Tab)

o We can provide the structure format (text, decimal, or date) if needed

• The general sample layout gives you a highlevel look and feel expectations

o All data / details must be able to export to excel

o All headers should be able to click and it sort A-Z or Highest to lowest.

• The example tab gives you just another example of the layout for this specific report.

o We want to be able to look at it several different ways; Region, Month, Fleet code, Account Name, Job Description.

• The layout for what it displays with the different view is slightly different. (See view details tab)

o Yes, the user can combine a combined selection Region: MW, Month: January, Job: Wipers

Additional Requirements: Long term it will live on our server so all files will be required and we will support it after the completed reporting dashboard is complete. We are open to hearing better ways of displaying the information. We encourage those who work with us to be thinking outside the box.

*We are looking long-term at many more projects; please place competitive bids for continued work. I can say that if this cost more than in-house our company will not allow further projects.

Skills: AJAX, Javascript, MySQL, PHP

See more: dashboard php, php reporting dashboard, dashboard report php, project dashboard php, php report dashboard, report php db2, php ajax report dashboard, javascript dashboard php, dashboard reporting php, javascript dashboard, yes o logo, work how freelancer php, who to write report, when to use freelancer, what to write on freelancer, what to do in freelancer, what to do freelancer, what to do as a freelancer, what month is january, what is the work of a freelancer, what is php freelancer, what is data structure, what experience should a freelancer have, what do you need to work as a freelancer in development work, ways to be freelancer

About the Employer:
( 13 reviews ) Springdale, United States

Project ID: #1508381

Awarded to:


Hi ready to start Thanks

$80 USD in 6 days
(138 Reviews)

5 freelancers are bidding on average $206 for this job


Check PMB please.

$250 USD in 1 day
(0 Reviews)

I am interested to work with you. check pm.

$400 USD in 15 days
(0 Reviews)

We have enough experience in maintenance and support and one of our engineers will surely study your case and provide a solution within 3 working days.

$100 USD in 3 days
(0 Reviews)

********expert for php **********

$200 USD in 10 days
(0 Reviews)