Dialog sistemi logo
Logo suite E3

ARE YOU AN IT PROFESSIONAL?

E3 is an integrated suite that controls data acquisition, processing and availability.
The E3 platform architecture operates on a relational database that users can access via the Web. It is provided with a fast data loading system and it ensures fast implementation (“Fast Development”) and quick delivery to all final users (“Quick Reporting”).
Suite E3 | Dialog Sistemi

E3 SUITE INTRODUCTION

E3 (EXPLORER Enterprise Edition) is a product based on high-tech solutions and applications containing the most advanced Business Intelligence technologies:

E3 (EXPLORER Enterprise Edition) is a product based on high-tech solutions and applications containing the most advanced Business Intelligence technologies:
• fully customisable to allow an easier analysis and consultation
• graphic and intuitive interface to implement complex tasks
• integrated with user’s Office environment and Excel spreadsheets, so that customers do not have to radically change their operational environment
• use of the main RDBMS (database) and of their most advanced functions, to guarantee the flexibility of software support platforms
• OLAP engine to implement efficient analysis on multi-dimensional data
• web integrated to allow its distribution, obtained through the use of analysis tools. 

MODULAR AND SCALABLE ARCHITECTURE
E3 follows a fully modular and scalable architecture; thanks to these features it is able to operate on different platforms and to grow in time. It is a group of a fully integrated software modules and products.
It’s organised following a multi-level architecture: it is able to operate through a client/server “standard” procedure on two or three levels or through multi-level web operations or in different operating environments.

CORPORATE IT SYSTEM INTEGRATION

The Business Intelligence solution operates through different levels compared to the other components if the corporate IT system and its integration do not require any modification of the existing structure. E3 works good with other applications and systems and is able to obtain data from different corporate sources such as:
• corporate
• ERP
• database
• user spreadsheets
• market data

This allows the creation of value without having to perform organisational changes, in terms of IT tools or the way in which users normally work.


PERFORMANCES AND GUARANTEED GROWTH OVERTIME

Thanks to the modular and scalable solutions offered by Dialog Sistemi, also in terms of projects implementation, all members of an organisation can obtain access to the information over time: consulting data that has been specifically developed to generate information and knowledge, it’s really easy, with high performances and at reasonable costs.
From a quantitative and performance point of view, scalability can be guaranteed up to large volumes, even with terabytes of data and hundreds of users. E3 assists the growth of the organisation and time optimal management referring to internal decision-making processes, while ensuring the opportunity to make the best decisions.

ETL

ETL

The E3 (Explorer Enterprise Edition) ETL (Extraction, Transform, Loading) environment allows the extraction, collection and transformation of a large amount of data coming from several sources.

PERIODICAL DATA PROCESSING

The module manages individual data, as it is collected, and also large amount of data. They merge into the system on a daily, weekly or monthly basis. The data is automatically updated and organised according to the desired time schedule.

HETEROGENEOUS DATA INTEGRATION

The ETL module allows the integration of heterogeneous information sources based on their format and structure (delimited files, XML, RDBMS tables, spreadsheets, click stream, etc.) coming from different systems (ERP, administrative, etc.) creating optimised Data Mart and Data Warehouse.

The new Data Entry module allows the integration of data in the Data Warehouse. If they are authorised they will be input manually in the system using some forms which have been predefined by the system administrator.

ADVANCED TOOLS FOR DATA PROCESSING

Important data are processed by the system applying business rules that have been previously defined during the analysis phase using the set features of the user interface.

 In the acquisition process raw data are processed in order to generate basic business information. Some advanced features are available for tasks such as distribution and allocation, fusion, balanced merge sort, predictive models creation, etc.

DATA CERTIFICATION AND QUALITY

E3 also supports its user for data consultation and certification procedures thanks to utilities that guarantee other sources data cleansing. This analysis allows the verification of its compliance with the business standards and criteria.

CLOSED-LOOP UPDATE

Moreover, the E3 platform provides automatic tools to automatically update (closed-loop) the information regarding the Business Intelligence system, ERP, the corporate portal database, etc.

RDBMS EFFICIENCY AND OPTIMISATION

ETL works transparently with all RDBMS (Oracle, SQL Server, DB2, Sybase, Informix, MySQL, etc.) and provides optimised tools to load and refresh data. These tools fully and automatically take advantage of advanced data management utilities offered by RDBMS.

