The enhancement of enterprise's core competitive ability needs strong operation and management ability, which needs timely, accurate and comprehensive business data analysis as reference and support.
A group is a large fashion group, the internal reporting system with Qlikview, but the management of the allocation is not flexible enough to meet the requirements of data security, followed by a number of only 10, only to meet the needs of some users of the report view, so the need for a unified can focus on enterprise operations, the overall situation, Intuitive BI decision system, data effective service in decision-making management Limited, to solve the enterprise management report level problems and requirements.
First, architecture design
650) this.width=650; "src=" http://img.blog.csdn.net/20160201094827965 "alt=" here write a picture describing "title=" "style=" border:none; "/ >
II. Development Tools
ETL Tools: Microsoft SSIS
BI Tools: Sail Soft Business Intelligence Finebi
Third, data preparation
Centralized management of different brands of data to extract business data to the data decision platform BI database. The data ETL uses Microsoft's SSIS. SSIS is the short name for Microsoft SQL Server 2005 Integration Services and is a platform for building high-performance data integration solutions, including extract, transform, and load (ETL) packages for data warehouses.
Data ETL supports data organization of multi-platform, multi-data storage format (multi-data source, multi-format data file, multidimensional database, etc.), and automates data searching and understanding according to description or rules. Integrate data from ERP and OA systems. Reduce the gap between massive, complex data and global decision data. Help form a reference for supporting decision-making requirements.
650) this.width=650; "src=" http://img.blog.csdn.net/20160201094839223 "alt=" here write a picture describing "title=" "style=" border:none; "/ >
The data extraction model is:
650) this.width=650; "src=" http://img.blog.csdn.net/20160201094916287 "alt=" here write a picture describing "title=" "style=" border:none; "/ >
Four, data modeling
According to the business support object and analyze the key indicators to design the data model according to the analysis topic. The Data warehouse contains all the business and activity data of an enterprise or organization, and can be divided into many topics, such as order topics, customer topics, product themes, and supply and marketing topics.
650) this.width=650; "src=" http://img.blog.csdn.net/20160201094931084 "alt=" here write a picture describing "title=" "style=" border:none; "/ >
The underlying data model is designed to:
650) this.width=650; "src=" http://img.blog.csdn.net/20160201095025741 "alt=" here write a picture describing "title=" "style=" border:none; "/ >
Five, multi-dimension online analysis design
Daily Office reports provide support for complex forms that require flexible analysis of data to provide OLAP analysis, allowing business people to customize analytic dimensions to meet individual needs.
650) this.width=650; "src=" http://img.blog.csdn.net/20160201095034695 "alt=" here write a picture describing "title=" "style=" border:none; "/ >
The principle of interaction is as follows:
650) this.width=650; "src=" http://img.blog.csdn.net/20160201095043200 "alt=" here write a picture describing "title=" "style=" border:none; "/ >
VI. safety and security of data
Role-based permission architecture can be used as follows to ensure the security of data access, the transmission process can set data encryption to ensure that the data is difficult to leak out.
Access Platform Permissions template file permissions toolbar permissions
Query control permissions cell fill permissions cell data permissions
This article is from the "West Lake Bully" blog, please be sure to keep this source http://10143917.blog.51cto.com/10133917/1740303
"Case analysis" sharing of a group BI decision system construction scheme