SQL Data Analysis Help

- A -

about SQL Data Analysis

above average - highlighting cells

	Supported database engines
	Running queries to retrieve data

add pivot table

advanced filtering

analysis table - chart

analysis table limit

apperance - analysis table

areas of a pivot table

arranging windows

- B -

below average - highlighting cells

- C -

chart - pivot table

	Analysis chart
	Analysis chart

close database connection

coloring cells using 2 color gradients - highlighting cells

coloring cells using 3 color gradients - highlighting cells

column field area

columns scrolling

conditional formatting

connect to database

create analysis table

create pivot table

	Creating a pivot table
	Creating additional analysis tables or pivot tables

	Summaries
	Creating a summary

creating groups

creating summaries

custom grouping

- D -

data bars - highlighting cells

data field area

data sets in use - querying

database connection

database engines

deleting summaries

disconnect from database

duplicate values - highlighting cells

- E -

editing summaries - pivot table

execute SQL query

export analysis table

export pivot table

- F -

filter field area

filtering the pivot table

	Supported database engines
	Running queries to retrieve data

	Appearance
	Stop a column from scrolling

formatting summary labels

formulas - using

formulas to highlight cells

- G -

group footer summary

group header summaries

grouping - pivot table

grouping columns

- H -

highlight cells

- I -

icon sets to highlight cells

- L -

label for summaries

- M -

maximum analysis tables

maximum number of analysis and pivot tables

maximum pivot tables

Microsoft Access

	Supported database engines
	Running queries to retrieve data

Microsoft SQL Server

multiple columns - sorting

multiple summaries

	Supported database engines
	Running queries to retrieve data

- N -

new analysis table

new pivot table

- O -

- P -

pivot table - chart

pivot table areas

pivot table limit

	Supported database engines
	Running queries to retrieve data

prefilter conditions - pivot table

print analysis table

print pivot table

- Q -

query data sets

- R -

range of values - highlighting cells

ranking - highlighting cells

removing summaries

report settings

- S -

sort by summary values

sort pivot table

sorting multiple columns

SQL for internal data sets

	Getting data from a database
	Running queries to retrieve data

	Supported database engines
	Running queries to retrieve data

SQL Server Compact

	Supported database engines
	Running queries to retrieve data

stacking columns

stop columns from scrolling

summaries - pivot table

summary - create

supported database engines

- T -

- U -

unique values - highlighting cells

using icons to highlight cells

- V -

version history

- W -

windows - arranging

- X -

- Y -