|
|
|
|
| LEADER |
00000nam a2200000 a 4500 |
| 003 |
AR-LpUFIB |
| 005 |
20250423183018.0 |
| 008 |
230201s2013 xxua r 000 0 eng d |
| 020 |
|
|
|a 9781118530801
|
| 024 |
8 |
|
|a DIF-M7110
|b 7298
|z DIF002909
|
| 040 |
|
|
|a AR-LpUFIB
|b spa
|c AR-LpUFIB
|
| 100 |
1 |
|
|a Kimball, Ralph
|9 43839
|
| 245 |
1 |
0 |
|a The data warehouse toolkit :
|b the definitive guide to dimensional modeling
|
| 250 |
|
|
|a 3rd ed.
|
| 260 |
|
|
|a Indianapolis :
|b Wiley,
|c c2013
|
| 300 |
|
|
|a xxxiv, 564 p. :
|b il.
|
| 500 |
|
|
|a Incluye índice
|
| 505 |
0 |
|
|a Introduction -- 1. Data Warehousing, Business Intelligence, and Dimensional Modeling Primer -- Different Worlds of Data Capture and Data Analysis -- Goals of Data Warehousing and Business Intelligence -- Dimensional Modeling Introduction -- Kimball’s DW/BI Architecture -- Alternative DW/BI Architectures -- Dimensional Modeling Myths -- More Reasons to Think Dimensionally -- Agile Considerations -- Summary -- 2. Kimball Dimensional Modeling Techniques Overview -- Fundamental Concepts -- Basic Fact Table Techniques -- Basic Dimension Table Techniques -- Integration via Conformed Dimensions -- Dealing with Slowly Changing Dimension Attributes -- Dealing with Dimension Hierarchies -- Advanced Fact Table Techniques -- Advanced Dimension Techniques -- Special Purpose Schemas -- -- 3. Retail Sales -- Four-Step Dimensional Design Process -- Retail Case Study -- Dimension Table Details -- Retail Schema in Action -- Retail Schema Extensibility -- Factless Fact Tables -- Dimension and Fact Table Keys -- Resisting Normalization Urges -- Summary -- 4. Inventory -- Value Chain Introduction -- Inventory Models -- Fact Table Types -- Value Chain Integration -- Enterprise Data Warehouse Bus Architecture -- Conformed Dimensions -- Conformed Facts -- Summary -- 5. Procurement -- Procurement Case Study -- Procurement Transactions and Bus Matrix -- Slowly Changing Dimension Basics -- Hybrid Slowly Changing Dimension Techniques -- Slowly Changing Dimension Recap -- Summary -- -- 6. Order Management -- Order Management Bus Matrix -- Order Transactions -- Invoice Transactions -- Accumulating Snapshot for Order Fulfillment Pipeline -- Summary -- 7. Accounting -- Accounting Case Study and Bus Matrix -- General Ledger Data -- Budgeting Process -- Dimension Attribute Hierarchies -- Consolidated Fact Tables -- Role of OLAP and Packaged Analytic Solutions -- Summary -- 8. Customer Relationship Management -- CRM Overview -- Customer Dimension Attributes -- Bridge Tables for Multivalued Dimensions -- Complex Customer Behavior -- Customer Data Integration Approaches -- Low Latency Reality Check -- Summary -- 9. Human Resources Management -- Employee Profi le Tracking -- Headcount Periodic Snapshot -- Bus Matrix for HR Processes -- Packaged Analytic Solutions and Data Models -- Recursive Employee Hierarchies -- Multivalued Skill Keyword Attributes -- Survey Questionnaire Data -- Summary -- 10. Financial Service -- Banking Case Study and Bus Matrix -- Dimension Triage to Avoid Too Few Dimensions -- Supertype and Subtype Schemas for Heterogeneous Products -- Hot Swappable Dimensions -- Summary -- -- 11. Telecommunications -- Telecommunications Case Study and Bus Matrix -- General Design Review Considerations -- Design Review Guidelines -- Draft Design Exercise Discussion -- Remodeling Existing Data Structures -- Geographic Location Dimension -- Summary -- -- 12. Transportation -- Airline Case Study and Bus Matrix -- Extensions to Other Industries -- Combining Correlated Dimensions -- More Date and Time Considerations -- Localization Recap -- Summary -- -- 13. Education -- University Case Study and Bus Matrix -- Accumulating Snapshot Fact Tables -- Factless Fact Tables -- More Educational Analytic Opportunities -- Summary -- -- 14. Healthcare -- Healthcare Case Study and Bus Matrix -- Claims Billing and Payments -- Electronic Medical Records -- Facility/Equipment Inventory Utilization -- Dealing with Retroactive Changes -- Summary -- -- 15. Electronic Commerce -- Clickstream Source Data -- Clickstream Dimensional Models -- Integrating Clickstream into Web Retailer’s Bus Matrix -- Profitability Across Channels Including Web -- Summary -- 16. Insurance -- Insurance Case Study -- Policy Transactions -- Premium Periodic Snapshot -- More Insurance Case Study Background -- Claim Transactions -- Claim Accumulating Snapshot -- Policy/Claim Consolidated Periodic Snapshot -- Factless Accident Events -- Common Dimensional Modeling Mistakes to Avoid -- Summary -- -- 17. Kimball DW/BI Lifecycle Overview -- Lifecycle Roadmap -- Lifecycle Launch Activities -- Lifecycle Technology Track -- Lifecycle Data Track -- Lifecycle BI Applications Track -- Lifecycle Wrap-up Activities -- Common Pitfalls to Avoid -- Summary -- -- 18. Dimensional Modeling Process and Tasks -- Modeling Process Overview -- Get Organized -- Design the Dimensional Model -- Summary -- -- 19. ETL Subsystems and Techniques -- Round Up the Requirements -- The 34 Subsystems of ETL -- Extracting: Getting Data into the Data Warehouse -- Cleaning and Conforming Data -- Delivering: Prepare for Presentation -- Managing the ETL Environment -- Summary -- -- 20. ETL System Design and Development Process and Tasks -- ETL Process Overview -- Develop the ETL Plan -- Develop One-Time Historic Load Processing -- Develop Incremental ETL Processing -- Real-Time Implications -- Summary -- 21. Big Data Analytics -- Big Data Overview -- Recommended Best Practices for Big Data -- Summary -- -- Index
|
| 650 |
|
4 |
|a DATA WAREHOUSE
|9 43034
|
| 650 |
|
4 |
|a DISEÑO DE BASES DE DATOS
|9 43157
|
| 700 |
1 |
|
|a Ross, Margy
|9 46854
|
| 942 |
|
|
|c BK
|
| 952 |
|
|
|0 0
|1 0
|4 0
|6 H27_KIM
|7 0
|9 77561
|a DIF
|b DIF
|d 2025-03-11
|i DIF-04475
|l 0
|o H.2.7 KIM
|p DIF-04475
|r 2025-03-11 17:02:59
|w 2025-03-11
|y BK
|
| 999 |
|
|
|c 52772
|d 52772
|
