eiVia extends the data warehouse architecture by adding event intelligence to link cause-and-effect data sources. This lays the foundation for answering the “Why?” question that is often the beginning of operational analytics.

eiVia provides an online spreadsheet that is linked to a powerful server-based analytic engine to provide Predictive Analytics to answer the questions: “What if?” and “What’s best?”

The result is a unique approach to the event-centric reporting, analysis and planning that is Actionable Business Intelligence.

True Online Analysis Processing

The ten critical requirements for online analysis:

1. Support multi-dimensional and multi-hierarchical databases that reflect the business model of the enterprise. Provide users with data transparency, allowing them to easily navigate the database from the spreadsheet interface.
2. Provide a library of calculations that is centrally managed and verified. Eliminate the dependence on spatial abstraction of data.
3. Synchronize security in both the database and application. Avoid downloading more data to users’ desktops than is “displayed on the glass.”
4. Allow users to work independently to model different scenarios, but provide an audit trail for all changes that users make to shared workspaces. Support information sharing and collaboration throughout business process workflows.
5. Facilitate the consolidation of data inputs and analysis performed by multiple users.
6. Allow users to invoke agent processes to highlight exceptions or generate alerts based on exceeding performance thresholds. These agent processes should also be used to trigger alerts when data entries are out of an acceptable range. Support bi-directional alerts that allow users to communicate actions that were taken as a result of an alert – in other words, closed-loop communications.
7. Provide cell locking, both within the spreadsheet, to model scenarios within constraints, and in a shared collaborative workspace, to enforce the locks during collaboration.
8. Allow users to create and compare multiple scenarios – “What if?” models – used to assess different assumptions in identifying the best solution.
9. Provide an interface for incorporating advanced procedural analytic models for statistical forecasting, optimization, goal seeking, and other complex formulas and procedures used to model business drivers.
10. Provide reporting from the online spreadsheet to produce presentation-quality, printer friendly reports.