Leading business intelligence software provider MicroStrategy has announced the Greater China general agent FirstBI world's third largest aluminum producer Sapa Group subsidiary Sapa Heat Transfer (Shanghai) Co., Ltd., and FirstBI signed a two month project implementation of the contract. Completed the SPI system and the original Excel data integration, the establishment of a unified data mart. Achieved using MicroStrategy 8i, including procurement, technology, production, planning, finance, quality, sales, warehouse and other departments of data showing demand.
The degree of information rapidly, Sapa the production system has accumulated a large amount of business data. Enterprise IT departments that have a reasonable use of the data, discover the value it contains, can help companies better monitor and manage production processes and procedures to promote production, processing, inventory, finance and other departments to improve performance. Before implementation of the project is facing this problem:
n statements mainly from production systems, production systems and the original report development difficulties exist, the process cumbersome, long period, the burden of heavy maintenance and other issues, most cases have to rely on IT departments or outsourcing provider, resulting in overall efficiency is not high, but not in time to meet business needs.
n need to accumulate the data to discover useful information, while the accuracy of the data put forward higher requirements.
n of data from different sources, mostly from the database system, but also some from the Excel file. Tend to go through many manual operations to get a complete report.
n information sharing is not convenient enough, to obtain the required data must log on to the production system, can not do any data access.
To solve the above problems, the project objectives are as follows:
n to establish a unified data source, provide various departments to share data access needs.
n instead of the original system to achieve and report, and the establishment of a better scalability and ease of use of data display platform.
n can provide all sectors of business analysts to directly and independently to complete most of the reports or charts showing the capacity needs, without having to rely solely on IT sector development.
n to establish a data distribution platform that allows users anytime, anywhere via a browser or e-mail in a way that the required information.
Sapa business intelligence project was completed for the original SPI system and Excel data integration, the establishment of a unified data mart. Data extraction transformation and loading the main script using Oracle database, the way to achieve and implement in time every morning. Achieved using MicroStrategy 8i, including procurement, technology, production, planning, finance, quality, sales, warehouse and other departments of data showing demand.
Sapa business intelligence project is completed, put to use for each department, each department has the report the user to analyze three types of users and professional users. Professional users can view and analyze reports in addition to the data, you can edit and create new report requirements, shorten the implementation cycle of new requirements to play the system ease of use. Through the use of MicroStrategy's Narrowcast, can be defined rules, the results of statistical analysis is sent to the recipient's mailbox regularly, to ensure that the information obtained to date. Web browser users can access business intelligence system, showing good scalability.
About Sapa Heat Transfer (Shanghai) Co., Ltd.:
Sapa Heat Transfer (Shanghai) Co., Ltd. is a wholly-owned Swedish company Sapa Group is the world's third-largest aluminum producer, specializing in the production and marketing of aluminum composite and non-composite materials, pipes, plates for the automotive industry aluminum heat transfer material. Company in the country has about 70 customers, including almost all the well-known domestic automobile manufacturers heat exchangers, more than 90% market coverage in the domestic automotive heat transfer with the production of composite aluminum alloy strip, bound to ensure that the leader of the Mother of status. Foreign users has rapidly grown to more than 40 throughout Japan, Korea, Southeast Asia and Australia, Iran and other countries. The Hai Sapa for its high-tech, high value-added products, won the honor for himself and achieved two gold and the city of Shanghai Expo 100 "first company" one of the glorious title. Sapa Heat Transfer (Shanghai) Co., Ltd. With high quality aluminum thermal products and superior customer service was widely recognized by many partners, continues to promote their products, expand marketing network, the company's information technology enterprise also done out the initial planning.
About Microstrategy
MicroStrategy Inc. was established in 1989, is the world's leading business intelligence (BI) technology providers. MicroStrategy provides integrated reporting, analysis and monitoring software products, the areas around the world every day to provide business leaders a better decision support. MicroStrategy because of its advanced technology capabilities, superb analytical skills, and excellent user and data scalability and other advantages, which were favored by more and more customers. <
About FirstBI (China) Company
FirstBI (China) Company is the sole MicroStrategy in Greater China general agent. The company has six branches in China and nearly 100 full-time MicroStrategy experts, BI has the strongest support for the domestic strength. In Beijing, Taipei, Guangzhou, Hong Kong and Shanghai, FirstBI branch channel has a number of long-term cooperation partners, they have, and large enterprises such as China Telecom, China Construction Bank, China Netcom, Netease and Baosteel signed a contract. As the total distribution, the company focused on end users and partners to provide customized business intelligence products and solutions.