Index_M


M

macros, 13, 284–89

maintenance. See systems maintenance

major gridlines, 57

make-table queries, 147

manufacturing organizations, 5, 7, 226

MapPoint, 113

MDX (Multidimensional Expressions) language, 246

measures

creating custom, in Data Analyzer, 245–51, 360–61

OLAP, 198

members, OLAP, 197

menu, PivotTable report, 112–16

menu bar, Data Analyzer, 228

metadata, 28

methods, 290

Microsoft software, 10–17

Access, 13. See also Access

business intelligence applications, 225

Data Analyzer, 16–17. See also Data Analyzer

data formats and, 3–4, 10. See also formats, data

data storage, 10–12

Excel, 12. See also Excel

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

FrontPage, 161–62, 211

Internet Explorer. See Internet Explorer

MapPoint, 113

Office Web Components, 13–14. See also Office Web Components

OLAP data and, 204–5

programming, using code. See code

Query, 63–70, 213, 220

SQL Server 2000, 14–16. See also SQL Server 2000; SQL Server 2000 Analysis Services

Visual Basic Editor, 290–91

Visual Basic programming languages, 285, 291

Windows, 74, 338

minor gridlines, 57

modules, 290

MOLAP (multidimensional OLAP), 203–4

Moving Average tool, Excel, 75, 81–83, 87–88

multidimensional data, 14, 16, 32–33, 35–36, 193, 203–4. See also online analytical processing

Multidimensional Expressions (MDX) language, 246

multiple consolidation ranges, PivotTable report, 106–8

multiple worksheets, Spreadsheet Component, 171




Accessing and Analyzing Data With Microsoft Excel
Accessing and Analyzing Data with Microsoft Excel (Bpg-Other)
ISBN: 073561895X
EAN: 2147483647
Year: 2006
Pages: 137
Authors: Paul Cornell

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net