You have chosen to sponsor your bid up to a maximum amount of .
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