Research and Markets


Printer Friendly

Printed from http://www.researchandmarkets.com/reports/5493


Applications in Data Warehousing


Description: Your essential guide to using your data effectively, legally and to maximise profit This report will show you how to: - Turn data into knowledge - Apply the latest techniques to increase market share - Minimise churn and detect fraud through data management - Stay on the right side of new data protection legislation - Analyse network and interconnect traffic - Organise data to support e-commerce - Reduce the risk in deployment Your questions answered: - What are the differences between a data warehouse and a data mart? - What can data mining do for us? - What patterns and variables should we be looking for? - What information can we get from our website? - Are we getting the most from our data warehouse? - Should we have our own datawarehouse or outsource? - How much will the data warehouse cost to deploy - and what are the hidden costs? - Will our data warehouse replace jobs? - What do the various suppliers offer? - What data will we need to collect in the future?


Contents:

1 INTRODUCTION.................................................................................. 1.1
1.1 Definitions...............................................................................................................1.1
1.1.1 Data Warehouse .......................................................................................1.1
1.1.2 Knowledge Management and Business Intelligence ..................................1.2
1.1.3 Data Mining Verses End User Querying ....................................................1.3
1.2 The Rationale for Business Intelligence................................................................1.4
1.2.1 The Arrival of Competition .........................................................................1.4
1.2.2 New Business Opportunities......................................................................1.5
1.2.3 Business Benefits of Data Warehousing....................................................1.6
1.3 Structure of the Report...........................................................................................1.7


2 GENERAL DATA WAREHOUSING AND DATA MINING CONCEPTS2.1
2.1 The Concepts..........................................................................................................2.2
2.2 A Condensed History .............................................................................................2.5
2.2.1 EIS - The ‘Corporate Dashboard’...............................................................2.5
2.2.2 End User Empowerment ...........................................................................2.6
2.3 The Technologies ...................................................................................................2.6
2.3.1 Processors and Operating Systems...........................................................2.6
2.3.2 Multidimensional Databases and OLAP.....................................................2.7
2.3.3 Systems Architectures...............................................................................2.8
2.3.4 Query Tools ..............................................................................................2.11
2.3.5 Data Mining...............................................................................................2.11


3 CUSTOMER BEHAVIOUR APPLICATIONS....................................... 3.1
3.1 Marketing Applications...........................................................................................3.4
3.1.1 Customer Segmentation............................................................................3.4
3.1.2 Customer Relationship Management.........................................................3.5
3.2 Churn Management ................................................................................................3.8
3.2.1 The Importance of Churn Management .....................................................3.8
3.2.2 Customer Lifetime Value ...........................................................................3.8
3.2.3 Data Mining Techniques in Churn Management ........................................3.10
3.3 Fraud Detection and Prevention ............................................................................3.11
3.3.1 Scaling the Fraud Problem........................................................................3.11
3.3.2 Mobile Fraud.............................................................................................3.11
3.3.3 Fixed Line Fraud .......................................................................................3.12
3.3.4 Data Mining in Fraud Management ........................................................... 3.13
3.4 Collection and Bad Debt Management.................................................................. 3.14
3.5 Analysing Web Browser Clickstream Data ........................................................... 3.15
3.6 Summary of Customer Behaviour Applications ................................................... 3.16
3.7 Data Protection Issues........................................................................................... 3.16
3.7.1 New European Legislation ........................................................................ 3.17
3.7.2 Implications for all Data Holders................................................................ 3.18
3.7.3 Special Implications for Telco Data ........................................................... 3.19
3.7.4 US Legislation .......................................................................................... 3.20


4 BUSINESS & NETWORK PERFORMANCE
APPLICATIONS ...................................................................................4.1
4.1 Business Performance Analysis ........................................................................... 4.1
4.1.1 'Scorecarding'........................................................................................... 4.1
4.2 Network Performance Analysis ............................................................................. 4.2
4.2.1 Network Planning and Traffic Analysis ...................................................... 4.2
4.2.2 Network Analysis Information for Pricing Packages................................... 4.3
4.2.3 Mobile Network Performance.................................................................... 4.3
4.2.4 IP and Packet Based Networks................................................................. 4.5
4.3 Interconnect Analysis ............................................................................................ 4.6
4.3.1 The Growing Importance of Interconnect .................................................. 4.6
4.3.2 Types of Analysis Needed ........................................................................ 4.7
4.3.3 Least Cost Routing ................................................................................... 4.8
4.3.4 IP Interconnect ......................................................................................... 4.8
4.4 Concluding Remarks.............................................................................................. 4.9


