Business intelligence systems enable users to interactively view and analyze their data to make timely, accurate, information-based decision.

They give you in-depth knowledge of your business, at your fingertips; at the exact moment you need it. It transforms your data to help you make better decisions, lower expenses and increase your competitive advantage.

California State University

Large-scale Multidimensional Data Warehouse Project

csu.jpgWith more than 433,000 students on 23 campuses, California State University (CSU) is the largest university in the United States and has an extremely significant impact on the economy of the state and the regions where its campuses are located.

CSU began looking for a better way to gather, consolidate and report financial results for 23 different campuses, as well as the Chancellor’s Office. An extremely large portion of their time and effort was spent consolidating financial information from campus workbooks that were not always consistent in terms of size and scope. CarpeDatum Consulting has implemented Business Performance Management (BPM) solutions for some of the world's largest companies. Our ability to select, design, and implement the right complement of tools has lead to successful engagements many companies.

CarpeDatum, Inc. was asked to provide assistance in creating a budgeting, forecasting and reporting solution. Using the TM1 OLAP system to improve existing processes, CarpeDatum’s solution provided:

  • Web delivery of financial input and reporting based on Microsoft Excel.
  • Standardization of organizational rules and calculations.
  • Top level consolidation for campuses and the CSU organization as a whole.
  • Excel/Web based input templates that provided a familiar inter-face for the planners and thus minimizes training time.

The main challenges of the project were centralizing a large amount of complex calculations used for reporting and ensuring they met strict financial reporting requirements, as well as ensuring comprehensive training of users and IT.

The Cal State team was able to release a web enabled input and reporting application to the campuses. By implementing a TM1 OLAP system with a Web based front end, users are more easily able to input financial data and analysts can consolidate data for all the campuses more quickly.