Accessing and Analyzing Data with Microsoft Excel (Bpg-Other)

R

radar charts, 28, 59

ragged data, 10

random sampling, 85

Rank and Percentile tool, Excel, 75, 83–84, 87–88, 305–6

ranking, Excel, 42

reading. See books

recording data, 5–9, 201–2

records, 2, 32–36. See also data lists, Excel

re-creating SQL Server databases, 333–34

References dialog box, 291

refreshing cube files, 219

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

relational OLAP (ROLAP), 203–4

relationships, 32, 34–35, 196

renaming Spreadsheet Component worksheets, 171

repairing Access databases, 339–40

replicating Access databases, 338

reporting

Access, 150–53, 135–36, 355

Excel. See PivotChart reports, Excel; PivotTable reports, Excel

systems maintenance. See systems maintenance

restoring

Access databases, 338

OLAP cubes, 341

SQL Server databases, 334

results, function, 49

retail sales organizations, 4, 7, 9, 226

ROLAP (relational OLAP), 203–4

row fields, PivotTable report, 98

rules, XML, 264–66

run time, Office Web Components and, 161, 164–65, 174–75, 184–85