Closed

Report .net sql mvc application

This project received 16 bids from talented freelancers with an average bid price of €631 EUR.

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

Application must be developed using Visual Studio .net 4.0 or 4.5 (best) using MVC4,razor syntax, EF 4.2 or 5 and as backend could use SQL Server

there is a database with a fact table, that have a DATETIME field and some others up to 20 fields of data, some of this fields are Id's to other tables (Dimensions)

The fact table is huge with more than 20 million of records so if you think is better to include some triggers or jobs in the backend to create some views/cubes/tables/etc under your consideration

You should be able to filter by a range of DATE "and/or" TIME (i mean also inside a DATE range select a TIME range), also you should be able to filter by a dimension variable also you should be able to select records only by a dimension value change ordered BY DATETIME; did it one or a mix of the conditions mentioned before you can AVG, min, MAX of the other dimensions for the report.

All this can be done using LINK or SQL with DATATABLE under your convenience, we don't need to create a frontend for all the posibilites that can be done for filtering the frontend is only for the results.

The frontend consist in some examples of the results of the previous work:

1 report with datatables or simple HTML5 of the results of the previous possibilities, cvs and pdf export
1 chart (google charts or rgraph) for a result of previous.
1 report where we can:
expand/contract DATE AND TIME values to have dimensions value AVG or MAX/MIN as a result of the previous

The reports shoud get data using jquery ajax load method webapi or .svc

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