Published on 04-May-2011
Validated on 01 Nov 2012
"We produce four- and five-dimensional OLAP cubes, and IBM SPSS Statistics proved to be the most practical and easy-to-use solution, since users don’t need in-depth or detailed training." - Jérôme Boué, Manager of Economic Research, Research and Forecasting Department, Versailles Chamber of Commerce and Industry
Business Analytics, Business Intelligence
In France, the role of Chambers of Commerce and Industry (CCI) is to protect the interests of companies and promote regional economic development.
The Versailles Chamber of Commerce and Industry (CCI) needed to identify economic activities and understand future developments using predictive scenarios. It also needed the ability to analyze data running to more than one million rows and dozens of columns.
Versailles CCI selected IBM SPSS Statistics to conduct predictive analyses of four- and five-dimensional OLAP cubes because it has the power to manage large volumes of data, test a range of scenarios, and simulate the effects of multiple assumptions.
• A powerful solution capable of managing large volumes of data • Practical and easy-to-use without the need for in-depth or detailed training
Click here for a French version of the case study.
In France, the role of Chambers of Commerce and Industry (CCI) is to protect the interests of companies and promote regional economic development. “It’s all about maintaining and developing economic activity,” says Jérôme Boué, manager of economic research in the Research and Forecasting Department of the Versailles Chamber of Commerce and Industry, which covers two French departments (Yvelines and Val d’Oise) that are home to around 75,000 companies.
One team, two missions
The seven-member Research function is tasked with improving understanding of what is actually going on in the region and identifying those areas of economic activity that deserve specific support initiatives. “For example, the CCI may become involved in encouraging networking between companies in a given industry sector,” Boué explains.
Its second mission involves forecasting – a role new for CCIs: “It’s not enough simply to know what’s going on in terms of economic activity; we also need to understand how things may develop in the future fusing predictive scenarios,” he continues.
Data by the million
The Versailles CCI introduced its research structure at the beginning of the 2000s: “Our obligation to understand our region better demanded the purchase of a software solution (IBM® SPSS® Statistics) to analyze our existing databases, which included the business registry and the Unedic (the French National Professional Union for Employment in Industry and Trade) database.” It was clear that this strategically important historical data could not be managed effectively using a spreadsheet program, since the total amount of data ran to more than one million rows and dozens of columns.
“The volume was much too great, and the key benefit of IBM SPSS Statistics is its power and ability to manage large volumes of data, especially given our need to divide up the region into sub-regions, group communities together, and analyze particular areas of the economy to make our analyses more relevant,” Boué explains.
However, there was no need to use extremely advanced statistical functions: “We produce four- and five-dimensional OLAP cubes, and IBM SPSS Statistics proved to be the most practical and easy-to-use solution, since users don’t need in-depth or detailed training,” he continues.
Scenarios tested, assumptions simulated
The need for statistical analyses goes beyond the CCI’s internal needs: “We also work on behalf of local authorities to conduct diagnostic economic analyses and, for major companies, to measure issues such as the economic impact of their local presence,” Boué adds. But the CCI also has a need for predictive analytics and, once again, IBM SPSS solutions have proved invaluable: “When you need to produce a diagnostic analysis and predict how it might evolve, it’s important that you can test alternative scenarios and simulate the effect of multiple assumptions,” he concludes.
About IBM Business Analytics
IBM Business Analytics software delivers complete, consistent and accurate information that decision-makers trust to improve business performance. A comprehensive portfolio of business intelligence, predictive analytics, financial performance and strategy management, and analytic applications provides clear, immediate and actionable insights into current performance and the ability to predict future outcomes.
Combined with rich industry solutions, proven practices and professional services, organisations of every size can drive the highest productivity, confidently automate decisions and deliver better results.
Products and services used
© Copyright IBM Corporation 2010 IBM Corporation Route 100 Somers, NY 10589 US Government Users Restricted Rights – Use, duplication of disclosure restricted by GSA ADP Schedule Contract with IBM Corp. Produced in the United States of America May 2010 All Rights Reserved IBM, the IBM logo, ibm.com, WebSphere, InfoSphere and Cognos are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both. If these and other IBM trademarked terms are marked on their first occurrence in this information with a trademark symbol (® or TM), these symbols indicate U.S. registered or common law trademarks owned by IBM at the time this information was published. Such trademarks may also be registered or common law trademarks in other countries. A current list of IBM trademarks is available on the Web at “Copyright and trademark information” at: www.ibm.com/legal/copybusiness.shtml SPSS is a trademark of SPSS, Inc., an IBM Company, registered in many jurisdictions worldwide. Other company, product or service names may be trademarks or service marks of others.