A data warehouse is the main repository of an organization's historical data, its corporate memory. It contains the raw material for management's decision support system. The critical factor leading to the use of a data warehouse is that a data analyst can perform complex queries and analysis, such as data mining, on the information without slowing down the operational systems.
●═══════╦╩═══════════════════════╦╩═══════════════●
Defining a data warehouse in the following terms;-
Business Intelligence
It describes a set of concepts and methods to improve business decision making by using fact-based support systems.
Business Objects
Business Objects Warehouse is a packaged data warehouse designed to meet the unique needs of your business users. It allows you to access, integrate, and optimize your data for cross-departmental reporting and analysis.
Cognos
Cognos describes itself as the foremost supplier of enterprise business intelligence (EBI) solutions, with over 2.5 million seats in thousands of companies worldwide.
Its EBI solution provides corporate data to all staff in the organisation and gives them ways to analyse it. This enables companies to co-ordinate decision-making across the entire enterprise.
CRM
Customer relationship management (CRM) is a business philosophy that aligns strategy, business culture, customer information and technology in order to manage customer interactions to the mutual benefit of the customer and the enterprise.
CRM is a process that leverages customer data, marketing models and life events to improve overall customer satisfaction and gives businesses the ability to perform customer segmentation and treat each customer uniquely.
Crystal Report
A Crystal Report file is a typed component that contains the definition of a report.
Crystal Reports displays a Save As dialog box with the tile name having a
default .txt extension.
ERP
The successful implementation and deployment of enterprise resource planning hinges on an organization's understanding of the complex and challenging issues involved in the process.
ER Win
"Erwin is the best modeling tool on the market!" is immediately rebutted with "ER Studio is better and will always be better!" The shouts continue.
Guidelines
MS-SQL Server 2000
OLAP
Online Analytical Processing, or OLAP (IPA: /ˈoʊlæp/), is an approach to quickly provide answers to analytical queries that are multidimensional in nature. OLAP is part of the broader category business intelligence, which also includes Extract transform load (ETL), relational reporting and data mining.
Policies
Processes
SDM
SDM has created transparency and simplicity in the management of data, processes, reporting, relationships, people and project.
The SDM solution is to develop a financial reporting tool which would feed into their global Contract/Financial Management Intranet Site and reduce their turnaround time from three days to instant reporting.
SDA
SDA is a set of programs for Survey Documentation and Analysis.
SDA is a set of programs for the documentation and Web-based analysis of survey data. There are also procedures for creating customized subsets of datasets.
Tera data
The Teradata Education Network is a membership-based learning community that allows you to harness the power of the Internet and expand your Teradata knowledge at your own pace.
●═══════╦╩═══════════════════════╦╩═══════════════●
History
Data Warehouses are a distinct type of computer database that were first developed during the late 1980s and early 1990s. They were developed to meet a growing demand for management information and analysis that could not be met by operational systems.
Advantages
There are many advantages to using a data warehouse, some of them are:
1) Data warehouses enhance end-user access to a wide variety of data.
2) Decision support system users can obtain specified trend reports, e.g. the item with the most sales in a particular area within the last two years.
3) Data warehouses can be a significant enabler of commercial business applications, particularly Customer Relationship Management (CRM) systems.