| |
|
The Sigma system comprise of several user-friendly Business Intelligence applications, providing an end-to-end solution including: data retrieval, data optimization and loading from the operational system, creating business models, data mining and investigation, creating multi-dimensional investigation cubes and reporting tools and up to data distribution and running scenarios.
Sigma provides a better, more unified and clearer picture of the organizational information and allows managers to make better decisions based on easy to read information, presented on their computer-screens in real time.
Sigma Warehouse
Sigma Warehouse is the optimal solution for data analysis, data mining, advanced data intersections and reporting. Sigma Warehouse includes the following modules:
- ETL – A complete environment for data retrieving and loading from any source and in any environment. The tool includes a rich language for data optimization and advanced business models building.
- Data warehouse – Sigma warehouse includes staging areas and models areas, meta data dictionary and index management. The data warehouse is capable of connecting to all the leading databases and can contain data in unlimited volumes while providing extremely fast response-time to end users.
- Data investigation and analysis – Sigma Warehouse includes designated tools for data analysis, segmentation, distribution, statistical measures and more. The tool uses a unique method which allows for a dynamic Drill Down investigation of any data item, be it a summary level item of an individual level one.
- Advanced processing tools – Sigma Warehouse includes a set of tools built to perform complex processes such as: merger, classification, summary, intersection, sampling, regression, frequencies and more. These tools allow for economical models development, data processing performance in the system with no limitation and with extremely fast results.
- Reporting tools – Sigma Warehouse includes a variety of tools which enable the generation of both individual and tabled reports, dynamic graphs etc. The output can be created in any common format: HTML, WORD, EXCEL, PCL, GIF, Active-X etc. All the outputs can be automatically transferred for publication in the reports warehouse – Sigma Web. The outputs are presented in a colorful way which allows for clear and easy highlight of exceptions.
- Scenarios – A fast development environment allows for dynamic reports activation menus building. The scenarios automatically run a number of Sigma processing moves to receive complex outputs. Activation of scenarios is performed by the end- user via a webby interface. The produced outputs are immediately filed in the Sigma Web system and published in the secured reports portal.
|
| |
|
Sigma Web
The Sigma Web system provides and easy and structured way to build a reports portal. Sigma Web enables to receive HTML reports that were produced by the Sigma Warehouse and/or Sigma/eOLAP and/or any other source, file them and distribute them in a structured, secured method in the portal.
Sigma eOLAP
Sigma eOLAP is a dynamic investigation system based on multi-dimensional cubes, operating in an Internet environment. Sigma eOLAP allows data investigation from summary levels to individual levels while presenting statistical measures and highlighting exceptions. |