Recognized and respected throughout the world as the most influential leaders in the data warehousing industry, Ralph Kimball and the Kimball Group have written articles covering more than 250 topics that define the field of data warehousing. For the first time, the Kimball Group's incomparable advice, design tips, and best practices have been gathered in this remarkable collection of articles, which spans a decade of data warehousing innovation.
Each group of articles is introduced with original commentaries that explain their role in the overall lifecycle methodology developed by the Kimball Group. These practical, hands-on articles are fully updated to reflect current practices and terminology and cover the complete lifecycle—including project planning, requirements gathering, dimensional modeling, ETL, and business intelligence and analytics.
This easily referenced collection is nothing less than vital if you are involved with data warehousing or business intelligence in any capacity.
Keywords: books by Ralph Kimball, the Kimball Group, data warehousing, data warehousing methods, data warehousing standards, data warehousing best practices, data warehousing advice, data warehousing articles, collection of data warehousing articles, data warehouse lifecycle, data warehouse methodology, data warehouse architecture, business intelligence, business requirements in data warehousing, dimensional modeling, star schema, data warehouse design, kimball data warehouse, data warehouse, data warehousing article, books by ralph kimball, kimball university, data warehouse ralph kimball, kimball articles, ralph kimball boulder creek, ralph kimball associates, 34 subsystems of ETL, 64 bit architectures for data warehouse, 2NF (second normal form), 3NF (third normal form), business rules, Chris Date criticisms, complex schemas, versus dimensional modeling, incompleteness, primary criticism, query complexity, performance for BI queries, real data, redundancy, uniqueness, usability, CIF use of 3NF, abstract dimensions, abused users, accumulating snapshot fact table, combining with periodic and transaction grains, date dimension roles, comparison to other grains, pipelines and short processes, procurement example, university and admissions example, nulls to be expected, fact table loader, ETL subsystem #13, real time partition, accurate counting, combining CASE and SUM, actions, tracking, activity based costing difficult environments for, modeling income statements, ad hoc attack, Adaptive Software Development, additive facts, declaring in metadata, non-additive example, semi-additive example, address cleaning and standardizing, international addresses, administration criteria for dimensional DWs, administrative costs, admissions, university, accumulating snapshot example, affinity grouping data mining, market basket example, aggregate builder, ETL subsystem #19, aggregate data quality measures, aggregate fact table definition, aggregate navigation criterion for dimensional DW, dimensional modeling advantages, of dissimilar fact table grains, main architecture articles, main algorithm, metadata and, minimum metadata requirement, OLAP considerations, query tool discipline, query tools, recommended data warehouse architecture, aggregate navigator, aggregate processing during ETL, aggregated data anticipates the business question, data quality reporting, aggregated dimensional models, aggregates, administration with Type 1 SCD, design requirements, fact provider responsibilities, goals for data warehouse, metadata requirements, objection removers, positive and negative impacts, removing from real time partition, server configurations, shrunken dimension tables, aggregation, when premature defeats drill down, agile development approach, Agile Manifesto, AI (artificial intelligence), airline flight segment database design, airline yield KPI use case, airline customer satisfaction dimension, airport role playing dimensions, Alda, Alan, interviewing skills, allocating costs, danger of implementing, conflicting requirements, allocation, environments, allocation rules for calculating profit, compliance requirements, allocations, income statement fact tables, profitability fact tables, substituting rules of thumb, version number in audit dimension, computing on the fly, implementing in OLAP, alternate reality, type 3 SCD, An Introduction to Database Systems (Chris Date), analytic application lifecycle, five stages, analytics matrix tracking, analytic application reports, analytic tools, analytics matrix, Analytics Workshop, AND queries, architecture, address matching and standardizing, aggregate navigation articles, archiving, long term preservation, BI architecture articles, BI comparison queries, BI portal, dashboards, BI upgrading unsuccessful, bus architecture, catastrophe protection, change data capture, criteria, dimensional DWs, data architecture chapter, data mining articles, data quality, distributed EDW, drilling across, drilling down, EDW diagram, ETL, 34 subsystems of, FTP-based integration, integrated EDW, late arriving data handling, Lifecycle place for, master data management (MDM), metadata Microsoft SQL Server 2005 data architecture, real time, ROLAP versus OLAP, SCDs and time variance of dimensions, security, separating IT systems, service oriented architecture (SOA), storage area network (SAN), surrogate key processing pipeline, time handling, architecture phase, data marts, archiving, historical letters case study, encapsulating and emulating strategy, examples of very long term requirements, limitations of media, formats, software, hardware, metadata examples, migrate and refresh strategy, requirements affecting ETL design, very long term digital preservation, Atkinson, Toby, multinational name and address resource, atomic data, as basis of dimensional models, drilling down, normalized form, storage architectures, CIF versus Kimball, atomic fact tables, as core foundation, atomic grain, dimensionality, atomic-level behavior data, audit columns for change data capture, audit dimension, assembler, ETL subsystem #6, data quality measures, detailed design, environmental descriptors, in data mining, fact tables, automobile collisions, factless fact table, automobile policy coverages, insurance case study, availability of data warehouse, minimizing offline time, taking aggregates offline, averaging over time, awkward formats, B-tree indexes, back pointers to operational systems, back room, backup and recovery use cases, backup system, ETL subsystem #23, backups data staging, objection removers, balance transactions, BEEP, begin- and end-effective time stamps, behavior analysis, from clickstream, market basket analysis, purchase behavior security risks, behavior dimension, behavior tags, recency, frequency, intensity, behavioral queries, non-behavior, Berry, Michael and Linoff, Gordon, data mining books, best practices building DW/BI systems, establishing operating procedures, BI (Business Intelligence) applications, architecture, blended development approach, top-down and bottom up, building interpersonal skills, building public speaking skills, building written communication skills, understanding the business world, bottom-up market basket algorithm, 423 boundaries with finance, IT, legal, and end users, 4-6 bridge tables, account to customer in banking, begin- and end-effective time stamps, correctly weighted report, Brin, David (The Transparent Society: Will Technology Force Us to Choose Between Privacy and Freedom?), browse a dimension, BI tool user interface design, budgeting case study, budgeting data aligned with planning data, bug tracking system, bus architecture, bus matrix, business acceptance, Business Dimensional Lifecycle (Kimball Lifecycle), business intelligence, business needs affecting ETL design, business phase of data mining, business processes as basis of dimensional models, versus departments, fact table grain, identifying, consequences of incorrect, subject areas, tying to strategic initiatives with matrix, business realignment, business reengineering, calendar date dimension design, centralized customer management system, centralized DW/BI systems, change data capture, choice presentation in web-oriented data warehouse, claims transations fact table, insurance case study, classification queries