SIMPLIFIED PRODUCTIVITY AND MANAGEMENT

E3 is really productive: the product is easy-to-use and intuitive, with shortened training time, meaning that managing and maximising management specific resources of infrastructure and data integration is really easy.

Administrators can programme all kinds of processes using time planning and scheduling features (calendar) even linked to external activities.

The system administration turns out to be much more simplified and resources can be optimised with advantages for the entire data management cycle.

Optimizer

Optimizer

E3 Optmizer is a new software module able to analyse Business Intelligence and Data Warehouse systems in real-time.

The E3 Optimizer will allow a reduction of time response

which will not depend on the amount of data to be searched. This is possible after a brief analysis of the customer’s needs and after the tool has been programmed. E3 Optimizer is an easy-to-access tool that does not require any kind of investment in terms of hardware or specialised technical staff. This tool works with all common databases and especially with Oracle. It actually uses summary (pre-aggregated data) and other sophisticated optimisation techniques automatically, replacing system administrators with its own “intelligence”. Easy maintenance, with reduced implementation costs, this tool represents an automatic, flexible, long-term and cost-effective solution.

Broadcast

Broadcast

Thanks to E3 Broadcast, companies can win the “information challenge”.
Decision makers only need access to some of the available information of their organisation. Nevertheless, they need to access this content in the

most appropriate way, according to their function and activity.

Distribution methods (interactive queries, electronic reports, portal deliveries, email shipping or through wireless devices) are intrinsic features of information itself since they have a direct impact on its final use.

E3 Broadcast allows the distribution of information:
E3 Broadcast sends notifications to users of the system on potential developments and events that could affect their activity.
Therefore, E3 Broadcast provides all the required tools to organise, produce and share documents and reports containing relevant information, improving the business decision making process at any level. E3 is a cost-effective and efficient solution through which any organisation can have access to Business Intelligence.

Reporting

Reporting

The user can access all the data organised in the Data warehouse, using preconfigured reports or creating new ones. Reports can be created according to the customers’ needs:

- standard: every solution has some preconfigured models; in this case it’s very easy to implement

- ad hoc: in this case, specific corporate layout needs have to be analysed in advance

The OLAP Analysis feature allows, while browsing, the production of a diverse context report generating pivot tables, charts, time series, etc. Furthermore, specific distribution features allows reports distribution (delivery) in different ways. 

REPORTS DEFINITION

Set up production, distribution and predefined report management parameters. The structure of information is linked to different categories such as customers, products, suppliers, time. It uses all preconfigured analysis models. At the same time it is also possible to choose layouts, methods of production and desired outputs. 

PRODUCTION

You can generate your reports thanks to interactive procedures: the user can recall the reporting preconfigured model and generate it providing appropriate parameters (e.g. relevant time frame and register e output directory). Production can also be conceived following some automated procedures in “batches” through appropriate scheduling which can be activated concurrently with specific events or depending on the execution of particular operations. 

OUTPUT AND REPORTS DISTRIBUTION

Reports can be stored in Excel spreadsheets for potential personalisation or integration. Their results can be also represented/exported graphically and they can also be used with all Office functions. PDF is another supported format (even zipped), a really useful and flexible format with a view to electronic distribution. The HTML format is also supported in the event of potential publication on the web. 

USER-SELECTED REPORTS

Through appropriate filters, it is possible to generate reports for specific users or user groups. Depending on how single users’ specifications have been defined, it’s possible to personalise specific features thanks to the Supervisor who can actually set up some rules to access the data contained in the Data Warehouse after having defined some appropriate filters. You can for instance obtain sales reports for every commercial area, or sales and commissions reports for each employee.

AD HOC REPORTS

Moreover, E3 offers a complete and modern development environment, based on the OLAP infrastructure and on the Data Warehouse, able to carry out ad hoc reports on the basis of the customer’s needs and the corporate layout.

WEB REPORT

E3 creates periodical predefined reports and statements on Intranet/Internet networks using the specific features of the Web Reporting application.

Reports are easily generated thanks to a normal browser from corporate data (through the OLAP technology already described in the Analysis and Report section) specifying familiar features to the users as customers, products, time, supplier, etc. Web reports are generated interactively way on the basis of the features and the data selected by the user. It is also possible to implement drill-down operations to a feature level.

CASE HISTORY

TESTIMONIALS

SOLUTIONS

Subscribe to our mailing list