5 ISSUES IN IMPLEMENTING A DATA WAREHOUSE.........................5.1
5.1 Strategic and Organisational Issues ..................................................................... 5.1
5.1.1 Planning for Success ................................................................................ 5.1
5.1.2 Ownership and Objectives ........................................................................ 5.2
5.1.3 Handling Organisational Change .............................................................. 5.3
5.2 Data Issues............................................................................................................. 5.3
5.2.1 Technical Issues....................................................................................... 5.3
5.2.2 Strategic Issues ........................................................................................ 5.5
5.3 Design Issues......................................................................................................... 5.6
5.4 Implementation Issues........................................................................................... 5.8
5.4.1 Implementation Life Cycle .........................................................................5.9
5.5 User Issues .............................................................................................................5.11
5.6 Cost Issues .............................................................................................................5.14


6 SOURCING AND SUPPLIERS ............................................................ 6.1
6.1 Purchasing Strategies ............................................................................................6.1
6.2 Supplier Issues .......................................................................................................6.2
6.2.1 The Case For and Against Using External Suppliers..................................6.2
6.2.2 Essential Services Provided by Suppliers ..................................................6.3


7 MAINSTREAM VENDORS................................................................... 7.1
7.1 Business Objects....................................................................................................7.1
7.1.1 Company Background...............................................................................7.1
7.1.2 Products ...................................................................................................7.1
7.1.3 Telco Case Studies ...................................................................................7.2
7.2 Cognos....................................................................................................................7.2
7.2.1 Company Overview...................................................................................7.2
7.2.2 Products ...................................................................................................7.3
7.2.3 Support and Consultancy Services............................................................7.4
7.2.4 Telco Case Study......................................................................................7.4
7.3 Constellar................................................................................................................7.4
7.3.1 Company Overview...................................................................................7.4
7.3.2 Products ...................................................................................................7.5
7.3.3 Applications ..............................................................................................7.6
7.3.4 Support and Consultancy Services............................................................7.7
7.3.5 Telco Case Studies ...................................................................................7.7
7.4 IBM ..........................................................................................................................7.7
7.4.1 Company Overview...................................................................................7.7
7.4.2 Products ...................................................................................................7.8
7.4.3 Applications ..............................................................................................7.9
7.4.4 Telco Case Studies ...................................................................................7.10
7.5 ICL ...........................................................................................................................7.10
7.5.1 Company Overview...................................................................................7.10
7.5.2 Service Overview ......................................................................................7.11
7.5.3 Support and Consultancy Services............................................................7.12
7.5.4 Telco Case Studies ...................................................................................7.12
7.6 Informix ...................................................................................................................7.13
7.6.1 Company Overview .................................................................................. 7.13
7.6.2 Products................................................................................................... 7.13
7.6.3 Telco Case Studies................................................................................... 7.14
7.7 NCR......................................................................................................................... 7.15
7.7.1 Company Overview .................................................................................. 7.15
7.7.2 Products................................................................................................... 7.16
7.7.3 Selected Applications ............................................................................... 7.17
7.7.4 Support and Consultancy Services ........................................................... 7.19
7.7.5 Telco Case Studies................................................................................... 7.19
7.8 SAS Institute........................................................................................................... 7.20
7.8.1 Company Overview .................................................................................. 7.20
7.8.2 Products................................................................................................... 7.21
7.8.3 Telco Case Studies................................................................................... 7.21
7.9 Sequent Computer Systems.................................................................................. 7.22
7.9.1 Company Overview .................................................................................. 7.22
7.9.2 Products................................................................................................... 7.22
7.9.3 Overview of Service.................................................................................. 7.23
7.9.4 Applications .............................................................................................. 7.24
7.9.5 Telco Case Studies................................................................................... 7.24
7.10 SPSS ................................................................................................................. 7.25
7.10.1 Company Overview .................................................................................. 7.25
7.10.2 Products................................................................................................... 7.25
7.10.3 Telco Case Study ..................................................................................... 7.26
7.11 WhiteCross Data Exploration ................................................................................ 7.26
7.11.1 Company Overview .................................................................................. 7.26
7.11.2 Products................................................................................................... 7.27
7.11.3 Applications .............................................................................................. 7.27
7.11.4 Pricing Scheme ........................................................................................ 7.28
7.11.5 Support and Consultancy Services ........................................................... 7.28
7.11.6 Telco Case Studies................................................................................... 7.28


