Index of data related to data warehouse

Data Warehouse Introduction

Definition:
A data warehouse is a structured data environment that supports decision-making and online analysis of application data sources. The data warehouse researches and solves the problem of obtaining information from the database.
Data Warehouse features theme-oriented, integration, stability, and time-variant.
Features:
1. Data Warehouse is subject-oriented;
2. The data warehouse is integrated. The data in the data warehouse comes from scattered operational data, which extracts the required data from the original data for processing and integration, unified and integrated before entering the data warehouse;
3. The data warehouse cannot be updated. The data warehouse mainly provides data for decision analysis, and the operations involved are mainly data query;
4. Data Warehouses change over time. traditional relational database systems are suitable for processing formatted data and can better meet the needs of commercial business processing, he achieved great success in the business field.
Implementation Method:
A data warehouse is a process rather than a project. The data warehouse system is an information delivery platform. It obtains data from the business processing system and organizes data based on Star and snowflake models,
It also provides users with various means to obtain information and knowledge from data. In terms of function structuring, the Data warehouse system should at least contain Data Acquisition, Data Storage ),
Data Access is a key component of Data Access.
Composition:
Data Warehouse database
Data extraction tools
Metadata
Access tools
Datamarts)
Data Warehouse Management
Information Publishing System
Design steps:
1) select an appropriate topic (the domain in which the problem is to be resolved)
2) Clearly define fact tables
3) confirm and confirm dimensions
4) Select a fact table
5) Calculate and store derivative data segments in the fact table
6) convert a dimension table
7) database data collection
8) Update the dimension table as needed
9) determine the query priority and query mode.
Procedure:
1) Collect and analyze business requirements
2) establish a data model and physical design of the Data Warehouse
3) define the data source
4) Select the Data Warehouse Technology and Platform
5) extract, purify, and convert data from operational databases to Data Warehouses
6) Select Access and report tools
7) select database connection Software
8) Select data analysis and data presentation software
9) update the data warehouse

Data warehouse data link
-- Basic Knowledge
OWB Learning
Principles, Design and Application of Data Warehouse Electronic Teaching Plan
Data warehouse and data mining resource Summary
Data Warehouse BASICS (Chinese and English versions)
Data warehouse toolkit-Complete Guide to dimensional modeling (2nd)
The Data Warehouse ETL Toolkit (Chinese Version)
ITPUB e-Magazine No. 15th: Data Warehouse special set released
Textbooks of this classic and practical SQLServer Data Warehouse
Data Warehouse lifecycle toolbox
Data warehouse and data mining
The data warehouse has a great relationship with the database. upload some Sybase, SQLServer, and Oracle documents.
Path to Data Warehouse
Oracle OWB official training course
Source code of data mining algorithms
The data warehouse lifecyle toolkit CD
Data Mining and Knowledge Discovery
Data Mining principles
Data Mining: Concepts, models, methods, and Algorithms
Data Mining: Chinese version of concepts and technologies
Data Mining Introduction [original]
Han jiayuan's Data Mining: Concepts and technologies
Data Mining ebook
Doctoral thesis on Data Mining knowledge
IBM data mining documentation
Multi-dimensional analysis and data mining
Favorites of some data mining
Two data mining books
Data Warehousing and Data Mining for Telecommunications
Getting started with Data Mining
OLAP data
Oracle OLAP White Paper
OWB entry _ DM entry _ OLAP entry
DB2 InfoSphere SQL Warehousing Tool User's Guide
BI papers
-- Best practices
Oracle Data Warehouse Solution
Series of Data Warehouse-Dimension Data Processing Methods
My personal experiences in Project Creation
Owb entry-level documentation (original)
Summary of several important details that are easy to ignore in the BIDW Project
Xx bi project summary and thoughts
Summary of original personal blog articles
An in-depth understanding of the use of proxy keys in Model Technology
Key Methods for BI success in non-technical aspects
Steps for synchronizing data to the CDC
Etl considerations
ETL considerations
Thoughts on data dimension
-- Theoretical Discussion
Data warehouse-ODS Concept
Business Intelligence and data warehouse seminar-Chinese documents
About data warehouse project planning
ETL Essence
How to plan the largest Massive Data Warehouse
OLAP tools destroy Business Intelligence
Can ETL architecture be standardized?
What are the benefits of implementing a data warehouse?
ETL process model I understand
Connection between data warehouse and data mart
Data Model of Data Warehouse
Question about becoming a Data Mining guru (as long as the mouse is used)
I hope you will have a heated discussion on this question.
Basic Idea of bidw project supported by data model
Model, fooled? -- Introduction to modes in Data Mining
How far is the data warehouse from us?
Data warehouse modeling
What is business intelligence? What are business intelligence tools?
Data warehouse and business intelligence (essay activity)
Questions about Data Warehouse and OLAP
Thoughts on the essence of advanced analysis (BI)
ETL tools
-- Informatica
Informatica powercenter User Manual (Chinese)
Informatica powercenter User Manual
Informatica tuning points (Elementary)
Informatica Performance Tuning points (intermediate)
Informatica Performance Tuning points (advanced)
Performance Tuning points of Informatica (Others)
Some information about Informatica powercenter
Informatica PowerCenter V7.1.2 features
Informatica practical Q & A documents: how to and FAQs
Informatica PowerCenter V7.1.2 Basic Training
Informatica Metadata Management Manual
Let's talk about Informatica.
Informatica PowerCenter/PowerMart 6 <Designer Guide>
What is the main role of Source Qualifier Transformation?
-- Datastage
Official Datastage Training Materials 1
Official Datastage training materials 2
Learning help document for Datastage Integration
Datastage 8 training documents and labs
IBM InfoSphere DataStage Data Flow and Job Design
DataStage Learning Guide
-- SSIS & DTS
-- OWL
-- Other Tools
Comparison documents of several presentation tools
Comparison between informatica and datastage ETL tools
BI tools
-- BO
BO software installation Configuration
BO video materials
BO getting started
BO designer Guide
BusinessObjects XI Enterprise Documents (Chinese)
Training materials for business objects
How to shield the menu of BO WebI
Can BO implement associated reports?
Bo Information
Example of crystal easy table
-- Hyperion
HyperionBrio83 learning materials User Manual
---
---
---
---
Epochs series (5) --- build rule file
---
Company Data System (7) --- Storage mechanisms Underneath
-- BIEE
Oracle by Example-Oracle Business Intelligence Enterprise Edition
Use Oracle Warehouse Builder to optimize performance
Proficient in BIEE Data Security
Log on to OBIEE Using LDAP Authentication
Oracle MapViewer and BIEE integration tutorial
A Chinese BIEE document for beginners
Time Dimension and timeline functions in Oracle BIEE
BIEE system administrator user manual
Oracle biee by example
-- Others
MicroStrategy 8.1.2 getting started
Official Microstrategy training materials
MSTR Secondary Development SDK training materials
Let's talk about the advantages of microstrategy.
Comparison between SQL Analysis services and Oracle
NCR Teradata Factory training materials released
Cognos 8.3 official documentation
Cognos8.4 official Chinese Document
Cognos training materials (very precious)
Data mining tools
SAS tutorial
Start with SPSS
SPSS BriefGuide 13
SPSS statistics application practices
Chinese data of SPSS-Clemintine
SPSS data mining platform Clementine Roadmap
SPSS data mining process manual _ CRISP-DM Oracle 10g Data Warehouse practice
Cognos8 training materials