Index_S

S

Sampling tool, Excel, 75, 84–88

saving

Access databases, 142

Excel OLAP queries, 219

XML data in Excel using code, 311–13

scatter charts, 28, 58–59

schemas, XML, 259, 270–75

security

Access databases, 338, 340–41

SQL Server databases, 336–37

Web data, 159–60

select queries, 147–49, 354–55

series fields, PivotChart report, 100

server-based data storage, 3, 10–11, 195

servers, OLAP, 208–14

shortcut menu, PivotTable report, 115

slicers, 255

slides, exporting Data Analyzer views to PowerPoint, 256–57, 361

software, business intelligence, 225. See also Microsoft software

Solver Add-In, Excel, 89–93, 349

sorting

Access, 138–40, 144–46, 353

Chart Component, 187, 192

data analysis and, 20–21

Excel, 42–44, 49, 345

Excel data lists, 297–302, 345

Office Web Components, 356

PivotTable Component, 175–76

querying and, 28

relational data and, 33

Spreadsheet Component, 169

sources. See data sources

Spreadsheet Component, 162–72. See also Office Web Components

analyzing data, 167–70, 356–57

data-bound sheets, 171–72

features, 14, 162–67, 170–72

multiple worksheets, 171

programming, using code, 315–20

publishing Excel data to, 166, 356

XML data support, 170–71, 273

spreadsheet flattener, Excel, 266–70

spreadsheets, 3, 10. See also Excel; Spreadsheet Component

SQL Server 2000

Analysis Services. See SQL Server 2000 Analysis Services

backing up and restoring databases, 334

Data Transformation Services, 10, 15, 342–43

database maintenance, 331–37

Database Maintenance Plan Wizard, 335–36

databases, Access and, 155–56

Desktop Engine, 15–16, 155, 337

documenting and re-creating databases, 333–34

features, 14–15, 202

Office Web Components and, 171–72, 192

securing databases, 336–37

as server-based, 11, 195

SQL Server 2000 Analysis Services

archiving and restoring OLAP cubes, 341

Data Analyzer code and, 321

data formats, 10

features, 15, 16, 202

OLAP and, 195, 208–14. See also online analytical processing

processing OLAP cubes, 341–43

systems maintenance, 341–43

statistics tool, Excel, 76–78

status bar functions, Excel, 72

stock charts, 28, 59

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

stored procedures, SQL Server, 155–56

strategies, data analysis, 5–10

subtotaling. See summarizing

SUM function, 121, 302–3

summarizing

calculated totals in PivotTable Components, 179–80, 358

data analysis and, 22–23

Excel data lists, 70–73, 297–302, 348–49

filtering vs., 25

multidimensional data, 35

Office Web Components summary functions, 167–70, 178–79, 190, 357–58

percentages as totals, 181–82

PivotTable Component, 179, 358

querying and, 28

relational data, 33

sorting vs., 20

summary statistics, 76

surface charts, 28, 59

surveys, 8

system databases, SQL Server, 335

systems maintenance, 329–43

Access databases, 337–41

books about, 343

plans, 329–31

SQL Server 2000 Analysis Services, 341–43

SQL Server 2000 databases, 15, 331–37

SQL Server 2000 Desktop Engine databases, 337