FOCUSBI: Data Warehouse (original)

Follow the public number: Focusbi See more articles; Add QQ Group: 808774277 Get learning materials and explore issues together.

　　

Business Intelligence Tutorial PDF

Link: https://pan.baidu.com/s/1f9VdZUXztwylkOdFLbcmWw Password: 2r4v

Data Warehouse is the core of decision support system, it is the decision-making process for all levels of enterprise, it provides the strategic, tactical and operational collection of all kinds of data support. It is integrated from multiple independent information systems for an enterprise information factory created for analytical reporting and decision support purposes, it provides high-level data for key indicators for the middle-tier to provide statistical indicators data for operations to provide monitoring metrics data, to provide guidance for business process improvement, monitoring competitors, cost, quality, performance assessment.

The characteristics of Data Warehouse: Subject-oriented, integration, stability, reaction history change. At present, the majority of enterprises are not data warehouse design, but integration into the Data warehouse data quality, how to manage the Data Warehouse, management data quality is the challenge faced by BI developers, especially the data quality, enterprise development in the early stage of some business systems, There is no unified planning base data at the same time many data fields do not specify whether required to fill the business and operations personnel only fill in the necessary amount, customer code, commodity code, in the absence of basic data planning and the availability of limited data information, BI data analysis is faced with less analytical dimensions and available data.

Back to the Data warehouse design and management, there are many factors to consider, such as: Data source, data volume, unified data type, query performance, business complexity, timeliness, warehouse hierarchy, visual corresponding to the needs of the data structure, metadata management, data quality, access control, data security. So how do we design and manage the data warehouse, often people speak of the technique, the Tao, the device to describe his understanding of an industry, I do not understand the data warehouse is not deep enough, I rely on those cattle of the device to talk about the design and management of Data Warehouse. Is the weapon, the soldier gun can not leave the body, the BI staff must be in the computer can not have data modeling tools, here I recommend several data modeling tools: Er/studio, Visio, PowerDesigner, we randomly choose a model can complete the data modeling, Here I'll show you the two data models built using PowerDesigner. A real estate is a manufacturing.

Data Warehousing Modeling Process:

　　

Modeling the first task is to understand the business, do not understand the business to do data analysis is to do data mining is to sprinkle rogue, technology for business services, close to the business, and more business departments to communicate, to seize the business core needs to do something is the result of business needs. The conceptual model, the logical model, the physical model, follow the process of the tool to complete the step-by-step. Or that sentence: in-depth understanding of the business, seize the core business, mining business pain points.

　　

FOCUSBI: Data Warehouse (original)