With the advent of information technologies and the Web, the volume of data available for companies has dramatically increased. In an information-based economy, today’s competitive advantage is determined by the way in which we receive, analyse and use the large amount of data in a more effective and timely manner compared to our competitors. And Business Intelligence is the answer to this new challenge: transforming missing data into valuable information to support decision making processes and management itself, laying the foundations for making the best choices.
OUR OFFER E3 PLATFORM (EXPLORER ENTERPRISE EDITION)
E3 (Explorer Enterprise Edition) is the Business Performance and Data Warehouse platform of Dialog Sistemi. The platform, which has been entirely made in Italy, is a complete, scalable and modular solution. It uses state of the art technologies covering the entire information chain in a single platform; it also provides all the tools needed to operate effectively in different performances control scenarios.
It allows the development of Business Intelligence applications aimed at corporate governance management in the short term with an excellent return on investment. The features and modules available, legitimate all the expectations of a stable business intelligence platform able to deal with a large volume of data, to create and present easily accesible information, achieving a complex management control system.
The E3 platform presents its main features taking advantage of user interfaces. In this way it’s easy to develop intuitive business applications without the need to create ad hoc codes.
Thanks to this kind of platform, the final user is more independent and even the partners wishing to expand their activities can use it.
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.
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.
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.
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.
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.
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.
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.
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 characters to the users as customers, products, time, supplier, etc. Web reports are generated interactively way on the basis of the characters and the data selected by the user. It is also possible to implement drill-down operations to a character level.
Thanks to OLAP Business Intelligence tools, users can analyse different areas of their corporate environment (sales, marketing, etc.), explore different aspects and identify both potential opportunities and areas of improvement with a few mouse clicks.
OLAP available tools even allow you to satisfy the need of your less
E3 OLAP Analysis is fast and efficient operating directly with Data Warehouse data, using a multidimensional OLAP analysis (OnLine Analytical Processing).
During the analysis procedure, the user can decide to consider some specific characters and quantitative data, handling them with drill operations, applying different filters, adding or eliminating new characters and trying to identity the most interesting information. This i only possible thanks to OLAP Business Intelligence tools especially conceived for business users.
Users personalise their analysis model adding or eliminating certain characters or data, processing and filters and changing the hierarchy. The interface provided by the navigation module is similar to of the Excel interface, in such a way as that the user can easily navigate within the system. In the menu bar and in the tool bar there are different commands corresponding to different data multi-dimensional analysis tools.
EASY ACCESS TO CORPORATE INFORMATION ASSET WITH THE E3 PLATFORM
the user can choose the level of detail: from cumulative data to more detailed with a step-by-step analysis, going through the different aggregation levels, or passing from a very detailed level to a global view.
It is also possible to navigate quantitative data such as quantity, income, costs, margins, through different characters such as product, organisation, customer, time. From summarised information (e.g. corporate or division margins) to basic information (e.g. margin of a product of a specific area).
The different ranges of graphic presentation provided by the system (e.g. Percentage to the total, alphabetical order, Pareto analysis 80/20) identify some specific aspects combining colours with different values to be kept under control.
PRESENTATION AND OUTPUT
The E3 Suite projects data directly in the user spreadsheet, automatically scaling and grouping lines and columns so to be more readable. With a few clicks, you can access graphic data through historical series tables and Pivot tables that can be shared via email or can be published in HTML. In this way al the corporate users can access the information through a normal browser. Users can also be informed via text message.
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.
E3 Dashboard is a Business Intelligence module that provides an integrated environment to easily define graphical management dashboards based on KPI/indicators and applications that follow the BSC (Balanced ScoreCard) methodology.
Thanks to the E3 Dashboard all corporate information is presented through indicators, detailed analysis, reports, spreadsheet tables, charts, slide shows, pictures, etc. It is also possible to create access links to web-based information and other documents and external applications.
E3 Dashboard draws information from the Business Intelligence platform extending its potential to the EIS module and allowing a complete display of all those features with a high graphic impact with structures and presentations in a variety of different formats.
E3 basic object and functions can be assembled freely to build directional applications without having to programme. These applications are equipped with interactive navigation and drill-down features allowing a high level of flexibility to the user.
E3 provides an integrated environment to easily implement:
• Structured maps indicating the number and the kind of the objects
• Information Pyramid
• Thematic maps and interactive customisable organisational charts
• Management dashboards and control panels based on KPI/indicators
• Balanced Scorecard applications
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 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 over 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 does not require any modification of its existing structure. E3 works in parallel with other programmes and it’s able to obtain data from different corporate sources such as:
• 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 accompanies the growth of the organisation and time optimal management referring to internal decision-making processes, while ensuring the opportunity to make the best decisions.