CREATE A DATABASE USING PHP AND MYSQL, CREATE REPORTS AND CHARTS

Job Description Build a database that supports up to 30 individual companies (OPERATORS) providing data points on a daily and monthly basis. This is a non-public database for our internal use. Build a plain functional UI (our internal IT department will customise for our purpose) 1/ sorting of data points 2/ displaying data points in a daily format (individual, and aggregated OPERATOR data) 3/ display data points in a monthly format (individual, and aggregated OPERATOR data) 4/ sort and display comparisons in either daily, monthly, yearly format Data Acquisition / Database A/ daily stream of data points either in a csv or Excel spreadsheet. B/ once a month, on the second day of the month, the OPERATOR sends a monthly wrap up for their account to the special purpose email account. Interface Create an interface that can select difference values in the database for display. A/ each company needs to be displayed singularly 1/ OPERATOR data to be displayed in daily increments for all data points 2/ OPERATOR data to be displayed as monthly totals in one line for all data points 3/ OPERATOR data to be displayed in yearly totals in one line for all data points B/ ability to display company data by select data points for company comparisons CHARTING Create charting of OPERATORS A/ FUNNEL CHARTS B/ PIE CHARTING C/ LINE CHARTING SAMPLE SPREAD SHEETS 1/ DAILY OPERATOR RAW DATA SAMPLE 2/ END OF MONTH OPERATOR RAW DATA SAMPLE 3/ OPERATOR ROLLING REPORT SAMPLE WITH FORMULAS PAYMENT SET ON AGREED BENCHMARKS