About data warehousing
Data warehouse is a repository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis.
A data warehouse houses a standardized, consistent, clean and integrated form of data sourced from various operational systems in use in the organization, structured in a way to specifically address the reporting and analytic requirements.
This definition of the data warehouse focuses on data storage. However, the means to retrieve and analyse data, to extract, transform and load data, and to manage the data dictionary are also considered essential components of a data warehousing system. Many references to data warehousing use this broader context. Thus, an expanded definition for data warehousing includes business intelligence tools, tools to extract, transform, and load data into the repository, and tools to manage and retrieve metadata.
MonsterClasses.com offers a comprehensive portfolio of training on a various IT solutions. With our expertise in the field of IT training and our world class Virtual Learning Solution, GETIIT offers you training customized to your needs.
A data warehouse is a copy of transaction data specifically structured for querying and reporting.
Classfications in Data WareHousing
1.ETL Tools.
2.BI Reporting Tools.
Extract, transform, and load (ETL) is a process in database usage and especially in data warehousing that involves:
- Extracting data from outside sources
- Transforming it to fit operational needs (which can include quality levels)
- Loading it into the end target (database or data warehouse)
What is ETL, Extract Transform and Load?
ETL is an abbreviation of the three words Extract, Transform and Load. It is an ETL process to extract data, mostly from different types of system, transform it into a structure that's more appropriate for reporting and analysis and finally load it into the database. The figure below displays these ETL steps.
ETL architecture and steps
Popular ETLTools
- Informatica
- Data Stage
- Ab Initio
- BO DI
2.BI Reporting Tools.
Business Intelligence Software is usually mentioned to as BI Software and its basic purpose examine data to help uncover future chances for development and also an general assessment of its current state. Business intelligence also helps a company to better see the correlation between certain data sets and helps gain powerful decision making and how to allocate resources for the best for optimal growth.
Business intelligence aims to support better business decision-making. Thus a BI system can be called a decision support system (DSS).[2] Though the term business intelligence is often used as a synonym for competitive intelligence, because they both support decision making, BI uses technologies, processes, and applications to analyze mostly internal, structured data and business processes while competitive intelligence is done by gathering, analyzing and disseminating information with or without support from technology and applications, and focuses on all-source information and data (unstructured or structured), mostly external, but also internal to a company, to support decision making.
Popular BI ReportingTools
- Business Objects
- Cognos
- OBIEE
- MicroStrategy
- Hyperion
