Report .net sql mvc application

IN PROGRESS
Bids
16
Avg Bid (EUR)
631
Project Budget (EUR)
€250 - €750

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

Skills required:
.NET, C# Programming, Javascript, MVC, SQL
Hire jlsfernandez
Project posted by:
jlsfernandez Spain
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


€ 800
in 7 days
€ 750
in 30 days
€ 500
in 12 days
€ 600
in 15 days
€ 450
in 12 days
€ 700
in 10 days
€ 700
in 30 days
€ 600
in 7 days
€ 700
in 30 days
€ 350
in 5 days