In the deepening of the market economy today, "Internet +" and the explosion of big data growth, data, information has become an important strategic resources. Traditional management concepts and models have not adapted to the present information society, and enterprises must rely on information and innovation to win.
In the medical industry, the medical informatization led by Western countries has been in the forefront, and in China, such a trend is also booming.
A well-known medical Group is a collection of drugs, health products production and sales of modern pharmaceutical enterprise group. Its Cardan jie, excellent and other products for the Chinese women's health care market and children's cold medicine market leader brand. has been successfully listed, the company has 3 medical research institutions, 13 drugs, health care products manufacturers, 5 sales logistics enterprises, more than 6,000 employees.
The information construction of the group should be rapid. Since March 2005 with Kingdee software company began to start all-round information construction, the enterprise marketing, finance, human resources, supply chain, knowledge and other aspects and levels of implementation of standardized information management.
Although EAS and its peripheral information systems have been in operation for many years, it has provided effective support for the first-line business operation and accumulated a large amount of business data, but there are still some deficiencies in data integration and analysis, especially the failure to provide effective data support for the strategic decision of middle and high level. Therefore, the comprehensive data analysis construction is imminent.
Enterprise demand:
- At present, the group is in the management rise stage, strengthen management, optimize the operation, all need to have timely, accurate, comprehensive data information to use as the basis.
- Need a global, intuitive, visual bi reporting system that can focus on the operational activities of the enterprise, integrating information data from each IT system.
- Based on the management topics of budget, cost, inventory plan, S&op, sales, finance, production, supply chain and other business fields, we will unify the status information of enterprise operation activities, unify the management of technical information, business information, resource information and knowledge information. Automate processing and analysis of information data based on different themes and dimensions for decision-making and operational control.
Facing challenges:
- The current business data is dispersed in various application systems, the business data between the systems is not integrated, it is difficult to get unified, complete, intuitive, and can be from the various business topics and dimensions to show the management data of operational activities.
- Many of the management reports require manual filling, hierarchical escalation, merging, processing, and consuming a lot of management resources. Inefficient, in fact, time, accuracy, comprehensiveness are limited, can not fully reflect the actual situation of the overall operation of the enterprise.
- Business expansion, the rapid growth of business data, along with the business management measures of the landing and strengthening, there are often operational reform and adjustment. Management report data collection and synthesis production, can not keep up with its business development speed. Not timely, accurate and comprehensive business data analysis, reflected in the guidance of enterprise operations.
- In the enterprise management, business decision-making, strategic decision-making, risk control, often appear the information data based on insufficient, inaccurate, difficult to judge the situation.
Solution:
1, integrate the business data of each system, do a good job of data classification and management
① Considering that the enterprise does not have a good data platform support, using Finebi ETL tool, the data of all systems of Renhe group are extracted, transformed and loaded into Finecube to form cube data.
② because of the more structured and unstructured data in the enterprise system, ETL can be used to realize the cleaning of data information well. The bottom, and then through the Finereport with the report tool, will require manual input, approval, combined non-system data writing, to achieve automation.
③ is able to configure the data business package for the extracted data, classify and manage the data according to the requirement of business analysis, read the association between the tables, read the field escape, and lay the foundation for the subsequent BI report generation, query, and multidimensional analysis.
Table Relationship View
2, visual report generation, free drag-and-drop multidimensional analysis, for the business unit speed up
The intra-Group business unit analyzes the impact factors related to an indicator by topic and multidimensional Analysis. For this purpose, it provides a free choice of filter controls, calculation indicators, linkage and drilling, as well as slicing, cutting, and other functions such as data warning. In particular, the production, sales and distribution departments can achieve real-time business analysis to meet the rapidly changing business needs.
Value analysis
3, centralized and unified decision-making management platform, help information strategy decision-making
Such a platform to achieve the report management, user management, institutional management, rights management, timing scheduling, and thus support the "one platform" of information management methods. Most importantly, the leadership is able to have a more comprehensive understanding of the business situation through this visualization.
Decision Platform Example
How to establish information strategy decision in medical industry