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
Skills Required
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