Transcript PowerPoint pateikties šablonas (lietuvių k.)

Centre of competence on data warehousing
Questionnaire on the use of software tools
according to the layered S-DWH architecture
Valerij Žavoronok
Informacinių sistemų priežiūros skyriaus
vedėjo pavaduotojas
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
www.stat.gov.lt
Introduction
Some of the objectives of the Centre of Competence – Data Warehousing (CoC-DWH) are:
 Contacting ESS members for identifying and prioritizing relevant projects and support requests
included clear arrangements about support to be delivered by the CoC-DWH.
 Setting up the knowledge repository in the ESSnet DWH domain of the CROS portal and
implement a plan for active maintenance, including S-DWH best practice cases in ESS member
states.
 Sharing experiences on the general aspects of running a Centre of Competence and getting
feedback for further evolution of this CoC concept.
As part of this process, we invited you to fill in our questionnaire. The main goal of the questionnaire is
to better understand your current situation and needs, and to provide the benefit of experience and
best practice to other countries.
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
2
www.stat.gov.lt
Overall statistics
Not
answered, 11,
30%
Answered, 26,
70%
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
3
www.stat.gov.lt
1. Background
In an S-DWH system we identified four functional layers, starting from the most detailed bottom
level up to the top of the S-DWH architecture where conceptual level is placed. The ground level
corresponds to the area where the process starts, while the top of the pile is where the data
warehousing process finishes.
- Can the functional scheme described above be applied in your NSI?
- What are the differences?
Don't
have, 1,
4%
Partly,
4, 15%
Yes, 21,
81%
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
4
www.stat.gov.lt
2. Access layer
Specialized Business Intelligence (BI) Tools for data access
14
12
12
11
10
8
7
6
6
5
4
2
2
1
1
0
0
Oracle
Microsoft
SAS BI
SAP BO
Tableau
IBM Cognos
(Proprietary) (Proprietary) (Proprietary) (Proprietary) (Proprietary) (Proprietary)
QlikView
(Free)
Other brand
Not using
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
5
www.stat.gov.lt
2. Access layer
Specialized Business Intelligence (BI) Tools for data access (cont.)
Are you satisfied with this product? Almost all users are satisfied with
their products.
2.1 Do you plan to change / update currently using software in the next three
years ? What are the reasons to do so ?
25
21
20
15
10
5
3
1
0
No
Neutral
Yes. To open source
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
6
www.stat.gov.lt
2. Access layer
Office Automation Tools for productivity and collaboration
30
25
24
20
15
10
5
4
1
0
0
Microsoft Office
(Proprietary)
Corel
WordPerfect
iWork
IBM‘s Lotus
SmartSuite
(Proprietary)
2
OpenOffice (free)
2
Other brand
Not using
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
7
www.stat.gov.lt
2. Access layer
Office Automation Tools for productivity and collaboration (cont.)
Are you satisfied with this product? All users are satisfied with their products.
2.2 Do you plan to change / update currently using software in the next three
years ? What are the reasons to do so ?
25
22
20
15
10
5
1
1
Yes. MS Office to Sharepoint
Yes. Oracle, SAS, MS to open source
0
No
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
8
www.stat.gov.lt
2. Access layer
Graphics and Publishing tools
16
14
12
10
8
6
4
2
0
14
11
11
5
4
4
3
2
2
2
1
0
0
0
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
9
www.stat.gov.lt
2. Access layer
Graphics and Publishing tools (cont.)
Are you satisfied with this product? All users are satisfied with their products.
2.3 Do you plan to change / update currently using software in the next three
years ? What are the reasons to do so ?
25
22
20
15
10
5
1
1
Yes. MS Office to Sharepoint
Yes. To buy also SAS and Stata
0
No
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
10
www.stat.gov.lt
2. Access layer
Web services tools
12
10
10
10
8
6
6
5
4
4
4
3
3
2
0
0
Stylus Studio
Microsoft Apache Axis SoapUI (free) Jboss (free) Tomcat/Java
Visual Studio
(free)
(mixed)
(Proprietary)
SDMX-RI
(free)
Other brand
Not using
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
11
www.stat.gov.lt
2. Access layer
Web services tools (cont.)
Are you satisfied with this product? Almost all users are satisfied with their
products. There are 3 answers partly and 1 negative answer.
2.4 Do you plan to change / update currently using software in the next three
years ? What are the reasons to do so ?
25
20
15
10
5
0
20
2
No
1
Yes. Java/tomcat to REST
architecture
1
Yes. PC-Axis to STAT database Yes. Microsoft VS to JBOSS
based system and supports
because of budget
SDMX.
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
12
www.stat.gov.lt
3. Interpretation and Data Analysis layer
Statistical Data Mining Tools
14
12
12
10
8
7
6
6
5
4
4
3
2
2
0
0
0
IBM SPSS
Custom
SAS
STATISTICA
Microsoft Oracle Data
Modeler
Java/web
Enterprise Data Miner
Analysis
Mining
(proprietary) applications
Miner
Services
(custom) (proprietary)
(proprietary)
R (free)
Other brand
Not using
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
13
www.stat.gov.lt
3. Interpretation and Data Analysis layer
Statistical Data Mining Tools (cont.)
Are you satisfied with this product? All users are satisfied with their products.
3.1 Do you plan to change / update currently using software in the next three
years ? What are the reasons to do so ?
15
14
10
5
4
1
0
No
Testing
Yes
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
14
www.stat.gov.lt
3. Interpretation and Data Analysis layer
Business Intelligence Tools for data analysis in a direct connection with database
12
11
10
8
6
6
4
4
2
3
3
2
3
2
3
2
1
2
1
0
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
15
www.stat.gov.lt
3. Interpretation and Data Analysis layer
Business Intelligence Tools for data analysis in a direct connection with database
(cont.)
Are you satisfied with this product? Almost all users are satisfied with their
products. There are 1 answer testing, 1 answer partly and 1 negative
answer.
3.2 Do you plan to change / update currently using software in the next three
years ? What are the reasons to do so ?
15
14
10
5
4
1
0
No
Testing
Yes
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
16
www.stat.gov.lt
3. Interpretation and Data Analysis layer
Tools for designing OLAP cubes
10
9
8
7
6
5
4
3
2
1
0
9
8
4
3
2
2
1
0
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
17
www.stat.gov.lt
3. Interpretation and Data Analysis layer
Tools for designing OLAP cubes (cont.)
Are you satisfied with this product? Almost all users are satisfied with their
products. There are 1 answer testing and 2 negative answers.
3.3 Do you plan to change / update currently using software in the next three
years ? What are the reasons to do so ?
20
15
15
10
5
1
1
1
Yes
Yes. SAS to VAIS Cube
Yes. SuperCross to SAS
0
No
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
18
www.stat.gov.lt
4.2. Would you be willing to share your software with other ESS NSIs?
Design
Tools
3
7
12
16
Yes
Yes
No
No
Main reasons not to share design and/or tools are licencing ang personalisation issues.
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
19
www.stat.gov.lt
5. Source Layer
10
9
8
7
6
5
4
3
2
1
0
9
8
6
5
5
3
1
1
1
1
0
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
20
www.stat.gov.lt
5. Source Layer (cont.)
Are you satisfied with this product? Almost all users are satisfied with their
products. There are 1 answer testing, 1 answer partly and 1 negative
answer.
5.1 Do you plan to change / update currently using software in the next three
years ? What are the reasons to do so ?
20
16
15
10
5
1
1
1
0
No
Yes. Software integration isYes.
required
iWay Data Migrator to VAIS Cube Yes. Blaise to EIS
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
21
www.stat.gov.lt
Thank You!
2014 m. rugsėjo 25 d.
Questionnaire on the use of software tools in S-DWH
22
www.stat.gov.lt