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]

e-commerce systems, feeding data warehouse data to

E/R modeling, dimensional modeling versus

elapsed time, measuring

enabling proactive caching

encryption

end-user reporting

     with Report Builder

Enterprise Data Warehouse

enterprise resource planning (ERP) systems

     data warehouse as solution to

     problems with

ER (entity-relationship) modeling in OLTP

ERP (enterprise resource planning) systems

     data warehouse as solution to

     problems with

error handling, data quality issues

ETL (extraction, transformation, and loading) process [See also data integration process.]

     data quality

     for data mining

     Slowly Changing Dimension transformation

     VLDBs (very large databases)

ETLM (extraction, transformation, loading, and managing) process

event notifications for importing data into data warehouse

Excel spreadsheet loading

Execute SQL tasks

executing packages [See running packages.]

expressions (Reporting Services), adding to reports

extracting IIS log file information