C Sharp and SQL server project and SQL server analysis

Decision Support System Problem Statement: With the growing markets, the competition is increasing every single day. The new businesses need to generate revenues and customer acquisition is becoming more important every single day. The most important factor is to perform analysis based on the products preferred by the user. The success of any company lies on the ability to interpret the daily flood of data. For this purpose, certain analyses are performed to check the sales and the products being sold. The problem lies with the efficient interpretation of the data and after performing analysis, taking some decisions to improve the sales. Motivation: The motivation of this project is to fulfill ever increasing needs of the growing markets and providing efficiency analysis to the company employees that can help them increase their revenues. Numerical data holds greats importance, but it’s better to visualize things. Therefore, in my project I will develop a platform where a simple company employee can perform analysis and visualize the results. Scope: Following functionalities will be provided: • Online Analytical Processing: o The option for the use to chose between the grain and the aggregate level. o Generation of reports based on the regional sales, products and quarter of year. Proposed solution: I propose a complete solution for a super market, with the franchises all over the country, based on the aggregation level specified by the user. This will give the company an edge in the market because, the analysis can help them target their customers properly, and increase the sales. For this, the database will be stored in the multi dimensional format, (a data warehouse will be made) and further analysis will then be carried out on them.) Deliverables: o An interface to extract multi dimensional data. o Specification of the aggregate level by the user. ( By means of user friendly mouse clicks) o Visualize the results obtained ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Domain: Visual Studio .Net 2005 SQL Server 2005 SQL Server Analysis Services (SSIS) 2005