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.


sanford.pngSanford needed a way to control and integrate financials in such a way that when an income statement is altered, the corporate financials reflect the result across the income statement and balance sheet.

CarpeDatum Consulting helped Sanford create an TM1 system designed to dramatically increase the efficiency and flexibility of financial reporting and budgeting for all Sanford International entities.

The latest system built by CarpeDatum provides financial analysts a fast and efficient way to access, report, translate and analyze accounting information sourced from the parent company (Newell-Rubbermaid) corporate general ledger (GL). The system also consolidates budgeting information provided by each of the international entities. Now financial analysts can rapidly provide management decision-makers with information and analysis including:

  • Budgeting & Forecasting
  • Currency Conversion
  • Financial Reporting
  • Sophisticated "What If" Analysis
  • Financial Analysis & Financial Ratio Reporting
  • Variance Analysis
  • Weekly & Daily Flash Reporting

Their new turnkey system combines sophisticated data processing and business rules to allow users to view financial data, as well as any, financial ratios or metrics, from any angle, quickly and easily. The iTM1 system is a real-time OLAP database, which means multiple users can simultaneously access and modify data. Any changes made to the data itself or any calculations are immediately reflected in the database, and are accessible by all other users instantaneously.

Data extracted from the Newell-Rubbermaid corporate GL and is then translated and fed into iTM1. The tight integration of iTM1 with Microsoft Excel provides a rapid learning curve, limited training, and flexibility required for sophisticated financial analysis & reporting.