Data Warehousing

Data Warehouse “Provides information on techniques to design, build, maintain and retrieve information from data. a. AB initio – is a database module. b. Business Intelligence – BI is a process of enhancing data into information and then into knowledge. Gather, store, analyze and provide access to data. c. Informatica – database module. d. ETL - Extract, transform, and load (ETL) is a process in data warehousing that involves, extracting data from outside sources, transforming it to fit business needs, and ultimately ,loading it into the data warehouse. ETL is important, as it is the way data actually gets loaded into the warehouse e. Cognos – is an Ottawa, Ontario based company which makes business intelligence (BI) and performance planning software. f. Data Stage – Is used for data extraction, transformation and loading (ETL) solution for information intensive companies, Offers end to end Meta data Management and data integration Applications such as CRM (Customer Relation Management), ERP (Enterprise Resource Planning), and SCM (Supply Chain Management). g. OLAP - Online Analytical Processing, a category of software tools that provides analysis of data stored in a database. OLAP tools enable users to analyze different dimensions of multidimensional data. For example, it provides time series and trend analysis views. OLAP often is used in data mining. h. Report Net - Cognos Report Net. Cognos Report Net improves your performance, reduced costs—complete reporting coverage and zero-footprint environment reduce maintenance. Quicker results—seamless integration and adaptive authoring shorten reporting times. Improved decision-making—reports and dashboards present critical data in easy-to-understand formats. Increased agility—create one version of data truth across divisions, departments, countries, and more.