Strategic data warehousing: achieving alignment with business
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Boca Raton, Fla.
CRC Press
2010
|
| Subjects: | |
| Online Access: | Inhaltsverzeichnis |
| Physical Description: | XVII, 199 S. graph. Darst. 25 cm |
| ISBN: | 9781420083941 |
Staff View
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV036517709 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | t | ||
| 008 | 100622s2010 xxud||| |||| 00||| eng d | ||
| 010 | |a 2009021246 | ||
| 020 | |a 9781420083941 |9 978-1-4200-8394-1 | ||
| 035 | |a (OCoLC)699139752 | ||
| 035 | |a (DE-599)BVBBV036517709 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 044 | |a xxu |c US | ||
| 050 | 0 | |a QA76.9.D37 | |
| 082 | 0 | |a 651.8 | |
| 084 | |a ST 530 |0 (DE-625)143679: |2 rvk | ||
| 100 | 1 | |a Bhansali, Neera |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Strategic data warehousing |b achieving alignment with business |c Neera Bhansali |
| 264 | 1 | |a Boca Raton, Fla. |b CRC Press |c 2010 | |
| 300 | |a XVII, 199 S. |b graph. Darst. |c 25 cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 4 | |a Datenverarbeitung | |
| 650 | 4 | |a Wirtschaft | |
| 650 | 4 | |a Data warehousing | |
| 650 | 4 | |a Business |x Data processing | |
| 650 | 0 | 7 | |a Data-Warehouse-Konzept |0 (DE-588)4406462-7 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Data-Warehouse-Konzept |0 (DE-588)4406462-7 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020439777&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-020439777 | ||
Record in the Search Index
| _version_ | 1804143088523804672 |
|---|---|
| adam_text | Titel: Strategic data warehousing
Autor: Bhansali, Neera
Jahr: 2010
Contents
Preface.........................................................................................................xiii
Acknowledgments.........................................................................................xv
About the Author........................................................................................rvii
1 Introduction........................•.........•............ ...........................................1
Data Warehouse...........................................................................................2
Challenges in Data Warehousing.................................................................3
Goal.............................................................................................................4
Strategic Alignment.....................................................................................5
Current Status of Strategic Alignment Research..........................................6
The Gap.......................................................................................................7
Case Studies.................................................................................................8
Organization of Remaining Chapters..........................................................8
2 Benefits of a Data Warehouse.................................................................9
Evolution of Information Technology..........................................................9
Evolution of Information Systems..............................................................10
Benefits of a Data Warehouse....................................................................12
Decision Support..............................................................................12
Data Analysis....................................................................................13
Data Mining.....................................................................................15
Enhanced Integrated Data................................................................16
Efficiency Improvements...................................................................17
Customer Management....................................................................17
Conclusion................................................................................................. °
3 Difference Between Data Warehouses and Traditional
Operational Systems.................................•..................•........................*9
Features of a Data Warehouse....................................................................19
Subject Oriented...............................................................................19
Integrated.........................................................................................20
vn
viii ¦ Contents
Nonvolatile.......................................................................................20
Time Variant....................................................................................21
Historical..........................................................................................21
Difference Between Data Warehouses and Traditional Operational
Systems......................................................................................................21
Used by Management.......................................................................22
Strategic Value..................................................................................22
Strategic Direction............................................................................23
Online Analytical Processing............................................................23
Subject Oriented...............................................................................24
Historical Data.................................................................................24
Unpredictable Query Pattern............................................................25
Other Important Differences............................................................25
4 Data Warehouse Development Process................................................29
Data Sourcing............................................................................................30
Data Modeling..........................................................................................30
Transforming Enterprise Data Model to Data Warehouse Model.... 34
Remove Operational Data................................................................35
Add an Element of Time to the Key Structure..................................35
Add Appropriate Derived Data.........................................................35
Transform Data Relationships into Data Artifacts............................36
Accommodate Different Levels of Granularity.................................37
Merge Like Data from Different Tables............................................39
Create Arrays of Data......................................................................40
Separate Data Attributes by Stability Characteristics........................41
Data Extraction and Conversion...............................................................42
Data Extraction................................................................................43
Data Cleaning..................................................................................43
Loading the Data Warehouse..........................................................44
Refresh.............................................................................................45
Data Warehouse Database Management System.......................................46
Differences between Relational and Multidimensional Designs........47
Data Warehouse Administration...............................................................48
Access and Business Intelligence Tools.......................................................49
Metadata....................................................................................................50
5 Data Warehouse Architectures.............................................................53
6 Factors Influencing the Success of a Data Warehouse..........................57
Organization Factors that Influence Success of a Data Warehouse............58
User Factors that Influence Success of a Data Warehouse.........................64
Technology Factors that Influence Success of a Data Warehouse...............65
Contents ¦ ix
Data Factors that Influence Success of a Data Warehouse..........................67
Data Quality....................................................................................68
Intrinsic Data Quality......................................................................69
Contextual Data Quality..................................................................70
Accessibility......................................................................................71
Representational Data Quality.........................................................71
7 Strategic Alignment..............................................................................75
Need for Strategic Alignment Between IT and Business............................76
The Strategic Alignment Model.................................................................78
Developments in Strategic Alignment Research.........................................80
Alternatives to the Strategic Alignment Model.........................................84
Enablers of Business-IT Alignment...........................................................86
Culture.............................................................................................87
Customer Focus................................................................................87
Organization....................................................................................87
Joint Responsibility...........................................................................88
Rewards............................................................................................89
Conclusion.................................................................................................89
8 Strategic Alignment of Data Warehouses.............................................91
Conceptual Model.....................................................................................91
Joint Responsibility between Data Warehouse and Business Managers......93
Alignment between Business Plan and Data Warehouse Plan..................100
Business User Satisfaction........................................................................104
Technical Integration...............................................................................109
Flexibility.................................................................................................112
9 Case Study: Strategic Alignment at Nielsen Media Research.............115
Introduction............................................................................................115
Overview of the Company.......................................................................115
Business Objective..........................................................................116
Background of the Data Warehouse...............................................116
The Data Warehouse Development..........................................................117
Project Initiation.............................................................................117
Data Warehouse Architecture Selection..........................................118
Physical Implementation.................................................................118
Strategic Alignment of the Data Warehouse at Nielsen Media
Research..................................................................................................119
Joint Responsibility between Business and Data Warehouse
Managers........................................................................................120
Commitment and Involvement of Senior Management.........120
Involvement of Data Warehouse Managers in Corporate
Strategy.................................................................................121
Contents
Alignment between Business and Data Warehouse Plans...............122
Architectural Alignment of the Data Warehouse...................122
Knowledge Sharing...............................................................123
Integration of Business and Data Warehouse Planning..........124
Communication between the Business and Data
Warehouse Managers.............................................................125
User Participation and Satisfaction, and Data Warehouse Success.. 126
User Participation..................................................................126
Perceived Usefulness..............................................................127
Ease of Use............................................................................128
Data Quality.........................................................................128
Technical Integration and Data Warehouse Alignment and
Success............................................................................................129
Value Management................................................................129
Technological Capability.......................................................130
Organizational Capability.....................................................131
Flexibility in Data Warehouse Planning.........................................131
Conclusion...............................................................................................133
10 Case Study: Strategic Alignment at Raymond James Financial.........135
Introduction............................................................................................135
Overview of the Company.......................................................................135
Company Subsidiaries....................................................................136
Business Objectives.........................................................................136
Corporate Structure........................................................................137
Background of the Data Warehouse........................................................137
Data Warehouse Objective.............................................................138
Data Warehouse Development.......................................................138
Conceptual Model.................................................................138
Physical Implementation.......................................................139
Project Initiation.......................,............................................139
Current Data Warehouse.......................................................139
Strategic Alignment of the Data Warehouse at Raymond James
Financial..................................................................................................140
Joint Responsibility Between Business and Data Warehouse
Managers........................................................................................140
Commitment and Involvement of Senior Management in
Data Warehouse Project........................................................140
Involvement of Data Warehouse Managers in Corporate
Strategy.................................................................................141
Alignment between Business and Data Warehouse Plans...............142
Architectural Alignment of the Data Warehouse...................143
Knowledge Sharing...............................................................144
Contents ¦ xi
Integration of Business and Data Warehouse Planning..........145
Communication between the Business and Data
Warehouse Managers.............................................................146
Business User Participation and Satisfaction, and Data
Warehouse Success.........................................................................147
User Participation..................................................................147
Perceived Usefulness..............................................................148
Ease of Use............................................................................149
Data Quality.........................................................................150
Technical Integration and Data Warehouse Alignment and Success... 151
Value Management................................................................152
Technological Capability.......................................................152
Organizational Capability.....................................................153
Flexibility in Data Warehouse Planning.........................................154
Conclusion...............................................................................................156
11 How to Assess Strategic Alignment of a Data Warehouse..................157
Design of the Interview Instruments........................................................158
Design of Interview Instruments for Senior Business Managers...............158
Questions for Senior Business Managers.........................................159
Questions for Senior Business Managers Regrouped According
to Main Questions..........................................................................159
Design of Interview Instruments for Data Warehouse Managers.............160
Questions for Data Warehouse Managers.......................................162
Questions for Data Warehouse Managers Regrouped According
to Main Questions..........................................................................162
Design of Interview Instruments for Business Users................................165
Questions for Business Users..........................................................165
Questions for Business Users Regrouped According to Main
Questions.......................................................................................165
12 Epilogue.............................................................................................169
Strategy....................................................................................................169
Organizational Culture............................................................................170
Service Orientation of Data Warehouses..................................................174
Governance Process.................................................................................175
References.....................................................................................•.............177
Index...........................................................................................................191
|
| any_adam_object | 1 |
| author | Bhansali, Neera |
| author_facet | Bhansali, Neera |
| author_role | aut |
| author_sort | Bhansali, Neera |
| author_variant | n b nb |
| building | Verbundindex |
| bvnumber | BV036517709 |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D37 |
| callnumber-search | QA76.9.D37 |
| callnumber-sort | QA 276.9 D37 |
| callnumber-subject | QA - Mathematics |
| classification_rvk | ST 530 |
| ctrlnum | (OCoLC)699139752 (DE-599)BVBBV036517709 |
| dewey-full | 651.8 |
| dewey-hundreds | 600 - Technology (Applied sciences) |
| dewey-ones | 651 - Office services |
| dewey-raw | 651.8 |
| dewey-search | 651.8 |
| dewey-sort | 3651.8 |
| dewey-tens | 650 - Management and auxiliary services |
| discipline | Informatik Wirtschaftswissenschaften |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01410nam a2200397zc 4500</leader><controlfield tag="001">BV036517709</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">100622s2010 xxud||| |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2009021246</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781420083941</subfield><subfield code="9">978-1-4200-8394-1</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)699139752</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV036517709</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">US</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.9.D37</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">651.8</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 530</subfield><subfield code="0">(DE-625)143679:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Bhansali, Neera</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Strategic data warehousing</subfield><subfield code="b">achieving alignment with business</subfield><subfield code="c">Neera Bhansali</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Boca Raton, Fla.</subfield><subfield code="b">CRC Press</subfield><subfield code="c">2010</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XVII, 199 S.</subfield><subfield code="b">graph. Darst.</subfield><subfield code="c">25 cm</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Datenverarbeitung</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Wirtschaft</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Data warehousing</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Business</subfield><subfield code="x">Data processing</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Data-Warehouse-Konzept</subfield><subfield code="0">(DE-588)4406462-7</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Data-Warehouse-Konzept</subfield><subfield code="0">(DE-588)4406462-7</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020439777&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-020439777</subfield></datafield></record></collection> |
| id | DE-604.BV036517709 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T22:42:06Z |
| institution | BVB |
| isbn | 9781420083941 |
| language | English |
| lccn | 2009021246 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-020439777 |
| oclc_num | 699139752 |
| open_access_boolean | |
| physical | XVII, 199 S. graph. Darst. 25 cm |
| publishDate | 2010 |
| publishDateSearch | 2010 |
| publishDateSort | 2010 |
| publisher | CRC Press |
| record_format | marc |
| spelling | Bhansali, Neera Verfasser aut Strategic data warehousing achieving alignment with business Neera Bhansali Boca Raton, Fla. CRC Press 2010 XVII, 199 S. graph. Darst. 25 cm txt rdacontent n rdamedia nc rdacarrier Datenverarbeitung Wirtschaft Data warehousing Business Data processing Data-Warehouse-Konzept (DE-588)4406462-7 gnd rswk-swf Data-Warehouse-Konzept (DE-588)4406462-7 s DE-604 HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020439777&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Bhansali, Neera Strategic data warehousing achieving alignment with business Datenverarbeitung Wirtschaft Data warehousing Business Data processing Data-Warehouse-Konzept (DE-588)4406462-7 gnd |
| subject_GND | (DE-588)4406462-7 |
| title | Strategic data warehousing achieving alignment with business |
| title_auth | Strategic data warehousing achieving alignment with business |
| title_exact_search | Strategic data warehousing achieving alignment with business |
| title_full | Strategic data warehousing achieving alignment with business Neera Bhansali |
| title_fullStr | Strategic data warehousing achieving alignment with business Neera Bhansali |
| title_full_unstemmed | Strategic data warehousing achieving alignment with business Neera Bhansali |
| title_short | Strategic data warehousing |
| title_sort | strategic data warehousing achieving alignment with business |
| title_sub | achieving alignment with business |
| topic | Datenverarbeitung Wirtschaft Data warehousing Business Data processing Data-Warehouse-Konzept (DE-588)4406462-7 gnd |
| topic_facet | Datenverarbeitung Wirtschaft Data warehousing Business Data processing Data-Warehouse-Konzept |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020439777&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT bhansalineera strategicdatawarehousingachievingalignmentwithbusiness |