Index_D

D

data

analysis. See data analysis

binding, 171–72, 192

business decisions and, 4–5. See also business decisions

collecting and recording, 5–9, 201–2

compatibility issues, 9–10

connection file types, 213

data lists. See data lists, Excel

databases, 2, 3, 105–6. See also Access; SQL Server 2000; systems maintenance

external. See external data

files, 2. See also files

formats, 1–4. See also formats, data

multidimensional (OLAP), 14, 16, 32–33, 35–36, 193, 203–4. See also cubes, OLAP; online analytical processing

nonrelational, 11, 14, 32–35, 129–30

relational, 11, 13, 14, 32–35, 129–32

sources. See data sources

storage, 3–6, 10–12, 203–4

terminology, 2

Web. See Web data

XML. See XML data

data access pages, Access, 13, 155, 156

data analysis

with Access, 13, 353–55. See also Access

business decisions and, 1–2, 4–8. See also business decisions

charting, 28–29. See also charting

data and, 1–10, 32–36. See also data

data lists and, 31–32. See also data lists, Excel

defined, 2

with Excel, 12, 345–51. See also Excel

filtering, 24–25. See also filtering

formatting, 25–26. See also formatting

importing, exporting, and querying, 27–28. See also exporting; importing; querying

maintaining systems. See systems maintenance

Microsoft software and, 10–17. See also Microsoft software

with Office Web Components, 13–14, 356–58. See also Office Web Components

online analytical processing (OLAP), 16–17, 349–51, 358–61. See also Data Analyzer; Excel, OLAP data analysis with; online analytical processing; SQL Server 2000 Analysis Services

pivoting, 30–31, 95–96, 351–53. See also PivotChart reports, Excel; PivotChart views, Access; PivotTable Component; PivotTable reports, Excel; PivotTable views, Access

programming features using code. See code

quick reference, 345–61

sorting, 20–21. See also sorting

with SQL Server 2000, 14–16. See also SQL Server 2000

strategies, 5–10

summarizing, 22–23. See also summarizing

trending, 23–24. See also trending

with XML data, 37–39. See also XML data

Data Analyzer, 225–57

BusinessCenter, 252–54, 361

changing views to analyze data, 235–44, 359–60

creating custom measures, 245–51, 360–61

creating views, 232–35, 358–59

data compatibility and, 10

data storage and, 11–12

exporting views, 254–57, 361

features, 16–17, 202, 205, 225–32

multidimensional expressions, 246

PivotTable and PivotChart reports vs., 226–27

programming, using code, 291, 321–26

quick reference, 358–61

user interface, 227–32

data fields, 99, 101

data files, 2

data labels, 58

data lists, Excel

features, 31–32, 70–73

filtering, sorting, and summarizing, 297–302, 345–46, 348–49

importing, into Access, 134

data sources. See also external data

code and, 317–19

Microsoft software, 27

OLAP, 194–95, 208–14

PivotTable Component, 175

PivotTable report, 105–9

Spreadsheet Component, 171–72

Data Transformation Services, 10, 15, 342–43

databases, 2, 3, 105–6. See also Access; SQL Server 2000; systems maintenance

Datasheet view, Access, 13, 138

datasheets, Chart Component built-in, 192

decisions. See business decisions

delete queries, 147

Descriptive Statistics tool, Excel, 75, 76–78, 87–88, 305–6

design time, Office Web Components and, 161, 163–64, 173–74, 183–84

Design view, Access, 138

Desktop Engine, SQL Server 2000, 15–16, 155, 337

dimension panes, Data Analyzer, 228–32, 236, 359–60

dimensions, OLAP, 197

direct data binding, Chart Component, 192

distributed views, 14

DoCmd object, Access, 313–15

documenting databases, 330, 333–34, 337

documents, XML, 262

doughnut charts, 28, 59

drilling through, 254

drilling up or drilling down, 190–91, 236, 359–60

drop zones, 97–98, 100, 110