DataSet Presentation

basesprocketData Management

Oct 31, 2013 (3 years and 10 months ago)

131 views

11/1/2013

DataSet™ Presentation

1

Front Cover

2008

DataSet™

An Advanced Business Intelligence Solution

11/1/2013

DataSet™ Presentation

2

I nf or mat ion System and Decision Aid

Web

EIS

DataSet

Vision

DataMart

/ DWH

Transactional

Data

Information System & Decision Aid

11/1/2013

DataSet™ Presentation

3




DataSet

Vision


DataSet

Model (
Views
)


EBIS (Applications)


Web Portal




DataSet

Server Model


DataSet

Web Server


DataSet

Warehouse

(
optional
)

3

Client

Server

Client & Server Architecture

11/1/2013

DataSet™ Presentation

4

Analysis Tools: DataSet Vision



Configurable Query Builder



Sophisticated Report Generator



Break levels with intervals



Charts, pictures and sub
-
reports included



Conditional formatting



Output to Excel, Word, PDF, HTML, XML etc...

Analysis Tools: DataSet Vision



New!
Advanced Dynamic Cubes

11/1/2013

DataSet™ Presentation

5



Generate, view and manipulate multi
-
dimensional
data in real
-
time from DataSet Vision queries on any
data source supported by DataSet Vision



Manipulate c
ubes independently on and offline



Generate cubes on
-
the
-
fly for interactive and
powerful Web
-
based OLAP navigation



Sophisticated Filtering

Analysis Tools: DataSet Vision Cubes



Speed
-
of
-
thought analysis with interactive slice and

dice, drill, rank etc…


Convert your iSeries
-
AS/400 (QUERY/400)
queries into a graphic query in DataSet Vision


Complete the converted query in DataSet Vision
to, for example, by adding variables and
optimizing its presentation.


Use converted AS/400 queries via the DataSet
Web Server Web Portal.


An iSeries TCP/IP query can now be launched in
“Batch” mode, with the result in an AS/400 table
and the possibility to schedule batch jobs.



11/1/2013

DataSet™ Presentation

6

Analysis Tools: DataSet Vision for iSeries

11/1/2013

DataSet™ Presentation

7



Subject domain definition



Definition of the links between tables



Customization of field names



Hide fields



Limit visibility



Create virtual fields



Parameterize according to each user

Data Modeling Tools: DataSet Model

11/1/2013

DataSet™ Presentation

8



One
-
click applications



No programming required



Object updating



Parameter feeding



One
-
click or double
-
click actions



Cascading dialog boxes



Action on pictures, graphs, reports, queries etc…

Application Creation: EBIS

11/1/2013

DataSet™ Presentation

9



Connection centralisation



Secured connections



User group definition



User definition



Grant rights on libraries, tables



Allocation of views created with Model



Allocation of menus for Web Server

DataSet Server

11/1/2013

DataSet™ Presentation

10



Menu creation for access via the Web



Secured Data Sources



Static information publication



Dynamic information publication



Definition of authorized output formats



EBIS application publication



Report linking via URLs

DataSet Web Server



New!
Real
-
time dynamic cube manipulation

11/1/2013

DataSet™ Presentation

11

Other

SQL Server

Oracle

IBM AS/400,
IBM DB2 and
MAINFRAME

Outils d’analyses de
haute productivité

Intégration vers les
outils bureautiques

Solutions par macros

et Agenda

Applications E.I.S.

Reports, charts and
cubes

Architecture


Scenario 1

11/1/2013

DataSet™ Presentation

12

DataSet Server

DataSet Connect

DataSet Administrator

DataSet Model

Other

SQL Server

Oracle

DataSet
Web Server

IBM AS/400,
IBM DB2 and

MAINFRAME

Architecture

11/1/2013

DataSet™ Presentation

13

DataSet Connect

DataSet Server

DataSet Administrator

DataSet Model

DTS

DataWareHouse

(
Optional
)

DataSet

Web Server

Architecture

Other

SQL Server

Oracle

IBM AS/400,
IBM DB2 and

MAINFRAME

11/1/2013

DataSet™ Presentation

14

Tools

Solution

Duplication and DWH

MicroSoft Data Engine

or another database

Security and Modeling

DataSet Server and DataSet Model

Analysis

Tools:

Queries
, Reports, Cubes,
Office
oriented

integration

DataSet Vision

EIS System

Business Intelligence Tools

EBIS (EveryBody Information System)

Distribution/Publication

DataSet Web Server

Technology Integration

11/1/2013

DataSet™ Presentation

15

sales@dataset.fr

Thank you!


Visit our Web site: www.dataset.fr