Closed

Web-based Data Count Tool and Data Warehousing System - repost

This project received 11 bids from talented freelancers with an average bid price of £564 GBP.

Get free quotes for a project like this
Employer working
Project Budget
N/A
Total Bids
11
Project Description

Maximum budget for this project is £[url removed, login to view]

We are looking for a freelancer to start this urgently.

Data Count Tool and Data Warehousing

Project Details:

Database:

? Schema should be able to store customer’s profile

? Questions and answers from surveys. This table should be scalable and can be group in query by respondent, answer, postcodes, etc…

? Must have lookup tables for postcodes, type of answers, type of questions, etc… for scalability

? No redundant data to be stored, relationships must be properly set

? Use foreign keys and triggers for referential integrity

? Engine must by InnoDB since it will be a MySql Database

? This database will be getting its data from a live survey database

UI:

Web-based UI with login page.

? Roles and Authentication must be implemented

? Admin users will be taken to Admin Home page

? Admin can view or print data counts for answers and questions

? Group these data counts by client, answers, questions, etc…

? Clients go directly to the client’s home page

? Should be written in PHP using CakePHP or Zend Framework

? Feature to allow Admins and Clients to create their own report forms

? Clients also can view or print report of data counts but only for their data

Operations Reports

Brief project information

? Dashboard

o This shows overview data of all operations reports

? Revenue Reports

o Daily Revenues

o Revenue Forecast

? Daily Deliveries

? Detailed Survey Report

? Survey Questions Statistics per agent

? Survey Dispositions Statistics

? Detailed Disqualified Survey Report

? Employee attendance Report

? Employees Active Directory

? Output Tally

? Reporting Update Tracker

? Pay-out table for the questions

? VOIP Usage Charges

These reports will get its data from the local survey database .

Time Frame:

? Three (3) to Four (4) days

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online