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
15 freelancers are bidding on average €633 for this job
Hello, we have very rich experience in .NET Framework based development. We can develop this for you using VS 2012 and ASP.NET MVC 4. Please, check PM for more details. Thank you.
Seems to be an intersting work and good opportunity to show my MVC skill to work with you in future as well, Hope to have long term work relation with you.
Hi, my team has many expert programmers on .NET framework, C++, Sql Server 2005/2008. I sure, we can do your job on time with high quality. Please view my message for detail. Thanks!
Dear Sir, Kindly Check PMB, For further discussion of your Project In Details... Many Thanks, Nikhil Pawar Webwing Technologies PVT Limited Business Development Executive