Kingrex Real Estate Business Intelligence BI overall implementation process

1.1 Industry background

1.1.1 Kingrex Real Estate

Kingrex Real Estate was founded in 1993, focusing on real estate development, and has always uphold the "forever integrity, abide by professional, forge ahead, win the future," the core values and "comfort Road" corporate mission. Kingrex Real Estate, from Shanghai. Through years of development, Kingrex established a "deep-rooted three-tier, product-leading" strategy. and rely on urban development to achieve: the consolidation of Shanghai, deep-rooted Yangtze River delta, the layout of the three-step strategy of the country. As a national brand real estate enterprise extending from real estate development to property management, Kingrex Real Estate has won many honors such as "China real estate Hundred Strong", "China real Estate Hundred operation efficiency TOP10" and so on. As of February 2013, the company has developed 22 projects in 13 cities in Shanghai, Hangzhou, Ningbo, Suzhou (Taicang), Changzhou, Zhoushan, Huzhou, Taizhou, Tianjin, Chongqing, Nantong, Changxing and Shaoxing. Excellent professional team, fast and efficient decision-making system, as well as international partners, so that Kingrex is in a high-speed development stage. At the same time, the company's new round of ultra-conventional development plans are brewing, Kingrex will continue to "practice customer expectations" for the cause, absolutely determined to become "a valuable residential supplier."

1.1.2 Soft Software Co., Ltd.

Sail Soft Software Co., Ltd. is specialized in reporting software products and business intelligence product Development company, providing reporting software and business intelligence products and overall application solutions. Finebi is a soft Software Co., Ltd. launched a business intelligence products, for enterprise information encountered difficulties, for enterprises to provide professional business intelligence solutions. Finebi Business Intelligence Analysis module can predict the future development of the simulation enterprise, assist the enterprise to adjust the strategy in time to make better decision, enhance the enterprise's sustainable competitiveness. In addition, Finebi self-help drag-and-drop design report way, rich management cockpit, mature real estate industry solutions, flexible mobile interactive analysis plate is also the new City real estate group information lacks the module, the two sides together, can be mutually beneficial and win, realize the complementarity of resources.
1.1.3 Information construction requirements in the industry

At present, the main operation is Mingyuan ERP, two sets of systems, a set of control costs, progress, a set of control management level (sales) from the business system directly take number, slow, logic is not unified, need to build a unified dimension and facts to analyze

1.2 Business Intelligence BI application background

Because Kingrex real estate originally used is the tool can not fully meet the demand, transformed into a sail soft business intelligence products.

1.2.1 Sail soft solved what the problem

The construction of the business intelligence platform must be consistent with the company's development strategy, and it is one of the prerequisites for the successful deployment of the enterprise business intelligence platform around the enterprise development strategy. The deployment of enterprise business intelligence platform, the real value of enterprise business intelligence, to provide a sound support enterprise decision-making information, is a complex system engineering, not overnight, need to be implemented in stages. In the construction of enterprise business intelligence, from the initial enterprise strategy and target blueprint to the final embodiment of satisfactory results, it is a process of repeated practice, and also a process of sustainable optimization. The final foreground presentation is based on a well-handled data warehouse.

Comparison of 1.2.2 and original solutions

Based on the strong expansion of the soft sail, the needs of customers more than 50% can be successfully implemented (excluding the complexity of the case), the chart is more eye-catching, and the addition of the completion of the whole platform is more complete, style can be consistent up. 1.3 Data processing

1.3.1ETL process

1.3.2 Raw Data comparison

Original database

Processing results

1.4 Data-level permission control

Different logins, different data permissions, the display style has a difference.

1.4.1 High-level account login:

1.4.2 Low-level account login

1.5 Report Application

1.5.1 Page Integration

The customer directly uses the FS data decision platform as a standalone system.

1.5.2 rights Integration in the FS to control permissions, user information from the OA system synchronization, permission group information from the OA synchronization, avoid secondary configuration.

1.6 section Function Module 1.6.1 Management Comprehensive analysis part of the show

1.6.2 Financial Comprehensive Analysis part show

1.6.3 Project

1.7 Sail Soft Real Estate bi Total solution get

Sail Soft Large Real Estate Group Project solution: Http://pan.baidu.com/s/1pJGeqKF

Sail Soft Real Estate BI Solution KPI Assessment system: Http://pan.baidu.com/s/1sjQj8lB

Sail Soft Real Estate BI solution management cockpit: Http://pan.baidu.com/s/1E2WNW

Kingrex Real Estate Business Intelligence BI overall implementation process