Practical Business Intelligence with SQL Server 2005

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Z]

identity columns

IIS logs, extracting information

importing data

     from Excel

     into data warehouse for real-time business intelligence

incremental loading in real-time business intelligence

incremental processing

indexed views on partitioned tables

indexes

     dimension tables, adding to

     fact tables, adding to

     in cube partitions

     on partitioned tables, managing

     partitioning

inferred members 2nd

     in real-time business intelligence

Inmon, Bill

inspecting data flow (packages)

instances of database engine

integrating data. [See data integration process.]

Integration Services

     data integration process 2nd

         connection managers

         dimension loading

         Excel spreadsheet loading

         fact table loading

         multiple file loading

         package deployment

         package operation in production

         package security

     data mining and 2nd

     fuzzy matching 2nd

     missing dimension members

     package design

         control flows

         data flows

         debugging

    packages

         configuring

         data quality

         deploying

         executing

interactive reports

invoking packages [See running packages.]

iterative approach to Business Intelligence (BI) projects