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]

dashboard applications [See scorecard applications.]

data destinations, support for

data flow (packages) 2nd

     dimension loading

     for inferred members

     inspecting

     legitimately missing members

     VLDBs (very large databases)

data integration process

     granularity of data

     source control

     with Integration Services

         connection managers

         dimension loading

         Excel spreadsheet loading

         fact table loading

         multiple file loading

         package deployment

         package operation in production

         package security

data marts, data warehouses versus

data mining 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

     in Integration Services 2nd

     managing

     predictions

     reprocessing mining models

     security 2nd

     segmentation with clusters

     Sequence Clustering algorithm

Data Mining dimension

Data Mining Extensions (DMX) 2nd

Data Mining Query transformations

data modeling [See dimensional modeling.]

data quality

     auditing with row counts

     dimensional modeling

     error handling

     in ETL process

     merging data

     missing dimension members

     need for in BI projects

     null values

     of packages

     out-of-range values

     preventing bad source data

     unexpected values

     zero values

data source view (DSV)

data sources

     data integration process

         connection managers

         dimension loading

         Excel spreadsheet loading

         fact table loading

         granularity of data

         multiple file loading

         package deployment

         package operation in production

         package security

         source control

         with Integration Services

     detecting changes in source data

     for data mining 2nd

     for reports

     preventing bad source data

     support for

Data Transformation Services (DTS) [See Integration Services.]

data truncation errors

data types, matching source and destination

Data Viewer

data warehouses

     as solution to ERP (enterprise resource planning) systems

     backing up

     building reports against

     constraints and

     creating with BI Development Studio

     data integration process

         connection managers

         dimension loading

         Excel spreadsheet loading

         fact table loading

         granularity of data

         multiple file loading

         package deployment

         package operation in production

         package security

         source control

         with Integration Services

     data marts versus

     data quality

         auditing with row counts

         dimensional modeling

         error handling

         in ETL process

         merging data

         missing dimension members

         null values

         out-of-range values

         preventing bad source data

         unexpected values

         zero values

     deployment

     design of

     dimension tables, building

     dimensional modeling for

         business process focus

         granularity

         identifying dimensions

         identifying measures

     ETL (extraction, transformation, and loading)

         for data mining

     fact tables, building

     feeding to e-commerce systems

     importing data for real-time business intelligence

     maintenance plans

     naming standards

     OOD (object-oriented design) in

     problems with real-time business intelligence

         proactive caching as solution

     restoring

     security

         application access

         database administrator access

         user access

     slowly changing dimensions (SCDs)

         Analysis Services and

         backups

         changing dimension tables for

         deployment

         detecting changes in source data

         for wide dimension tables

         processing in Analysis Services

         Slowly Changing Dimension transformation

         translating business keys to surrogate keys

         Type 1 SCD

         Type 2 SCD

     Time dimension

     UDM (Unified Dimensional Model) versus

     VLDBs (very large databases)

         aggregations 2nd

         automated processing

         backing up

         cube partitions 2nd

         data flow

         Database Synchronization

         fact tables in

         initial loading

         large dimension support

         partitioned tables 2nd

         partitioned views

data, loading into cubes

data-driven subscriptions 2nd

database access for Reporting Services

database administrator access to data warehouses

database engine (SQL Server)

     availability

     job scheduling

     management of

     scalability

     security

     very large database support

Database Engine Tuning Advisor

database servers, deploying Reporting Services on

Database Synchronization (Analysis Services)

datasets in Reporting Services

DateDiff function

dates, loading slowly changing dimensions (SCDs) [See also time information.]

debugging packages

degenerate dimensions 2nd

deleted members, slowly changing dimensions (SCDs) and

deleting

     cube partitions

     partitions

deploying

     Analysis Services databases

     data mining models

     data warehouses

     packages 2nd

     Reporting Services

     reports to server

     slowly changing dimensions (SCDs)

     SQL Server components

     WSS (Windows SharePoint Services)

Deployment Wizard

Derived Column transforms

descriptive attributes [See attributes.]

designing

     aggregations for VLDBs (very large databases) 2nd

     dimensional data models

     packages

         control flows

         data flows

         debugging

     partitioned cubes

     partitioned tables

     reports 2nd

differential backups

dimension loading

dimension members [See inferred members; missing dimension members.]

dimension modeling in VLDBs (very large databases)

dimension table loading (data warehouses)

dimension tables

     building for data warehouses

     changing for slowly changing dimensions (SCDs)

     cube creation

     rebuilding

dimension views, relationships with fact views

dimensional modeling

     candidate attributes, listing

     candidate measures, listing

     data quality

     design process

     E/R modeling versus

     for data mining

     for data warehouse projects 2nd

         business process focus

         granularity

         identifying dimensions

         identifying measures

     for real-time business intelligence

     for reports

     hierarchies

    measures

         grouping into fact tables

         loading test data

     scorecard applications

     snowflake design

         star design versus

     star design

         snowflake design versus

     surrogate keys

     synonyms

dimensions (data warehouses)

     adding hierarchies to

    changing dimensions [See slowly changing dimensions (SCDs).]

     conformed dimensions

     Data Mining dimension

     degenerate dimensions

     fact dimensions

     identifying for data warehouse dimensional model

     large dimension support

     relationships between

     relationships with cubes

     setting up

     Time dimension

discretization feature (Analysis Services)

discriminating between clusters

display formats for measures

display values for attributes

distributed partitioned views (DPVs) 2nd

DMX (Data Mining Extensions) 2nd

DPVs (distributed partitioned views)

drilling down (OLAP)

drilling down reports 2nd

drilling through reports 2nd

drop outdated cache property (proactive caching)

DSV (data source view)

DTS (Data Transformation Services) [See Integration Services.]