| 000 | 05002nam a2200301 i 4500 | ||
|---|---|---|---|
| 999 |
_c10555 _d10555 |
||
| 005 | 20200129150432.0 | ||
| 008 | 131112s2013 inua gr 000 0deng d | ||
| 020 | _a9781118530801 | ||
| 040 |
_aUISEK-EC _bspa |
||
| 100 | 1 |
_aKimball, Ralph _95073 _eaut |
|
| 245 | 1 | 4 |
_aThe data warehouse toolkit : _bthe definitive guide to dimensional modeling / _cRalph Kimball, Margy Ross. |
| 250 | _a3ra edición | ||
| 264 | 1 |
_aIndianapolis : _bWiley, _c2013. |
|
| 300 |
_axxxiv, 564 páginas : _bilustraciones ; _c24 cm |
||
| 336 | _atxt | ||
| 337 |
_2rdamedia _an |
||
| 338 |
_2rdacarrier _anc |
||
| 500 | _aIncluye índice. | ||
| 505 | 2 | _aData 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 - 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 - 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 - Inventory - Value chain introduction - Inventory models - Fact table types - Value chain integration - Enterprise data warehouse bus architecture - Conformed dimensions - Conformed facts - Procurement - Procurement case study - Procurement transactions and bus matrix - Slowly changing dimension basics - Hybrid slowly changing dimension techniques - Slowly changing dimension recap - Order management - Order management bus matrix - Order transactions - Invoice transactions - Accumulating snapshot for order fulfillment pipeline - 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 - Customer relationship management - CRM overview - Customer dimension attributes - Bridge tables for multivalued dimensions - Complex customer behavior - Customer data integration approaches - Low latency reality check - Human resources management - Employee profile 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 - Financial services - Banking case study and bus matrix - Dimension triage to avoid too few dimensions - Supertype and subtype schemas for heterogeneous products - Hot swappable dimensions – 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 - Transportation - Airline case study and bus matrix - Extensions to other industries - Combining correlated dimensions - More date and time considerations - Localization recap - Education - University case study and bus matrix - Accumulating snapshot fact tables - Factless fact tables - More educational analytic opportunities - Healthcare - Healthcare case study and bus matrix - Claims billing and payments - Electronic medical records - Facility/equipment inventory utilization - Dealing with retroactive changes - Electronic commerce - Clickstream source data - Clickstream dimensional models - Integrating clickstream into web retailer's bus matrix - Profitability across channels including web - 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 - Kimball dw/bi lifecycle overview - Lifecycle roadmap – Lifecycle launch activities - Lifecycle technology track - Lifecycle data track - Dimensional modeling process and tasks - Modeling process overview - ETL subsystems and techniques – ETL system design and development process and tasks - Big data analytics big data overview recommended best practices for big data summary index advertisement | |
| 526 | _aM. de tecnología de la información | ||
| 700 | 1 |
_aRoss, Margy. _95080 _eaut |
|
| 082 | 0 | 4 |
_a005.74 _bK495d 2013 _2 |
| 650 | 1 | 7 |
_a Diseño de bases de datos _2lemb _95084 |
| 650 | 2 | 7 |
_aBases de datos _2unescot _91079 |
| 653 | _aArquitectura de almacenamiento de datos | ||
| 942 | _cBK | ||
| 949 |
_an _bn |
||