8 SPECIALIST TELCO APPLICATIONS ................................................8.1
8.1 Amdocs................................................................................................................... 8.1
8.1.1 Company Overview .................................................................................. 8.1
8.1.2 Products................................................................................................... 8.1
8.1.3 Applications .............................................................................................. 8.1
8.1.4 Product Architecture and Connectivity ...................................................... 8.3
8.1.5 Support and Consultancy Services ........................................................... 8.3
8.1.6 Telco Case Studies ...................................................................................8.3
8.2 Dataphone...............................................................................................................8.3
8.2.1 Company Overview...................................................................................8.3
8.2.2 Products and Services ..............................................................................8.4
8.2.3 Product Architecture and Connectivity .......................................................8.5
8.2.4 Pricing Scheme.........................................................................................8.5
8.2.5 Support and Consultancy Services............................................................8.5
8.2.6 Telco Case Studies ...................................................................................8.6
8.3 GTE TSI ...................................................................................................................8.6
8.3.1 Company Overview...................................................................................8.6
8.3.2 Product and Services Overview.................................................................8.6
8.3.3 Telco Case Studies ...................................................................................8.7
8.4 Kenan Systems.......................................................................................................8.7
8.4.1 Company Overview...................................................................................8.7
8.4.2 Products ...................................................................................................8.7
8.4.3 Telco Case Study......................................................................................8.8
8.5 MSI...........................................................................................................................8.8
8.5.1 Company Overview...................................................................................8.8
8.5.2 Products ...................................................................................................8.9
8.5.3 Product Architecture and Connectivity .......................................................8.10
8.5.4 Support and Consultancy Services............................................................8.10
8.5.5 Telco Case Studies ...................................................................................8.10
8.6 Narus.......................................................................................................................8.11
8.6.1 Company Overview...................................................................................8.11
8.6.2 Products ...................................................................................................8.11
8.6.3 Examples of Use.......................................................................................8.12
8.7 Neural Technology .................................................................................................8.12
8.7.1 Company Overview...................................................................................8.12
8.7.2 Products ...................................................................................................8.12
8.7.3 Telco Case Studies ...................................................................................8.13
8.8 SLP InfoWare ..........................................................................................................8.14
8.8.1 Company Overview...................................................................................8.14
8.8.2 Products ...................................................................................................8.14
8.8.3 Application Architecture.............................................................................8.16
8.8.4 Support and Consultancy Services............................................................8.17
8.8.5 Pricing Scheme.........................................................................................8.17
8.8.6 Telco Case Studies ...................................................................................8.18
8.9 Sofrecom.................................................................................................................8.18
8.9.1 Company Overview .................................................................................. 8.18
8.9.2 Products................................................................................................... 8.18
8.10 solution42............................................................................................................... 8.19
8.10.1 Company Overview .................................................................................. 8.19
8.10.2 Product..................................................................................................... 8.20
8.10.3 Applications .............................................................................................. 8.23
8.10.4 Product Architecture and Connectivity ...................................................... 8.23
8.10.5 Pricing Scheme ........................................................................................ 8.23
8.10.6 Support and Consultancy Services ........................................................... 8.23
8.10.7 Telco Case Studies................................................................................... 8.24
8.11 TTI Telecom............................................................................................................ 8.25
8.11.1 Company Overview .................................................................................. 8.25
8.11.2 Products................................................................................................... 8.25
8.11.3 Applications .............................................................................................. 8.25
8.11.4 Product Architecture and Connectivity ...................................................... 8.27
8.11.5 Pricing Scheme ........................................................................................ 8.28
8.11.6 Support and Consultancy Services ........................................................... 8.28
8.11.7 Telco Case Studies................................................................................... 8.28


9 CONCLUSIONS AND FORECASTS....................................................9.1
9.1 Data Warehousing – The Road Ahead................................................................... 9.1
9.1.1 E-deployment ........................................................................................... 9.1
9.1.2 New Data Types ....................................................................................... 9.2
9.1.3 Increased Capacity................................................................................... 9.3
9.1.4 Reduction in Cost .................................................................................... 9.3
9.1.5 The Operational Data Store ...................................................................... 9.4
9.2 Outlook and Forecasts........................................................................................... 9.5
9.2.1 Current Market Size.................................................................................. 9.5
9.2.2 Market Share............................................................................................ 9.5
9.2.3 Market Forecasts...................................................................................... 9.6
9.2.4 Market Breakdown By Sector.................................................................... 9.8


GLOSSARY OF TERMS................................................................................ G.1


APPENDIX 1 - LIST OF VENDOR ADDRESSES.......................................... A.1



FIGURES


