Contents
|
Index
|
Search
Introduction
About SQL Data Analysis
Version history
Supported database engines
Direct connections without client libraries
Connecting to an Oracle database without OCI
Contact us
Using SQL Data Analysis
The workspace
Getting data from a database
Running queries to retrieve data
Closing a database connection
Running queries on the retrieved data sets
Opening a data file
Using the analysis table
Appearance
Summaries
Advanced summaries
Groups
Highlighting cells
Highlighting options
Data bars
Icon set
Three color scale
Two color scale
Range of values
Duplicate values
Ranking
Unique values
Above or below average
Using formulas
Formulas
Sorting
Filtering
Analysis chart
Chart elements
Chart synchronization
Printing and exporting
Using the pivot table
Creating a pivot table
Pivot table areas
Summaries
Custom grouping
Filtering
Sorting
Analysis chart
Printing and exporting
Creating additional analysis tables or pivot tables
Frequent tasks
Adding more analysis or pivot tables
Analysis table
Creating a summary
Sort using a summary value
Grouping columns
Stop a column from scrolling
Stacking columns
Hiding a column
Displaying a chart
Pivot table
Hiding a column
Displaying a chart
Hiding a chart series