Daily or weekly or biweekly receive file in tab limited format.This needs to be loaded into sql server 2008 table(s).Based on the data, the software should generate line graph .
The data is about stock market.Only one file will be available per day or per week (whatever the period).The dat will have the information about main industry groups.Each main industry will have subindustries.Each main industry will have the stocks related that main industry and each subindustry will have the stock related to the subindustry which will be the subset of main industry stocks.
The developer should be able to work independantly and also should be able to develop and give the complete software without any error as per specification.
So based on the the dat we have to show the main industry line graphs and when the usr drill down(click) the main industry line grpgh, it needs to show the performance of all subindustries for that main industry.Finally when the user click on the subindustry graph it needs to bring the graph of the stocks of sub industry.Also from main industry graph the user should have the capabilty of seeing the performance of all the stocks in the main industry.
First pahse of the project, i want only the main industry and sub industry group performance in line graph.The stock performance will be the second phase.
The developer should have very good knowledge of SSIS,SSAS,SSRS,SQL server 2008 r2,designing tables,SQL strored procedure,,line graph ,bar graph using ssrs.Knowledge of drill down.
the software should have the ability to chart for given date range(one day, one week,10 days...etc)
The table structure is simple and the data columns are under 10 for each raw in the receing tab file.
Skills: ssrs, stored-procedures, microsoft-sql-server