Successful Migration to the SAS®9 platform

Early Adopter Ugine & ALZ discovers the value the SAS®9 platform can bring to an ever-changing business environment

As Ugine & ALZ undergoes a complex merger, Kris Vranken, program manager of the data warehouse competence center, faces many challenges, such as standardization, integration and rationalization of data. As participants in an extensive Early Adopter Program, the company determined that the brand new SAS®9 technology solutions are well geared to take up the role of enterprise platform for end-to-end business intelligence.

 

The reduced development times for new applications and the easier maintenance of SAS®9 will enable an IT department to work much more effectively.
Kris Vranken

Kris Vranken
Data warehouse program manager

 

SAS®9 allows one to feed totally consistent data into a variety of
reporting formats, depending on the IT skills and strategic position
of each corporate user.

Building on Existing Legacy Systems

Ugine & ALZ was established following the merger of French steel company Ugine and Belgian steel producer ALZ. It now constitutes an important part of the Arcelor Group. This merger presented several specific challenges, particularly those involving the different organizational backgrounds within these corporations. Originally a state-owned company, Ugine was organized in a centralized manner. ALZ, on the other hand, was a smaller company with a more entrepreneurial culture. These differences were visible in the IT area as well. Ugine was using an ad hoc query and analysis tool to meet the various tactical reporting needs of each department. ALZ, in turn, was relying on intranet-based applications with reports prepared and managed by the data warehousing team.

"Both the end users and the IT staff are accustomed to working with a particular set of tools. Therefore, our future target is to build a common, integrated platform that will support all of the existing reporting applications," states Vranken. "Early Adopter experiences show that SAS®9 is well suited to take up this role."

One Platform, Multiple Reporting Applications

The initial tests show that SAS®9 technology solutions improve the quality and manageability of data while maintaining and improving all the features and functions that members of staff are used to. The system provides for full end-to-end integration. IT staff can manage all parameters through the SAS server, and consistent information is fed to the full range of reporting tools used at Ugine & ALZ.

It is Vranken's vision to get the right tools in the hands of the right people, while having all of them technically integrated on the same platform by consistent metadata. Management will have complete access to static KPI dashboards and balanced scorecards. A single overview gives them everything they need to make the right decisions within minutes. Assistant managers will have additional drill-down and query functions to analyze figures in greater detail, if needed. Power users on the business side will get advanced drill-down functions, simulations and customizing features such as choice of colors and symbols. Depending on the user's position and IT skills, information can be viewed in a wide range of formats, from static to interactive reports.

Ease of Use and Reuse

"Keeping things simple for each and every user was a key priority," stresses Vranken. "Employees at Ugine & ALZ can continue to view and print their reports in the ad hoc query and reporting application, choose static HTML or dynamic Java reports, or even obtain their data in Excel format. All the information they require is now available through a single portal on our corporate intranet."

The reusability of reports, analysis results, and models has also been greatly improved in SAS®9 Enterprise BI Server. The SAS® Add-In for Microsoft Office enables people to reuse functions written by others in SAS by simply adapting them in Microsoft Excel and Word. An immediate benefit is that the IT department will become more productive since a larger number of employees can produce informative and attractive reports without any SAS background.

SAS®9 Makes the Job Easier for IT Developers

Vranken and his team were among the first to sample the many benefits that SAS®9 has to offer an IT staff. "The Early Adopter experiences showed that SAS®9 can make life easier for us, right from the planning level. For instance, it features all the tools necessary to capture, define and store metadata. This alone will greatly enhance our ability to translate business definitions into IT concepts, which can then be consistently applied across the entire system. All the words and concepts used in reports will have the same meaning for everyone in the company."

SAS®9 Enterprise ETL Server provides thin-client, multi-developer support for the ETL (extract-transform-load) process. The development environment is seamlessly integrated with the metadata repository and can be accessed by several developers simultaneously. It is also more user-friendly, since it uses Java.
In addition, new storage facilities were tested; they proved invaluable in supporting the multilingual and multicultural environment at Ugine & ALZ. A part of the SAS Intelligence Storage solution, the brand new SAS OLAP Server maximizes user comfort and query efficiency, and prepares data for use in a variety of languages.

Doing More With the Same Resources

An enthusiastic Vranken is full of praise for SAS®9, even before the Early Adopter Program ended. "Implementing SAS®9 technology solutions end-to-end is proving to be beneficial for both business and IT users. Every employee at Ugine & ALZ will find a reporting interface that ideally matches both their strategic position and IT knowledge. Because the metadata is now uniquely defined, the consistency of data, and therefore the quality of reports, has dramatically improved. In addition, people wishing to use Excel as their primary reporting tool can continue to do so with greater facility."

Noticeable improvements are also apparent in the IT department. New applications can be developed more rapidly and additional reports can be created by users. This means that the IT team is no longer a bottleneck when it comes to meeting the demand for new reports and applications. "Not only does this free time for us to focus on maintenance and other business-critical IT systems, it also reduces the IT cost of new developments," adds Vranken. "Since developing new applications now demands fewer person-days, we can accomplish much more with the same resources."

Ugine & ALZ

Challenge

The need of better data consistency and manageability.

Solution

SAS® Enterprise Data Integration Server
SAS® Enterprise BI Server
SAS® OLAP Server

Benefits

Ugine & ALZ uses its production capacity more effectively and improves delivery and service levels to its customers.

SAS®9 - Key Benefits

Ugine & ALZ
  • Improved manageability of data.
  • Better data quality.
  • Reduced development time for new applications.
  • Additional support for a greater number of reporting applications.
  • Easier system maintenance.
  • Multideveloper support during ETL process.
  • Improved productivity of IT staff.
The results illustrated in this article are specific to the particular situations, business models, data input, and computing environments described herein. Each SAS customer’s experience is unique based on business and technical variables and all statements must be considered non-typical. Actual savings, results, and performance characteristics will vary depending on individual customer configurations and conditions. SAS does not guarantee or represent that every customer will achieve similar results. The only warranties for SAS products and services are those that are set forth in the express warranty statements in the written agreement for such products and services. Nothing herein should be construed as constituting an additional warranty. Customers have shared their successes with SAS as part of an agreed-upon contractual exchange or project success summarization following a successful implementation of SAS software. Brand and product names are trademarks of their respective companies.

Back to Top