1.1 Exploiting Customer Information Held by a Telco ................................................1.2
1.2 Comparison of End User Querying and Reporting and Data Mining Techniques1.3
1.3 Turning Data into Knowledge: the Information Value Chain ................................1.5
1.4 Applications of Data Warehousing Across the Enterprise ...................................1.6
2.1 Migration to a Data Warehouse..............................................................................2.2
2.2 Comparison of Data Warehouses and Data Marts ................................................2.3
2.3 Semantic of Data Warehouse.................................................................................2.5
2.4 Illustrative Star Schema .........................................................................................2.9
2.5 Summary of Features of a Data Warehouse..........................................................2.10
2.6 Relationship Between Data Mining Operations, Techniques and Algorithms .....2.13
3.1 Customer Service Operational Flow and Supporting Systems ............................3.2
3.2 Examples of Telco Applications that use Data Mining .........................................3.3
3.3 Segmentation in the Mobile Phone Industry .........................................................3.6
3.4 Example of Calculation of Lifetime Value of Mobile Phone
Customer.................................................................................................................3.9
3.5 Exposure to Fraud in Different Prepaid Technologies..........................................3.12
3.6 Examples of Typical Data Mining Queries for Telcos ...........................................3.16
4.1 Example of Least Cost Routing Solution...............................................................4.8
4.2 Overlaying a Telco's Strategic Objectives on Data Mining Applications: Example
from Belgacom .......................................................................................................4.10
5.1 Integrating Data from Legacy Systems .................................................................5.4
5.2 Examples of Query/Mining Benchmarks ...............................................................5.7
5.3 Correlating Risks with Data Warehousing Strategies...........................................5.9
5.4 Flow Diagram for Data Warehousing Project .......................................................5.10
5.5 Information Levels for the Description of the Data Warehouse ...........................5.12
5.6 Estimating the Costs and Benefits of Warehouse Adoption ................................5.16
6.1 Suppliers of Data Warehousing Solution Components ........................................6.3
7.1 Constellar Hub Architecture .................................................................................. 7.6
7.2 NCR's Privacy Solution.......................................................................................... 7.19
8.1 Overview of Amdocs' Products ............................................................................. 8.2
8.2 foCust System and Data Flow Architecture .......................................................... 8.22
8.3 CallExpertDW Architecture.................................................................................... 8.28
9.1 An Architecture for E-CRM .................................................................................... 9.2
9.2 Growth in Storage Needs with New Data Types ................................................... 9.3
9.3 Comparison of Real Time Data Warehouse with Conventional
Data Warehouse..................................................................................................... 9.5
9.4 Installed base of Data Warehouse Systems.......................................................... 9.6
9.5 Waves of Growth in Data Warehousing ................................................................ 9.7
9.6 Growth in Data Warehousing Software Market to 2005........................................ 9.7
9.7 From Business Intelligence to Enterprise Performance....................................... 9.9




Ordering: Order Online - visit http://www.researchandmarkets.com/reports/5493

Order by Fax - using the order form below

Order By Post - print the order form below and send to

Research and Markets,
Guinness Centre,
Taylors Lane,
Dublin 8,
Ireland.


Research and Markets Page 1 of 2
Printed 14/02/2012 06:28:34
Fax Order Form
To place an order via fax simply print this form, fill in the information below and fax the completed form to
646-607-1907 (from USA) or +353 1 6849977 (from Rest of World). If you have any questions please email help@researchandmarkets.net

Order information
Please verify that the product information is correct and select the format you require.
Product Name:
Applications in Data Warehousing

Web Address:
http://www.researchandmarkets.com/reports/5493
Office Code:
OC8IHINLSNNSS

Report formats
Please enter the quantity of the report format you require.

Format Quantity Price
Hard Copy €1,555.00 + EUR€ 50.00 Shipping/Handling *
Electronic €1,793.00
CD ROM €1,793.00 + EUR€ 50.00 Shipping/Handling *
* Shipping/Handling is only charged once per order.


Contact information
Please enter all the information below in BLOCK CAPITALS.

First Name:   Last Name:  
Email Address:
Job Title:
Organisation:
Address:
City:
Postal/Zip Code:
Country:
Phone Number:
Fax Number:


Please fax this form to:
(646) 607-1907 or (646) 964-6609 (from USA)
+353-1-481-1716 or +353-1-653-1571 (from Rest of World)
Research and Markets Page 2 of 2
Printed 14/02/2012 06:28:34

Payment information

Please indicate the payment method you would like to use by selecting the appropriate box.

 Pay by Credit Card:
American Express
Diners Club
Master Card
Visa
Cardholder's Name:
Cardholder's Signature:
Expiry Date: /
Card Number:
CVV Security Code:
Issue Date: /   (Diners Club only)


 Pay by Check:
Please post the check, accompanied by this form, to:

Research and Markets,
Guinness Centre,
Taylors Lane,
Dublin 8,
Ireland.


 Pay by Wire Transfer:
Please transfer funds to:

Account number: 83313083
Sort code: 98-53-30
Swift code: ULSBIE2D
IBAN number: IE78ULSB98533083313083
Bank Address: Ulster Bank,
27-35 Main St,
Blackrock,
Co. Dublin,
Ireland.
If you have a Marketing Code please enter it below:
Marketing Code:


Please note that by ordering from Research and Markets you are agreeing to our Terms and Conditions at http://www.researchandmarkets.com/info/terms.asp

Please fax this form to:
(646) 607-1907 or (646) 964-6609 (from USA)
+353-1-481-1716 or +353-1-653-1571 (from Rest of World)