The First Data
Morphing Tool
AMADEA is the only embedded
offer allowing the interactive exploitation of the whole corporate information.
AMADEA, as the first tool of data
Morphing, is also the first tool to rapidly transform raw data from
various production systems into knowledge-rich data, ready to be integrated
and deployed by Information and Business Intelligence systems.
As an unprecedented tool of productivity, AMADEA
enables the firms to change their information system and so to adapt
to their market evolution and to their strategies.
AMADEA's concept relies on the
notion of scenarios with parameters. These scenarios are graphically
implemented, in an interactive way, and without requiring any program.
Any refined data is systematically connected to raw data, without breaking
the transformation process.
Data preparation process becomes interactive, easy
to do, easy to maintain, and easy to understand.
Once connected to data sources, AMADEA
supplies all the pre-defined functions for cleansing (replace missing
values, put aside outlying values, etc).
The transformation step in itself is supported by a comprehensive
operators library. Operators are graphically assembled so that the user
does not need to program. Then the resulting tables can be exported
under most data format available on the market.
AMADEA is based on standards,
it can connect to most of usual data sources like log files, flat files,
RDBMS, XML files, etc... and describes the steps required to produce
elaborated and aggregated data for analysis or models definition.
AMADEA has been successfully used
in different application domains like e-commerce site personalization,
customer behavior studies for e-commerce, patient data studies, retail
sales analysis, CRM, etc.
Transformation
as a process
This approach gives AMADEA its
power and places it as the professional data transformation solution
for the future. In other words, a transformation is no longer a complex
computer program designed and executed far from the end-users. It is
now the description of an elementary succession of steps, simple and
understandable, Each actor can follow the whole process.
The central window enables the user to draw and control the execution
of the transformation process. Selecting the output of one of the operators
automatically updates the data grid to reflect the transformations processed
by this operator on the input table. The frames on the left of the screen
give access to transformation operators. The parameters of each operator
can be spelt out in the right of the screen.
Interactivity
- Full graphical definition of transformation processes, no programming
is required
- Interactive data transformation process definition through an advanced
intuitive user interface.
Powerfull Built
in Operators
Create new columns, aggregate, binarize, select, filter,
join, get and change meta data, etc. and see immediately the result. No
more need to wait for long batch processes! AMADEA's
very fast ETL engine proposes a set of very efficient and powerful operations
and a unique set of functions able to take easily into account longitudinal
aspect of temporal data (history of customers, sales, of patients,
of web connections, etc.).
Time savings
- Use of AMADEA brought unprecedented gain in
development time and maintenance of even complex data transformation
processes working on very large amount of data.
- Its unique fast and powerful ETL engine allows interactive and exploratory
definition of transformation processes.
- The use of AMADEA increases data preparation
efficiency up to 95% of the time usually required to get the same result
with traditional approaches.
Understandable
process
The data transformation process remains easy to understand
and offers in fine a unique communication tool through which all the actors
of the transformation can understand each other (marketing professionals,
statisticians, data administrators, analysts, etc.).
Data traceability
Any refined data, from a result table, is still connected
to raw data, without having broken the chain that was used to produce
it.
Dynamic process
with parameters
Transformation processes are dynamic and flexible. A datamart
created with AMADEA is not defined once for ever,
but each run of the process can produce different results depending on
the parameters associated to the session. Scripts to select the parameters
are web pages that are automatically generated from the definition of
the transformation.
Efficient process
Using AMADEA allows the user to
save a lot of time in defining a transformation. Splitting up the transformation
into elementary steps makes it easier to design, and then maintain data
transformations.
Producing new variables, filtering data, and so on, is
so simple that in fine, the transformation often contains more relevant
information, with higher quality compared to traditional approaches, because
the transformation definition will have been tested, and modified, possibly
several times, during the design of the transformation
Large data sets
AMADEA was built to rapidly handle
large data volumes. It uses its own engine for memory management so as
to optimize the use of the computer memory according to free space. The
software adapts easily to the available capacities, thus offering a scalable
solution.
Some characteristics
- Connection to an unlimited number of various data sources: XML, logs
files, RDBMS, flat files...
- Extraction and analysis of web servers logs
- Possibility of reusing transformations libraries
- Interactivity
- Powerful transformation operator
- Self gathering of information process
- Possibility of changing the parameters and of reusing the process
- Transformation can be driven by browser
- Total traceability
- Management of very big datasets
- Management of Metadata
- Gain of productivity up to 90%
|
