Ameriprise Financial, Inc. is an American diversified financial services company. Ameriprise Financial engages in business through its subsidiaries, providing financial planning, products and services, including wealth management, asset management, insurance, annuities and estate planning. We receive all subjects’ data in the form of Excel, OLEDB and flat files which need to be loaded into the Database schemas. For loading data into DB we are designing SSIS Packages. The resulting model gives us an idea about growth in profit, prediction about increase in sales. The data Warehouse plays a major role in enabling various stores to view the data at a lowest level and help them to make decisions to bring more revenue to company with new policies.

National Hearing Care is a Hearing Care Clinic in Australia and it is one of the best for the treatment of Hearing and producing the Hearing devices as per the need of the customer. Using this existing database, we analyze their business moment like different product sales trends, sales profits, regional sales, top N products sales. The resulting model gives us an idea about growth in profit, prediction about increase in sales which helps the management in decision making