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