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]

accessing

     data warehouses

         for applications

         for database administrators

         for users

     database for Reporting Services

     reports 2nd

additive measures 2nd 3rd

     transforming logic into

address information

administrators (Analysis Services), security

ADOMD.NET

aggregates (OLAP)

aggregations for VLDBs (very large databases)

     designing 2nd

algorithms for data mining 2nd 3rd

Analysis Services

     administrator security

     architecture of

     availability

     data mining features 2nd

         adding to Web applications

         algorithms for 2nd

         architecture for

         Association Rules algorithm

         creating mining structure

         Data Mining dimension

         data sources for

         deployment

         dimensional modeling for

         ETL process

         managing

         predictions

         reprocessing mining models

         security 2nd

         segmentation with clusters

         Sequence Clustering algorithm

     Database Synchronization

     development environment

     discretization feature

     managing

     missing dimension members

     partitioned cubes

         managing

     scalability

     security

     slowly changing dimensions (SCDs)

         processing

     translations

     UDM (Unified Dimension Model)

     very large database support

Analysis Services databases [See also cubes (OLAP).]

     architecture of

     backing up

     creating

     cube creation

     cube processing

     cube setup

     deployment

     dimension setup

     in scorecard applications

         KPIs (key performance indicators)

         many-to-many relationships

         parent-child dimensions

         perspectives

         security

         setup

     on-time shipments analysis

     relational tables versus

     security

     source code control

     types of data

     updating views

Analysis Services Deployment Wizard

Analysis Services queries, parameters for

application access to data warehouses

architecture

     for data mining

     of Analysis Services

     of Analysis Services databases

     of Reporting Services

Association Rules algorithm

attributes

     adding to dimension tables

     candidate attributes, listing

     data warehouses

     relationships between

     setting up dimensions

auditing data quality

     with row counts

authentication

     for Analysis Services

     Windows authentication

automated processing, VLDBs (very large databases)

availability

     Analysis Services

     SQL Server database engine